쿼리 한번으로 데이터베이스 용량 알아내기

 

Shell

SELECT table_schema "team", SUM(data_length + index_length) / 1024 / 1024 "Size(MB)" FROM information_schema.TABLES GROUP BY table_schema; +--------------------+------------+ | team | Size(MB) | +--------------------+------------+ | information_schema | 0.14062500 | | mysql | 0.62320518 | | performance_schema | 0.00000000 | | team | 0.14011765 | +--------------------+------------+ 4 rows in set (0.01 sec)

0 1 2 3 4 5 6 7 8 9 10 11

SELECT table_schema "team", SUM(data_length + index_length) / 1024 / 1024 "Size(MB)" FROM information_schema.TABLES GROUP BY table_schema; +--------------------+------------+ | team               | Size(MB)   | +--------------------+------------+ | information_schema | 0.14062500 | | mysql              | 0.62320518 | | performance_schema | 0.00000000 | | team               | 0.14011765 | +--------------------+------------+ 4 rows in set (0.01 sec)

 

DBinformation_schemaqueryselectSUM데이터베이스용량쿼리