select table_name as '表名', (data_length/1024/1024) as '数据容量(MB)', (index_length/1024/1024) as '索引容量(MB)', ((data_length+index_length)/1024/1024) as '数据容量+索引容量容量(MB)', table_rows as '数据行数' from information_schema.TABLES where table_schema = '表名' order by ((data_length+index_length)/1024/1024) desc
标签：1024,查看,容量,index,库下,length,mysql,table,data From： https://www.cnblogs.com/zrui-xyu/p/16828313.html