Dev. | Coding | DB/MySQL
MySQL 테이블 스키마 용량 확인
가을타는넘
2021. 7. 13. 20:31
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 DESC, Total_size DESC;