Development/DataBase

[MySQL] DB 용량 확인

키르히아이스 2015. 2. 10. 11:13

select table_schema as DatabaseName,

sum(data_length + index_length) / 1024 / 1024 "Size(MB)"

from information_schema.tables

-- where table_schema = "TestDB"

group by table_schema


TestDB : 용량 확인 할 DB명