테이블(table)별 용량 확인 쿼리
마스터욱
0
23
0
0
2018-10-25 10:51:19
SELECT
table_name,
table_rows,
round(data_length/(1024*1024),2) as 'DATA_SIZE(MB)',
round(index_length/(1024*1024),2) as 'INDEX_SIZE(MB)'
FROM information_schema.TABLES
where table_schema = 데이터베이스명
ORDER BY data_length DESC