SELECT table_schema AS '数据库',
　　　　TABLE_NAME AS '表名',
　　　　table_rows AS '记录数',
　　　　truncate(data_length/1024/1024, 2) AS '数据容量(MB)',
　　　　truncate(data_free/1024/1024, 2) AS '数据空洞(MB)',
　　　　truncate(index_length/1024/1024, 2) AS '索引容量(MB)'
FROM information_schema.tables ORDER BY data_length DESC,index_length DESC;

标签: none

添加新评论