Mysql 查询数据库容量

select

table_schema as '数据库',

sum(table_rows) as '记录数',

sum(truncate(data_length/1024/1024, 2)) as '数据容量(MB)',

sum(truncate(index_length/1024/1024, 2)) as '索引容量(MB)'

from information_schema.tables

WHERE table_schema = '你的库名';

group by table_schema

order by sum(data_length) desc, sum(index_length) desc;

结果如下： 

 

如果想查整个数据库的容量，你就把where条件去掉。