查看 MySQL 表磁盘占用空间实用 SQL

有时候我们需要直到在 mysql 数据库中某张表占用了多少磁盘空间为优化方案提供决策参考，但团队中并不是每个人都有云数据库管理后台的访问权限，这时候可以使用 SQL 查询某张表占用的磁盘空间大小。

SELECT
    table_name AS 'Table',
    round(data_length / 1024 / 1024, 2) AS 'Data Size (MB)',
    round(data_length / 1024 / 1024 / 1024, 2) AS 'Data Size (GB)',
    round(index_length / 1024 / 1024, 2) AS 'Index Size (MB)',
    round(index_length / 1024 / 1024 / 1024, 2) AS 'Index Size (GB)',
    round((data_length + index_length) / 1024 / 1024, 2) AS 'Total Size (MB)',
    round((data_length + index_length) / 1024 / 1024 / 1024, 2) AS 'Total Size (GB)'
FROM
    information_schema.tables
WHERE
        table_schema = 'database_name' AND
        table_name = 'table_name';