MySQL 데이터베이스 테이블명 용량 확인 쿼리
마스터욱
0
33
0
0
2021-03-19 01:22:57
SELECT TABLE_NAME AS "Tables",
round(((data_length + index_length) / 1024 / 1024), 2) "Size in MB"
FROM information_schema.TABLES
WHERE table_schema = "데이터베이스명"
ORDER BY (data_length + index_length) DESC;
