MySQL查询数据库大小

最新推荐文章于 2024-05-28 10:14:32 发布

cddb_Leonidas

最新推荐文章于 2024-05-28 10:14:32 发布

阅读量733

点赞数

分类专栏： mysql 数据库文章标签：数据库 MySQL 数据库常识

本文链接：https://blog.csdn.net/jyf0412/article/details/38557405

版权

数据库同时被 2 个专栏收录

12 篇文章 0 订阅

订阅专栏

mysql

5 篇文章 0 订阅

订阅专栏

MySQL查询所有数据库大小

SELECT 
concat(round(sum(data_length/1024/1024),2),' MB') as DataSise 
FROM information_schema.TABLES ;

查询都没算上索引，其实索引空间占用也挺多的，如果要加上，请自行换

concat(round(sum(data_length/1024/1024),2),' MB') as DataSise 为

concat(round(sum(DATA_LENGTH)/1024/1024+sum(INDEX_LENGTH)/1024/1024,2),' MB') as DataSise

MySQL按数据库分组查询数据库大小

SELECT 
TABLE_SCHEMA as DBName,
concat(round(sum(data_length/1024/1024),2),' MB') as DataSise 
FROM information_schema.TABLES 
GROUP BY table_schema
ORDER BY DataSise DESC;

MySQL查询表存储空间大小

SELECT 
TABLE_SCHEMA AS DBName,
TABLE_NAME   AS TableName,
concat(round(sum(DATA_LENGTH/1024/1024),2),' MB') AS DataSise 
FROM information_schema.TABLES 
GROUP BY TABLE_SCHEMA,TABLE_NAME
ORDER BY DataSise DESC;

MySQL查询表数据行数、存储空间

SELECT 
TABLE_SCHEMA AS DBName,
TABLE_NAME   AS TableName,
TABLE_ROWS   AS DataRows,
concat(round(sum(DATA_LENGTH/1024/1024),2),' MB') AS DataSise 
FROM information_schema.TABLES 
GROUP BY TABLE_SCHEMA,TABLE_NAME
ORDER BY DataRows DESC;