https://www.adminschool.net/wiki/ 2026-04-22T06:18:49+00:00 https://www.adminschool.net/wiki/ https://www.adminschool.net/wiki/lib/exe/fetch.php?media=wiki:dokuwiki.svg text/html 2025-10-03T13:30:50+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adminschool.net/wiki/doku.php?id=dbms:mysql:admin:table&rev=1759498250&do=diff MySQL DB/테이블 사이즈 Table 최고 사이즈 SHOW TABLE STATUS FROM {DB_NAME} LIKE '{TABLE_NAME}'; * Create_options에 있는 max_rows와 avg_row_length를 곱한 값 용량 * 1024로 두번 나누면 MB 로 계산 DB 사이즈 SELECT count(*) NUM_OF_TABLE, table_schema, concat(round(sum(table_rows)/1000000,2),'M') rows, concat(round(sum(data_length)/(1024*1024*1024),2),'G') DATA, concat(round(sum(index_length)/(1024*1024*1024),2),'G') idx, concat(round(sum(data_length+index_length)/(1024*1024*1024),2),'G') total_size, round(sum(…