[MySQL] 데이터베이스 용량 확인 / 버전확인

버전확인

select version();

 

 

전체 용량확인

SELECT SUM(data_length+index_length)/1024/1024 "USED_MB", SUM(data_free)/1024/1024 "FREE_MB"

FROM information_schema.tables;

 

 

데이터베이스별 용량확인

SELECT table_schema AS DBMS, CONCAT((SUM(data_length + index_length) / 1024 / 1024)," MB") AS "Size" FROM information_schema.TABLES GROUP BY table_schema;