Mysql查看表占用空间

SELECT
table_schema AS ‘数据库’,
table_name AS ‘表名’,
table_rows AS ‘记录数’,
TRUNCATE (data_length / 1024 / 1024, 2) AS ‘数据容量（MB）’,
TRUNCATE (index_length / 1024 / 1024, 2) AS ‘索引容量（MB）’
FROM
information_schema.TABLES
WHERE table_schema = ‘数据库名称’
ORDER BY data_length DESC,
index_length DESC ;