查询数据库空间占用大小

1、查询每个数据库占用空间大小

SELECT TABLE_SCHEMA, CONCAT(TRUNCATE(SUM(data_length)/1024/1024,2),' MB') AS data_size,
CONCAT(TRUNCATE(SUM(index_length)/1024/1024,2),'MB') AS index_size,
CONCAT(TRUNCATE(SUM(data_length+index_length)/1024/1024/1024,2),'G')
FROM information_schema.tables
GROUP BY TABLE_SCHEMA
ORDER BY data_length DESC;

 

2、查询数据库下表占用空间大小

SELECT TABLE_NAME, CONCAT(TRUNCATE(data_length/1024/1024,2),' MB') AS data_size,
CONCAT(TRUNCATE(index_length/1024/1024,2),' MB') AS index_size,
CONCAT(TRUNCATE(SUM(data_length+index_length)/1024/1024/1024,2),'G') total_size
FROM information_schema.tables WHERE TABLE_SCHEMA = 'mktinfo'
GROUP BY TABLE_NAME
ORDER BY data_length DESC;