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)

 

posted @ 2018-09-11 10:06  bianxiaobian  阅读(260)  评论(0)    收藏  举报