{"id":51656,"date":"2024-08-15T03:46:45","date_gmt":"2024-08-14T18:46:45","guid":{"rendered":"https:\/\/m9js.shop\/blog\/development\/mysql-disk-space-problems-and-how-to-fix-them"},"modified":"2024-08-15T03:46:45","modified_gmt":"2024-08-14T18:46:45","slug":"mysql-disk-space-problems-and-how-to-fix-them","status":"publish","type":"post","link":"https:\/\/m9js.shop\/blog\/development\/mysql-disk-space-problems-and-how-to-fix-them","title":{"rendered":"MySQL\uc758 \ub514\uc2a4\ud06c \uacf5\uac04 \ubd80\uc871 \ubb38\uc81c\uc640 \uadf8 \ud574\uacb0 \ubc29\ubc95"},"content":{"rendered":"
MySQL\uc740 \uc804 \uc138\uacc4\uc801\uc73c\ub85c \uac00\uc7a5 \ub110\ub9ac \uc0ac\uc6a9\ub418\ub294 \uc624\ud508 \uc18c\uc2a4 \uad00\uacc4\ud615 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uad00\ub9ac \uc2dc\uc2a4\ud15c(RDBMS) \uc911 \ud558\ub098\uc785\ub2c8\ub2e4. \uadf8\ub7ec\ub098 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \uc6b4\uc601\ud558\ub2e4 \ubcf4\uba74 \ub514\uc2a4\ud06c \uacf5\uac04 \ubd80\uc871 \ubb38\uc81c\uc5d0 \uc9c1\uba74\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc774 \ubb38\uc81c\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \uc131\ub2a5 \uc800\ud558, \uc11c\ube44\uc2a4 \uc911\ub2e8, \ub370\uc774\ud130 \uc190\uc2e4 \ub4f1\uc758 \uc2ec\uac01\ud55c \uacb0\uacfc\ub97c \ucd08\ub798\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ubcf8 \uae00\uc5d0\uc11c\ub294 MySQL\uc758 \ub514\uc2a4\ud06c \uacf5\uac04 \ubd80\uc871 \ubb38\uc81c\ub97c \ub2e4\ub8e8\uace0, \uc774\ub97c \ud574\uacb0\ud558\uae30 \uc704\ud55c \ub2e4\uc591\ud55c \ubc29\ubc95\uc744 \uc81c\uc2dc\ud558\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n
MySQL\uc758 \ub514\uc2a4\ud06c \uacf5\uac04 \ubd80\uc871 \ubb38\uc81c\ub294 \uc5ec\ub7ec \uac00\uc9c0 \uc6d0\uc778\uc73c\ub85c \ubc1c\uc0dd\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uac00\uc7a5 \uc77c\ubc18\uc801\uc778 \uc6d0\uc778\uc740 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4.<\/p>\n
\uc774\ub7ec\ud55c \uc6d0\uc778\ub4e4\uc740 \uac01\uac01 \ub2e4\ub978 \ubc29\uc2dd\uc73c\ub85c \ub514\uc2a4\ud06c \uacf5\uac04\uc744 \uc18c\ubaa8\ud558\uac8c \ub429\ub2c8\ub2e4. \uc608\ub97c \ub4e4\uc5b4, \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \uae09\uaca9\ud55c \uc131\uc7a5\uc740 \uc0c8\ub85c\uc6b4 \ub370\uc774\ud130\uac00 \uc9c0\uc18d\uc801\uc73c\ub85c \ucd94\uac00\ub418\uba74\uc11c \ub514\uc2a4\ud06c \uacf5\uac04\uc744 \ube60\ub974\uac8c \uc18c\ubaa8\ud558\uac8c \ub429\ub2c8\ub2e4. \ub610\ud55c, \ub85c\uadf8 \ud30c\uc77c\uc740 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \ubaa8\ub4e0 \ud2b8\ub79c\uc7ad\uc158\uc744 \uae30\ub85d\ud558\uae30 \ub54c\ubb38\uc5d0, \uc774 \ud30c\uc77c\uc774 \ube44\uc815\uc0c1\uc801\uc73c\ub85c \uc99d\uac00\ud558\uba74 \ub514\uc2a4\ud06c \uacf5\uac04\uc744 \ud06c\uac8c \ucc28\uc9c0\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n
\uc778\ub371\uc2a4\ub294 \ub370\uc774\ud130 \uac80\uc0c9 \uc18d\ub3c4\ub97c \ub192\uc774\uae30 \uc704\ud574 \uc0ac\uc6a9\ub418\uc9c0\ub9cc, \uc778\ub371\uc2a4\uac00 \ube44\ud6a8\uc728\uc801\uc73c\ub85c \uc0ac\uc6a9\ub418\uba74 \uc624\ud788\ub824 \ub514\uc2a4\ud06c \uacf5\uac04\uc744 \ub0ad\ube44\ud558\uac8c \ub429\ub2c8\ub2e4. \ubd88\ud544\uc694\ud55c \ub370\uc774\ud130\ub294 \uc8fc\uae30\uc801\uc73c\ub85c \uc815\ub9ac\ud558\uc9c0 \uc54a\uc73c\uba74 \uc313\uc774\uac8c \ub418\uc5b4 \ub514\uc2a4\ud06c \uacf5\uac04\uc744 \ucc28\uc9c0\ud558\uac8c \ub429\ub2c8\ub2e4. \ub9c8\uc9c0\ub9c9\uc73c\ub85c, \ubc31\uc5c5 \ud30c\uc77c\uc740 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \uc548\uc804\uc131\uc744 \ub192\uc774\uae30 \uc704\ud574 \ud544\uc694\ud558\uc9c0\ub9cc, \uc774\ub97c \uad00\ub9ac\ud558\uc9c0 \uc54a\uc73c\uba74 \ub514\uc2a4\ud06c \uacf5\uac04\uc744 \uacfc\ub3c4\ud558\uac8c \uc18c\ubaa8\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n
\ub514\uc2a4\ud06c \uacf5\uac04 \ubd80\uc871 \ubb38\uc81c\ub294 \uc5ec\ub7ec \uac00\uc9c0 \uc99d\uc0c1\uc73c\ub85c \ub098\ud0c0\ub0a9\ub2c8\ub2e4. \uc774\ub7ec\ud55c \uc99d\uc0c1\uc744 \uc870\uae30\uc5d0 \uc778\uc2dd\ud558\ub294 \uac83\uc774 \uc911\uc694\ud569\ub2c8\ub2e4.<\/p>\n
\ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc5f0\uacb0 \uc624\ub958\ub294 \ub514\uc2a4\ud06c \uacf5\uac04\uc774 \ubd80\uc871\ud560 \ub54c \uac00\uc7a5 \uba3c\uc800 \ub098\ud0c0\ub098\ub294 \uc99d\uc0c1 \uc911 \ud558\ub098\uc785\ub2c8\ub2e4. \uc774 \uacbd\uc6b0, \uc0c8\ub85c\uc6b4 \uc5f0\uacb0\uc744 \uc0dd\uc131\ud560 \uc218 \uc5c6\uac8c \ub418\uc5b4 \uc11c\ube44\uc2a4 \uc911\ub2e8\uc774 \ubc1c\uc0dd\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ud2b8\ub79c\uc7ad\uc158 \uc2e4\ud328\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0 \ub370\uc774\ud130\ub97c \ucd94\uac00\ud558\uac70\ub098 \uc218\uc815\ud560 \ub54c \ubc1c\uc0dd\ud558\uba70, \uc774\ub294 \uc0ac\uc6a9\uc790\uc5d0\uac8c \ud070 \ubd88\ud3b8\uc744 \ucd08\ub798\ud569\ub2c8\ub2e4.<\/p>\n
\ucffc\ub9ac \uc2e4\ud589 \uc9c0\uc5f0\uc740 \ub514\uc2a4\ud06c \uacf5\uac04 \ubd80\uc871\uc73c\ub85c \uc778\ud574 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \uc131\ub2a5\uc774 \uc800\ud558\ub420 \ub54c \ubc1c\uc0dd\ud569\ub2c8\ub2e4. \uc774\ub85c \uc778\ud574 \uc0ac\uc6a9\uc790 \uacbd\ud5d8\uc774 \ub098\ube60\uc9c8 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ub85c\uadf8 \ud30c\uc77c \ud06c\uae30 \uc99d\uac00 \uc5ed\uc2dc \ub514\uc2a4\ud06c \uacf5\uac04 \ubd80\uc871\uc758 \uc9d5\ud6c4\ub85c, \ub85c\uadf8 \ud30c\uc77c\uc774 \uacfc\ub3c4\ud558\uac8c \ucee4\uc9c0\uba74 \ub514\uc2a4\ud06c \uacf5\uac04\uc744 \ube60\ub974\uac8c \uc18c\ubaa8\ud558\uac8c \ub429\ub2c8\ub2e4. \ub9c8\uc9c0\ub9c9\uc73c\ub85c, \uc11c\ubc84 \uc131\ub2a5 \uc800\ud558\ub294 \ub514\uc2a4\ud06c \uacf5\uac04 \ubd80\uc871\uc73c\ub85c \uc778\ud574 \ubc1c\uc0dd\ud558\ub294 \uc5ec\ub7ec \ubb38\uc81c\uc758 \uacb0\uacfc\ub85c \ub098\ud0c0\ub0a9\ub2c8\ub2e4.<\/p>\n
\ub514\uc2a4\ud06c \uacf5\uac04 \ubd80\uc871 \ubb38\uc81c\ub97c \uc608\ubc29\ud558\uace0 \ud574\uacb0\ud558\uae30 \uc704\ud574\uc11c\ub294 \ud6a8\uacfc\uc801\uc778 \ub514\uc2a4\ud06c \uacf5\uac04 \uad00\ub9ac\uac00 \ud544\uc694\ud569\ub2c8\ub2e4. \ub2e4\uc74c\uc740 MySQL\uc5d0\uc11c \ub514\uc2a4\ud06c \uacf5\uac04\uc744 \ud6a8\uc728\uc801\uc73c\ub85c \uad00\ub9ac\ud558\ub294 \ubc29\ubc95\uc785\ub2c8\ub2e4.<\/p>\n
\uc815\uae30\uc801\uc778 \ub370\uc774\ud130 \uc815\ub9ac\ub294 \ubd88\ud544\uc694\ud55c \ub370\uc774\ud130\ub97c \uc0ad\uc81c\ud558\uac70\ub098 \uc544\uce74\uc774\ube0c\ud558\uc5ec \ub514\uc2a4\ud06c \uacf5\uac04\uc744 \ud655\ubcf4\ud558\ub294 \ubc29\ubc95\uc785\ub2c8\ub2e4. \uc608\ub97c \ub4e4\uc5b4, \uc624\ub798\ub41c \ub85c\uadf8 \ub370\uc774\ud130\ub97c \uc0ad\uc81c\ud558\uac70\ub098, \uc0ac\uc6a9\ud558\uc9c0 \uc54a\ub294 \ud14c\uc774\ube14\uc744 \uc81c\uac70\ud558\ub294 \uac83\uc774 \ud3ec\ud568\ub429\ub2c8\ub2e4. \ub85c\uadf8 \ud30c\uc77c \uad00\ub9ac\ub294 \ub85c\uadf8 \ud30c\uc77c\uc758 \ud06c\uae30\ub97c \uc81c\ud55c\ud558\uac70\ub098 \uc8fc\uae30\uc801\uc73c\ub85c \uc0ad\uc81c\ud558\uc5ec \ub514\uc2a4\ud06c \uacf5\uac04\uc744 \ud655\ubcf4\ud558\ub294 \ubc29\ubc95\uc785\ub2c8\ub2e4.<\/p>\n
\uc778\ub371\uc2a4 \ucd5c\uc801\ud654\ub294 \ubd88\ud544\uc694\ud55c \uc778\ub371\uc2a4\ub97c \uc81c\uac70\ud558\uac70\ub098, \uc778\ub371\uc2a4 \uad6c\uc870\ub97c \uc7ac\uc870\uc815\ud558\uc5ec \ub514\uc2a4\ud06c \uacf5\uac04\uc744 \uc808\uc57d\ud558\ub294 \ubc29\ubc95\uc785\ub2c8\ub2e4. \ubc31\uc5c5 \ud30c\uc77c \uad00\ub9ac\ub294 \uc624\ub798\ub41c \ubc31\uc5c5 \ud30c\uc77c\uc744 \uc0ad\uc81c\ud558\uac70\ub098 \uc678\ubd80 \uc800\uc7a5\uc18c\ub85c \uc774\ub3d9\ud558\uc5ec \ub514\uc2a4\ud06c \uacf5\uac04\uc744 \ud655\ubcf4\ud558\ub294 \ubc29\ubc95\uc785\ub2c8\ub2e4. \ub9c8\uc9c0\ub9c9\uc73c\ub85c, \ud30c\ud2f0\uc154\ub2dd\uc740 \ub300\uc6a9\ub7c9 \ud14c\uc774\ube14\uc744 \uc5ec\ub7ec \uac1c\uc758 \uc791\uc740 \ud14c\uc774\ube14\ub85c \ub098\ub204\uc5b4 \uad00\ub9ac\ud568\uc73c\ub85c\uc368 \uc131\ub2a5\uc744 \ud5a5\uc0c1\uc2dc\ud0a4\uace0 \ub514\uc2a4\ud06c \uacf5\uac04\uc744 \ud6a8\uc728\uc801\uc73c\ub85c \uc0ac\uc6a9\ud560 \uc218 \uc788\uac8c \ud569\ub2c8\ub2e4.<\/p>\n
\ub514\uc2a4\ud06c \uacf5\uac04 \ubd80\uc871 \ubb38\uc81c\uac00 \ubc1c\uc0dd\ud588\uc744 \ub54c, \uc774\ub97c \ud574\uacb0\ud558\uae30 \uc704\ud55c \uad6c\uccb4\uc801\uc778 \ubc29\ubc95\uc740 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4.<\/p>\n
\ub514\uc2a4\ud06c \uc0ac\uc6a9\ub7c9 \ud655\uc778\uc740 MySQL\uc758 `SHOW TABLE STATUS` \uba85\ub839\uc5b4\ub97c \uc0ac\uc6a9\ud558\uc5ec \uac01 \ud14c\uc774\ube14\uc758 \ud06c\uae30\ub97c \ud655\uc778\ud558\ub294 \ubc29\ubc95\uc785\ub2c8\ub2e4. \uc774\ub97c \ud1b5\ud574 \uc5b4\ub5a4 \ud14c\uc774\ube14\uc774 \ub9ce\uc740 \ub514\uc2a4\ud06c \uacf5\uac04\uc744 \ucc28\uc9c0\ud558\uace0 \uc788\ub294\uc9c0 \ud30c\uc545\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n
SHOW TABLE STATUS;<\/code><\/pre>\n\ubd88\ud544\uc694\ud55c \ub370\uc774\ud130 \uc0ad\uc81c\ub294 `DELETE` \uba85\ub839\uc5b4\ub97c \uc0ac\uc6a9\ud558\uc5ec \ud2b9\uc815 \uc870\uac74\uc5d0 \ub9de\ub294 \ub370\uc774\ud130\ub97c \uc0ad\uc81c\ud558\ub294 \ubc29\ubc95\uc785\ub2c8\ub2e4. \uc608\ub97c \ub4e4\uc5b4, \ud2b9\uc815 \ub0a0\uc9dc \uc774\uc804\uc758 \ub370\uc774\ud130\ub97c \uc0ad\uc81c\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n
DELETE FROM \ud14c\uc774\ube14\uba85 WHERE \ub0a0\uc9dc\uceec\ub7fc < '2023-01-01';<\/code><\/pre>\n\ub85c\uadf8 \ud30c\uc77c \uc555\ucd95 \ubc0f \uc0ad\uc81c\ub294 `gzip`\uc640 \uac19\uc740 \ub3c4\uad6c\ub97c \uc0ac\uc6a9\ud558\uc5ec \ub85c\uadf8 \ud30c\uc77c\uc744 \uc555\ucd95\ud558\uace0, \uc624\ub798\ub41c \ub85c\uadf8 \ud30c\uc77c\uc740 \uc0ad\uc81c\ud558\ub294 \ubc29\ubc95\uc785\ub2c8\ub2e4. \uc778\ub371\uc2a4 \uc7ac\uad6c\uc131\uc740 `OPTIMIZE TABLE` \uba85\ub839\uc5b4\ub97c \uc0ac\uc6a9\ud558\uc5ec \uc778\ub371\uc2a4\ub97c \uc7ac\uad6c\uc131\ud558\uace0 \ub514\uc2a4\ud06c \uacf5\uac04\uc744 \ud68c\uc218\ud558\ub294 \ubc29\ubc95\uc785\ub2c8\ub2e4.<\/p>\n
OPTIMIZE TABLE \ud14c\uc774\ube14\uba85;<\/code><\/pre>\n\ubc31\uc5c5 \ud30c\uc77c \uc815\ub9ac\ub294 \uc624\ub798\ub41c \ubc31\uc5c5 \ud30c\uc77c\uc744 \uc0ad\uc81c\ud558\uac70\ub098 \uc678\ubd80 \uc800\uc7a5\uc18c\ub85c \uc774\ub3d9\ud558\uc5ec \ub514\uc2a4\ud06c \uacf5\uac04\uc744 \ud655\ubcf4\ud558\ub294 \ubc29\ubc95\uc785\ub2c8\ub2e4. \uc774\ub7ec\ud55c \ubc29\ubc95\ub4e4\uc744 \ud1b5\ud574 MySQL\uc758 \ub514\uc2a4\ud06c \uacf5\uac04 \ubd80\uc871 \ubb38\uc81c\ub97c \ud6a8\uacfc\uc801\uc73c\ub85c \ud574\uacb0\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n
5. MySQL \ub514\uc2a4\ud06c \uacf5\uac04 \ubaa8\ub2c8\ud130\ub9c1 \ub3c4\uad6c<\/h2>\n
MySQL\uc758 \ub514\uc2a4\ud06c \uacf5\uac04\uc744 \ud6a8\uacfc\uc801\uc73c\ub85c \uad00\ub9ac\ud558\uae30 \uc704\ud574\uc11c\ub294 \ubaa8\ub2c8\ud130\ub9c1 \ub3c4\uad6c\ub97c \uc0ac\uc6a9\ud558\ub294 \uac83\uc774 \uc911\uc694\ud569\ub2c8\ub2e4. \ub2e4\uc74c\uc740 MySQL\uc5d0\uc11c \uc0ac\uc6a9\ud560 \uc218 \uc788\ub294 \uba87 \uac00\uc9c0 \ubaa8\ub2c8\ud130\ub9c1 \ub3c4\uad6c\uc785\ub2c8\ub2e4.<\/p>\n
\n- MySQL Workbench<\/li>\n
- phpMyAdmin<\/li>\n
- Percona Monitoring and Management (PMM)<\/li>\n
- Grafana\uc640 Prometheus<\/li>\n
- Nagios<\/li>\n<\/ul>\n
MySQL Workbench\ub294 MySQL \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \uad00\ub9ac\ud558\uace0 \ubaa8\ub2c8\ud130\ub9c1\ud560 \uc218 \uc788\ub294 GUI \ub3c4\uad6c\ub85c, \ub514\uc2a4\ud06c \uc0ac\uc6a9\ub7c9\uc744 \uc2dc\uac01\uc801\uc73c\ub85c \ud655\uc778\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. phpMyAdmin\uc740 \uc6f9 \uae30\ubc18\uc758 MySQL \uad00\ub9ac \ub3c4\uad6c\ub85c, \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc640 \ud14c\uc774\ube14\uc758 \ud06c\uae30\ub97c \uc27d\uac8c \ud655\uc778\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n
Percona Monitoring and Management (PMM)\ub294 MySQL \uc131\ub2a5 \ubaa8\ub2c8\ud130\ub9c1 \ubc0f \uad00\ub9ac \ub3c4\uad6c\ub85c, \uc2e4\uc2dc\uac04\uc73c\ub85c \ub514\uc2a4\ud06c \uc0ac\uc6a9\ub7c9\uacfc \uc131\ub2a5 \uc9c0\ud45c\ub97c \ubaa8\ub2c8\ud130\ub9c1\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. Grafana\uc640 Prometheus\ub294 \uc624\ud508 \uc18c\uc2a4 \ubaa8\ub2c8\ud130\ub9c1 \ub3c4\uad6c\ub85c, MySQL\uc758 \uc131\ub2a5 \uc9c0\ud45c\ub97c \uc2dc\uac01\ud654\ud558\uc5ec \ubaa8\ub2c8\ud130\ub9c1\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n
Nagios\ub294 \uc11c\ubc84 \ubc0f \ub124\ud2b8\uc6cc\ud06c \ubaa8\ub2c8\ud130\ub9c1 \ub3c4\uad6c\ub85c, MySQL \uc11c\ubc84\uc758 \uc0c1\ud0dc\uc640 \ub514\uc2a4\ud06c \uc0ac\uc6a9\ub7c9\uc744 \ubaa8\ub2c8\ud130\ub9c1\ud560 \uc218 \uc788\ub294 \uae30\ub2a5\uc744 \uc81c\uacf5\ud569\ub2c8\ub2e4. \uc774\ub7ec\ud55c \ub3c4\uad6c\ub4e4\uc744 \ud65c\uc6a9\ud558\uba74 MySQL\uc758 \ub514\uc2a4\ud06c \uacf5\uac04\uc744 \ud6a8\uacfc\uc801\uc73c\ub85c \uad00\ub9ac\ud558\uace0 \ubaa8\ub2c8\ud130\ub9c1\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n
6. MySQL \uc131\ub2a5 \ucd5c\uc801\ud654\uc640 \ub514\uc2a4\ud06c \uacf5\uac04 \uad00\ub9ac<\/h2>\n
MySQL\uc758 \uc131\ub2a5 \ucd5c\uc801\ud654\ub294 \ub514\uc2a4\ud06c \uacf5\uac04 \uad00\ub9ac\uc640 \ubc00\uc811\ud55c \uad00\ub828\uc774 \uc788\uc2b5\ub2c8\ub2e4. \uc131\ub2a5\uc774 \uc800\ud558\ub418\uba74 \ubd88\ud544\uc694\ud55c \ub370\uc774\ud130\uac00 \uc313\uc774\uac8c \ub418\uace0, \uc774\ub294 \ub514\uc2a4\ud06c \uacf5\uac04 \ubd80\uc871 \ubb38\uc81c\ub85c \uc774\uc5b4\uc9c8 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ub530\ub77c\uc11c \uc131\ub2a5 \ucd5c\uc801\ud654\uc640 \ub514\uc2a4\ud06c \uacf5\uac04 \uad00\ub9ac\ub294 \ud568\uaed8 \uc774\ub8e8\uc5b4\uc838\uc57c \ud569\ub2c8\ub2e4.<\/p>\n
\n- \ucffc\ub9ac \ucd5c\uc801\ud654<\/li>\n
- \uc778\ub371\uc2a4 \ucd5c\uc801\ud654<\/li>\n
- \uce90\uc2f1 \uc0ac\uc6a9<\/li>\n
- \ud558\ub4dc\uc6e8\uc5b4 \uc5c5\uadf8\ub808\uc774\ub4dc<\/li>\n
- \ub370\uc774\ud130 \uc544\uce74\uc774\ube59<\/li>\n<\/ul>\n
\ucffc\ub9ac \ucd5c\uc801\ud654\ub294 \ube44\ud6a8\uc728\uc801\uc778 \ucffc\ub9ac\ub97c \uac1c\uc120\ud558\uc5ec \uc131\ub2a5\uc744 \ud5a5\uc0c1\uc2dc\ud0a4\ub294 \ubc29\ubc95\uc785\ub2c8\ub2e4. \uc608\ub97c \ub4e4\uc5b4, `JOIN` \ucffc\ub9ac\ub97c \ucd5c\uc801\ud654\ud558\uac70\ub098 \uc11c\ube0c\ucffc\ub9ac\ub97c \uc0ac\uc6a9\ud558\ub294 \ub300\uc2e0 `JOIN`\uc744 \uc0ac\uc6a9\ud558\ub294 \uac83\uc774 \ud3ec\ud568\ub429\ub2c8\ub2e4.<\/p>\n
SELECT a.*, b.* FROM \ud14c\uc774\ube14A a JOIN \ud14c\uc774\ube14B b ON a.id = b.id;<\/code><\/pre>\n\uc778\ub371\uc2a4 \ucd5c\uc801\ud654\ub294 \ubd88\ud544\uc694\ud55c \uc778\ub371\uc2a4\ub97c \uc81c\uac70\ud558\uac70\ub098 \ud544\uc694\ud55c \uc778\ub371\uc2a4\ub97c \ucd94\uac00\ud558\uc5ec \uc131\ub2a5\uc744 \ud5a5\uc0c1\uc2dc\ud0a4\ub294 \ubc29\ubc95\uc785\ub2c8\ub2e4. \uce90\uc2f1 \uc0ac\uc6a9\uc740 \uc790\uc8fc \uc870\ud68c\ub418\ub294 \ub370\uc774\ud130\ub97c \uba54\ubaa8\ub9ac\uc5d0 \uc800\uc7a5\ud558\uc5ec \uc131\ub2a5\uc744 \ud5a5\uc0c1\uc2dc\ud0a4\ub294 \ubc29\ubc95\uc785\ub2c8\ub2e4.<\/p>\n
\ud558\ub4dc\uc6e8\uc5b4 \uc5c5\uadf8\ub808\uc774\ub4dc\ub294 \uc11c\ubc84\uc758 \ud558\ub4dc\uc6e8\uc5b4 \uc131\ub2a5\uc744 \ud5a5\uc0c1\uc2dc\ucf1c MySQL\uc758 \uc131\ub2a5\uc744 \uac1c\uc120\ud558\ub294 \ubc29\ubc95\uc785\ub2c8\ub2e4. \ub9c8\uc9c0\ub9c9\uc73c\ub85c, \ub370\uc774\ud130 \uc544\uce74\uc774\ube59\uc740 \uc624\ub798\ub41c \ub370\uc774\ud130\ub97c \ubcc4\ub3c4\uc758 \uc800\uc7a5\uc18c\ub85c \uc774\ub3d9\ud558\uc5ec \ub514\uc2a4\ud06c \uacf5\uac04\uc744 \ud655\ubcf4\ud558\ub294 \ubc29\ubc95\uc785\ub2c8\ub2e4.<\/p>\n
7. MySQL \ubc31\uc5c5 \ubc0f \ubcf5\uc6d0 \uc804\ub7b5<\/h2>\n
MySQL\uc5d0\uc11c \ub370\uc774\ud130\ub97c \uc548\uc804\ud558\uac8c \ubcf4\ud638\ud558\uae30 \uc704\ud574\uc11c\ub294 \ubc31\uc5c5 \ubc0f \ubcf5\uc6d0 \uc804\ub7b5\uc774 \ud544\uc694\ud569\ub2c8\ub2e4. \ubc31\uc5c5 \ud30c\uc77c\uc740 \ub514\uc2a4\ud06c \uacf5\uac04\uc744 \ucc28\uc9c0\ud558\uc9c0\ub9cc, \uc774\ub97c \ud6a8\uc728\uc801\uc73c\ub85c \uad00\ub9ac\ud558\uba74 \ub514\uc2a4\ud06c \uacf5\uac04 \ubd80\uc871 \ubb38\uc81c\ub97c \uc608\ubc29\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n
\n- \uc815\uae30\uc801\uc778 \ubc31\uc5c5 \uc218\ud589<\/li>\n
- \uc99d\ubd84 \ubc31\uc5c5 \uc0ac\uc6a9<\/li>\n
- \uc678\ubd80 \uc800\uc7a5\uc18c \ud65c\uc6a9<\/li>\n
- \ubc31\uc5c5 \ud30c\uc77c \uc555\ucd95<\/li>\n
- \ubc31\uc5c5 \uc815\ucc45 \uc218\ub9bd<\/li>\n<\/ul>\n
\uc815\uae30\uc801\uc778 \ubc31\uc5c5 \uc218\ud589\uc740 \ub370\uc774\ud130 \uc190\uc2e4\uc744 \ubc29\uc9c0\ud558\uae30 \uc704\ud574 \ud544\uc218\uc801\uc785\ub2c8\ub2e4. \uc99d\ubd84 \ubc31\uc5c5\uc740 \ubcc0\uacbd\ub41c \ub370\uc774\ud130\ub9cc \ubc31\uc5c5\ud558\uc5ec \ub514\uc2a4\ud06c \uacf5\uac04\uc744 \uc808\uc57d\ud558\ub294 \ubc29\ubc95\uc785\ub2c8\ub2e4. \uc678\ubd80 \uc800\uc7a5\uc18c \ud65c\uc6a9\uc740 \ud074\ub77c\uc6b0\ub4dc \uc2a4\ud1a0\ub9ac\uc9c0\ub098 \uc678\ubd80 \ud558\ub4dc \ub4dc\ub77c\uc774\ube0c\uc5d0 \ubc31\uc5c5 \ud30c\uc77c\uc744 \uc800\uc7a5\ud558\uc5ec \uc11c\ubc84\uc758 \ub514\uc2a4\ud06c \uacf5\uac04\uc744 \uc808\uc57d\ud558\ub294 \ubc29\ubc95\uc785\ub2c8\ub2e4.<\/p>\n
\ubc31\uc5c5 \ud30c\uc77c \uc555\ucd95\uc740 `gzip`\uc640 \uac19\uc740 \ub3c4\uad6c\ub97c \uc0ac\uc6a9\ud558\uc5ec \ubc31\uc5c5 \ud30c\uc77c\uc758 \ud06c\uae30\ub97c \uc904\uc774\ub294 \ubc29\ubc95\uc785\ub2c8\ub2e4. \ub9c8\uc9c0\ub9c9\uc73c\ub85c, \ubc31\uc5c5 \uc815\ucc45 \uc218\ub9bd\uc740 \ubc31\uc5c5 \uc8fc\uae30, \ubcf4\uad00 \uae30\uac04 \ub4f1\uc744 \uc815\ud558\uc5ec \uccb4\uacc4\uc801\uc73c\ub85c \ubc31\uc5c5\uc744 \uad00\ub9ac\ud558\ub294 \ubc29\ubc95\uc785\ub2c8\ub2e4.<\/p>\n
8. \uacb0\ub860: MySQL \ub514\uc2a4\ud06c \uacf5\uac04 \uad00\ub9ac\uc758 \uc911\uc694\uc131<\/h2>\n
MySQL\uc758 \ub514\uc2a4\ud06c \uacf5\uac04 \ubd80\uc871 \ubb38\uc81c\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc6b4\uc601\uc5d0 \uc788\uc5b4 \ub9e4\uc6b0 \uc911\uc694\ud55c \uc774\uc288\uc785\ub2c8\ub2e4. \uc774 \ubb38\uc81c\ub97c \ud574\uacb0\ud558\uae30 \uc704\ud574\uc11c\ub294 \uc6d0\uc778\uc744 \ud30c\uc545\ud558\uace0, \ud6a8\uacfc\uc801\uc778 \uad00\ub9ac \ubc0f \ubaa8\ub2c8\ud130\ub9c1 \uc804\ub7b5\uc744 \uc218\ub9bd\ud574\uc57c \ud569\ub2c8\ub2e4. \uc815\uae30\uc801\uc778 \ub370\uc774\ud130 \uc815\ub9ac, \ub85c\uadf8 \ud30c\uc77c \uad00\ub9ac, \uc778\ub371\uc2a4 \ucd5c\uc801\ud654, \ubc31\uc5c5 \ud30c\uc77c \uad00\ub9ac \ub4f1\uc744 \ud1b5\ud574 \ub514\uc2a4\ud06c \uacf5\uac04\uc744 \ud6a8\uc728\uc801\uc73c\ub85c \uc0ac\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n
\ub610\ud55c, MySQL \uc131\ub2a5 \ucd5c\uc801\ud654\uc640 \ud568\uaed8 \ub514\uc2a4\ud06c \uacf5\uac04 \uad00\ub9ac\ub97c \ubcd1\ud589\ud568\uc73c\ub85c\uc368 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \uc548\uc815\uc131\uacfc \uc131\ub2a5\uc744 \ub192\uc77c \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ub2e4\uc591\ud55c \ubaa8\ub2c8\ud130\ub9c1 \ub3c4\uad6c\ub97c \ud65c\uc6a9\ud558\uc5ec \uc2e4\uc2dc\uac04\uc73c\ub85c \ub514\uc2a4\ud06c \uc0ac\uc6a9\ub7c9\uc744 \uccb4\ud06c\ud558\uace0, \ubb38\uc81c\uac00 \ubc1c\uc0dd\ud558\uae30 \uc804\uc5d0 \uc608\ubc29 \uc870\uce58\ub97c \ucde8\ud558\ub294 \uac83\uc774 \uc911\uc694\ud569\ub2c8\ub2e4.<\/p>\n
\uacb0\ub860\uc801\uc73c\ub85c, MySQL\uc758 \ub514\uc2a4\ud06c \uacf5\uac04 \uad00\ub9ac\uc640 \ucd5c\uc801\ud654\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc6b4\uc601\uc758 \ud575\uc2ec \uc694\uc18c\uc774\uba70, \uc774\ub97c \ud1b5\ud574 \uc548\uc815\uc801\uc774\uace0 \ud6a8\uc728\uc801\uc778 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ud658\uacbd\uc744 \uad6c\ucd95\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n","protected":false},"excerpt":{"rendered":"
\ubaa9\ucc28 MySQL\uc758 \ub514\uc2a4\ud06c \uacf5\uac04 \ubd80\uc871 \ubb38\uc81c\uc640 \uadf8 \ud574\uacb0 \ubc29\ubc95 1. MySQL \ub514\uc2a4\ud06c \uacf5\uac04 \ubd80\uc871 \ubb38\uc81c\uc758 […]<\/p>\n","protected":false},"author":1,"featured_media":33704,"comment_status":"","ping_status":"","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[1957],"tags":[2351,2208,2100],"class_list":["post-51656","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-development","tag-management","tag-monitoring","tag-mysql"],"acf":[],"_links":{"self":[{"href":"https:\/\/m9js.shop\/blog\/wp-json\/wp\/v2\/posts\/51656","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/m9js.shop\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/m9js.shop\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/m9js.shop\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/m9js.shop\/blog\/wp-json\/wp\/v2\/comments?post=51656"}],"version-history":[{"count":0,"href":"https:\/\/m9js.shop\/blog\/wp-json\/wp\/v2\/posts\/51656\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/m9js.shop\/blog\/wp-json\/wp\/v2\/media\/33704"}],"wp:attachment":[{"href":"https:\/\/m9js.shop\/blog\/wp-json\/wp\/v2\/media?parent=51656"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/m9js.shop\/blog\/wp-json\/wp\/v2\/categories?post=51656"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/m9js.shop\/blog\/wp-json\/wp\/v2\/tags?post=51656"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}