mysql (1) 썸네일형 리스트형 [MySQL] DB/Table/Column 용량 확인 DB 용량 확인 SELECT table_schema AS 'DATABASE', ROUND(SUM(data_length+index_length)/(1024*1024), 2) AS 'Size(MB)' FROM information_schema.tables WHERE TABLE_SCHEMA not in ('sys', 'mysql', 'information_schema','performance_shcema') GROUP BY table_schema ORDER BY 2 DESC; Table 별 용량 확인 SELECT table_name as 'TableName', ROUND(SUM(data_length+index_length)/(1024*1024), 2) AS 'All(MB)', ROUND(SUM(data_len.. 이전 1 다음