Mysql 테이블 별 사이즈, Row개수 출력

Mysql 테이블 별 사이즈, Row개수 출력

select 
	TABLE_NAME, 
    TABLE_ROWS, 
    DATA_LENGTH, 
    INDEX_LENGTH, 
    ROUND((DATA_LENGTH + INDEX_LENGTH)/1024/1024) AS 'TOTAL SIZE (MB)' 
from 
	information_schema.TABLES
where 
	TABLE_TYPE='BASE TABLE';