{"id":51665,"date":"2024-08-15T04:04:56","date_gmt":"2024-08-14T19:04:56","guid":{"rendered":"https:\/\/8gfg.shop\/blog\/development\/causes-of-database-failures-and-how-to-respond-to-them-in-mysql"},"modified":"2024-08-15T04:04:56","modified_gmt":"2024-08-14T19:04:56","slug":"causes-of-database-failures-and-how-to-respond-to-them-in-mysql","status":"publish","type":"post","link":"https:\/\/8gfg.shop\/blog\/development\/causes-of-database-failures-and-how-to-respond-to-them-in-mysql","title":{"rendered":"MySQL\uc5d0\uc11c\uc758 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc7a5\uc560 \uc6d0\uc778\uacfc \ub300\uc751 \ubc29\ubc95"},"content":{"rendered":"<ul class=\"toc_post_list\">\n<li>\n<h2>\ubaa9\ucc28<\/h2>\n<ul>\n<li><a href=\"#mysql%ec%97%90%ec%84%9c%ec%9d%98-%eb%8d%b0%ec%9d%b4%ed%84%b0%eb%b2%a0%ec%9d%b4%ec%8a%a4-%ec%9e%a5%ec%95%a0-%ec%9b%90%ec%9d%b8%ea%b3%bc-%eb%8c%80%ec%9d%91-%eb%b0%a9%eb%b2%95-KUbbRbKeZs\">MySQL\uc5d0\uc11c\uc758 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc7a5\uc560 \uc6d0\uc778\uacfc \ub300\uc751 \ubc29\ubc95<\/a><\/li>\n<li><a href=\"#1-mysql-%eb%8d%b0%ec%9d%b4%ed%84%b0%eb%b2%a0%ec%9d%b4%ec%8a%a4-%ec%9e%a5%ec%95%a0%ec%9d%98-%ec%9d%bc%eb%b0%98%ec%a0%81%ec%9d%b8-%ec%9b%90%ec%9d%b8-KUbbRbKeZs\">1. MySQL \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc7a5\uc560\uc758 \uc77c\ubc18\uc801\uc778 \uc6d0\uc778<\/a><\/li>\n<li><a href=\"#2-%ed%95%98%eb%93%9c%ec%9b%a8%ec%96%b4-%ea%b3%a0%ec%9e%a5%ec%97%90-%eb%8c%80%ed%95%9c-%eb%8c%80%ec%9d%91-%eb%b0%a9%eb%b2%95-KUbbRbKeZs\">2. \ud558\ub4dc\uc6e8\uc5b4 \uace0\uc7a5\uc5d0 \ub300\ud55c \ub300\uc751 \ubc29\ubc95<\/a><\/li>\n<li><a href=\"#3-%ec%86%8c%ed%94%84%ed%8a%b8%ec%9b%a8%ec%96%b4-%eb%b2%84%ea%b7%b8%ec%99%80-%ea%b7%b8-%eb%8c%80%ec%9d%91-%eb%b0%a9%eb%b2%95-KUbbRbKeZs\">3. \uc18c\ud504\ud2b8\uc6e8\uc5b4 \ubc84\uadf8\uc640 \uadf8 \ub300\uc751 \ubc29\ubc95<\/a><\/li>\n<li><a href=\"#4-%eb%84%a4%ed%8a%b8%ec%9b%8c%ed%81%ac-%eb%ac%b8%ec%a0%9c%ec%99%80-%ea%b7%b8-%ed%95%b4%ea%b2%b0-%eb%b0%a9%ec%95%88-KUbbRbKeZs\">4. \ub124\ud2b8\uc6cc\ud06c \ubb38\uc81c\uc640 \uadf8 \ud574\uacb0 \ubc29\uc548<\/a><\/li>\n<li><a href=\"#5-%ec%9e%98%eb%aa%bb%eb%90%9c-%ec%bf%bc%eb%a6%ac%ec%99%80-%ec%84%b1%eb%8a%a5-%ec%b5%9c%ec%a0%81%ed%99%94-KUbbRbKeZs\">5. \uc798\ubabb\ub41c \ucffc\ub9ac\uc640 \uc131\ub2a5 \ucd5c\uc801\ud654<\/a><\/li>\n<li><a href=\"#6-%eb%8d%b0%ec%9d%b4%ed%84%b0-%ec%86%90%ec%83%81%ea%b3%bc-%eb%b3%b5%ea%b5%ac-%eb%b0%a9%eb%b2%95-KUbbRbKeZs\">6. \ub370\uc774\ud130 \uc190\uc0c1\uacfc \ubcf5\uad6c \ubc29\ubc95<\/a><\/li>\n<li><a href=\"#7-%eb%a6%ac%ec%86%8c%ec%8a%a4-%eb%b6%80%ec%a1%b1%ea%b3%bc-%ea%b4%80%eb%a6%ac-%eb%b0%a9%ec%95%88-KUbbRbKeZs\">7. \ub9ac\uc18c\uc2a4 \ubd80\uc871\uacfc \uad00\ub9ac \ubc29\uc548<\/a><\/li>\n<li><a href=\"#8-%eb%b3%b4%ec%95%88-%ea%b3%b5%ea%b2%a9%ea%b3%bc-%eb%8c%80%ec%9d%91-%ec%a0%84%eb%9e%b5-KUbbRbKeZs\">8. \ubcf4\uc548 \uacf5\uaca9\uacfc \ub300\uc751 \uc804\ub7b5<\/a><\/li>\n<li><a href=\"#%ea%b2%b0%eb%a1%a0-KUbbRbKeZs\">\uacb0\ub860<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<h1 id=\"mysql%ec%97%90%ec%84%9c%ec%9d%98-%eb%8d%b0%ec%9d%b4%ed%84%b0%eb%b2%a0%ec%9d%b4%ec%8a%a4-%ec%9e%a5%ec%95%a0-%ec%9b%90%ec%9d%b8%ea%b3%bc-%eb%8c%80%ec%9d%91-%eb%b0%a9%eb%b2%95-KUbbRbKeZs\">MySQL\uc5d0\uc11c\uc758 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc7a5\uc560 \uc6d0\uc778\uacfc \ub300\uc751 \ubc29\ubc95<\/h1>\n<p>\ub370\uc774\ud130\ubca0\uc774\uc2a4\ub294 \ud604\ub300\uc758 \ubaa8\ub4e0 \uc560\ud50c\ub9ac\ucf00\uc774\uc158\uc5d0\uc11c \ud575\uc2ec\uc801\uc778 \uc5ed\ud560\uc744 \ud569\ub2c8\ub2e4. \ud2b9\ud788 MySQL\uc740 \uc624\ud508 \uc18c\uc2a4 \uad00\uacc4\ud615 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uad00\ub9ac \uc2dc\uc2a4\ud15c\uc73c\ub85c, \ub9ce\uc740 \uae30\uc5c5\uacfc \uac1c\ubc1c\uc790\ub4e4\uc774 \uc120\ud638\ud558\ub294 \uc120\ud0dd\uc9c0\uc785\ub2c8\ub2e4. \uadf8\ub7ec\ub098 MySQL \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub294 \ub2e4\uc591\ud55c \uc774\uc720\ub85c \uc7a5\uc560\uac00 \ubc1c\uc0dd\ud560 \uc218 \uc788\uc73c\uba70, \uc774\ub7ec\ud55c \uc7a5\uc560\ub294 \ube44\uc988\ub2c8\uc2a4\uc5d0 \uc2ec\uac01\ud55c \uc601\ud5a5\uc744 \ubbf8\uce60 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ubcf8 \uae00\uc5d0\uc11c\ub294 MySQL\uc5d0\uc11c \ubc1c\uc0dd\ud560 \uc218 \uc788\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc7a5\uc560\uc758 \uc6d0\uc778\uacfc \uadf8\uc5d0 \ub300\ud55c \ub300\uc751 \ubc29\ubc95\uc744 \uc2ec\ub3c4 \uc788\uac8c \ub2e4\ub8e8\uc5b4 \ubcf4\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n<h2 id=\"1-mysql-%eb%8d%b0%ec%9d%b4%ed%84%b0%eb%b2%a0%ec%9d%b4%ec%8a%a4-%ec%9e%a5%ec%95%a0%ec%9d%98-%ec%9d%bc%eb%b0%98%ec%a0%81%ec%9d%b8-%ec%9b%90%ec%9d%b8-KUbbRbKeZs\">1. MySQL \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc7a5\uc560\uc758 \uc77c\ubc18\uc801\uc778 \uc6d0\uc778<\/h2>\n<p>MySQL \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0\uc11c \uc7a5\uc560\uac00 \ubc1c\uc0dd\ud558\ub294 \uc6d0\uc778\uc740 \ub2e4\uc591\ud569\ub2c8\ub2e4. \uc774 \uc139\uc158\uc5d0\uc11c\ub294 \uac00\uc7a5 \uc77c\ubc18\uc801\uc778 \uc6d0\uc778\ub4e4\uc744 \uc0b4\ud3b4\ubcf4\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n<ul>\n<li>\ud558\ub4dc\uc6e8\uc5b4 \uace0\uc7a5<\/li>\n<li>\uc18c\ud504\ud2b8\uc6e8\uc5b4 \ubc84\uadf8<\/li>\n<li>\ub124\ud2b8\uc6cc\ud06c \ubb38\uc81c<\/li>\n<li>\uc798\ubabb\ub41c \ucffc\ub9ac<\/li>\n<li>\ub370\uc774\ud130 \uc190\uc0c1<\/li>\n<li>\ub9ac\uc18c\uc2a4 \ubd80\uc871<\/li>\n<li>\ubcf4\uc548 \uacf5\uaca9<\/li>\n<li>\ubc31\uc5c5 \uc2e4\ud328<\/li>\n<\/ul>\n<p>\ud558\ub4dc\uc6e8\uc5b4 \uace0\uc7a5\uc740 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc11c\ubc84\uc758 \ubb3c\ub9ac\uc801 \uad6c\uc131 \uc694\uc18c\uac00 \uace0\uc7a5\ub098\ub294 \uacbd\uc6b0\ub97c \ub9d0\ud569\ub2c8\ub2e4. \uc608\ub97c \ub4e4\uc5b4, \ud558\ub4dc \ub4dc\ub77c\uc774\ube0c\uc758 \uace0\uc7a5\uc740 \ub370\uc774\ud130 \uc190\uc2e4\ub85c \uc774\uc5b4\uc9c8 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc18c\ud504\ud2b8\uc6e8\uc5b4 \ubc84\uadf8\ub294 MySQL\uc758 \ud2b9\uc815 \ubc84\uc804\uc5d0\uc11c \ubc1c\uc0dd\ud560 \uc218 \uc788\ub294 \ubb38\uc81c\ub85c, \uc608\uae30\uce58 \uc54a\uc740 \ub3d9\uc791\uc744 \ucd08\ub798\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ub124\ud2b8\uc6cc\ud06c \ubb38\uc81c\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc640 \uc560\ud50c\ub9ac\ucf00\uc774\uc158 \uac04\uc758 \uc5f0\uacb0\uc774 \ub04a\uc5b4\uc9c0\uac70\ub098 \uc9c0\uc5f0\ub418\ub294 \uacbd\uc6b0\ub97c \ud3ec\ud568\ud569\ub2c8\ub2e4.<\/p>\n<p>\uc798\ubabb\ub41c \ucffc\ub9ac\ub294 \ube44\ud6a8\uc728\uc801\uc778 \ucffc\ub9ac \uc2e4\ud589\uc73c\ub85c \uc778\ud574 \uc131\ub2a5 \uc800\ud558\ub97c \ucd08\ub798\ud560 \uc218 \uc788\uc73c\uba70, \uc774\ub294 \uacb0\uad6d \uc2dc\uc2a4\ud15c \uc7a5\uc560\ub85c \uc774\uc5b4\uc9c8 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ub370\uc774\ud130 \uc190\uc0c1\uc740 \uc5ec\ub7ec \uac00\uc9c0 \uc774\uc720\ub85c \ubc1c\uc0dd\ud560 \uc218 \uc788\uc73c\uba70, \uc774\ub85c \uc778\ud574 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uac00 \uc815\uc0c1\uc801\uc73c\ub85c \uc791\ub3d9\ud558\uc9c0 \uc54a\uc744 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ub9ac\uc18c\uc2a4 \ubd80\uc871\uc740 CPU, \uba54\ubaa8\ub9ac, \ub514\uc2a4\ud06c \uacf5\uac04 \ub4f1\uc758 \uc790\uc6d0\uc774 \ubd80\uc871\ud574\uc9c0\ub294 \uacbd\uc6b0\ub97c \ub9d0\ud569\ub2c8\ub2e4.<\/p>\n<p>\ubcf4\uc548 \uacf5\uaca9\uc740 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0 \ub300\ud55c \uc678\ubd80\uc758 \uc545\uc758\uc801\uc778 \uacf5\uaca9\uc73c\ub85c, \ub370\uc774\ud130 \uc720\ucd9c\uc774\ub098 \uc190\uc0c1\uc744 \ucd08\ub798\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ub9c8\uc9c0\ub9c9\uc73c\ub85c \ubc31\uc5c5 \uc2e4\ud328\ub294 \ub370\uc774\ud130 \ubcf5\uad6c\ub97c \uc704\ud55c \uc911\uc694\ud55c \uc808\ucc28\uac00 \uc2e4\ud328\ud558\ub294 \uacbd\uc6b0\ub85c, \uc774\ub294 \ub370\uc774\ud130 \uc190\uc2e4\ub85c \uc774\uc5b4\uc9c8 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<h2 id=\"2-%ed%95%98%eb%93%9c%ec%9b%a8%ec%96%b4-%ea%b3%a0%ec%9e%a5%ec%97%90-%eb%8c%80%ed%95%9c-%eb%8c%80%ec%9d%91-%eb%b0%a9%eb%b2%95-KUbbRbKeZs\">2. \ud558\ub4dc\uc6e8\uc5b4 \uace0\uc7a5\uc5d0 \ub300\ud55c \ub300\uc751 \ubc29\ubc95<\/h2>\n<p>\ud558\ub4dc\uc6e8\uc5b4 \uace0\uc7a5\uc740 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc7a5\uc560\uc758 \uc8fc\uc694 \uc6d0\uc778 \uc911 \ud558\ub098\uc785\ub2c8\ub2e4. \uc774 \uc139\uc158\uc5d0\uc11c\ub294 \ud558\ub4dc\uc6e8\uc5b4 \uace0\uc7a5\uc5d0 \ub300\ud55c \uc608\ubc29 \ubc0f \ub300\uc751 \ubc29\ubc95\uc744 \uc0b4\ud3b4\ubcf4\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n<p>\uccab \ubc88\uc9f8\ub85c, \uc815\uae30\uc801\uc778 \ud558\ub4dc\uc6e8\uc5b4 \uc810\uac80\uc774 \ud544\uc694\ud569\ub2c8\ub2e4. \uc11c\ubc84\uc758 \ud558\ub4dc \ub4dc\ub77c\uc774\ube0c, \uba54\ubaa8\ub9ac, CPU \ub4f1\uc758 \uc0c1\ud0dc\ub97c \uc8fc\uae30\uc801\uc73c\ub85c \uc810\uac80\ud558\uc5ec \ubb38\uc81c\uac00 \ubc1c\uc0dd\ud558\uae30 \uc804\uc5d0 \ubbf8\ub9ac \ub300\ucc98\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc608\ub97c \ub4e4\uc5b4, SMART(Self-Monitoring, Analysis and Reporting Technology) \ub3c4\uad6c\ub97c \uc0ac\uc6a9\ud558\uc5ec \ud558\ub4dc \ub4dc\ub77c\uc774\ube0c\uc758 \uc0c1\ud0dc\ub97c \ubaa8\ub2c8\ud130\ub9c1\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<pre><code>smartctl -a \/dev\/sda<\/code><\/pre>\n<p>\ub450 \ubc88\uc9f8\ub85c, RAID(\uc911\ubcf5 \ubc30\uc5f4 \ub3c5\ub9bd \ub514\uc2a4\ud06c)\ub97c \uad6c\uc131\ud558\ub294 \uac83\uc774 \uc88b\uc2b5\ub2c8\ub2e4. RAID\ub294 \uc5ec\ub7ec \uac1c\uc758 \ud558\ub4dc \ub4dc\ub77c\uc774\ube0c\ub97c \ud558\ub098\uc758 \ub17c\ub9ac\uc801 \ub4dc\ub77c\uc774\ube0c\ub85c \ubb36\uc5b4 \ub370\uc774\ud130\uc758 \uc548\uc804\uc131\uc744 \ub192\uc774\ub294 \uae30\uc220\uc785\ub2c8\ub2e4. RAID 1(\ubbf8\ub7ec\ub9c1)\uc774\ub098 RAID 5(\ud328\ub9ac\ud2f0)\ub97c \uc0ac\uc6a9\ud558\uba74 \ud558\ub4dc \ub4dc\ub77c\uc774\ube0c\uac00 \uace0\uc7a5 \ub098\ub354\ub77c\ub3c4 \ub370\uc774\ud130 \uc190\uc2e4\uc744 \ubc29\uc9c0\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<p>\uc138 \ubc88\uc9f8\ub85c, \uc815\uae30\uc801\uc778 \ubc31\uc5c5\uc744 \uc218\ud589\ud574\uc57c \ud569\ub2c8\ub2e4. \ud558\ub4dc\uc6e8\uc5b4 \uace0\uc7a5\uc774 \ubc1c\uc0dd\ud558\ub354\ub77c\ub3c4 \ucd5c\uc2e0 \ub370\uc774\ud130\ub97c \ubcf5\uad6c\ud560 \uc218 \uc788\ub3c4\ub85d \uc8fc\uae30\uc801\uc73c\ub85c \ubc31\uc5c5\uc744 \uc218\ud589\ud558\ub294 \uac83\uc774 \uc911\uc694\ud569\ub2c8\ub2e4. \ubc31\uc5c5\uc740 \ub85c\uceec \uc800\uc7a5\uc18c\ubfd0\ub9cc \uc544\ub2c8\ub77c \ud074\ub77c\uc6b0\ub4dc \uc11c\ube44\uc2a4\uc5d0\ub3c4 \uc800\uc7a5\ud558\ub294 \uac83\uc774 \uc88b\uc2b5\ub2c8\ub2e4.<\/p>\n<p>\ub9c8\uc9c0\ub9c9\uc73c\ub85c, \ud558\ub4dc\uc6e8\uc5b4 \uc774\uc911\ud654 \uad6c\uc131\uc744 \uace0\ub824\ud574\uc57c \ud569\ub2c8\ub2e4. \uc774\uc911\ud654 \uad6c\uc131\uc740 \ud558\ub098\uc758 \uc11c\ubc84\uac00 \uace0\uc7a5 \ub098\ub354\ub77c\ub3c4 \ub2e4\ub978 \uc11c\ubc84\uac00 \uc790\ub3d9\uc73c\ub85c \ub300\uccb4\ud558\uc5ec \uc11c\ube44\uc2a4 \uc911\ub2e8\uc744 \ucd5c\uc18c\ud654\ud558\ub294 \ubc29\ubc95\uc785\ub2c8\ub2e4. \uc774\ub97c \ud1b5\ud574 \ube44\uc988\ub2c8\uc2a4 \uc5f0\uc18d\uc131\uc744 \uc720\uc9c0\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<h2 id=\"3-%ec%86%8c%ed%94%84%ed%8a%b8%ec%9b%a8%ec%96%b4-%eb%b2%84%ea%b7%b8%ec%99%80-%ea%b7%b8-%eb%8c%80%ec%9d%91-%eb%b0%a9%eb%b2%95-KUbbRbKeZs\">3. \uc18c\ud504\ud2b8\uc6e8\uc5b4 \ubc84\uadf8\uc640 \uadf8 \ub300\uc751 \ubc29\ubc95<\/h2>\n<p>\uc18c\ud504\ud2b8\uc6e8\uc5b4 \ubc84\uadf8\ub294 MySQL \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0\uc11c \ubc1c\uc0dd\ud560 \uc218 \uc788\ub294 \ub610 \ub2e4\ub978 \uc7a5\uc560 \uc6d0\uc778\uc785\ub2c8\ub2e4. \uc774 \uc139\uc158\uc5d0\uc11c\ub294 \uc18c\ud504\ud2b8\uc6e8\uc5b4 \ubc84\uadf8\uc5d0 \ub300\ud55c \uc774\ud574\uc640 \ub300\uc751 \ubc29\ubc95\uc744 \ub2e4\ub8e8\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n<p>\uc18c\ud504\ud2b8\uc6e8\uc5b4 \ubc84\uadf8\ub294 MySQL\uc758 \ud2b9\uc815 \ubc84\uc804\uc5d0\uc11c \ubc1c\uc0dd\ud560 \uc218 \uc788\ub294 \ubb38\uc81c\ub85c, \uc608\uae30\uce58 \uc54a\uc740 \ub3d9\uc791\uc774\ub098 \uc131\ub2a5 \uc800\ud558\ub97c \ucd08\ub798\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc774\ub97c \uc608\ubc29\ud558\uae30 \uc704\ud574\uc11c\ub294 \ud56d\uc0c1 \ucd5c\uc2e0 \ubc84\uc804\uc73c\ub85c \uc5c5\ub370\uc774\ud2b8\ud558\ub294 \uac83\uc774 \uc911\uc694\ud569\ub2c8\ub2e4. MySQL\uc740 \uc815\uae30\uc801\uc73c\ub85c \ubcf4\uc548 \ud328\uce58\uc640 \ubc84\uadf8 \uc218\uc815\uc744 \uc81c\uacf5\ud558\ubbc0\ub85c, \uc774\ub97c \uc801\uc6a9\ud558\uc5ec \uc2dc\uc2a4\ud15c\uc758 \uc548\uc815\uc131\uc744 \ub192\uc77c \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<p>\ub610\ud55c, MySQL\uc758 \uacf5\uc2dd \ubb38\uc11c\ub098 \ucee4\ubba4\ub2c8\ud2f0 \ud3ec\ub7fc\uc744 \ud1b5\ud574 \uc54c\ub824\uc9c4 \ubc84\uadf8\uc640 \uadf8 \ud574\uacb0 \ubc29\ubc95\uc744 \ud655\uc778\ud558\ub294 \uac83\ub3c4 \uc88b\uc740 \ubc29\ubc95\uc785\ub2c8\ub2e4. \uc608\ub97c \ub4e4\uc5b4, \ud2b9\uc815 \ucffc\ub9ac\uc5d0\uc11c \uc131\ub2a5 \ubb38\uc81c\uac00 \ubc1c\uc0dd\ud558\ub294 \uacbd\uc6b0, \ud574\ub2f9 \ucffc\ub9ac\ub97c \ucd5c\uc801\ud654\ud558\uac70\ub098 \uc778\ub371\uc2a4\ub97c \ucd94\uac00\ud558\uc5ec \uc131\ub2a5\uc744 \uac1c\uc120\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<pre><code>ALTER TABLE table_name ADD INDEX index_name (column_name);<\/code><\/pre>\n<p>\ubc84\uadf8\uac00 \ubc1c\uc0dd\ud588\uc744 \ub54c\ub294 \ub85c\uadf8 \ud30c\uc77c\uc744 \ubd84\uc11d\ud558\uc5ec \ubb38\uc81c\uc758 \uc6d0\uc778\uc744 \ud30c\uc545\ud574\uc57c \ud569\ub2c8\ub2e4. MySQL\uc758 \uc5d0\ub7ec \ub85c\uadf8\ub294 \ubb38\uc81c \ud574\uacb0\uc5d0 \uc720\uc6a9\ud55c \uc815\ubcf4\ub97c \uc81c\uacf5\ud569\ub2c8\ub2e4. \uc5d0\ub7ec \ub85c\uadf8\ub97c \ud1b5\ud574 \uc5b4\ub5a4 \ucffc\ub9ac\uac00 \uc2e4\ud328\ud588\ub294\uc9c0, \uc5b4\ub5a4 \uc624\ub958 \uba54\uc2dc\uc9c0\uac00 \ubc1c\uc0dd\ud588\ub294\uc9c0\ub97c \ud655\uc778\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<p>\ub9c8\uc9c0\ub9c9\uc73c\ub85c, \ud14c\uc2a4\ud2b8 \ud658\uacbd\uc5d0\uc11c \uc0c8\ub85c\uc6b4 \uae30\ub2a5\uc774\ub098 \uc5c5\ub370\uc774\ud2b8\ub97c \uc801\uc6a9\ud574 \ubcf4\ub294 \uac83\uc774 \uc88b\uc2b5\ub2c8\ub2e4. \ud504\ub85c\ub355\uc158 \ud658\uacbd\uc5d0 \uc9c1\uc811 \uc801\uc6a9\ud558\uae30 \uc804\uc5d0 \ud14c\uc2a4\ud2b8 \ud658\uacbd\uc5d0\uc11c \ucda9\ubd84\ud788 \uac80\uc99d\ud558\uc5ec \ubb38\uc81c\ub97c \uc0ac\uc804\uc5d0 \uc608\ubc29\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<h2 id=\"4-%eb%84%a4%ed%8a%b8%ec%9b%8c%ed%81%ac-%eb%ac%b8%ec%a0%9c%ec%99%80-%ea%b7%b8-%ed%95%b4%ea%b2%b0-%eb%b0%a9%ec%95%88-KUbbRbKeZs\">4. \ub124\ud2b8\uc6cc\ud06c \ubb38\uc81c\uc640 \uadf8 \ud574\uacb0 \ubc29\uc548<\/h2>\n<p>\ub124\ud2b8\uc6cc\ud06c \ubb38\uc81c\ub294 MySQL \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc640 \uc560\ud50c\ub9ac\ucf00\uc774\uc158 \uac04\uc758 \uc5f0\uacb0\uc774 \ub04a\uc5b4\uc9c0\uac70\ub098 \uc9c0\uc5f0\ub418\ub294 \uacbd\uc6b0\ub97c \ud3ec\ud568\ud569\ub2c8\ub2e4. \uc774 \uc139\uc158\uc5d0\uc11c\ub294 \ub124\ud2b8\uc6cc\ud06c \ubb38\uc81c\uc5d0 \ub300\ud55c \uc774\ud574\uc640 \ud574\uacb0 \ubc29\uc548\uc744 \ub2e4\ub8e8\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n<p>\ub124\ud2b8\uc6cc\ud06c \ubb38\uc81c\ub294 \ub2e4\uc591\ud55c \uc6d0\uc778\uc73c\ub85c \ubc1c\uc0dd\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc608\ub97c \ub4e4\uc5b4, \ub77c\uc6b0\ud130\ub098 \uc2a4\uc704\uce58\uc758 \uace0\uc7a5, \ub124\ud2b8\uc6cc\ud06c \ucf00\uc774\ube14\uc758 \uc190\uc0c1 \ub4f1\uc774 \uc788\uc2b5\ub2c8\ub2e4. \uc774\ub7ec\ud55c \ubb38\uc81c\ub97c \uc608\ubc29\ud558\uae30 \uc704\ud574\uc11c\ub294 \ub124\ud2b8\uc6cc\ud06c \uc7a5\ube44\uc758 \uc0c1\ud0dc\ub97c \uc8fc\uae30\uc801\uc73c\ub85c \uc810\uac80\ud558\uace0, \ud544\uc694\uc2dc \uad50\uccb4\ud558\ub294 \uac83\uc774 \uc911\uc694\ud569\ub2c8\ub2e4.<\/p>\n<p>\ub610\ud55c, \ub124\ud2b8\uc6cc\ud06c \ubaa8\ub2c8\ud130\ub9c1 \ub3c4\uad6c\ub97c \uc0ac\uc6a9\ud558\uc5ec \uc2e4\uc2dc\uac04\uc73c\ub85c \ub124\ud2b8\uc6cc\ud06c \uc0c1\ud0dc\ub97c \ubaa8\ub2c8\ud130\ub9c1\ud558\ub294 \uac83\ub3c4 \uc88b\uc740 \ubc29\ubc95\uc785\ub2c8\ub2e4. \uc608\ub97c \ub4e4\uc5b4, Nagios\ub098 Zabbix\uc640 \uac19\uc740 \ub3c4\uad6c\ub97c \uc0ac\uc6a9\ud558\uc5ec \ub124\ud2b8\uc6cc\ud06c \ud2b8\ub798\ud53d\uc744 \ubaa8\ub2c8\ud130\ub9c1\ud558\uace0, \ubb38\uc81c\uac00 \ubc1c\uc0dd\ud588\uc744 \ub54c \uc989\uc2dc \uc54c\ub9bc\uc744 \ubc1b\uc744 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<pre><code>sudo apt-get install nagios-nrpe-plugin<\/code><\/pre>\n<p>\ub124\ud2b8\uc6cc\ud06c \uc9c0\uc5f0\uc774 \ubc1c\uc0dd\ud558\ub294 \uacbd\uc6b0, \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc640 \uc560\ud50c\ub9ac\ucf00\uc774\uc158 \uac04\uc758 \uc5f0\uacb0 \uc124\uc815\uc744 \ucd5c\uc801\ud654\ud574\uc57c \ud569\ub2c8\ub2e4. \uc608\ub97c \ub4e4\uc5b4, MySQL\uc758 `wait_timeout` \ubc0f `interactive_timeout` \uac12\uc744 \uc870\uc815\ud558\uc5ec \uc5f0\uacb0 \uc720\uc9c0 \uc2dc\uac04\uc744 \ub298\ub9b4 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<p>\ub9c8\uc9c0\ub9c9\uc73c\ub85c, VPN\uc774\ub098 \uc804\uc6a9 \ud68c\uc120\uc744 \uc0ac\uc6a9\ud558\ub294 \uac83\ub3c4 \uace0\ub824\ud574 \ubcfc \ub9cc\ud569\ub2c8\ub2e4. \uacf5\uc6a9 \uc778\ud130\ub137\uc744 \ud1b5\ud574 \uc5f0\uacb0\ud560 \uacbd\uc6b0 \ubcf4\uc548\uacfc \uc548\uc815\uc131 \ubb38\uc81c\uac00 \ubc1c\uc0dd\ud560 \uc218 \uc788\uc73c\ubbc0\ub85c, \uc548\uc804\ud55c \uc5f0\uacb0\uc744 \uc704\ud574 \uc804\uc6a9 \ud68c\uc120\uc744 \uc0ac\uc6a9\ud558\ub294 \uac83\uc774 \uc88b\uc2b5\ub2c8\ub2e4.<\/p>\n<h2 id=\"5-%ec%9e%98%eb%aa%bb%eb%90%9c-%ec%bf%bc%eb%a6%ac%ec%99%80-%ec%84%b1%eb%8a%a5-%ec%b5%9c%ec%a0%81%ed%99%94-KUbbRbKeZs\">5. \uc798\ubabb\ub41c \ucffc\ub9ac\uc640 \uc131\ub2a5 \ucd5c\uc801\ud654<\/h2>\n<p>\uc798\ubabb\ub41c \ucffc\ub9ac\ub294 \ube44\ud6a8\uc728\uc801\uc778 \ucffc\ub9ac \uc2e4\ud589\uc73c\ub85c \uc778\ud574 \uc131\ub2a5 \uc800\ud558\ub97c \ucd08\ub798\ud560 \uc218 \uc788\uc73c\uba70, \uc774\ub294 \uacb0\uad6d \uc2dc\uc2a4\ud15c \uc7a5\uc560\ub85c \uc774\uc5b4\uc9c8 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc774 \uc139\uc158\uc5d0\uc11c\ub294 \uc798\ubabb\ub41c \ucffc\ub9ac\ub97c \uc2dd\ubcc4\ud558\uace0 \ucd5c\uc801\ud654\ud558\ub294 \ubc29\ubc95\uc744 \ub2e4\ub8e8\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n<p>\uc798\ubabb\ub41c \ucffc\ub9ac\ub97c \uc2dd\ubcc4\ud558\uae30 \uc704\ud574\uc11c\ub294 MySQL\uc758 `EXPLAIN` \uba85\ub839\uc5b4\ub97c \uc0ac\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc774 \uba85\ub839\uc5b4\ub294 \ucffc\ub9ac\uac00 \uc2e4\ud589\ub420 \ub54c MySQL\uc774 \uc0ac\uc6a9\ud558\ub294 \uc2e4\ud589 \uacc4\ud68d\uc744 \ubcf4\uc5ec\uc90d\ub2c8\ub2e4. \uc774\ub97c \ud1b5\ud574 \ucffc\ub9ac\uc758 \uc131\ub2a5 \ubcd1\ubaa9 \uc9c0\uc810\uc744 \ud30c\uc545\ud558\uace0 \ucd5c\uc801\ud654\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<pre><code>EXPLAIN SELECT * FROM table_name WHERE column_name = 'value';<\/code><\/pre>\n<p>\ucffc\ub9ac\ub97c \ucd5c\uc801\ud654\ud558\uae30 \uc704\ud574\uc11c\ub294 \uc778\ub371\uc2a4\ub97c \uc801\uc808\ud788 \ud65c\uc6a9\ud574\uc57c \ud569\ub2c8\ub2e4. \uc778\ub371\uc2a4\ub294 \ub370\uc774\ud130 \uac80\uc0c9 \uc18d\ub3c4\ub97c \ub192\uc5ec\uc8fc\ub294 \uc911\uc694\ud55c \uc694\uc18c\uc785\ub2c8\ub2e4. \uc790\uc8fc \uac80\uc0c9\ub418\ub294 \uceec\ub7fc\uc5d0 \uc778\ub371\uc2a4\ub97c \ucd94\uac00\ud558\uba74 \ucffc\ub9ac \uc131\ub2a5\uc744 \ud06c\uac8c \ud5a5\uc0c1\uc2dc\ud0ac \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<p>\ub610\ud55c, \ubd88\ud544\uc694\ud55c \ub370\uc774\ud130\ub97c \uc870\ud68c\ud558\uc9c0 \uc54a\ub3c4\ub85d \ucffc\ub9ac\ub97c \uc791\uc131\ud574\uc57c \ud569\ub2c8\ub2e4. \uc608\ub97c \ub4e4\uc5b4, `SELECT *` \ub300\uc2e0 \ud544\uc694\ud55c \uceec\ub7fc\ub9cc \uc120\ud0dd\ud558\uc5ec \uc870\ud68c\ud558\ub294 \uac83\uc774 \uc88b\uc2b5\ub2c8\ub2e4. \uc774\ub97c \ud1b5\ud574 \ub370\uc774\ud130 \uc804\uc1a1\ub7c9\uc744 \uc904\uc774\uace0 \uc131\ub2a5\uc744 \uac1c\uc120\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<p>\ub9c8\uc9c0\ub9c9\uc73c\ub85c, \ucffc\ub9ac \uce90\uc2f1\uc744 \ud65c\uc6a9\ud558\uc5ec \uc131\ub2a5\uc744 \ud5a5\uc0c1\uc2dc\ud0ac \uc218 \uc788\uc2b5\ub2c8\ub2e4. MySQL\uc740 \ub3d9\uc77c\ud55c \ucffc\ub9ac\uc5d0 \ub300\ud574 \uacb0\uacfc\ub97c \uce90\uc2dc\ud558\uc5ec \ub2e4\uc74c \uc694\uccad \uc2dc \ube60\ub974\uac8c \uc751\ub2f5\ud560 \uc218 \uc788\ub3c4\ub85d \ud569\ub2c8\ub2e4. \uc774\ub97c \ud1b5\ud574 \ubc18\ubcf5\uc801\uc778 \ucffc\ub9ac \uc2e4\ud589 \uc2dc \uc131\ub2a5\uc744 \uac1c\uc120\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<h2 id=\"6-%eb%8d%b0%ec%9d%b4%ed%84%b0-%ec%86%90%ec%83%81%ea%b3%bc-%eb%b3%b5%ea%b5%ac-%eb%b0%a9%eb%b2%95-KUbbRbKeZs\">6. \ub370\uc774\ud130 \uc190\uc0c1\uacfc \ubcf5\uad6c \ubc29\ubc95<\/h2>\n<p>\ub370\uc774\ud130 \uc190\uc0c1\uc740 \uc5ec\ub7ec \uac00\uc9c0 \uc774\uc720\ub85c \ubc1c\uc0dd\ud560 \uc218 \uc788\uc73c\uba70, \uc774\ub85c \uc778\ud574 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uac00 \uc815\uc0c1\uc801\uc73c\ub85c \uc791\ub3d9\ud558\uc9c0 \uc54a\uc744 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc774 \uc139\uc158\uc5d0\uc11c\ub294 \ub370\uc774\ud130 \uc190\uc0c1\uc758 \uc6d0\uc778\uacfc \ubcf5\uad6c \ubc29\ubc95\uc744 \ub2e4\ub8e8\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n<p>\ub370\uc774\ud130 \uc190\uc0c1\uc758 \uc6d0\uc778\uc740 \ub2e4\uc591\ud569\ub2c8\ub2e4. \ud558\ub4dc\uc6e8\uc5b4 \uace0\uc7a5, \uc18c\ud504\ud2b8\uc6e8\uc5b4 \ubc84\uadf8, \uc798\ubabb\ub41c \ucffc\ub9ac \uc2e4\ud589 \ub4f1\uc774 \uadf8 \uc608\uc785\ub2c8\ub2e4. \ub370\uc774\ud130 \uc190\uc0c1\uc774 \ubc1c\uc0dd\ud588\uc744 \ub54c\ub294 \uba3c\uc800 MySQL\uc758 `CHECK TABLE` \uba85\ub839\uc5b4\ub97c \uc0ac\uc6a9\ud558\uc5ec \ud14c\uc774\ube14\uc758 \uc0c1\ud0dc\ub97c \uc810\uac80\ud574\uc57c \ud569\ub2c8\ub2e4.<\/p>\n<pre><code>CHECK TABLE table_name;<\/code><\/pre>\n<p>\ub370\uc774\ud130 \uc190\uc0c1\uc774 \ud655\uc778\ub418\uba74 `REPAIR TABLE` \uba85\ub839\uc5b4\ub97c \uc0ac\uc6a9\ud558\uc5ec \ud14c\uc774\ube14\uc744 \ubcf5\uad6c\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uadf8\ub7ec\ub098 \uc774 \ubc29\ubc95\uc740 \ubaa8\ub4e0 \uacbd\uc6b0\uc5d0 \ud6a8\uacfc\uc801\uc774\uc9c0 \uc54a\uc73c\ubbc0\ub85c, \uc815\uae30\uc801\uc778 \ubc31\uc5c5\uc774 \ud544\uc218\uc801\uc785\ub2c8\ub2e4.<\/p>\n<p>\uc815\uae30\uc801\uc778 \ubc31\uc5c5\uc740 \ub370\uc774\ud130 \uc190\uc2e4\uc744 \ubc29\uc9c0\ud558\ub294 \uac00\uc7a5 \ud6a8\uacfc\uc801\uc778 \ubc29\ubc95\uc785\ub2c8\ub2e4. MySQL\uc5d0\uc11c\ub294 `mysqldump` \uba85\ub839\uc5b4\ub97c \uc0ac\uc6a9\ud558\uc5ec \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \ubc31\uc5c5\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<pre><code>mysqldump -u username -p database_name &gt; backup.sql<\/code><\/pre>\n<p>\ubc31\uc5c5 \ud30c\uc77c\uc774 \uc0dd\uc131\ub418\uba74, \ub370\uc774\ud130 \uc190\uc0c1\uc774 \ubc1c\uc0dd\ud588\uc744 \ub54c \ud574\ub2f9 \ud30c\uc77c\uc744 \uc0ac\uc6a9\ud558\uc5ec \ub370\uc774\ud130\ub97c \ubcf5\uad6c\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ubcf5\uad6c \uacfc\uc815\uc740 `mysql` \uba85\ub839\uc5b4\ub97c \uc0ac\uc6a9\ud558\uc5ec \ubc31\uc5c5 \ud30c\uc77c\uc744 \ub2e4\uc2dc \ub85c\ub4dc\ud558\ub294 \ubc29\uc2dd\uc73c\ub85c \uc9c4\ud589\ub429\ub2c8\ub2e4.<\/p>\n<pre><code>mysql -u username -p database_name &lt; backup.sql<\/code><\/pre>\n<p>\ub9c8\uc9c0\ub9c9\uc73c\ub85c, \ub370\uc774\ud130 \uc190\uc0c1\uc744 \uc608\ubc29\ud558\uae30 \uc704\ud574\uc11c\ub294 \ub370\uc774\ud130 \ubb34\uacb0\uc131\uc744 \uc720\uc9c0\ud558\ub294 \uac83\uc774 \uc911\uc694\ud569\ub2c8\ub2e4. \uc774\ub97c \uc704\ud574 \uc678\ub798 \ud0a4 \uc81c\uc57d \uc870\uac74\uc744 \uc124\uc815\ud558\uace0 \ud2b8\ub79c\uc7ad\uc158\uc744 \uc801\uc808\ud788 \ud65c\uc6a9\ud574\uc57c \ud569\ub2c8\ub2e4.<\/p>\n<h2 id=\"7-%eb%a6%ac%ec%86%8c%ec%8a%a4-%eb%b6%80%ec%a1%b1%ea%b3%bc-%ea%b4%80%eb%a6%ac-%eb%b0%a9%ec%95%88-KUbbRbKeZs\">7. \ub9ac\uc18c\uc2a4 \ubd80\uc871\uacfc \uad00\ub9ac \ubc29\uc548<\/h2>\n<p>\ub9ac\uc18c\uc2a4 \ubd80\uc871\uc740 CPU, \uba54\ubaa8\ub9ac, \ub514\uc2a4\ud06c \uacf5\uac04 \ub4f1\uc758 \uc790\uc6d0\uc774 \ubd80\uc871\ud574\uc9c0\ub294 \uacbd\uc6b0\ub97c \ub9d0\ud569\ub2c8\ub2e4. \uc774 \uc139\uc158\uc5d0\uc11c\ub294 \ub9ac\uc18c\uc2a4 \ubd80\uc871 \ubb38\uc81c\ub97c \ud574\uacb0\ud558\uae30 \uc704\ud55c \uad00\ub9ac \ubc29\uc548\uc744 \ub2e4\ub8e8\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n<p>\ub9ac\uc18c\uc2a4 \ubd80\uc871 \ubb38\uc81c\ub97c \uc608\ubc29\ud558\uae30 \uc704\ud574\uc11c\ub294 \uc2dc\uc2a4\ud15c \ubaa8\ub2c8\ud130\ub9c1 \ub3c4\uad6c\ub97c \uc0ac\uc6a9\ud558\uc5ec \uc790\uc6d0 \uc0ac\uc6a9\ub7c9\uc744 \uc2e4\uc2dc\uac04\uc73c\ub85c \ubaa8\ub2c8\ud130\ub9c1\ud574\uc57c \ud569\ub2c8\ub2e4. \uc608\ub97c \ub4e4\uc5b4, `top` \uba85\ub839\uc5b4\ub97c \uc0ac\uc6a9\ud558\uc5ec CPU\uc640 \uba54\ubaa8\ub9ac \uc0ac\uc6a9\ub7c9\uc744 \ud655\uc778\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<pre><code>top<\/code><\/pre>\n<p>\ub610\ud55c, MySQL\uc758 `SHOW STATUS` \uba85\ub839\uc5b4\ub97c \uc0ac\uc6a9\ud558\uc5ec \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \uc0c1\ud0dc \uc815\ubcf4\ub97c \ud655\uc778\ud558\uace0, \ub9ac\uc18c\uc2a4 \uc0ac\uc6a9\ub7c9\uc744 \ubd84\uc11d\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<pre><code>SHOW STATUS;<\/code><\/pre>\n<p>\ub9ac\uc18c\uc2a4 \ubd80\uc871 \ubb38\uc81c\uac00 \ubc1c\uc0dd\ud588\uc744 \ub54c\ub294 \uc6b0\uc120\uc801\uc73c\ub85c \ubd88\ud544\uc694\ud55c \ud504\ub85c\uc138\uc2a4\ub97c \uc885\ub8cc\ud558\uac70\ub098 \uc11c\ubc84\ub97c \uc7ac\ubd80\ud305\ud558\uc5ec \uc790\uc6d0\uc744 \ud655\ubcf4\ud574\uc57c \ud569\ub2c8\ub2e4. \ub610\ud55c, MySQL \uc124\uc815 \ud30c\uc77c(my.cnf)\uc5d0\uc11c `innodb_buffer_pool_size`, `max_connections` \ub4f1\uc758 \uac12\uc744 \uc870\uc815\ud558\uc5ec \ub9ac\uc18c\uc2a4 \uc0ac\uc6a9\ub7c9\uc744 \ucd5c\uc801\ud654\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<p>\ub9c8\uc9c0\ub9c9\uc73c\ub85c, \ud544\uc694\uc2dc \uc11c\ubc84\ub97c \uc5c5\uadf8\ub808\uc774\ub4dc\ud558\uac70\ub098 \ud074\ub77c\uc6b0\ub4dc \uc11c\ube44\uc2a4\ub97c \ud65c\uc6a9\ud558\uc5ec \ub9ac\uc18c\uc2a4\ub97c \ud655\uc7a5\ud558\ub294 \uac83\ub3c4 \uace0\ub824\ud574 \ubcfc \ub9cc\ud569\ub2c8\ub2e4. \ud074\ub77c\uc6b0\ub4dc \uc11c\ube44\uc2a4\ub294 \ud544\uc694\uc5d0 \ub530\ub77c \uc790\uc6d0\uc744 \uc720\uc5f0\ud558\uac8c \uc870\uc815\ud560 \uc218 \uc788\ub294 \uc7a5\uc810\uc774 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<h2 id=\"8-%eb%b3%b4%ec%95%88-%ea%b3%b5%ea%b2%a9%ea%b3%bc-%eb%8c%80%ec%9d%91-%ec%a0%84%eb%9e%b5-KUbbRbKeZs\">8. \ubcf4\uc548 \uacf5\uaca9\uacfc \ub300\uc751 \uc804\ub7b5<\/h2>\n<p>\ubcf4\uc548 \uacf5\uaca9\uc740 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0 \ub300\ud55c \uc678\ubd80\uc758 \uc545\uc758\uc801\uc778 \uacf5\uaca9\uc73c\ub85c, \ub370\uc774\ud130 \uc720\ucd9c\uc774\ub098 \uc190\uc0c1\uc744 \ucd08\ub798\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc774 \uc139\uc158\uc5d0\uc11c\ub294 \ubcf4\uc548 \uacf5\uaca9\uc5d0 \ub300\ud55c \uc774\ud574\uc640 \ub300\uc751 \uc804\ub7b5\uc744 \ub2e4\ub8e8\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n<p>\ubcf4\uc548 \uacf5\uaca9\uc5d0\ub294 SQL \uc778\uc81d\uc158, DDoS \uacf5\uaca9 \ub4f1\uc774 \ud3ec\ud568\ub429\ub2c8\ub2e4. SQL \uc778\uc81d\uc158\uc740 \uc545\uc758\uc801\uc778 \uc0ac\uc6a9\uc790\uac00 \ucffc\ub9ac\uc5d0 \uc545\uc131 \ucf54\ub4dc\ub97c \uc0bd\uc785\ud558\uc5ec \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0 \uc811\uadfc\ud558\ub294 \uacf5\uaca9\uc785\ub2c8\ub2e4. \uc774\ub97c \uc608\ubc29\ud558\uae30 \uc704\ud574\uc11c\ub294 \uc0ac\uc6a9\uc790 \uc785\ub825\uac12\uc744 \ucca0\uc800\ud788 \uac80\uc99d\ud558\uace0, Prepared Statement\ub97c \uc0ac\uc6a9\ud558\ub294 \uac83\uc774 \uc88b\uc2b5\ub2c8\ub2e4.<\/p>\n<pre><code>stmt = conn.prepareStatement(\"SELECT * FROM users WHERE username = ? AND password = ?\");<\/code><\/pre>\n<p>DDoS \uacf5\uaca9\uc740 \ub300\ub7c9\uc758 \ud2b8\ub798\ud53d\uc744 \ubc1c\uc0dd\uc2dc\ucf1c \uc11c\ubc84\ub97c \ub9c8\ube44\uc2dc\ud0a4\ub294 \uacf5\uaca9\uc785\ub2c8\ub2e4. \uc774\ub97c \ubc29\uc5b4\ud558\uae30 \uc704\ud574\uc11c\ub294 \ubc29\ud654\ubcbd\uacfc IDS\/IPS(\uce68\uc785 \ud0d0\uc9c0 \ubc0f \ubc29\uc9c0 \uc2dc\uc2a4\ud15c)\ub97c \uc124\uc815\ud558\uc5ec \ube44\uc815\uc0c1\uc801\uc778 \ud2b8\ub798\ud53d\uc744 \ucc28\ub2e8\ud574\uc57c \ud569\ub2c8\ub2e4.<\/p>\n<p>\ub610\ud55c, \uc815\uae30\uc801\uc778 \ubcf4\uc548 \uc810\uac80\uacfc \ucde8\uc57d\uc810 \ubd84\uc11d\uc744 \ud1b5\ud574 \uc2dc\uc2a4\ud15c\uc758 \ubcf4\uc548\uc744 \uac15\ud654\ud574\uc57c \ud569\ub2c8\ub2e4. \ubcf4\uc548 \ud328\uce58\ub97c \uc8fc\uae30\uc801\uc73c\ub85c \uc801\uc6a9\ud558\uace0, \uc0ac\uc6a9\uc790 \uad8c\ud55c \uad00\ub9ac\ub97c \ucca0\uc800\ud788 \ud558\uc5ec \ubd88\ud544\uc694\ud55c \uc811\uadfc\uc744 \ucc28\ub2e8\ud574\uc57c \ud569\ub2c8\ub2e4.<\/p>\n<p>\ub9c8\uc9c0\ub9c9\uc73c\ub85c, \ub370\uc774\ud130 \uc554\ud638\ud654\ub97c \ud1b5\ud574 \uc911\uc694\ud55c \ub370\uc774\ud130\ub97c \ubcf4\ud638\ud558\ub294 \uac83\ub3c4 \uc88b\uc740 \ubc29\ubc95\uc785\ub2c8\ub2e4. MySQL\uc5d0\uc11c\ub294 SSL\/TLS\ub97c \uc0ac\uc6a9\ud558\uc5ec \ub370\uc774\ud130 \uc804\uc1a1 \uc2dc \uc554\ud638\ud654\ub97c \uc9c0\uc6d0\ud569\ub2c8\ub2e4.<\/p>\n<h2 id=\"%ea%b2%b0%eb%a1%a0-KUbbRbKeZs\">\uacb0\ub860<\/h2>\n<p>MySQL \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0\uc11c \ubc1c\uc0dd\ud560 \uc218 \uc788\ub294 \uc7a5\uc560 \uc6d0\uc778\uacfc \uadf8\uc5d0 \ub300\ud55c \ub300\uc751 \ubc29\ubc95\uc5d0 \ub300\ud574 \uc0b4\ud3b4\ubcf4\uc558\uc2b5\ub2c8\ub2e4. \ud558\ub4dc\uc6e8\uc5b4 \uace0\uc7a5, \uc18c\ud504\ud2b8\uc6e8\uc5b4 \ubc84\uadf8, \ub124\ud2b8\uc6cc\ud06c \ubb38\uc81c \ub4f1 \ub2e4\uc591\ud55c \uc6d0\uc778\uc774 \uc874\uc7ac\ud558\uba70, \uac01 \uc6d0\uc778\uc5d0 \ub300\ud55c \uc801\uc808\ud55c \ub300\uc751 \uc804\ub7b5\uc774 \ud544\uc694\ud569\ub2c8\ub2e4.<\/p>\n<p>\uc815\uae30\uc801\uc778 \uc810\uac80\uacfc \ubaa8\ub2c8\ud130\ub9c1, \ubc31\uc5c5 \ubc0f \ubcf5\uad6c \uc808\ucc28\uc758 \ud655\ub9bd\uc740 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc7a5\uc560\ub97c \uc608\ubc29\ud558\uace0 \ube44\uc988\ub2c8\uc2a4 \uc5f0\uc18d\uc131\uc744 \uc720\uc9c0\ud558\ub294 \ub370 \uc911\uc694\ud55c \uc5ed\ud560\uc744 \ud569\ub2c8\ub2e4. \ub610\ud55c, \ubcf4\uc548 \uacf5\uaca9\uc5d0 \ub300\ud55c \ub300\ube44\uc640 \ub9ac\uc18c\uc2a4 \uad00\ub9ac\ub3c4 \ud544\uc218\uc801\uc785\ub2c8\ub2e4.<\/p>\n<p>\uc774 \uae00\uc774 MySQL \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uad00\ub9ac\uc5d0 \uc788\uc5b4 \uc720\uc775\ud55c \ud1b5\ucc30\ub825\uc744 \uc81c\uacf5\ud558\uc600\uae30\ub97c \ubc14\ub78d\ub2c8\ub2e4. \uc9c0\uc18d\uc801\uc778 \ud559\uc2b5\uacfc \uac1c\uc120\uc744 \ud1b5\ud574 \uc548\uc815\uc801\uc774\uace0 \ud6a8\uc728\uc801\uc778 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc6b4\uc601\uc774 \uc774\ub8e8\uc5b4\uc9c0\uae38 \ubc14\ub78d\ub2c8\ub2e4.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\ubaa9\ucc28 MySQL\uc5d0\uc11c\uc758 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc7a5\uc560 \uc6d0\uc778\uacfc \ub300\uc751 \ubc29\ubc95 1. MySQL \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc7a5\uc560\uc758 \uc77c\ubc18\uc801\uc778 \uc6d0\uc778 2. \ud558\ub4dc\uc6e8\uc5b4 [&hellip;]<\/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":[2132,2208,2100],"class_list":["post-51665","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-development","tag-analysis","tag-monitoring","tag-mysql"],"acf":[],"_links":{"self":[{"href":"https:\/\/8gfg.shop\/blog\/wp-json\/wp\/v2\/posts\/51665","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/8gfg.shop\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/8gfg.shop\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/8gfg.shop\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/8gfg.shop\/blog\/wp-json\/wp\/v2\/comments?post=51665"}],"version-history":[{"count":0,"href":"https:\/\/8gfg.shop\/blog\/wp-json\/wp\/v2\/posts\/51665\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/8gfg.shop\/blog\/wp-json\/wp\/v2\/media\/33704"}],"wp:attachment":[{"href":"https:\/\/8gfg.shop\/blog\/wp-json\/wp\/v2\/media?parent=51665"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/8gfg.shop\/blog\/wp-json\/wp\/v2\/categories?post=51665"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/8gfg.shop\/blog\/wp-json\/wp\/v2\/tags?post=51665"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}