Mysql 查询表占用的空间

文章目录

SELECT
  TABLE_NAME AS `Table`,
  (DATA_LENGTH + INDEX_LENGTH)  AS `Size (B)`
FROM
  information_schema.TABLES
WHERE
  TABLE_SCHEMA = "database_name"
ORDER BY
  (DATA_LENGTH + INDEX_LENGTH)
DESC;