mysql에서 테이블 레코드수, 용량 확인

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)',

    TABLE_COMMENT

FROM information_schema.TABLES

where table_schema = '디비명'

GROUP BY table_name 

ORDER BY table_name ASC