\ubaa9\ucc28<\/h2>\n\n- \uc11c\ubc84 \uc18d\ub3c4 \uc800\ud558\uc640 MySQL \uc7a5\uc560: \ubb38\uc81c \ud574\uacb0\uc744 \uc704\ud55c \ub2e8\uacc4\ubcc4 \uac00\uc774\ub4dc<\/a><\/li>\n
- 1. \uc11c\ubc84 \uc18d\ub3c4 \uc800\ud558\uc758 \uc6d0\uc778 \ubd84\uc11d<\/a><\/li>\n
- 2. MySQL \uc7a5\uc560\uc758 \uc8fc\uc694 \uc6d0\uc778<\/a><\/li>\n
- 3. \uc11c\ubc84 \uc18d\ub3c4 \uc800\ud558 \uc9c4\ub2e8 \ubc29\ubc95<\/a><\/li>\n
- 4. MySQL \uc7a5\uc560 \uc9c4\ub2e8 \ubc29\ubc95<\/a><\/li>\n
- 5. \ubb38\uc81c \ud574\uacb0\uc744 \uc704\ud55c \ub2e8\uacc4\ubcc4 \uc811\uadfc\ubc95<\/a><\/li>\n
- 6. \uc608\ubc29 \uc870\uce58 \ubc0f \ucd5c\uc801\ud654 \ubc29\ubc95<\/a><\/li>\n
- 7. \uc0ac\ub840 \uc5f0\uad6c: \uc131\uacf5\uc801\uc778 \ubb38\uc81c \ud574\uacb0 \uc0ac\ub840<\/a><\/li>\n
- 8. \uacb0\ub860: \uc9c0\uc18d \uac00\ub2a5\ud55c \uc11c\ubc84 \uad00\ub9ac \uc804\ub7b5<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n
\uc11c\ubc84 \uc18d\ub3c4 \uc800\ud558\uc640 MySQL \uc7a5\uc560: \ubb38\uc81c \ud574\uacb0\uc744 \uc704\ud55c \ub2e8\uacc4\ubcc4 \uac00\uc774\ub4dc<\/h1>\n
![\"\uc11c\ubc84](\"https:\/\/m9js.shop\/blog\/wp-content\/uploads\/2024\/08\/4f845ad77637c35ee0eeee2c2652c940.jpeg\")
<\/p>\n
\ud604\ub300\uc758 \uc6f9 \ud658\uacbd\uc5d0\uc11c \uc11c\ubc84\uc758 \uc131\ub2a5\uc740 \ube44\uc988\ub2c8\uc2a4\uc758 \uc131\uacf5\uc5d0 \uacb0\uc815\uc801\uc778 \uc601\ud5a5\uc744 \ubbf8\uce69\ub2c8\ub2e4. \ud2b9\ud788, \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uad00\ub9ac \uc2dc\uc2a4\ud15c\uc778 MySQL\uc740 \ub9ce\uc740 \uc6f9 \uc560\ud50c\ub9ac\ucf00\uc774\uc158\uc758 \ud575\uc2ec \uc694\uc18c\ub85c \uc790\ub9ac \uc7a1\uace0 \uc788\uc2b5\ub2c8\ub2e4. \uadf8\ub7ec\ub098 \uc11c\ubc84 \uc18d\ub3c4\uac00 \uc800\ud558\ub418\uac70\ub098 MySQL \uc7a5\uc560\uac00 \ubc1c\uc0dd\ud558\uba74 \uc0ac\uc6a9\uc790 \uacbd\ud5d8\uc774 \ub098\ube60\uc9c0\uace0, \uc774\ub294 \uace7 \ub9e4\ucd9c \uac10\uc18c\ub85c \uc774\uc5b4\uc9c8 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ubcf8 \uac00\uc774\ub4dc\ub294 \uc11c\ubc84 \uc18d\ub3c4 \uc800\ud558\uc640 MySQL \uc7a5\uc560\uc758 \uc6d0\uc778, \ubb38\uc81c \ud574\uacb0 \ubc29\ubc95, \uc608\ubc29 \uc870\uce58 \ub4f1\uc744 \ub2e8\uacc4\ubcc4\ub85c \uc124\uba85\ud569\ub2c8\ub2e4.<\/p>\n
1. \uc11c\ubc84 \uc18d\ub3c4 \uc800\ud558\uc758 \uc6d0\uc778 \ubd84\uc11d<\/h2>\n
\uc11c\ubc84 \uc18d\ub3c4 \uc800\ud558\ub294 \uc5ec\ub7ec \uac00\uc9c0 \uc694\uc778\uc5d0 \uc758\ud574 \ubc1c\uc0dd\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc774 \uc139\uc158\uc5d0\uc11c\ub294 \uc8fc\uc694 \uc6d0\uc778\ub4e4\uc744 \uc0b4\ud3b4\ubcf4\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n
\n- \ud558\ub4dc\uc6e8\uc5b4 \uc131\ub2a5 \ubd80\uc871<\/li>\n
- \ub124\ud2b8\uc6cc\ud06c \ub300\uc5ed\ud3ed \uc81c\ud55c<\/li>\n
- \uc18c\ud504\ud2b8\uc6e8\uc5b4 \uc124\uc815 \uc624\ub958<\/li>\n
- \ud2b8\ub798\ud53d \uae09\uc99d<\/li>\n
- \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ucffc\ub9ac \ube44\ud6a8\uc728\uc131<\/li>\n<\/ul>\n
\uccab \ubc88\uc9f8\ub85c, \ud558\ub4dc\uc6e8\uc5b4 \uc131\ub2a5 \ubd80\uc871\uc740 \uc11c\ubc84\uc758 CPU, \uba54\ubaa8\ub9ac, \ub514\uc2a4\ud06c I\/O \uc131\ub2a5\uc774 \ub0ae\uc744 \ub54c \ubc1c\uc0dd\ud569\ub2c8\ub2e4. \uc608\ub97c \ub4e4\uc5b4, \uc6f9\uc0ac\uc774\ud2b8\uc5d0 \ub9ce\uc740 \uc0ac\uc6a9\uc790\uac00 \ub3d9\uc2dc\uc5d0 \uc811\uc18d\ud558\uba74 CPU \uc0ac\uc6a9\ub960\uc774 \uae09\uaca9\ud788 \uc99d\uac00\ud558\uc5ec \uc11c\ubc84 \uc18d\ub3c4\uac00 \ub290\ub824\uc9c8 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n
\ub450 \ubc88\uc9f8\ub85c, \ub124\ud2b8\uc6cc\ud06c \ub300\uc5ed\ud3ed \uc81c\ud55c\uc740 \uc11c\ubc84\uc640 \ud074\ub77c\uc774\uc5b8\ud2b8 \uac04\uc758 \ub370\uc774\ud130 \uc804\uc1a1 \uc18d\ub3c4\ub97c \uc800\ud558\uc2dc\ud0b5\ub2c8\ub2e4. \ud2b9\ud788, \ub300\uc6a9\ub7c9 \ud30c\uc77c\uc744 \uc804\uc1a1\ud560 \ub54c \uc774 \ubb38\uc81c\uac00 \ub450\ub4dc\ub7ec\uc9d1\ub2c8\ub2e4.<\/p>\n
\uc138 \ubc88\uc9f8\ub85c, \uc18c\ud504\ud2b8\uc6e8\uc5b4 \uc124\uc815 \uc624\ub958\ub294 \uc11c\ubc84\uc758 \uc6b4\uc601 \uccb4\uc81c\ub098 \uc6f9 \uc11c\ubc84 \uc18c\ud504\ud2b8\uc6e8\uc5b4\uc758 \uc798\ubabb\ub41c \uc124\uc815\uc73c\ub85c \uc778\ud574 \ubc1c\uc0dd\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc608\ub97c \ub4e4\uc5b4, Apache \uc6f9 \uc11c\ubc84\uc758 KeepAlive \uc124\uc815\uc774 \ube44\ud6a8\uc728\uc801\uc77c \uacbd\uc6b0 \uc5f0\uacb0\uc774 \ub290\ub824\uc9c8 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n
\ub124 \ubc88\uc9f8\ub85c, \ud2b8\ub798\ud53d \uae09\uc99d\uc740 \uc608\uc0c1\uce58 \ubabb\ud55c \uc0ac\uc6a9\uc790 \uc218\uc758 \uc99d\uac00\ub85c \uc778\ud574 \uc11c\ubc84\uac00 \uacfc\ubd80\ud558\uc5d0 \uac78\ub9ac\ub294 \uc0c1\ud669\uc785\ub2c8\ub2e4. \uc774 \uacbd\uc6b0, \ub85c\ub4dc \ubc38\ub7f0\uc11c\ub97c \ub3c4\uc785\ud558\uc5ec \uc5ec\ub7ec \uc11c\ubc84\uc5d0 \ud2b8\ub798\ud53d\uc744 \ubd84\uc0b0\uc2dc\ud0a4\ub294 \uac83\uc774 \ud6a8\uacfc\uc801\uc785\ub2c8\ub2e4.<\/p>\n
\ub9c8\uc9c0\ub9c9\uc73c\ub85c, \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ucffc\ub9ac \ube44\ud6a8\uc728\uc131\uc740 \uc798\ubabb\ub41c \uc778\ub371\uc2a4 \uc124\uc815\uc774\ub098 \ube44\ud6a8\uc728\uc801\uc778 \ucffc\ub9ac\ub85c \uc778\ud574 \ubc1c\uc0dd\ud569\ub2c8\ub2e4. \uc608\ub97c \ub4e4\uc5b4, SELECT \ucffc\ub9ac\uc5d0\uc11c WHERE \uc808\uc744 \uc0ac\uc6a9\ud558\uc9c0 \uc54a\uc73c\uba74 \uc804\uccb4 \ud14c\uc774\ube14\uc744 \uc2a4\uce94\ud558\uac8c \ub418\uc5b4 \uc131\ub2a5\uc774 \uc800\ud558\ub429\ub2c8\ub2e4.<\/p>\n
2. MySQL \uc7a5\uc560\uc758 \uc8fc\uc694 \uc6d0\uc778<\/h2>\n
MySQL \uc7a5\uc560\ub294 \ub2e4\uc591\ud55c \uc6d0\uc778\uc73c\ub85c \ubc1c\uc0dd\ud560 \uc218 \uc788\uc73c\uba70, \uc774\ub97c \uc774\ud574\ud558\ub294 \uac83\uc774 \uc911\uc694\ud569\ub2c8\ub2e4. \uc774 \uc139\uc158\uc5d0\uc11c\ub294 MySQL \uc7a5\uc560\uc758 \uc8fc\uc694 \uc6d0\uc778\uc744 \uc0b4\ud3b4\ubcf4\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n
\n- \ub514\uc2a4\ud06c \uacf5\uac04 \ubd80\uc871<\/li>\n
- \uba54\ubaa8\ub9ac \ubd80\uc871<\/li>\n
- \uc798\ubabb\ub41c \ucffc\ub9ac \uc2e4\ud589<\/li>\n
- \uc11c\ubc84 \ud06c\ub798\uc2dc<\/li>\n
- \ub124\ud2b8\uc6cc\ud06c \ubb38\uc81c<\/li>\n<\/ul>\n
\uccab \ubc88\uc9f8\ub85c, \ub514\uc2a4\ud06c \uacf5\uac04 \ubd80\uc871\uc740 MySQL \ub370\uc774\ud130\ubca0\uc774\uc2a4\uac00 \ub370\uc774\ud130\ub97c \uc800\uc7a5\ud560 \uacf5\uac04\uc774 \uc5c6\uc744 \ub54c \ubc1c\uc0dd\ud569\ub2c8\ub2e4. \uc774 \uacbd\uc6b0, \ub370\uc774\ud130\ubca0\uc774\uc2a4\uac00 \ub354 \uc774\uc0c1 \ub370\uc774\ud130\ub97c \uc0bd\uc785\ud560 \uc218 \uc5c6\uac8c \ub418\uc5b4 \uc7a5\uc560\uac00 \ubc1c\uc0dd\ud569\ub2c8\ub2e4.<\/p>\n
\ub450 \ubc88\uc9f8\ub85c, \uba54\ubaa8\ub9ac \ubd80\uc871\uc740 MySQL \uc11c\ubc84\uac00 \ud544\uc694\ud55c \uba54\ubaa8\ub9ac\ub97c \ud655\ubcf4\ud558\uc9c0 \ubabb\ud560 \ub54c \ubc1c\uc0dd\ud569\ub2c8\ub2e4. \uc774 \uacbd\uc6b0, \ucffc\ub9ac \uc2e4\ud589 \uc18d\ub3c4\uac00 \ub290\ub824\uc9c0\uac70\ub098 \uc11c\ubc84\uac00 \uc751\ub2f5\ud558\uc9c0 \uc54a\uc744 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n
\uc138 \ubc88\uc9f8\ub85c, \uc798\ubabb\ub41c \ucffc\ub9ac \uc2e4\ud589\uc740 \ube44\ud6a8\uc728\uc801\uc778 \ucffc\ub9ac\ub85c \uc778\ud574 MySQL \uc11c\ubc84\uac00 \uacfc\ubd80\ud558\uc5d0 \uac78\ub9ac\ub294 \uc0c1\ud669\uc785\ub2c8\ub2e4. \uc608\ub97c \ub4e4\uc5b4, JOIN \uc5f0\uc0b0\uc774 \ub9ce\uc740 \ucffc\ub9ac\ub294 \uc131\ub2a5 \uc800\ud558\ub97c \ucd08\ub798\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n
\ub124 \ubc88\uc9f8\ub85c, \uc11c\ubc84 \ud06c\ub798\uc2dc\ub294 \ud558\ub4dc\uc6e8\uc5b4 \uace0\uc7a5\uc774\ub098 \uc18c\ud504\ud2b8\uc6e8\uc5b4 \ubc84\uadf8\ub85c \uc778\ud574 \ubc1c\uc0dd\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc774 \uacbd\uc6b0, \ub370\uc774\ud130 \uc190\uc2e4\uc774 \ubc1c\uc0dd\ud560 \uc218 \uc788\uc73c\ubbc0\ub85c \uc815\uae30\uc801\uc778 \ubc31\uc5c5\uc774 \ud544\uc694\ud569\ub2c8\ub2e4.<\/p>\n
\ub9c8\uc9c0\ub9c9\uc73c\ub85c, \ub124\ud2b8\uc6cc\ud06c \ubb38\uc81c\ub294 MySQL \uc11c\ubc84\uc640 \ud074\ub77c\uc774\uc5b8\ud2b8 \uac04\uc758 \uc5f0\uacb0\uc774 \ubd88\uc548\uc815\ud560 \ub54c \ubc1c\uc0dd\ud569\ub2c8\ub2e4. \uc774 \uacbd\uc6b0, \ucffc\ub9ac \uc2e4\ud589\uc774 \uc9c0\uc5f0\ub418\uac70\ub098 \uc2e4\ud328\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n
3. \uc11c\ubc84 \uc18d\ub3c4 \uc800\ud558 \uc9c4\ub2e8 \ubc29\ubc95<\/h2>\n
\uc11c\ubc84 \uc18d\ub3c4 \uc800\ud558\ub97c \uc9c4\ub2e8\ud558\uae30 \uc704\ud574\uc11c\ub294 \uc5ec\ub7ec \uac00\uc9c0 \ub3c4\uad6c\uc640 \ubc29\ubc95\uc744 \uc0ac\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc774 \uc139\uc158\uc5d0\uc11c\ub294 \ud6a8\uacfc\uc801\uc778 \uc9c4\ub2e8 \ubc29\ubc95\uc744 \uc18c\uac1c\ud569\ub2c8\ub2e4.<\/p>\n
\n- \uc11c\ubc84 \ubaa8\ub2c8\ud130\ub9c1 \ub3c4\uad6c \uc0ac\uc6a9<\/li>\n
- \ub85c\uadf8 \ud30c\uc77c \ubd84\uc11d<\/li>\n
- \uc131\ub2a5 \ud14c\uc2a4\ud2b8 \uc218\ud589<\/li>\n
- \ucffc\ub9ac \uc131\ub2a5 \ubd84\uc11d<\/li>\n
- \ub124\ud2b8\uc6cc\ud06c \ud2b8\ub798\ud53d \ubd84\uc11d<\/li>\n<\/ul>\n
\uccab \ubc88\uc9f8\ub85c, \uc11c\ubc84 \ubaa8\ub2c8\ud130\ub9c1 \ub3c4\uad6c\ub97c \uc0ac\uc6a9\ud558\uba74 CPU \uc0ac\uc6a9\ub960, \uba54\ubaa8\ub9ac \uc0ac\uc6a9\ub7c9, \ub514\uc2a4\ud06c I\/O \ub4f1\uc744 \uc2e4\uc2dc\uac04\uc73c\ub85c \ubaa8\ub2c8\ud130\ub9c1\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc608\ub97c \ub4e4\uc5b4, Nagios\ub098 Zabbix\uc640 \uac19\uc740 \ub3c4\uad6c\ub97c \uc0ac\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n
\ub450 \ubc88\uc9f8\ub85c, \ub85c\uadf8 \ud30c\uc77c \ubd84\uc11d\uc740 \uc11c\ubc84\uc758 \uc624\ub958 \ubc0f \uacbd\uace0 \uba54\uc2dc\uc9c0\ub97c \ud655\uc778\ud558\ub294 \ub370 \uc720\uc6a9\ud569\ub2c8\ub2e4. Apache\ub098 Nginx\uc758 \ub85c\uadf8 \ud30c\uc77c\uc744 \ubd84\uc11d\ud558\uc5ec \ubb38\uc81c\uc758 \uc6d0\uc778\uc744 \ud30c\uc545\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n
\uc138 \ubc88\uc9f8\ub85c, \uc131\ub2a5 \ud14c\uc2a4\ud2b8\ub97c \uc218\ud589\ud558\uba74 \uc11c\ubc84\uc758 \ucd5c\ub300 \ucc98\ub9ac \ub2a5\ub825\uc744 \ud655\uc778\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. Apache Benchmark\ub098 JMeter\uc640 \uac19\uc740 \ub3c4\uad6c\ub97c \uc0ac\uc6a9\ud558\uc5ec \ubd80\ud558 \ud14c\uc2a4\ud2b8\ub97c \uc9c4\ud589\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n
\ub124 \ubc88\uc9f8\ub85c, \ucffc\ub9ac \uc131\ub2a5 \ubd84\uc11d\uc740 MySQL\uc758 EXPLAIN \uba85\ub839\uc5b4\ub97c \uc0ac\uc6a9\ud558\uc5ec \ucffc\ub9ac \uc2e4\ud589 \uacc4\ud68d\uc744 \ud655\uc778\ud558\ub294 \ubc29\ubc95\uc785\ub2c8\ub2e4. \uc774\ub97c \ud1b5\ud574 \ube44\ud6a8\uc728\uc801\uc778 \ucffc\ub9ac\ub97c \ucc3e\uc544\ub0bc \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n
\ub9c8\uc9c0\ub9c9\uc73c\ub85c, \ub124\ud2b8\uc6cc\ud06c \ud2b8\ub798\ud53d \ubd84\uc11d\uc740 Wireshark\uc640 \uac19\uc740 \ub3c4\uad6c\ub97c \uc0ac\uc6a9\ud558\uc5ec \ub124\ud2b8\uc6cc\ud06c \ud328\ud0b7\uc744 \ucea1\ucc98\ud558\uace0 \ubd84\uc11d\ud558\ub294 \ubc29\ubc95\uc785\ub2c8\ub2e4. \uc774\ub97c \ud1b5\ud574 \ub124\ud2b8\uc6cc\ud06c \ubcd1\ubaa9 \ud604\uc0c1\uc744 \ud30c\uc545\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n
4. MySQL \uc7a5\uc560 \uc9c4\ub2e8 \ubc29\ubc95<\/h2>\n
MySQL \uc7a5\uc560\ub97c \uc9c4\ub2e8\ud558\uae30 \uc704\ud574\uc11c\ub294 \ud2b9\uc815\ud55c \uc808\ucc28\ub97c \ub530\ub974\ub294 \uac83\uc774 \uc911\uc694\ud569\ub2c8\ub2e4. \uc774 \uc139\uc158\uc5d0\uc11c\ub294 MySQL \uc7a5\uc560 \uc9c4\ub2e8 \ubc29\ubc95\uc744 \uc124\uba85\ud569\ub2c8\ub2e4.<\/p>\n
\n- MySQL \uc0c1\ud0dc \ud655\uc778<\/li>\n
- \uc5d0\ub7ec \ub85c\uadf8 \ubd84\uc11d<\/li>\n
- \ucffc\ub9ac \uc131\ub2a5 \ubaa8\ub2c8\ud130\ub9c1<\/li>\n
- \ub514\uc2a4\ud06c \uacf5\uac04 \ud655\uc778<\/li>\n
- \uc11c\ubc84 \ub9ac\uc18c\uc2a4 \ubaa8\ub2c8\ud130\ub9c1<\/li>\n<\/ul>\n
\uccab \ubc88\uc9f8\ub85c, MySQL \uc0c1\ud0dc \ud655\uc778\uc740 MySQL\uc758 SHOW STATUS \uba85\ub839\uc5b4\ub97c \uc0ac\uc6a9\ud558\uc5ec \ud604\uc7ac \uc0c1\ud0dc\ub97c \ud655\uc778\ud558\ub294 \ubc29\ubc95\uc785\ub2c8\ub2e4. \uc774\ub97c \ud1b5\ud574 \uc5f0\uacb0 \uc218, \ucffc\ub9ac \uc218 \ub4f1\uc744 \ud30c\uc545\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n
\ub450 \ubc88\uc9f8\ub85c, \uc5d0\ub7ec \ub85c\uadf8 \ubd84\uc11d\uc740 MySQL\uc758 \uc5d0\ub7ec \ub85c\uadf8 \ud30c\uc77c\uc744 \ud655\uc778\ud558\uc5ec \uc7a5\uc560 \uc6d0\uc778\uc744 \ud30c\uc545\ud558\ub294 \ubc29\ubc95\uc785\ub2c8\ub2e4. \uc5d0\ub7ec \ub85c\uadf8\uc5d0\ub294 \uc911\uc694\ud55c \uc815\ubcf4\uac00 \ud3ec\ud568\ub418\uc5b4 \uc788\uc73c\ubbc0\ub85c \uc8fc\uc758 \uae4a\uac8c \uc0b4\ud3b4\ubd10\uc57c \ud569\ub2c8\ub2e4.<\/p>\n
\uc138 \ubc88\uc9f8\ub85c, \ucffc\ub9ac \uc131\ub2a5 \ubaa8\ub2c8\ud130\ub9c1\uc740 slow query log\ub97c \ud65c\uc131\ud654\ud558\uc5ec \ub290\ub9b0 \ucffc\ub9ac\ub97c \uae30\ub85d\ud558\ub294 \ubc29\ubc95\uc785\ub2c8\ub2e4. \uc774\ub97c \ud1b5\ud574 \uc131\ub2a5 \uc800\ud558\uc758 \uc6d0\uc778\uc744 \ucc3e\uc744 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n
\ub124 \ubc88\uc9f8\ub85c, \ub514\uc2a4\ud06c \uacf5\uac04 \ud655\uc778\uc740 df \uba85\ub839\uc5b4\ub97c \uc0ac\uc6a9\ud558\uc5ec \ub514\uc2a4\ud06c \uc0ac\uc6a9\ub7c9\uc744 \ud655\uc778\ud558\ub294 \ubc29\ubc95\uc785\ub2c8\ub2e4. \ub514\uc2a4\ud06c \uacf5\uac04\uc774 \ubd80\uc871\ud558\uba74 MySQL\uc774 \uc815\uc0c1\uc801\uc73c\ub85c \uc791\ub3d9\ud558\uc9c0 \uc54a\uc744 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n
\ub9c8\uc9c0\ub9c9\uc73c\ub85c, \uc11c\ubc84 \ub9ac\uc18c\uc2a4 \ubaa8\ub2c8\ud130\ub9c1\uc740 top \uba85\ub839\uc5b4\ub97c \uc0ac\uc6a9\ud558\uc5ec CPU \ubc0f \uba54\ubaa8\ub9ac \uc0ac\uc6a9\ub7c9\uc744 \uc2e4\uc2dc\uac04\uc73c\ub85c \ud655\uc778\ud558\ub294 \ubc29\ubc95\uc785\ub2c8\ub2e4. \uc774\ub97c \ud1b5\ud574 \ub9ac\uc18c\uc2a4 \ubd80\uc871 \ubb38\uc81c\ub97c \uc870\uae30\uc5d0 \ubc1c\uacac\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n
5. \ubb38\uc81c \ud574\uacb0\uc744 \uc704\ud55c \ub2e8\uacc4\ubcc4 \uc811\uadfc\ubc95<\/h2>\n
\uc11c\ubc84 \uc18d\ub3c4 \uc800\ud558 \ubc0f MySQL \uc7a5\uc560 \ubb38\uc81c\ub97c \ud574\uacb0\ud558\uae30 \uc704\ud574\uc11c\ub294 \uccb4\uacc4\uc801\uc778 \uc811\uadfc\uc774 \ud544\uc694\ud569\ub2c8\ub2e4. \uc774 \uc139\uc158\uc5d0\uc11c\ub294 \ubb38\uc81c \ud574\uacb0\uc744 \uc704\ud55c \ub2e8\uacc4\ubcc4 \uc811\uadfc\ubc95\uc744 \uc124\uba85\ud569\ub2c8\ub2e4.<\/p>\n
\n- \ubb38\uc81c \uc815\uc758 \ubc0f \ubc94\uc704 \uc124\uc815<\/li>\n
- \uc6d0\uc778 \ubd84\uc11d \ubc0f \uc9c4\ub2e8<\/li>\n
- \ud574\uacb0 \ubc29\uc548 \ubaa8\uc0c9<\/li>\n
- \ud574\uacb0 \ubc29\uc548 \uc801\uc6a9<\/li>\n
- \uacb0\uacfc \uac80\uc99d \ubc0f \ubaa8\ub2c8\ud130\ub9c1<\/li>\n<\/ul>\n
\uccab \ubc88\uc9f8 \ub2e8\uacc4\ub294 \ubb38\uc81c \uc815\uc758 \ubc0f \ubc94\uc704 \uc124\uc815\uc785\ub2c8\ub2e4. \uc5b4\ub5a4 \ubb38\uc81c\uac00 \ubc1c\uc0dd\ud588\ub294\uc9c0 \uba85\ud655\ud788 \uc815\uc758\ud558\uace0, \uc601\ud5a5\uc744 \ubc1b\ub294 \uc2dc\uc2a4\ud15c\uc774\ub098 \uc11c\ube44\uc2a4\uc758 \ubc94\uc704\ub97c \uc124\uc815\ud574\uc57c \ud569\ub2c8\ub2e4.<\/p>\n
\ub450 \ubc88\uc9f8 \ub2e8\uacc4\ub294 \uc6d0\uc778 \ubd84\uc11d \ubc0f \uc9c4\ub2e8\uc785\ub2c8\ub2e4. \uc55e\uc11c \uc124\uba85\ud55c \uc9c4\ub2e8 \ubc29\ubc95\uc744 \ud65c\uc6a9\ud558\uc5ec \ubb38\uc81c\uc758 \uc6d0\uc778\uc744 \ud30c\uc545\ud569\ub2c8\ub2e4.<\/p>\n
\uc138 \ubc88\uc9f8 \ub2e8\uacc4\ub294 \ud574\uacb0 \ubc29\uc548 \ubaa8\uc0c9\uc785\ub2c8\ub2e4. \uc6d0\uc778\uc5d0 \ub530\ub77c \uc801\uc808\ud55c \ud574\uacb0 \ubc29\uc548\uc744 \ucc3e\uc544\uc57c \ud569\ub2c8\ub2e4. \uc608\ub97c \ub4e4\uc5b4, \ud558\ub4dc\uc6e8\uc5b4 \uc131\ub2a5 \ubd80\uc871\uc774 \uc6d0\uc778\uc774\ub77c\uba74 \uc5c5\uadf8\ub808\uc774\ub4dc\ub97c \uace0\ub824\ud574\uc57c \ud569\ub2c8\ub2e4.<\/p>\n
\ub124 \ubc88\uc9f8 \ub2e8\uacc4\ub294 \ud574\uacb0 \ubc29\uc548 \uc801\uc6a9\uc785\ub2c8\ub2e4. \uc120\ud0dd\ud55c \ud574\uacb0 \ubc29\uc548\uc744 \uc2e4\uc81c\ub85c \uc801\uc6a9\ud558\uace0, \uc2dc\uc2a4\ud15c\uc5d0 \ubbf8\uce58\ub294 \uc601\ud5a5\uc744 \uad00\ucc30\ud574\uc57c \ud569\ub2c8\ub2e4.<\/p>\n
\ub9c8\uc9c0\ub9c9 \ub2e8\uacc4\ub294 \uacb0\uacfc \uac80\uc99d \ubc0f \ubaa8\ub2c8\ud130\ub9c1\uc785\ub2c8\ub2e4. \ubb38\uc81c \ud574\uacb0 \ud6c4\uc5d0\ub3c4 \uc9c0\uc18d\uc801\uc73c\ub85c \uc2dc\uc2a4\ud15c\uc744 \ubaa8\ub2c8\ud130\ub9c1\ud558\uc5ec \uc7ac\ubc1c \ubc29\uc9c0\ub97c \uc704\ud55c \uc870\uce58\ub97c \ucde8\ud574\uc57c \ud569\ub2c8\ub2e4.<\/p>\n
6. \uc608\ubc29 \uc870\uce58 \ubc0f \ucd5c\uc801\ud654 \ubc29\ubc95<\/h2>\n
\ubb38\uc81c\uac00 \ubc1c\uc0dd\ud55c \ud6c4\uc5d0 \ud574\uacb0\ud558\ub294 \uac83\ubcf4\ub2e4 \uc608\ubc29\ud558\ub294 \uac83\uc774 \ub354 \uc911\uc694\ud569\ub2c8\ub2e4. \uc774 \uc139\uc158\uc5d0\uc11c\ub294 \uc11c\ubc84 \uc18d\ub3c4 \uc800\ud558 \ubc0f MySQL \uc7a5\uc560\ub97c \uc608\ubc29\ud558\uae30 \uc704\ud55c \uc870\uce58\uc640 \ucd5c\uc801\ud654 \ubc29\ubc95\uc744 \uc124\uba85\ud569\ub2c8\ub2e4.<\/p>\n
\n- \uc815\uae30\uc801\uc778 \uc2dc\uc2a4\ud15c \uc810\uac80<\/li>\n
- \uc131\ub2a5 \ubaa8\ub2c8\ud130\ub9c1 \ub3c4\uad6c \ud65c\uc6a9<\/li>\n
- \ucffc\ub9ac \ucd5c\uc801\ud654<\/li>\n
- \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc778\ub371\uc2a4 \uad00\ub9ac<\/li>\n
- \ud558\ub4dc\uc6e8\uc5b4 \uc5c5\uadf8\ub808\uc774\ub4dc \uacc4\ud68d<\/li>\n<\/ul>\n
\uccab \ubc88\uc9f8\ub85c, \uc815\uae30\uc801\uc778 \uc2dc\uc2a4\ud15c \uc810\uac80\uc740 \ud558\ub4dc\uc6e8\uc5b4 \ubc0f \uc18c\ud504\ud2b8\uc6e8\uc5b4 \uc0c1\ud0dc\ub97c \uc8fc\uae30\uc801\uc73c\ub85c \uc810\uac80\ud558\uc5ec \ubb38\uc81c\ub97c \uc0ac\uc804\uc5d0 \ubc1c\uacac\ud558\ub294 \ubc29\ubc95\uc785\ub2c8\ub2e4.<\/p>\n
\ub450 \ubc88\uc9f8\ub85c, \uc131\ub2a5 \ubaa8\ub2c8\ud130\ub9c1 \ub3c4\uad6c\ub97c \ud65c\uc6a9\ud558\uba74 \uc2e4\uc2dc\uac04\uc73c\ub85c \uc2dc\uc2a4\ud15c \uc131\ub2a5\uc744 \ubaa8\ub2c8\ud130\ub9c1\ud558\uace0 \uc774\uc0c1 \uc9d5\ud6c4\ub97c \uc870\uae30\uc5d0 \ubc1c\uacac\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n
\uc138 \ubc88\uc9f8\ub85c, \ucffc\ub9ac \ucd5c\uc801\ud654\ub294 \ube44\ud6a8\uc728\uc801\uc778 \ucffc\ub9ac\ub97c \uac1c\uc120\ud558\uc5ec \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc131\ub2a5\uc744 \ud5a5\uc0c1\uc2dc\ud0a4\ub294 \ubc29\ubc95\uc785\ub2c8\ub2e4. EXPLAIN \uba85\ub839\uc5b4\ub97c \ud65c\uc6a9\ud558\uc5ec \ucffc\ub9ac \uc2e4\ud589 \uacc4\ud68d\uc744 \ubd84\uc11d\ud558\uace0 \ucd5c\uc801\ud654\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n
\ub124 \ubc88\uc9f8\ub85c, \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc778\ub371\uc2a4 \uad00\ub9ac\ub294 \uc778\ub371\uc2a4\ub97c \uc801\uc808\ud788 \uc124\uc815\ud558\uc5ec \uac80\uc0c9 \uc131\ub2a5\uc744 \ud5a5\uc0c1\uc2dc\ud0a4\ub294 \ubc29\ubc95\uc785\ub2c8\ub2e4. \uc778\ub371\uc2a4\uac00 \uc5c6\uc73c\uba74 \uc804\uccb4 \ud14c\uc774\ube14 \uc2a4\uce94\uc774 \ubc1c\uc0dd\ud558\uc5ec \uc131\ub2a5\uc774 \uc800\ud558\ub429\ub2c8\ub2e4.<\/p>\n
\ub9c8\uc9c0\ub9c9\uc73c\ub85c, \ud558\ub4dc\uc6e8\uc5b4 \uc5c5\uadf8\ub808\uc774\ub4dc \uacc4\ud68d\uc740 \uc2dc\uc2a4\ud15c\uc758 \uc131\ub2a5 \uc694\uad6c \uc0ac\ud56d\uc5d0 \ub9de\ucdb0 \ud558\ub4dc\uc6e8\uc5b4\ub97c \uc5c5\uadf8\ub808\uc774\ub4dc\ud558\ub294 \uac83\uc785\ub2c8\ub2e4. \uc608\ub97c \ub4e4\uc5b4, SSD\ub85c \ub514\uc2a4\ud06c\ub97c \uad50\uccb4\ud558\uba74 I\/O \uc131\ub2a5\uc774 \ud06c\uac8c \ud5a5\uc0c1\ub429\ub2c8\ub2e4.<\/p>\n
7. \uc0ac\ub840 \uc5f0\uad6c: \uc131\uacf5\uc801\uc778 \ubb38\uc81c \ud574\uacb0 \uc0ac\ub840<\/h2>\n
\ubb38\uc81c \ud574\uacb0\uc758 \uc2e4\uc81c \uc0ac\ub840\ub97c \ud1b5\ud574 \ud6a8\uacfc\uc801\uc778 \uc811\uadfc\ubc95\uc744 \uc774\ud574\ud558\ub294 \uac83\uc774 \uc911\uc694\ud569\ub2c8\ub2e4. \uc774 \uc139\uc158\uc5d0\uc11c\ub294 \uc131\uacf5\uc801\uc778 \ubb38\uc81c \ud574\uacb0 \uc0ac\ub840\ub97c \uc18c\uac1c\ud569\ub2c8\ub2e4.<\/p>\n
\n- \uc804\uc790\uc0c1\uac70\ub798 \uc0ac\uc774\ud2b8\uc758 \uc131\ub2a5 \uac1c\uc120 \uc0ac\ub840<\/li>\n
- \ub300\ud559 \ud3ec\ud138 \uc0ac\uc774\ud2b8\uc758 MySQL \uc7a5\uc560 \ud574\uacb0 \uc0ac\ub840<\/li>\n
- \uac8c\uc784 \uc11c\ubc84\uc758 \ud2b8\ub798\ud53d \uad00\ub9ac \uc0ac\ub840<\/li>\n
- \ub274\uc2a4 \uc0ac\uc774\ud2b8\uc758 \ub85c\ub4dc \ubc38\ub7f0\uc2f1 \uc0ac\ub840<\/li>\n
- \ud074\ub77c\uc6b0\ub4dc \uc11c\ube44\uc2a4\uc758 \uc790\ub3d9\ud654\ub41c \ubaa8\ub2c8\ud130\ub9c1 \uc0ac\ub840<\/li>\n<\/ul>\n
\uccab \ubc88\uc9f8 \uc0ac\ub840\ub294 \ud55c \uc804\uc790\uc0c1\uac70\ub798 \uc0ac\uc774\ud2b8\uc5d0\uc11c \ubc1c\uc0dd\ud55c \uc131\ub2a5 \uc800\ud558 \ubb38\uc81c\uc785\ub2c8\ub2e4. \uc774 \uc0ac\uc774\ud2b8\ub294 \ud2b8\ub798\ud53d \uae09\uc99d\uc73c\ub85c \uc778\ud574 \uc11c\ubc84\uac00 \ub290\ub824\uc84c\uc2b5\ub2c8\ub2e4. \uc774\ub97c \ud574\uacb0\ud558\uae30 \uc704\ud574 \ub85c\ub4dc \ubc38\ub7f0\uc11c\ub97c \ub3c4\uc785\ud558\uace0, \uce90\uc2f1 \uc194\ub8e8\uc158\uc744 \uc801\uc6a9\ud558\uc5ec \uc131\ub2a5\uc744 \ud06c\uac8c \uac1c\uc120\ud588\uc2b5\ub2c8\ub2e4.<\/p>\n
\ub450 \ubc88\uc9f8 \uc0ac\ub840\ub294 \ud55c \ub300\ud559 \ud3ec\ud138 \uc0ac\uc774\ud2b8\uc5d0\uc11c \ubc1c\uc0dd\ud55c MySQL \uc7a5\uc560\uc785\ub2c8\ub2e4. \uc774 \uc0ac\uc774\ud2b8\ub294 \ud559\uc0dd\ub4e4\uc758 \uc218\uac15 \uc2e0\uccad \uae30\uac04 \ub3d9\uc548 \ud2b8\ub798\ud53d\uc774 \uae09\uc99d\ud588\uc2b5\ub2c8\ub2e4. \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc778\ub371\uc2a4\ub97c \ucd5c\uc801\ud654\ud558\uace0, \ucffc\ub9ac\ub97c \uac1c\uc120\ud558\uc5ec \uc7a5\uc560\ub97c \ud574\uacb0\ud588\uc2b5\ub2c8\ub2e4.<\/p>\n
\uc138 \ubc88\uc9f8 \uc0ac\ub840\ub294 \ud55c \uac8c\uc784 \uc11c\ubc84\uc5d0\uc11c \ubc1c\uc0dd\ud55c \ud2b8\ub798\ud53d \uad00\ub9ac \ubb38\uc81c\uc785\ub2c8\ub2e4. \uc774 \uac8c\uc784\uc740 \ucd9c\uc2dc \ud6c4 \uc0ac\uc6a9\uc790 \uc218\uac00 \uae09\uc99d\ud558\uc5ec \uc11c\ubc84\uac00 \uacfc\ubd80\ud558\uc5d0 \uac78\ub838\uc2b5\ub2c8\ub2e4. \uc774\ub97c \ud574\uacb0\ud558\uae30 \uc704\ud574 \ud074\ub77c\uc6b0\ub4dc \uae30\ubc18\uc758 \uc790\ub3d9 \ud655\uc7a5 \uae30\ub2a5\uc744 \ub3c4\uc785\ud558\uc5ec \ud2b8\ub798\ud53d\uc744 \ud6a8\uacfc\uc801\uc73c\ub85c \uad00\ub9ac\ud588\uc2b5\ub2c8\ub2e4.<\/p>\n
\ub124 \ubc88\uc9f8 \uc0ac\ub840\ub294 \ud55c \ub274\uc2a4 \uc0ac\uc774\ud2b8\uc5d0\uc11c \ubc1c\uc0dd\ud55c \ub85c\ub4dc \ubc38\ub7f0\uc2f1 \ubb38\uc81c\uc785\ub2c8\ub2e4. \uc774 \uc0ac\uc774\ud2b8\ub294 \ud2b9\uc815 \uc2dc\uac04\ub300\uc5d0 \ud2b8\ub798\ud53d\uc774 \uc9d1\uc911\ub418\uc5b4 \uc11c\ubc84\uac00 \ub290\ub824\uc84c\uc2b5\ub2c8\ub2e4. \uc5ec\ub7ec \ub300\uc758 \uc11c\ubc84\uc5d0 \ud2b8\ub798\ud53d\uc744 \ubd84\uc0b0\uc2dc\ud0a4\ub294 \ub85c\ub4dc \ubc38\ub7f0\uc2f1 \uc194\ub8e8\uc158\uc744 \ub3c4\uc785\ud558\uc5ec \ubb38\uc81c\ub97c \ud574\uacb0\ud588\uc2b5\ub2c8\ub2e4.<\/p>\n
\ub9c8\uc9c0\ub9c9 \uc0ac\ub840\ub294 \ud074\ub77c\uc6b0\ub4dc \uc11c\ube44\uc2a4\uc5d0\uc11c \uc790\ub3d9\ud654\ub41c \ubaa8\ub2c8\ud130\ub9c1 \uc2dc\uc2a4\ud15c\uc744 \uad6c\ucd95\ud55c \uac83\uc785\ub2c8\ub2e4. \uc774 \uc2dc\uc2a4\ud15c\uc740 \uc2e4\uc2dc\uac04\uc73c\ub85c \uc11c\ubc84 \uc0c1\ud0dc\ub97c \ubaa8\ub2c8\ud130\ub9c1\ud558\uace0 \uc774\uc0c1 \uc9d5\ud6c4\uac00 \ubc1c\uacac\ub418\uba74 \uc790\ub3d9\uc73c\ub85c \uacbd\uace0\ub97c \ubc1c\uc1a1\ud558\uc5ec \uc2e0\uc18d\ud558\uac8c \ub300\uc751\ud560 \uc218 \uc788\ub3c4\ub85d \ud588\uc2b5\ub2c8\ub2e4.<\/p>\n
8. \uacb0\ub860: \uc9c0\uc18d \uac00\ub2a5\ud55c \uc11c\ubc84 \uad00\ub9ac \uc804\ub7b5<\/h2>\n
\uc11c\ubc84 \uc18d\ub3c4 \uc800\ud558\uc640 MySQL \uc7a5\uc560\ub294 \ud604\ub300 \uc6f9 \ud658\uacbd\uc5d0\uc11c \ud53c\ud560 \uc218 \uc5c6\ub294 \ubb38\uc81c\uc785\ub2c8\ub2e4. \uadf8\ub7ec\ub098 \uc801\uc808\ud55c \uc9c4\ub2e8\uacfc \ubb38\uc81c \ud574\uacb0 \ubc29\ubc95\uc744 \ud1b5\ud574 \uc774\ub7ec\ud55c \ubb38\uc81c\ub97c \ud6a8\uacfc\uc801\uc73c\ub85c \uad00\ub9ac\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ubcf8 \uac00\uc774\ub4dc\uc5d0\uc11c \uc81c\uc2dc\ud55c \ub2e8\uacc4\ubcc4 \uc811\uadfc\ubc95\uacfc \uc608\ubc29 \uc870\uce58\ub97c \ud1b5\ud574 \uc9c0\uc18d \uac00\ub2a5\ud55c \uc11c\ubc84 \uad00\ub9ac \uc804\ub7b5\uc744 \uad6c\ucd95\ud558\ub294 \uac83\uc774 \uc911\uc694\ud569\ub2c8\ub2e4.<\/p>\n
\uc11c\ubc84 \uad00\ub9ac\uc790\ub294 \ud56d\uc0c1 \ucd5c\uc2e0 \uae30\uc220 \ub3d9\ud5a5\uacfc \ucd5c\uc801\ud654 \ubc29\ubc95\uc744 \ud559\uc2b5\ud558\uace0 \uc801\uc6a9\ud574\uc57c \ud569\ub2c8\ub2e4. \ub610\ud55c, \uc815\uae30\uc801\uc778 \uc810\uac80\uacfc \ubaa8\ub2c8\ud130\ub9c1\uc744 \ud1b5\ud574 \uc2dc\uc2a4\ud15c\uc758 \uc548\uc815\uc131\uc744 \uc720\uc9c0\ud574\uc57c \ud569\ub2c8\ub2e4. \uc774\ub97c \ud1b5\ud574 \uc0ac\uc6a9\uc790 \uacbd\ud5d8\uc744 \ud5a5\uc0c1\uc2dc\ud0a4\uace0 \ube44\uc988\ub2c8\uc2a4 \uc131\uacf5\uc5d0 \uae30\uc5ec\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n
\uacb0\ub860\uc801\uc73c\ub85c, \uc11c\ubc84 \uc18d\ub3c4 \uc800\ud558\uc640 MySQL \uc7a5\uc560 \ubb38\uc81c\ub294 \uccb4\uacc4\uc801\uc778 \uc811\uadfc\uacfc \uc9c0\uc18d\uc801\uc778 \uad00\ub9ac\ub85c \ud574\uacb0\ud560 \uc218 \uc788\uc73c\uba70, \uc774\ub97c \ud1b5\ud574 \uc548\uc815\uc801\uc774\uace0 \ud6a8\uc728\uc801\uc778 \uc6f9 \uc11c\ube44\uc2a4\ub97c \uc81c\uacf5\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n","protected":false},"excerpt":{"rendered":"
\ubaa9\ucc28 \uc11c\ubc84 \uc18d\ub3c4 \uc800\ud558\uc640 MySQL \uc7a5\uc560: \ubb38\uc81c \ud574\uacb0\uc744 \uc704\ud55c \ub2e8\uacc4\ubcc4 \uac00\uc774\ub4dc 1. \uc11c\ubc84 \uc18d\ub3c4 \uc800\ud558\uc758 […]<\/p>\n","protected":false},"author":1,"featured_media":51563,"comment_status":"","ping_status":"","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[1957],"tags":[2100,2455],"class_list":["post-51668","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-development","tag-mysql","tag-query"],"acf":[],"_links":{"self":[{"href":"https:\/\/m9js.shop\/blog\/wp-json\/wp\/v2\/posts\/51668","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=51668"}],"version-history":[{"count":0,"href":"https:\/\/m9js.shop\/blog\/wp-json\/wp\/v2\/posts\/51668\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/m9js.shop\/blog\/wp-json\/wp\/v2\/media\/51563"}],"wp:attachment":[{"href":"https:\/\/m9js.shop\/blog\/wp-json\/wp\/v2\/media?parent=51668"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/m9js.shop\/blog\/wp-json\/wp\/v2\/categories?post=51668"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/m9js.shop\/blog\/wp-json\/wp\/v2\/tags?post=51668"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
\uc11c\ubc84 \uc18d\ub3c4 \uc800\ud558\uc640 MySQL \uc7a5\uc560: \ubb38\uc81c \ud574\uacb0\uc744 \uc704\ud55c \ub2e8\uacc4\ubcc4 \uac00\uc774\ub4dc<\/h1>\n
<\/p>\n
\ud604\ub300\uc758 \uc6f9 \ud658\uacbd\uc5d0\uc11c \uc11c\ubc84\uc758 \uc131\ub2a5\uc740 \ube44\uc988\ub2c8\uc2a4\uc758 \uc131\uacf5\uc5d0 \uacb0\uc815\uc801\uc778 \uc601\ud5a5\uc744 \ubbf8\uce69\ub2c8\ub2e4. \ud2b9\ud788, \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uad00\ub9ac \uc2dc\uc2a4\ud15c\uc778 MySQL\uc740 \ub9ce\uc740 \uc6f9 \uc560\ud50c\ub9ac\ucf00\uc774\uc158\uc758 \ud575\uc2ec \uc694\uc18c\ub85c \uc790\ub9ac \uc7a1\uace0 \uc788\uc2b5\ub2c8\ub2e4. \uadf8\ub7ec\ub098 \uc11c\ubc84 \uc18d\ub3c4\uac00 \uc800\ud558\ub418\uac70\ub098 MySQL \uc7a5\uc560\uac00 \ubc1c\uc0dd\ud558\uba74 \uc0ac\uc6a9\uc790 \uacbd\ud5d8\uc774 \ub098\ube60\uc9c0\uace0, \uc774\ub294 \uace7 \ub9e4\ucd9c \uac10\uc18c\ub85c \uc774\uc5b4\uc9c8 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ubcf8 \uac00\uc774\ub4dc\ub294 \uc11c\ubc84 \uc18d\ub3c4 \uc800\ud558\uc640 MySQL \uc7a5\uc560\uc758 \uc6d0\uc778, \ubb38\uc81c \ud574\uacb0 \ubc29\ubc95, \uc608\ubc29 \uc870\uce58 \ub4f1\uc744 \ub2e8\uacc4\ubcc4\ub85c \uc124\uba85\ud569\ub2c8\ub2e4.<\/p>\n
1. \uc11c\ubc84 \uc18d\ub3c4 \uc800\ud558\uc758 \uc6d0\uc778 \ubd84\uc11d<\/h2>\n
\uc11c\ubc84 \uc18d\ub3c4 \uc800\ud558\ub294 \uc5ec\ub7ec \uac00\uc9c0 \uc694\uc778\uc5d0 \uc758\ud574 \ubc1c\uc0dd\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc774 \uc139\uc158\uc5d0\uc11c\ub294 \uc8fc\uc694 \uc6d0\uc778\ub4e4\uc744 \uc0b4\ud3b4\ubcf4\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n
- \n
- \ud558\ub4dc\uc6e8\uc5b4 \uc131\ub2a5 \ubd80\uc871<\/li>\n
- \ub124\ud2b8\uc6cc\ud06c \ub300\uc5ed\ud3ed \uc81c\ud55c<\/li>\n
- \uc18c\ud504\ud2b8\uc6e8\uc5b4 \uc124\uc815 \uc624\ub958<\/li>\n
- \ud2b8\ub798\ud53d \uae09\uc99d<\/li>\n
- \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ucffc\ub9ac \ube44\ud6a8\uc728\uc131<\/li>\n<\/ul>\n
\uccab \ubc88\uc9f8\ub85c, \ud558\ub4dc\uc6e8\uc5b4 \uc131\ub2a5 \ubd80\uc871\uc740 \uc11c\ubc84\uc758 CPU, \uba54\ubaa8\ub9ac, \ub514\uc2a4\ud06c I\/O \uc131\ub2a5\uc774 \ub0ae\uc744 \ub54c \ubc1c\uc0dd\ud569\ub2c8\ub2e4. \uc608\ub97c \ub4e4\uc5b4, \uc6f9\uc0ac\uc774\ud2b8\uc5d0 \ub9ce\uc740 \uc0ac\uc6a9\uc790\uac00 \ub3d9\uc2dc\uc5d0 \uc811\uc18d\ud558\uba74 CPU \uc0ac\uc6a9\ub960\uc774 \uae09\uaca9\ud788 \uc99d\uac00\ud558\uc5ec \uc11c\ubc84 \uc18d\ub3c4\uac00 \ub290\ub824\uc9c8 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n
\ub450 \ubc88\uc9f8\ub85c, \ub124\ud2b8\uc6cc\ud06c \ub300\uc5ed\ud3ed \uc81c\ud55c\uc740 \uc11c\ubc84\uc640 \ud074\ub77c\uc774\uc5b8\ud2b8 \uac04\uc758 \ub370\uc774\ud130 \uc804\uc1a1 \uc18d\ub3c4\ub97c \uc800\ud558\uc2dc\ud0b5\ub2c8\ub2e4. \ud2b9\ud788, \ub300\uc6a9\ub7c9 \ud30c\uc77c\uc744 \uc804\uc1a1\ud560 \ub54c \uc774 \ubb38\uc81c\uac00 \ub450\ub4dc\ub7ec\uc9d1\ub2c8\ub2e4.<\/p>\n
\uc138 \ubc88\uc9f8\ub85c, \uc18c\ud504\ud2b8\uc6e8\uc5b4 \uc124\uc815 \uc624\ub958\ub294 \uc11c\ubc84\uc758 \uc6b4\uc601 \uccb4\uc81c\ub098 \uc6f9 \uc11c\ubc84 \uc18c\ud504\ud2b8\uc6e8\uc5b4\uc758 \uc798\ubabb\ub41c \uc124\uc815\uc73c\ub85c \uc778\ud574 \ubc1c\uc0dd\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc608\ub97c \ub4e4\uc5b4, Apache \uc6f9 \uc11c\ubc84\uc758 KeepAlive \uc124\uc815\uc774 \ube44\ud6a8\uc728\uc801\uc77c \uacbd\uc6b0 \uc5f0\uacb0\uc774 \ub290\ub824\uc9c8 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n
\ub124 \ubc88\uc9f8\ub85c, \ud2b8\ub798\ud53d \uae09\uc99d\uc740 \uc608\uc0c1\uce58 \ubabb\ud55c \uc0ac\uc6a9\uc790 \uc218\uc758 \uc99d\uac00\ub85c \uc778\ud574 \uc11c\ubc84\uac00 \uacfc\ubd80\ud558\uc5d0 \uac78\ub9ac\ub294 \uc0c1\ud669\uc785\ub2c8\ub2e4. \uc774 \uacbd\uc6b0, \ub85c\ub4dc \ubc38\ub7f0\uc11c\ub97c \ub3c4\uc785\ud558\uc5ec \uc5ec\ub7ec \uc11c\ubc84\uc5d0 \ud2b8\ub798\ud53d\uc744 \ubd84\uc0b0\uc2dc\ud0a4\ub294 \uac83\uc774 \ud6a8\uacfc\uc801\uc785\ub2c8\ub2e4.<\/p>\n
\ub9c8\uc9c0\ub9c9\uc73c\ub85c, \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ucffc\ub9ac \ube44\ud6a8\uc728\uc131\uc740 \uc798\ubabb\ub41c \uc778\ub371\uc2a4 \uc124\uc815\uc774\ub098 \ube44\ud6a8\uc728\uc801\uc778 \ucffc\ub9ac\ub85c \uc778\ud574 \ubc1c\uc0dd\ud569\ub2c8\ub2e4. \uc608\ub97c \ub4e4\uc5b4, SELECT \ucffc\ub9ac\uc5d0\uc11c WHERE \uc808\uc744 \uc0ac\uc6a9\ud558\uc9c0 \uc54a\uc73c\uba74 \uc804\uccb4 \ud14c\uc774\ube14\uc744 \uc2a4\uce94\ud558\uac8c \ub418\uc5b4 \uc131\ub2a5\uc774 \uc800\ud558\ub429\ub2c8\ub2e4.<\/p>\n
2. MySQL \uc7a5\uc560\uc758 \uc8fc\uc694 \uc6d0\uc778<\/h2>\n
MySQL \uc7a5\uc560\ub294 \ub2e4\uc591\ud55c \uc6d0\uc778\uc73c\ub85c \ubc1c\uc0dd\ud560 \uc218 \uc788\uc73c\uba70, \uc774\ub97c \uc774\ud574\ud558\ub294 \uac83\uc774 \uc911\uc694\ud569\ub2c8\ub2e4. \uc774 \uc139\uc158\uc5d0\uc11c\ub294 MySQL \uc7a5\uc560\uc758 \uc8fc\uc694 \uc6d0\uc778\uc744 \uc0b4\ud3b4\ubcf4\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n
- \n
- \ub514\uc2a4\ud06c \uacf5\uac04 \ubd80\uc871<\/li>\n
- \uba54\ubaa8\ub9ac \ubd80\uc871<\/li>\n
- \uc798\ubabb\ub41c \ucffc\ub9ac \uc2e4\ud589<\/li>\n
- \uc11c\ubc84 \ud06c\ub798\uc2dc<\/li>\n
- \ub124\ud2b8\uc6cc\ud06c \ubb38\uc81c<\/li>\n<\/ul>\n
\uccab \ubc88\uc9f8\ub85c, \ub514\uc2a4\ud06c \uacf5\uac04 \ubd80\uc871\uc740 MySQL \ub370\uc774\ud130\ubca0\uc774\uc2a4\uac00 \ub370\uc774\ud130\ub97c \uc800\uc7a5\ud560 \uacf5\uac04\uc774 \uc5c6\uc744 \ub54c \ubc1c\uc0dd\ud569\ub2c8\ub2e4. \uc774 \uacbd\uc6b0, \ub370\uc774\ud130\ubca0\uc774\uc2a4\uac00 \ub354 \uc774\uc0c1 \ub370\uc774\ud130\ub97c \uc0bd\uc785\ud560 \uc218 \uc5c6\uac8c \ub418\uc5b4 \uc7a5\uc560\uac00 \ubc1c\uc0dd\ud569\ub2c8\ub2e4.<\/p>\n
\ub450 \ubc88\uc9f8\ub85c, \uba54\ubaa8\ub9ac \ubd80\uc871\uc740 MySQL \uc11c\ubc84\uac00 \ud544\uc694\ud55c \uba54\ubaa8\ub9ac\ub97c \ud655\ubcf4\ud558\uc9c0 \ubabb\ud560 \ub54c \ubc1c\uc0dd\ud569\ub2c8\ub2e4. \uc774 \uacbd\uc6b0, \ucffc\ub9ac \uc2e4\ud589 \uc18d\ub3c4\uac00 \ub290\ub824\uc9c0\uac70\ub098 \uc11c\ubc84\uac00 \uc751\ub2f5\ud558\uc9c0 \uc54a\uc744 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n
\uc138 \ubc88\uc9f8\ub85c, \uc798\ubabb\ub41c \ucffc\ub9ac \uc2e4\ud589\uc740 \ube44\ud6a8\uc728\uc801\uc778 \ucffc\ub9ac\ub85c \uc778\ud574 MySQL \uc11c\ubc84\uac00 \uacfc\ubd80\ud558\uc5d0 \uac78\ub9ac\ub294 \uc0c1\ud669\uc785\ub2c8\ub2e4. \uc608\ub97c \ub4e4\uc5b4, JOIN \uc5f0\uc0b0\uc774 \ub9ce\uc740 \ucffc\ub9ac\ub294 \uc131\ub2a5 \uc800\ud558\ub97c \ucd08\ub798\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n
\ub124 \ubc88\uc9f8\ub85c, \uc11c\ubc84 \ud06c\ub798\uc2dc\ub294 \ud558\ub4dc\uc6e8\uc5b4 \uace0\uc7a5\uc774\ub098 \uc18c\ud504\ud2b8\uc6e8\uc5b4 \ubc84\uadf8\ub85c \uc778\ud574 \ubc1c\uc0dd\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc774 \uacbd\uc6b0, \ub370\uc774\ud130 \uc190\uc2e4\uc774 \ubc1c\uc0dd\ud560 \uc218 \uc788\uc73c\ubbc0\ub85c \uc815\uae30\uc801\uc778 \ubc31\uc5c5\uc774 \ud544\uc694\ud569\ub2c8\ub2e4.<\/p>\n
\ub9c8\uc9c0\ub9c9\uc73c\ub85c, \ub124\ud2b8\uc6cc\ud06c \ubb38\uc81c\ub294 MySQL \uc11c\ubc84\uc640 \ud074\ub77c\uc774\uc5b8\ud2b8 \uac04\uc758 \uc5f0\uacb0\uc774 \ubd88\uc548\uc815\ud560 \ub54c \ubc1c\uc0dd\ud569\ub2c8\ub2e4. \uc774 \uacbd\uc6b0, \ucffc\ub9ac \uc2e4\ud589\uc774 \uc9c0\uc5f0\ub418\uac70\ub098 \uc2e4\ud328\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n
3. \uc11c\ubc84 \uc18d\ub3c4 \uc800\ud558 \uc9c4\ub2e8 \ubc29\ubc95<\/h2>\n
\uc11c\ubc84 \uc18d\ub3c4 \uc800\ud558\ub97c \uc9c4\ub2e8\ud558\uae30 \uc704\ud574\uc11c\ub294 \uc5ec\ub7ec \uac00\uc9c0 \ub3c4\uad6c\uc640 \ubc29\ubc95\uc744 \uc0ac\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc774 \uc139\uc158\uc5d0\uc11c\ub294 \ud6a8\uacfc\uc801\uc778 \uc9c4\ub2e8 \ubc29\ubc95\uc744 \uc18c\uac1c\ud569\ub2c8\ub2e4.<\/p>\n
- \n
- \uc11c\ubc84 \ubaa8\ub2c8\ud130\ub9c1 \ub3c4\uad6c \uc0ac\uc6a9<\/li>\n
- \ub85c\uadf8 \ud30c\uc77c \ubd84\uc11d<\/li>\n
- \uc131\ub2a5 \ud14c\uc2a4\ud2b8 \uc218\ud589<\/li>\n
- \ucffc\ub9ac \uc131\ub2a5 \ubd84\uc11d<\/li>\n
- \ub124\ud2b8\uc6cc\ud06c \ud2b8\ub798\ud53d \ubd84\uc11d<\/li>\n<\/ul>\n
\uccab \ubc88\uc9f8\ub85c, \uc11c\ubc84 \ubaa8\ub2c8\ud130\ub9c1 \ub3c4\uad6c\ub97c \uc0ac\uc6a9\ud558\uba74 CPU \uc0ac\uc6a9\ub960, \uba54\ubaa8\ub9ac \uc0ac\uc6a9\ub7c9, \ub514\uc2a4\ud06c I\/O \ub4f1\uc744 \uc2e4\uc2dc\uac04\uc73c\ub85c \ubaa8\ub2c8\ud130\ub9c1\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc608\ub97c \ub4e4\uc5b4, Nagios\ub098 Zabbix\uc640 \uac19\uc740 \ub3c4\uad6c\ub97c \uc0ac\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n
\ub450 \ubc88\uc9f8\ub85c, \ub85c\uadf8 \ud30c\uc77c \ubd84\uc11d\uc740 \uc11c\ubc84\uc758 \uc624\ub958 \ubc0f \uacbd\uace0 \uba54\uc2dc\uc9c0\ub97c \ud655\uc778\ud558\ub294 \ub370 \uc720\uc6a9\ud569\ub2c8\ub2e4. Apache\ub098 Nginx\uc758 \ub85c\uadf8 \ud30c\uc77c\uc744 \ubd84\uc11d\ud558\uc5ec \ubb38\uc81c\uc758 \uc6d0\uc778\uc744 \ud30c\uc545\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n
\uc138 \ubc88\uc9f8\ub85c, \uc131\ub2a5 \ud14c\uc2a4\ud2b8\ub97c \uc218\ud589\ud558\uba74 \uc11c\ubc84\uc758 \ucd5c\ub300 \ucc98\ub9ac \ub2a5\ub825\uc744 \ud655\uc778\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. Apache Benchmark\ub098 JMeter\uc640 \uac19\uc740 \ub3c4\uad6c\ub97c \uc0ac\uc6a9\ud558\uc5ec \ubd80\ud558 \ud14c\uc2a4\ud2b8\ub97c \uc9c4\ud589\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n
\ub124 \ubc88\uc9f8\ub85c, \ucffc\ub9ac \uc131\ub2a5 \ubd84\uc11d\uc740 MySQL\uc758 EXPLAIN \uba85\ub839\uc5b4\ub97c \uc0ac\uc6a9\ud558\uc5ec \ucffc\ub9ac \uc2e4\ud589 \uacc4\ud68d\uc744 \ud655\uc778\ud558\ub294 \ubc29\ubc95\uc785\ub2c8\ub2e4. \uc774\ub97c \ud1b5\ud574 \ube44\ud6a8\uc728\uc801\uc778 \ucffc\ub9ac\ub97c \ucc3e\uc544\ub0bc \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n
\ub9c8\uc9c0\ub9c9\uc73c\ub85c, \ub124\ud2b8\uc6cc\ud06c \ud2b8\ub798\ud53d \ubd84\uc11d\uc740 Wireshark\uc640 \uac19\uc740 \ub3c4\uad6c\ub97c \uc0ac\uc6a9\ud558\uc5ec \ub124\ud2b8\uc6cc\ud06c \ud328\ud0b7\uc744 \ucea1\ucc98\ud558\uace0 \ubd84\uc11d\ud558\ub294 \ubc29\ubc95\uc785\ub2c8\ub2e4. \uc774\ub97c \ud1b5\ud574 \ub124\ud2b8\uc6cc\ud06c \ubcd1\ubaa9 \ud604\uc0c1\uc744 \ud30c\uc545\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n
4. MySQL \uc7a5\uc560 \uc9c4\ub2e8 \ubc29\ubc95<\/h2>\n
MySQL \uc7a5\uc560\ub97c \uc9c4\ub2e8\ud558\uae30 \uc704\ud574\uc11c\ub294 \ud2b9\uc815\ud55c \uc808\ucc28\ub97c \ub530\ub974\ub294 \uac83\uc774 \uc911\uc694\ud569\ub2c8\ub2e4. \uc774 \uc139\uc158\uc5d0\uc11c\ub294 MySQL \uc7a5\uc560 \uc9c4\ub2e8 \ubc29\ubc95\uc744 \uc124\uba85\ud569\ub2c8\ub2e4.<\/p>\n
- \n
- MySQL \uc0c1\ud0dc \ud655\uc778<\/li>\n
- \uc5d0\ub7ec \ub85c\uadf8 \ubd84\uc11d<\/li>\n
- \ucffc\ub9ac \uc131\ub2a5 \ubaa8\ub2c8\ud130\ub9c1<\/li>\n
- \ub514\uc2a4\ud06c \uacf5\uac04 \ud655\uc778<\/li>\n
- \uc11c\ubc84 \ub9ac\uc18c\uc2a4 \ubaa8\ub2c8\ud130\ub9c1<\/li>\n<\/ul>\n
\uccab \ubc88\uc9f8\ub85c, MySQL \uc0c1\ud0dc \ud655\uc778\uc740 MySQL\uc758 SHOW STATUS \uba85\ub839\uc5b4\ub97c \uc0ac\uc6a9\ud558\uc5ec \ud604\uc7ac \uc0c1\ud0dc\ub97c \ud655\uc778\ud558\ub294 \ubc29\ubc95\uc785\ub2c8\ub2e4. \uc774\ub97c \ud1b5\ud574 \uc5f0\uacb0 \uc218, \ucffc\ub9ac \uc218 \ub4f1\uc744 \ud30c\uc545\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n
\ub450 \ubc88\uc9f8\ub85c, \uc5d0\ub7ec \ub85c\uadf8 \ubd84\uc11d\uc740 MySQL\uc758 \uc5d0\ub7ec \ub85c\uadf8 \ud30c\uc77c\uc744 \ud655\uc778\ud558\uc5ec \uc7a5\uc560 \uc6d0\uc778\uc744 \ud30c\uc545\ud558\ub294 \ubc29\ubc95\uc785\ub2c8\ub2e4. \uc5d0\ub7ec \ub85c\uadf8\uc5d0\ub294 \uc911\uc694\ud55c \uc815\ubcf4\uac00 \ud3ec\ud568\ub418\uc5b4 \uc788\uc73c\ubbc0\ub85c \uc8fc\uc758 \uae4a\uac8c \uc0b4\ud3b4\ubd10\uc57c \ud569\ub2c8\ub2e4.<\/p>\n
\uc138 \ubc88\uc9f8\ub85c, \ucffc\ub9ac \uc131\ub2a5 \ubaa8\ub2c8\ud130\ub9c1\uc740 slow query log\ub97c \ud65c\uc131\ud654\ud558\uc5ec \ub290\ub9b0 \ucffc\ub9ac\ub97c \uae30\ub85d\ud558\ub294 \ubc29\ubc95\uc785\ub2c8\ub2e4. \uc774\ub97c \ud1b5\ud574 \uc131\ub2a5 \uc800\ud558\uc758 \uc6d0\uc778\uc744 \ucc3e\uc744 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n
\ub124 \ubc88\uc9f8\ub85c, \ub514\uc2a4\ud06c \uacf5\uac04 \ud655\uc778\uc740 df \uba85\ub839\uc5b4\ub97c \uc0ac\uc6a9\ud558\uc5ec \ub514\uc2a4\ud06c \uc0ac\uc6a9\ub7c9\uc744 \ud655\uc778\ud558\ub294 \ubc29\ubc95\uc785\ub2c8\ub2e4. \ub514\uc2a4\ud06c \uacf5\uac04\uc774 \ubd80\uc871\ud558\uba74 MySQL\uc774 \uc815\uc0c1\uc801\uc73c\ub85c \uc791\ub3d9\ud558\uc9c0 \uc54a\uc744 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n
\ub9c8\uc9c0\ub9c9\uc73c\ub85c, \uc11c\ubc84 \ub9ac\uc18c\uc2a4 \ubaa8\ub2c8\ud130\ub9c1\uc740 top \uba85\ub839\uc5b4\ub97c \uc0ac\uc6a9\ud558\uc5ec CPU \ubc0f \uba54\ubaa8\ub9ac \uc0ac\uc6a9\ub7c9\uc744 \uc2e4\uc2dc\uac04\uc73c\ub85c \ud655\uc778\ud558\ub294 \ubc29\ubc95\uc785\ub2c8\ub2e4. \uc774\ub97c \ud1b5\ud574 \ub9ac\uc18c\uc2a4 \ubd80\uc871 \ubb38\uc81c\ub97c \uc870\uae30\uc5d0 \ubc1c\uacac\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n
5. \ubb38\uc81c \ud574\uacb0\uc744 \uc704\ud55c \ub2e8\uacc4\ubcc4 \uc811\uadfc\ubc95<\/h2>\n
\uc11c\ubc84 \uc18d\ub3c4 \uc800\ud558 \ubc0f MySQL \uc7a5\uc560 \ubb38\uc81c\ub97c \ud574\uacb0\ud558\uae30 \uc704\ud574\uc11c\ub294 \uccb4\uacc4\uc801\uc778 \uc811\uadfc\uc774 \ud544\uc694\ud569\ub2c8\ub2e4. \uc774 \uc139\uc158\uc5d0\uc11c\ub294 \ubb38\uc81c \ud574\uacb0\uc744 \uc704\ud55c \ub2e8\uacc4\ubcc4 \uc811\uadfc\ubc95\uc744 \uc124\uba85\ud569\ub2c8\ub2e4.<\/p>\n
- \n
- \ubb38\uc81c \uc815\uc758 \ubc0f \ubc94\uc704 \uc124\uc815<\/li>\n
- \uc6d0\uc778 \ubd84\uc11d \ubc0f \uc9c4\ub2e8<\/li>\n
- \ud574\uacb0 \ubc29\uc548 \ubaa8\uc0c9<\/li>\n
- \ud574\uacb0 \ubc29\uc548 \uc801\uc6a9<\/li>\n
- \uacb0\uacfc \uac80\uc99d \ubc0f \ubaa8\ub2c8\ud130\ub9c1<\/li>\n<\/ul>\n
\uccab \ubc88\uc9f8 \ub2e8\uacc4\ub294 \ubb38\uc81c \uc815\uc758 \ubc0f \ubc94\uc704 \uc124\uc815\uc785\ub2c8\ub2e4. \uc5b4\ub5a4 \ubb38\uc81c\uac00 \ubc1c\uc0dd\ud588\ub294\uc9c0 \uba85\ud655\ud788 \uc815\uc758\ud558\uace0, \uc601\ud5a5\uc744 \ubc1b\ub294 \uc2dc\uc2a4\ud15c\uc774\ub098 \uc11c\ube44\uc2a4\uc758 \ubc94\uc704\ub97c \uc124\uc815\ud574\uc57c \ud569\ub2c8\ub2e4.<\/p>\n
\ub450 \ubc88\uc9f8 \ub2e8\uacc4\ub294 \uc6d0\uc778 \ubd84\uc11d \ubc0f \uc9c4\ub2e8\uc785\ub2c8\ub2e4. \uc55e\uc11c \uc124\uba85\ud55c \uc9c4\ub2e8 \ubc29\ubc95\uc744 \ud65c\uc6a9\ud558\uc5ec \ubb38\uc81c\uc758 \uc6d0\uc778\uc744 \ud30c\uc545\ud569\ub2c8\ub2e4.<\/p>\n
\uc138 \ubc88\uc9f8 \ub2e8\uacc4\ub294 \ud574\uacb0 \ubc29\uc548 \ubaa8\uc0c9\uc785\ub2c8\ub2e4. \uc6d0\uc778\uc5d0 \ub530\ub77c \uc801\uc808\ud55c \ud574\uacb0 \ubc29\uc548\uc744 \ucc3e\uc544\uc57c \ud569\ub2c8\ub2e4. \uc608\ub97c \ub4e4\uc5b4, \ud558\ub4dc\uc6e8\uc5b4 \uc131\ub2a5 \ubd80\uc871\uc774 \uc6d0\uc778\uc774\ub77c\uba74 \uc5c5\uadf8\ub808\uc774\ub4dc\ub97c \uace0\ub824\ud574\uc57c \ud569\ub2c8\ub2e4.<\/p>\n
\ub124 \ubc88\uc9f8 \ub2e8\uacc4\ub294 \ud574\uacb0 \ubc29\uc548 \uc801\uc6a9\uc785\ub2c8\ub2e4. \uc120\ud0dd\ud55c \ud574\uacb0 \ubc29\uc548\uc744 \uc2e4\uc81c\ub85c \uc801\uc6a9\ud558\uace0, \uc2dc\uc2a4\ud15c\uc5d0 \ubbf8\uce58\ub294 \uc601\ud5a5\uc744 \uad00\ucc30\ud574\uc57c \ud569\ub2c8\ub2e4.<\/p>\n
\ub9c8\uc9c0\ub9c9 \ub2e8\uacc4\ub294 \uacb0\uacfc \uac80\uc99d \ubc0f \ubaa8\ub2c8\ud130\ub9c1\uc785\ub2c8\ub2e4. \ubb38\uc81c \ud574\uacb0 \ud6c4\uc5d0\ub3c4 \uc9c0\uc18d\uc801\uc73c\ub85c \uc2dc\uc2a4\ud15c\uc744 \ubaa8\ub2c8\ud130\ub9c1\ud558\uc5ec \uc7ac\ubc1c \ubc29\uc9c0\ub97c \uc704\ud55c \uc870\uce58\ub97c \ucde8\ud574\uc57c \ud569\ub2c8\ub2e4.<\/p>\n
6. \uc608\ubc29 \uc870\uce58 \ubc0f \ucd5c\uc801\ud654 \ubc29\ubc95<\/h2>\n
\ubb38\uc81c\uac00 \ubc1c\uc0dd\ud55c \ud6c4\uc5d0 \ud574\uacb0\ud558\ub294 \uac83\ubcf4\ub2e4 \uc608\ubc29\ud558\ub294 \uac83\uc774 \ub354 \uc911\uc694\ud569\ub2c8\ub2e4. \uc774 \uc139\uc158\uc5d0\uc11c\ub294 \uc11c\ubc84 \uc18d\ub3c4 \uc800\ud558 \ubc0f MySQL \uc7a5\uc560\ub97c \uc608\ubc29\ud558\uae30 \uc704\ud55c \uc870\uce58\uc640 \ucd5c\uc801\ud654 \ubc29\ubc95\uc744 \uc124\uba85\ud569\ub2c8\ub2e4.<\/p>\n
- \n
- \uc815\uae30\uc801\uc778 \uc2dc\uc2a4\ud15c \uc810\uac80<\/li>\n
- \uc131\ub2a5 \ubaa8\ub2c8\ud130\ub9c1 \ub3c4\uad6c \ud65c\uc6a9<\/li>\n
- \ucffc\ub9ac \ucd5c\uc801\ud654<\/li>\n
- \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc778\ub371\uc2a4 \uad00\ub9ac<\/li>\n
- \ud558\ub4dc\uc6e8\uc5b4 \uc5c5\uadf8\ub808\uc774\ub4dc \uacc4\ud68d<\/li>\n<\/ul>\n
\uccab \ubc88\uc9f8\ub85c, \uc815\uae30\uc801\uc778 \uc2dc\uc2a4\ud15c \uc810\uac80\uc740 \ud558\ub4dc\uc6e8\uc5b4 \ubc0f \uc18c\ud504\ud2b8\uc6e8\uc5b4 \uc0c1\ud0dc\ub97c \uc8fc\uae30\uc801\uc73c\ub85c \uc810\uac80\ud558\uc5ec \ubb38\uc81c\ub97c \uc0ac\uc804\uc5d0 \ubc1c\uacac\ud558\ub294 \ubc29\ubc95\uc785\ub2c8\ub2e4.<\/p>\n
\ub450 \ubc88\uc9f8\ub85c, \uc131\ub2a5 \ubaa8\ub2c8\ud130\ub9c1 \ub3c4\uad6c\ub97c \ud65c\uc6a9\ud558\uba74 \uc2e4\uc2dc\uac04\uc73c\ub85c \uc2dc\uc2a4\ud15c \uc131\ub2a5\uc744 \ubaa8\ub2c8\ud130\ub9c1\ud558\uace0 \uc774\uc0c1 \uc9d5\ud6c4\ub97c \uc870\uae30\uc5d0 \ubc1c\uacac\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n
\uc138 \ubc88\uc9f8\ub85c, \ucffc\ub9ac \ucd5c\uc801\ud654\ub294 \ube44\ud6a8\uc728\uc801\uc778 \ucffc\ub9ac\ub97c \uac1c\uc120\ud558\uc5ec \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc131\ub2a5\uc744 \ud5a5\uc0c1\uc2dc\ud0a4\ub294 \ubc29\ubc95\uc785\ub2c8\ub2e4. EXPLAIN \uba85\ub839\uc5b4\ub97c \ud65c\uc6a9\ud558\uc5ec \ucffc\ub9ac \uc2e4\ud589 \uacc4\ud68d\uc744 \ubd84\uc11d\ud558\uace0 \ucd5c\uc801\ud654\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n
\ub124 \ubc88\uc9f8\ub85c, \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc778\ub371\uc2a4 \uad00\ub9ac\ub294 \uc778\ub371\uc2a4\ub97c \uc801\uc808\ud788 \uc124\uc815\ud558\uc5ec \uac80\uc0c9 \uc131\ub2a5\uc744 \ud5a5\uc0c1\uc2dc\ud0a4\ub294 \ubc29\ubc95\uc785\ub2c8\ub2e4. \uc778\ub371\uc2a4\uac00 \uc5c6\uc73c\uba74 \uc804\uccb4 \ud14c\uc774\ube14 \uc2a4\uce94\uc774 \ubc1c\uc0dd\ud558\uc5ec \uc131\ub2a5\uc774 \uc800\ud558\ub429\ub2c8\ub2e4.<\/p>\n
\ub9c8\uc9c0\ub9c9\uc73c\ub85c, \ud558\ub4dc\uc6e8\uc5b4 \uc5c5\uadf8\ub808\uc774\ub4dc \uacc4\ud68d\uc740 \uc2dc\uc2a4\ud15c\uc758 \uc131\ub2a5 \uc694\uad6c \uc0ac\ud56d\uc5d0 \ub9de\ucdb0 \ud558\ub4dc\uc6e8\uc5b4\ub97c \uc5c5\uadf8\ub808\uc774\ub4dc\ud558\ub294 \uac83\uc785\ub2c8\ub2e4. \uc608\ub97c \ub4e4\uc5b4, SSD\ub85c \ub514\uc2a4\ud06c\ub97c \uad50\uccb4\ud558\uba74 I\/O \uc131\ub2a5\uc774 \ud06c\uac8c \ud5a5\uc0c1\ub429\ub2c8\ub2e4.<\/p>\n
7. \uc0ac\ub840 \uc5f0\uad6c: \uc131\uacf5\uc801\uc778 \ubb38\uc81c \ud574\uacb0 \uc0ac\ub840<\/h2>\n
\ubb38\uc81c \ud574\uacb0\uc758 \uc2e4\uc81c \uc0ac\ub840\ub97c \ud1b5\ud574 \ud6a8\uacfc\uc801\uc778 \uc811\uadfc\ubc95\uc744 \uc774\ud574\ud558\ub294 \uac83\uc774 \uc911\uc694\ud569\ub2c8\ub2e4. \uc774 \uc139\uc158\uc5d0\uc11c\ub294 \uc131\uacf5\uc801\uc778 \ubb38\uc81c \ud574\uacb0 \uc0ac\ub840\ub97c \uc18c\uac1c\ud569\ub2c8\ub2e4.<\/p>\n
- \n
- \uc804\uc790\uc0c1\uac70\ub798 \uc0ac\uc774\ud2b8\uc758 \uc131\ub2a5 \uac1c\uc120 \uc0ac\ub840<\/li>\n
- \ub300\ud559 \ud3ec\ud138 \uc0ac\uc774\ud2b8\uc758 MySQL \uc7a5\uc560 \ud574\uacb0 \uc0ac\ub840<\/li>\n
- \uac8c\uc784 \uc11c\ubc84\uc758 \ud2b8\ub798\ud53d \uad00\ub9ac \uc0ac\ub840<\/li>\n
- \ub274\uc2a4 \uc0ac\uc774\ud2b8\uc758 \ub85c\ub4dc \ubc38\ub7f0\uc2f1 \uc0ac\ub840<\/li>\n
- \ud074\ub77c\uc6b0\ub4dc \uc11c\ube44\uc2a4\uc758 \uc790\ub3d9\ud654\ub41c \ubaa8\ub2c8\ud130\ub9c1 \uc0ac\ub840<\/li>\n<\/ul>\n
\uccab \ubc88\uc9f8 \uc0ac\ub840\ub294 \ud55c \uc804\uc790\uc0c1\uac70\ub798 \uc0ac\uc774\ud2b8\uc5d0\uc11c \ubc1c\uc0dd\ud55c \uc131\ub2a5 \uc800\ud558 \ubb38\uc81c\uc785\ub2c8\ub2e4. \uc774 \uc0ac\uc774\ud2b8\ub294 \ud2b8\ub798\ud53d \uae09\uc99d\uc73c\ub85c \uc778\ud574 \uc11c\ubc84\uac00 \ub290\ub824\uc84c\uc2b5\ub2c8\ub2e4. \uc774\ub97c \ud574\uacb0\ud558\uae30 \uc704\ud574 \ub85c\ub4dc \ubc38\ub7f0\uc11c\ub97c \ub3c4\uc785\ud558\uace0, \uce90\uc2f1 \uc194\ub8e8\uc158\uc744 \uc801\uc6a9\ud558\uc5ec \uc131\ub2a5\uc744 \ud06c\uac8c \uac1c\uc120\ud588\uc2b5\ub2c8\ub2e4.<\/p>\n
\ub450 \ubc88\uc9f8 \uc0ac\ub840\ub294 \ud55c \ub300\ud559 \ud3ec\ud138 \uc0ac\uc774\ud2b8\uc5d0\uc11c \ubc1c\uc0dd\ud55c MySQL \uc7a5\uc560\uc785\ub2c8\ub2e4. \uc774 \uc0ac\uc774\ud2b8\ub294 \ud559\uc0dd\ub4e4\uc758 \uc218\uac15 \uc2e0\uccad \uae30\uac04 \ub3d9\uc548 \ud2b8\ub798\ud53d\uc774 \uae09\uc99d\ud588\uc2b5\ub2c8\ub2e4. \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc778\ub371\uc2a4\ub97c \ucd5c\uc801\ud654\ud558\uace0, \ucffc\ub9ac\ub97c \uac1c\uc120\ud558\uc5ec \uc7a5\uc560\ub97c \ud574\uacb0\ud588\uc2b5\ub2c8\ub2e4.<\/p>\n
\uc138 \ubc88\uc9f8 \uc0ac\ub840\ub294 \ud55c \uac8c\uc784 \uc11c\ubc84\uc5d0\uc11c \ubc1c\uc0dd\ud55c \ud2b8\ub798\ud53d \uad00\ub9ac \ubb38\uc81c\uc785\ub2c8\ub2e4. \uc774 \uac8c\uc784\uc740 \ucd9c\uc2dc \ud6c4 \uc0ac\uc6a9\uc790 \uc218\uac00 \uae09\uc99d\ud558\uc5ec \uc11c\ubc84\uac00 \uacfc\ubd80\ud558\uc5d0 \uac78\ub838\uc2b5\ub2c8\ub2e4. \uc774\ub97c \ud574\uacb0\ud558\uae30 \uc704\ud574 \ud074\ub77c\uc6b0\ub4dc \uae30\ubc18\uc758 \uc790\ub3d9 \ud655\uc7a5 \uae30\ub2a5\uc744 \ub3c4\uc785\ud558\uc5ec \ud2b8\ub798\ud53d\uc744 \ud6a8\uacfc\uc801\uc73c\ub85c \uad00\ub9ac\ud588\uc2b5\ub2c8\ub2e4.<\/p>\n
\ub124 \ubc88\uc9f8 \uc0ac\ub840\ub294 \ud55c \ub274\uc2a4 \uc0ac\uc774\ud2b8\uc5d0\uc11c \ubc1c\uc0dd\ud55c \ub85c\ub4dc \ubc38\ub7f0\uc2f1 \ubb38\uc81c\uc785\ub2c8\ub2e4. \uc774 \uc0ac\uc774\ud2b8\ub294 \ud2b9\uc815 \uc2dc\uac04\ub300\uc5d0 \ud2b8\ub798\ud53d\uc774 \uc9d1\uc911\ub418\uc5b4 \uc11c\ubc84\uac00 \ub290\ub824\uc84c\uc2b5\ub2c8\ub2e4. \uc5ec\ub7ec \ub300\uc758 \uc11c\ubc84\uc5d0 \ud2b8\ub798\ud53d\uc744 \ubd84\uc0b0\uc2dc\ud0a4\ub294 \ub85c\ub4dc \ubc38\ub7f0\uc2f1 \uc194\ub8e8\uc158\uc744 \ub3c4\uc785\ud558\uc5ec \ubb38\uc81c\ub97c \ud574\uacb0\ud588\uc2b5\ub2c8\ub2e4.<\/p>\n
\ub9c8\uc9c0\ub9c9 \uc0ac\ub840\ub294 \ud074\ub77c\uc6b0\ub4dc \uc11c\ube44\uc2a4\uc5d0\uc11c \uc790\ub3d9\ud654\ub41c \ubaa8\ub2c8\ud130\ub9c1 \uc2dc\uc2a4\ud15c\uc744 \uad6c\ucd95\ud55c \uac83\uc785\ub2c8\ub2e4. \uc774 \uc2dc\uc2a4\ud15c\uc740 \uc2e4\uc2dc\uac04\uc73c\ub85c \uc11c\ubc84 \uc0c1\ud0dc\ub97c \ubaa8\ub2c8\ud130\ub9c1\ud558\uace0 \uc774\uc0c1 \uc9d5\ud6c4\uac00 \ubc1c\uacac\ub418\uba74 \uc790\ub3d9\uc73c\ub85c \uacbd\uace0\ub97c \ubc1c\uc1a1\ud558\uc5ec \uc2e0\uc18d\ud558\uac8c \ub300\uc751\ud560 \uc218 \uc788\ub3c4\ub85d \ud588\uc2b5\ub2c8\ub2e4.<\/p>\n
8. \uacb0\ub860: \uc9c0\uc18d \uac00\ub2a5\ud55c \uc11c\ubc84 \uad00\ub9ac \uc804\ub7b5<\/h2>\n
\uc11c\ubc84 \uc18d\ub3c4 \uc800\ud558\uc640 MySQL \uc7a5\uc560\ub294 \ud604\ub300 \uc6f9 \ud658\uacbd\uc5d0\uc11c \ud53c\ud560 \uc218 \uc5c6\ub294 \ubb38\uc81c\uc785\ub2c8\ub2e4. \uadf8\ub7ec\ub098 \uc801\uc808\ud55c \uc9c4\ub2e8\uacfc \ubb38\uc81c \ud574\uacb0 \ubc29\ubc95\uc744 \ud1b5\ud574 \uc774\ub7ec\ud55c \ubb38\uc81c\ub97c \ud6a8\uacfc\uc801\uc73c\ub85c \uad00\ub9ac\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ubcf8 \uac00\uc774\ub4dc\uc5d0\uc11c \uc81c\uc2dc\ud55c \ub2e8\uacc4\ubcc4 \uc811\uadfc\ubc95\uacfc \uc608\ubc29 \uc870\uce58\ub97c \ud1b5\ud574 \uc9c0\uc18d \uac00\ub2a5\ud55c \uc11c\ubc84 \uad00\ub9ac \uc804\ub7b5\uc744 \uad6c\ucd95\ud558\ub294 \uac83\uc774 \uc911\uc694\ud569\ub2c8\ub2e4.<\/p>\n
\uc11c\ubc84 \uad00\ub9ac\uc790\ub294 \ud56d\uc0c1 \ucd5c\uc2e0 \uae30\uc220 \ub3d9\ud5a5\uacfc \ucd5c\uc801\ud654 \ubc29\ubc95\uc744 \ud559\uc2b5\ud558\uace0 \uc801\uc6a9\ud574\uc57c \ud569\ub2c8\ub2e4. \ub610\ud55c, \uc815\uae30\uc801\uc778 \uc810\uac80\uacfc \ubaa8\ub2c8\ud130\ub9c1\uc744 \ud1b5\ud574 \uc2dc\uc2a4\ud15c\uc758 \uc548\uc815\uc131\uc744 \uc720\uc9c0\ud574\uc57c \ud569\ub2c8\ub2e4. \uc774\ub97c \ud1b5\ud574 \uc0ac\uc6a9\uc790 \uacbd\ud5d8\uc744 \ud5a5\uc0c1\uc2dc\ud0a4\uace0 \ube44\uc988\ub2c8\uc2a4 \uc131\uacf5\uc5d0 \uae30\uc5ec\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n
\uacb0\ub860\uc801\uc73c\ub85c, \uc11c\ubc84 \uc18d\ub3c4 \uc800\ud558\uc640 MySQL \uc7a5\uc560 \ubb38\uc81c\ub294 \uccb4\uacc4\uc801\uc778 \uc811\uadfc\uacfc \uc9c0\uc18d\uc801\uc778 \uad00\ub9ac\ub85c \ud574\uacb0\ud560 \uc218 \uc788\uc73c\uba70, \uc774\ub97c \ud1b5\ud574 \uc548\uc815\uc801\uc774\uace0 \ud6a8\uc728\uc801\uc778 \uc6f9 \uc11c\ube44\uc2a4\ub97c \uc81c\uacf5\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n","protected":false},"excerpt":{"rendered":"
\ubaa9\ucc28 \uc11c\ubc84 \uc18d\ub3c4 \uc800\ud558\uc640 MySQL \uc7a5\uc560: \ubb38\uc81c \ud574\uacb0\uc744 \uc704\ud55c \ub2e8\uacc4\ubcc4 \uac00\uc774\ub4dc 1. \uc11c\ubc84 \uc18d\ub3c4 \uc800\ud558\uc758 […]<\/p>\n","protected":false},"author":1,"featured_media":51563,"comment_status":"","ping_status":"","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[1957],"tags":[2100,2455],"class_list":["post-51668","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-development","tag-mysql","tag-query"],"acf":[],"_links":{"self":[{"href":"https:\/\/m9js.shop\/blog\/wp-json\/wp\/v2\/posts\/51668","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=51668"}],"version-history":[{"count":0,"href":"https:\/\/m9js.shop\/blog\/wp-json\/wp\/v2\/posts\/51668\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/m9js.shop\/blog\/wp-json\/wp\/v2\/media\/51563"}],"wp:attachment":[{"href":"https:\/\/m9js.shop\/blog\/wp-json\/wp\/v2\/media?parent=51668"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/m9js.shop\/blog\/wp-json\/wp\/v2\/categories?post=51668"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/m9js.shop\/blog\/wp-json\/wp\/v2\/tags?post=51668"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}