mysql 查询各数据库的占用大小
select TABLE_SCHEMA, concat(truncate(sum(data_length)/1024/1024,2),\’ MB\’) as data_size,
concat(truncate(sum(index_length)/1024/1024,2),\’MB\’) as index_size
from information_schema.tables
group by TABLE_SCHEMA
order by data_length desc;
版权声明：本文为rayong原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。