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;