용량조회1 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/(10.. 2022. 7. 29. 이전 1 다음