MySQL 용량 확인

MySQL 용량 확인

• 데이터베이스별 용량 확인

  SELECT table_schema "Database Name",
  SUM(data_length + index_length) / 1024 / 1024 "Size(MB)"
  FROM information_schema.TABLES
  GROUP BY table_schema;

• 테이블별 용량 확인

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