MySQL数据库统计每个数据库的大小

最新推荐文章于 2024-03-15 15:18:23 发布

挠背小能手

最新推荐文章于 2024-03-15 15:18:23 发布

阅读量536

点赞数

分类专栏： MySQL日常运维文章标签：数据库 mysql

本文链接：https://blog.csdn.net/m0_37625564/article/details/128240724

版权

MySQL日常运维专栏收录该内容

7 篇文章 0 订阅

订阅专栏

统计每个数据库的大小

select table_schema,sum(data_length)/1024/1024/1024 "data_length(GB)",sum(index_length)/1024/1024/1024 "index_length(GB)",sum(data_length+index_length)/1024/1024/1024 "total_size(GB)"
from information_schema.tables
where table_schema!='information_schema'
and table_schema!='mysql'
group by table_schema;

+--------------------+-----------------+------------------+----------------+
| table_schema       | data_length(GB) | index_length(GB) | total_size(GB) |
+--------------------+-----------------+------------------+----------------+
| lei                |  0.008316040039 |   0.004409790039 | 0.012725830078 |
| performance_schema |  0.000000000000 |   0.000000000000 | 0.000000000000 |
| ray                |  0.008316040039 |   0.004409790039 | 0.012725830078 |
| sys                |  0.000015258789 |   0.000000000000 | 0.000015258789 |
+--------------------+-----------------+------------------+----------------+
4 rows in set (0.03 sec)