MySQL容量计算SQL

select
table_schema as'数据库',
table_name as'表名',
table_rows as'记录数',
truncate(data_length/1024/1024,2)as'数据容量(MB)',
truncate(index_length/1024/1024,2)as'索引容量(MB)'
from information_schema.tables
where table_schema='databases_name'
order by data_length desc,index_length desc;