mysql mariadb DB 전체 용량, 테이블별 용량 조회

- DB별 용량 조회

SELECT 
    table_schema AS 'DBName', -- 
    ROUND(SUM(data_length+index_length)/1024/1024, 1) AS 'Size(MB)'
FROM information_schema.tables
GROUP BY table_schema
ORDER BY 2 DESC;

- Table별 용량조회

SELECT 
    table_name AS 'TableName', 
    MAX(TABLE_SCHEMA) AS 'DBName', 
    ROUND(SUM(data_length+index_length)/(1024*1024), 2) AS 'All(MB)',
    ROUND(data_length/(1024*1024), 2) AS 'Data(MB)',
    ROUND(index_length/(1024*1024), 2) AS 'Index(MB)'
FROM information_schema.tables
GROUP BY table_name
ORDER BY data_length DESC; 

서버 용량체크할 때 좋음 ㅋ