查看mysql库中所有表的大小和记录数
SELECT
TABLE_NAME,
DATA_LENGTH,
INDEX_LENGTH,
( DATA_LENGTH + INDEX_LENGTH ) AS length,
TABLE_ROWS,
concat( round( ( DATA_LENGTH + INDEX_LENGTH ) / 1024 / 1024, 3 ), 'MB' ) AS total_size
FROM
information_schema.TABLES
WHERE
TABLE_SCHEMA = 'database_name'
ORDER BY
length DESC;
结果: