MySQL查看某一表的数据大小
mysql> select concat(round(sum(data_length/1024/1024/1024),2),'GB') as data_length_MB, -> concat(round(sum(index_length/1024/1024/1024),2),'GB') as index_length_MB -> from information_schema.tables where -> table_schema='CH_MedicareData' -> and table_name = 'MI_Medicare_2017'; +----------------+-----------------+ | data_length_MB | index_length_MB | +----------------+-----------------+ | 60.49GB | 56.22GB | +----------------+-----------------+ 1 row in set (0.00 sec)

浙公网安备 33010602011771号