MySQL 테이블 스키마 용량 확인
SELECT concat(TABLE_SCHEMA,'.',TABLE_NAME) as Database_Tablename , TABLE_ROWS as TableRows , concat(round(DATA_LENGTH/(1024*1024),2),'M') Data , concat(round(INDEX_LENGTH/(1024*1024),2),'M') Idx , concat(round((DATA_LENGTH+INDEX_LENGTH)/(1024*1024),2),'M') Total_size , round(INDEX_LENGTH/DATA_LENGTH,2) Idxfrac FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'Scheme_Name' ORDER BY TABLE_ROWS ..