테이블별 로우 수, 용량

SELECT

    table_name,

    table_rows,

    round(data_length/(1024*1024),2) as 'DATA_SIZE(MB)',

    round(index_length/(1024*1024),2) as 'INDEX_SIZE(MB)'

 FROM information_schema.TABLES 

 WHERE table_schema = 'DB_name'

 GROUP BY table_name 

 ORDER BY data_length DESC LIMIT 10;

 

 

출처 : https://nexthops.tistory.com/27