【DB】查询数据库表所占空间大小

【DB】查询数据库表所占空间大小

SELECT table_schema AS 'Database', table_name AS 'Table', round(((data_length + index_length) / 1024 / 1024), 2) AS 'Size in MB' FROM information_schema.TABLES WHERE table_schema = 'dbName' -- 替换为你的数据库名 ORDER BY (data_length + index_length) DESC;