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`
ORDER BY
	TABLE_SCHEMA DESC,
	DATA_LENGTH DESC,
	INDEX_LENGTH DESC

结果信息