데이터베이스 내 각 테이블 용량 확인(내림차순)

 

SELECT table_name AS "테이블명", 
       round(((data_length + index_length) / 1024 / 1024), 2) AS "테이블 용량(MB)"
FROM information_schema.tables 
WHERE table_schema = 'your_database_name'
ORDER BY (data_length + index_length) DESC;