Mysql数据库中统计表大小

原创于 2026-08-20 09:10:23 发布 · 90 阅读

2 ·

本内容遵循CC 4.0 BY-SA版权协议

GEO检测

收录于

当前文章被以下社区和专栏收录：

#数据库中统计表大小
SELECT 
    table_name AS '表名',
    ROUND(data_length / 1024 / 1024, 2) AS '数据大小(MB)',
    ROUND(index_length / 1024 / 1024, 2) AS '索引大小 (MB)',
    round((data_length+index_length)/1024/1024,2) as '总大小(MB)',
    table_rows as '行数'
FROM
    information_schema.tables
WHERE
    table_schema = 'your_database'
    order by (data_length+index_length) desc;
    
select sum(total) as '总大小(MB)' from (SELECT 
    table_name AS '表名',
    ROUND(data_length / 1024 / 1024, 2) AS '数据大小(MB)',
    ROUND(index_length / 1024 / 1024, 2) AS '索引大小(MB)',
    round((data_length+index_length)/1024/1024,2) as total,
    table_rows as '行数'
FROM
    information_schema.tables
WHERE
    table_schema = 'your_database'
    order by (data_length+index_length) desc) as t;