查看mysql数据库的大小

有谁看见我的剑了？

已于 2023-01-30 18:10:20 修改

阅读量643

点赞数

文章标签：数据库 mysql sql

于 2023-01-30 17:41:56 首次发布

本文链接：https://blog.csdn.net/qq_50247813/article/details/128806384

版权

查看所有库的总量

select
-> concat(round(sum(DATA_LENGTH/1024/1024),2),'MB') as ALL_DB_DATA_SIZE,
-> concat(round(sum(INDEX_LENGTH/1024/1024),2),'MB') as ALL_DB_INDEX_SIZE,
-> concat(round(sum((DATA_LENGTH + INDEX_LENGTH)/1024/1024),2),'MB') as ALL_DB_TOTAL_SIZE
-> from information_schema.TABLES;

在这里插入图片描述

查看库的大小并进行排序

select
-> table_schema as DB_NAME,
-> concat(round(sum(DATA_LENGTH/1024/1024),2),'MB') as DB_DATA_SIZE,
-> concat(round(sum(INDEX_LENGTH/1024/1024),2),'MB') as DB_INDEX_SIZE,
-> concat(round(sum((DATA_LENGTH + INDEX_LENGTH)/1024/1024),2),'MB') as DB_TOTAL_SIZE
-> from information_schema.TABLES
-> group by table_schema
-> order by sum(DATA_LENGTH + INDEX_LENGTH) desc;

在这里插入图片描述
转载：