mysql db tables 별로 데이타 사용량 확인 쿼리

SELECT TABLE_NAME AS "Tables",   round(((data_length + index_length) / 1024 / 1024), 2) "Size in MB"

FROM information_schema.TABLES

WHERE table_schema = "dbname"

ORDER BY (data_length + index_length) DESC;