DB size query

SELECT
     table_name ,
     round(((data_length + index_length) /1024/1024/1024), 2) `Size(GB)`
FROM information_schema.TABLES
WHERE TABLE_SCHEMA='데이터베이스 명'
ORDER BY (data_length + index_length) DESC;

MB 로 표시할경우 : 1024/1024