查询数据库中所有表的数据量大小、表行记录数
SELECT
TABLE_NAME AS ‘表名字’,
DATA_LENGTH AS ‘数据大小’,
INDEX_LENGTH AS ‘索引大小’,
TABLE_ROWS AS ‘表格行数量’,
(DATA_LENGTH + INDEX_LENGTH) AS ‘数据和所有总大小’,
concat(round((DATA_LENGTH + INDEX_LENGTH) / 1024 / 1024,2),‘MB’) AS ‘占用空间’
FROM
information_schema. TABLES
WHERE
TABLE_SCHEMA = ‘数据库名’
ORDER BY
TABLE_ROWS DESC;