MYSQL 查询占用空间最大的前 10 张表

SELECT
table_schema AS ' 数据库 ',
table_name AS ' 表名 ',
a.TABLE_TYPE,
a.`ENGINE`,
a.CREATE_TIME,
a.UPDATE_TIME,
a.TABLE_COLLATION,
table_rows AS ' 记录数 ',
TRUNCATE (data_length / 1024 / 1024, 2) AS ' 数据容量 (MB)',
TRUNCATE (index_length / 1024 / 1024, 2) AS ' 索引容量 (MB)',
TRUNCATE (( data_length + index_length) / 1024 / 1024, 2 ) AS ' 总大小 (MB)'
FROM information_schema.TABLES a
ORDER BY ( data_length + index_length ) DESC
LIMIT 10;