mysql中快速统计每个库每个表的大小和条数总和

SELECTTABLE_SCHEMA AS 数据库名,TABLE_NAME AS 表名,TABLE_ROWS AS 预估行数,ROUND(DATA_LENGTH / 1024 / 1024, 2) AS 数据大小(MB),ROUND(INDEX_LENGTH / 1024 / 1024, 2) AS 索引大小(MB),ROUND((DATA_LENGTH INDEX_LENGTH) / 1024 / 1024, 2) AS 总空间(MB)FROMinformation_schema.TABLESWHERETABLE_SCHEMA NOT IN (information_schema, sys, performance_schema, mysql) -- 过滤系统库-- AND TABLE_SCHEMA 你的数据库名 -- 如果只想看某个特定库取消此行的注释ORDER BY(DATA_LENGTH INDEX_LENGTH) DESCLIMIT 20; -- 只看前20个大表SELECTTABLE_SCHEMA AS 数据库名,TABLE_NAME AS 表名,TABLE_ROWS AS 预估行数,ROUND((DATA_LENGTH INDEX_LENGTH) / 1024 / 1024, 2) AS 总空间(MB)FROMinformation_schema.TABLESWHERETABLE_SCHEMA NOT IN (information_schema, sys, performance_schema, mysql)ORDER BYTABLE_ROWS DESCLIMIT 20;