mysql中快速统计每个库每个表的大小和条数总和
SELECT TABLE_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)
FROM inform…
2026/7/31 9:30:27