MYSQL查看表占用空间

分类: 文章 • 2025-02-22 13:01:28

查看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;