MySQL查询每个表的大小

共计 152 个字符，预计需要花费 1 分钟才能阅读完成。

SELECT
    TABLE_NAME,
    ROUND( sum( data_length + index_length )/ 1024 / 1024, 2 ) AS M 
FROM
    information_schema.TABLES 
WHERE
    TABLE_SCHEMA = "数据库名称" 
GROUP BY
    TABLE_NAME 
ORDER BY
    M DESC;