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;