MySQL 查看数据库和表空间大小及碎片处理
1. 查看所有数据库空间大小 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.tablesGROUP BY table_schemaORDER BY
原创
2021-11-05 18:00:43 ·
2588 阅读 ·
0 评论