데이터베이스별 용량 확인

 

 

1. 데이터베이스별 용량 확인

SELECT TABLE_SCHEMA "DATABASE NAME"
             ,SUM(DATA_LENGTH + INDEX_LENGTH) / 1024 / 1024 "SIZE(MB)"
FROM INFORMATION_SCHEMA.TABLES
GROUP BY TABLE_SCHEMA;

2. 테이블별 용량 확인

SELECT CONCAT(TABLE_SCHEMA,'.',TABLE_NAME) TABLE_SCHEMA
              ,CONCAT(ROUND(DATA_LENGTH/(1024*1024*1024),2),'G') DATA
               ,CONCAT(ROUND(INDEX_LENGTH/(1024*1024*1024),2),'G') IDX
               ,CONCAT(ROUND((DATA_LENGTH+INDEX_LENGTH)/(1024*1024*1024),2),'G') TOTAL_GB
               ,ROUND(INDEX_LENGTH/DATA_LENGTH,2) LENGTH
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_ROWS IS NOT NULL;