MySql查看数据库及表容量大小并排序
查看所有数据库容量大小selecttable_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 sum(data_lengt.
原创
2020-08-08 02:02:17 ·
3336 阅读 ·
0 评论