MySQL统计数据库和表大小

最新推荐文章于 2024-11-14 15:58:00 发布

数据库记录

最新推荐文章于 2024-11-14 15:58:00 发布

阅读量89

点赞数

分类专栏： MySQL 文章标签：数据库 mysql sql Powered by 金山文档

本文链接：https://blog.csdn.net/l1456848128/article/details/128715477

版权

MySQL 专栏收录该内容

1 篇文章 0 订阅

订阅专栏

统计数据库大小

SELECT 
table_schema,
SUM(truncate((data_length+index_length+data_free)/1024/1024,2)) AS total_size_MB,
SUM(truncate(data_length/1024/1024,2)) AS data_size_MB,
SUM(truncate(index_length/1024/1024,2)) AS index_size_MB,
SUM(truncate(data_free/1024/1024,2)) AS index_size_MB,
sum(table_rows) as table_rows
FROM information_schema.tables 
where table_schema not in('mysql','sys','information_schema','performance_schema')
group by TABLE_SCHEMA
order by total_size_MB desc
limit 100;

统计表大小

SELECT 
table_schema,
table_name,
TRUNCATE((data_length+index_length+data_free)/1024/1024,2) AS total_size_MB,
TRUNCATE(data_length/1024/1024,2) AS data_size_MB,
TRUNCATE(index_length/1024/1024,2) AS index_size_MB,
TRUNCATE(data_free/1024/1024,2) AS data_free_MB,
table_rows
FROM information_schema.tables 
where table_schema not in('mysql','sys','information_schema','performance_schema')
group by table_name
order by total_size_MB desc
limit 100;