查看某個數據庫中所有表的空間與行數統計

SELECT TABLE_NAME AS `表名`,TABLE_ROWS AS `行數`,ROUND(DATA_LENGTH / 1024 / 1024, 2) AS `數據大小(MB)`,ROUND(INDEX_LENGTH / 1024 / 1024, 2) AS `索引大小(MB)`,ROUND((DATA_LENGTH + INDEX_LENGTH) / 1024 / 1024, 2) AS `總占用空間(MB)`,ROUND((DATA_LENGTH + INDEX_LENGTH) / 1024 / 1024 / 1024, 2) AS `總占用空間(GB)`
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = 'your_database_name' -- 替換為你的數據庫名
ORDER BY (DATA_LENGTH + INDEX_LENGTH) DESC;

執行結果

查看某個數據庫總空間占用情況??

SELECT TABLE_SCHEMA AS `數據庫名`,SUM(TABLE_ROWS) AS `總行數`,ROUND(SUM(DATA_LENGTH) / 1024 / 1024, 2) AS `數據總大小(MB)`,ROUND(SUM(INDEX_LENGTH) / 1024 / 1024, 2) AS `索引總大小(MB)`,ROUND(SUM(DATA_LENGTH + INDEX_LENGTH) / 1024 / 1024, 2) AS `總占用空間(MB)`,ROUND(SUM(DATA_LENGTH + INDEX_LENGTH) / 1024 / 1024 / 1024, 2) AS `總占用空間(GB)`
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = 'your_database_name'
GROUP BY TABLE_SCHEMA;

執行結果