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;
'Dev. | Coding | DB > MySQL' 카테고리의 다른 글
애플리케이션 구조에 맞게 MariaDB 를 배포/초기화 간편화 방법 (0) | 2023.09.10 |
---|