[MySQL] 용량 확인 및 테이블 데이터 삭제

SELECT
	concat(table_schema,'.',table_name) AS "table",
	concat(round(data_length/(1024*1024),2)," MB") AS data,
	concat(round(index_length/(1024*1024),2)," MB") AS idx,
	concat(round((data_length+index_length)/(1024*1024),2)," MB") AS total_size,
	round(index_length/data_length,2) idxfrac
FROM 
	information_schema.TABLES
WHERE 
	table_rows is not null;

SELECT TABLE_NAME AS "Tables",
                     round(((data_length + index_length) / 1024 / 1024), 2) "Size in MB"
FROM information_schema.TABLES
WHERE table_schema = "exss"
ORDER BY (data_length + index_length) DESC;

 

테이블 데이터 idx = 1 제외하고 모두 삭제

DELETE FROM {table_name} WHERE idx <> 1;