\ub370\uc774\ud130\ubca0\uc774\uc2a4\ub294 \ud604\ub300 \uc560\ud50c\ub9ac\ucf00\uc774\uc158\uc758 \ud575\uc2ec \uad6c\uc131 \uc694\uc18c\ub85c, \ub370\uc774\ud130\uc758 \uc800\uc7a5, \uac80\uc0c9 \ubc0f \uad00\ub9ac\uc5d0 \ud544\uc218\uc801\uc785\ub2c8\ub2e4. \uadf8 \uc911\uc5d0\uc11c\ub3c4 MySQL\uc740 \uac00\uc7a5 \ub110\ub9ac \uc0ac\uc6a9\ub418\ub294 \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\uac00 \uc99d\uac00\ud568\uc5d0 \ub530\ub77c \uc131\ub2a5 \uc800\ud558 \ubb38\uc81c\uac00 \ubc1c\uc0dd\ud560 \uc218 \uc788\uc73c\uba70, \uc774 \ubb38\uc81c\ub97c \ud574\uacb0\ud558\uae30 \uc704\ud574 \uc778\ub371\uc2a4 \ucd5c\uc801\ud654\uac00 \ud544\uc694\ud569\ub2c8\ub2e4. \ubcf8 \uae00\uc5d0\uc11c\ub294 MySQL\uc758 \uc778\ub371\uc2a4 \ucd5c\uc801\ud654\uc5d0 \ub300\ud55c \uc2ec\uce35\uc801\uc778 \ubd84\uc11d\uc744 \uc81c\uacf5\ud558\uace0, \uc131\ub2a5 \ubb38\uc81c\ub97c \ud574\uacb0\ud558\uae30 \uc704\ud55c \ub2e4\uc591\ud55c \ubc29\ubc95\uc744 \uc81c\uc2dc\ud558\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n
\uc778\ub371\uc2a4\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0\uc11c \ub370\uc774\ud130\ub97c \ube60\ub974\uac8c \uac80\uc0c9\ud560 \uc218 \uc788\ub3c4\ub85d \ub3c4\uc640\uc8fc\ub294 \ub370\uc774\ud130 \uad6c\uc870\uc785\ub2c8\ub2e4. \uc778\ub371\uc2a4\ub294 \ucc45\uc758 \ubaa9\ucc28\uc640 \uc720\uc0ac\ud55c \uc5ed\ud560\uc744 \ud558\uba70, \ud2b9\uc815 \uc5f4\uc5d0 \ub300\ud55c \uac80\uc0c9 \uc18d\ub3c4\ub97c \ud06c\uac8c \ud5a5\uc0c1\uc2dc\ud0b5\ub2c8\ub2e4. MySQL\uc5d0\uc11c\ub294 \ub2e4\uc591\ud55c \uc720\ud615\uc758 \uc778\ub371\uc2a4\ub97c \uc9c0\uc6d0\ud558\uba70, \uac01 \uc778\ub371\uc2a4\ub294 \ud2b9\uc815 \uc0c1\ud669\uc5d0\uc11c \ucd5c\uc801\uc758 \uc131\ub2a5\uc744 \ubc1c\ud718\ud569\ub2c8\ub2e4.<\/p>\n
\uc778\ub371\uc2a4\uc758 \uc8fc\uc694 \uae30\ub2a5\uc740 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4:<\/p>\n
\uc778\ub371\uc2a4\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc131\ub2a5\uc744 \ud06c\uac8c \ud5a5\uc0c1\uc2dc\ud0ac \uc218 \uc788\uc9c0\ub9cc, \uc798\ubabb\ub41c \uc778\ub371\uc2a4 \uc0ac\uc6a9\uc740 \uc624\ud788\ub824 \uc131\ub2a5 \uc800\ud558\ub97c \ucd08\ub798\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ub530\ub77c\uc11c \uc778\ub371\uc2a4\ub97c \uc124\uacc4\ud558\uace0 \ucd5c\uc801\ud654\ud558\ub294 \uacfc\uc815\uc774 \uc911\uc694\ud569\ub2c8\ub2e4.<\/p>\n
MySQL\uc5d0\uc11c\ub294 \uc5ec\ub7ec \uc885\ub958\uc758 \uc778\ub371\uc2a4\ub97c \uc81c\uacf5\ud558\uba70, \uac01 \uc778\ub371\uc2a4\ub294 \ud2b9\uc815 \uc6a9\ub3c4\uc5d0 \ub9de\uac8c \uc124\uacc4\ub418\uc5c8\uc2b5\ub2c8\ub2e4. \uc8fc\uc694 \uc778\ub371\uc2a4 \uc885\ub958\ub294 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4:<\/p>\n
\uac01 \uc778\ub371\uc2a4 \uc720\ud615\uc740 \ud2b9\uc815 \uc0c1\ud669\uc5d0\uc11c \ucd5c\uc801\uc758 \uc131\ub2a5\uc744 \ubc1c\ud718\ud558\ubbc0\ub85c, \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc124\uacc4 \uc2dc \uc801\uc808\ud55c \uc778\ub371\uc2a4\ub97c \uc120\ud0dd\ud558\ub294 \uac83\uc774 \uc911\uc694\ud569\ub2c8\ub2e4.<\/p>\n
\uc778\ub371\uc2a4\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc131\ub2a5\uc744 \ud5a5\uc0c1\uc2dc\ud0a4\ub294 \uc911\uc694\ud55c \uc694\uc18c\uc774\uc9c0\ub9cc, \uc798\ubabb\ub41c \uc778\ub371\uc2a4 \uc0ac\uc6a9\uc740 \uc131\ub2a5 \uc800\ud558\ub97c \ucd08\ub798\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc608\ub97c \ub4e4\uc5b4, \ubd88\ud544\uc694\ud55c \uc778\ub371\uc2a4\ub97c \uc0dd\uc131\ud558\uba74 \ub370\uc774\ud130 \uc0bd\uc785, \uc218\uc815 \ubc0f \uc0ad\uc81c \uc791\uc5c5\uc774 \ub290\ub824\uc9c8 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ub610\ud55c, \uc778\ub371\uc2a4\uac00 \ub108\ubb34 \ub9ce\uc73c\uba74 \uba54\ubaa8\ub9ac \uc0ac\uc6a9\ub7c9\uc774 \uc99d\uac00\ud558\uace0, \ucffc\ub9ac \ucd5c\uc801\ud654\uac00 \uc5b4\ub824\uc6cc\uc9c8 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n
\uc778\ub371\uc2a4 \ucd5c\uc801\ud654\ub294 \ub2e4\uc74c\uacfc \uac19\uc740 \uc774\uc720\ub85c \ud544\uc694\ud569\ub2c8\ub2e4:<\/p>\n
\ub530\ub77c\uc11c \uc778\ub371\uc2a4 \ucd5c\uc801\ud654\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc131\ub2a5\uc744 \uadf9\ub300\ud654\ud558\uace0 \uc790\uc6d0\uc744 \ud6a8\uc728\uc801\uc73c\ub85c \uc0ac\uc6a9\ud558\ub294 \ub370 \ud544\uc218\uc801\uc785\ub2c8\ub2e4.<\/p>\n
MySQL\uc5d0\uc11c\ub294 \uc778\ub371\uc2a4\ub97c \ubd84\uc11d\ud558\uace0 \ucd5c\uc801\ud654\ud558\uae30 \uc704\ud55c \ub2e4\uc591\ud55c \ub3c4\uad6c\uc640 \uae30\ubc95\uc744 \uc81c\uacf5\ud569\ub2c8\ub2e4. \uc774\ub7ec\ud55c \ub3c4\uad6c\ub97c \uc0ac\uc6a9\ud558\uba74 \ud604\uc7ac \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \uc778\ub371\uc2a4 \uc0c1\ud0dc\ub97c \ud30c\uc545\ud558\uace0, \uc131\ub2a5 \ubb38\uc81c\ub97c \uc9c4\ub2e8\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n
\uc8fc\uc694 \ub3c4\uad6c\uc640 \uae30\ubc95\uc740 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4:<\/p>\n
\uc774\ub7ec\ud55c \ub3c4\uad6c\ub97c \ud65c\uc6a9\ud558\uc5ec \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \uc778\ub371\uc2a4\ub97c \ubd84\uc11d\ud558\uace0 \ucd5c\uc801\ud654\ud558\ub294 \uacfc\uc815\uc740 \uc131\ub2a5 \ubb38\uc81c\ub97c \ud574\uacb0\ud558\ub294 \ub370 \ud070 \ub3c4\uc6c0\uc774 \ub429\ub2c8\ub2e4.<\/p>\n
\uc778\ub371\uc2a4\ub97c \ucd5c\uc801\ud654\ud558\uae30 \uc704\ud574\uc11c\ub294 \uba87 \uac00\uc9c0 \uc804\ub7b5\uc744 \uace0\ub824\ud574\uc57c \ud569\ub2c8\ub2e4. \uc774\ub7ec\ud55c \uc804\ub7b5\uc740 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \ud2b9\uc131\uacfc \ucffc\ub9ac \ud328\ud134\uc5d0 \ub530\ub77c \ub2ec\ub77c\uc9c8 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n
\uc8fc\uc694 \ucd5c\uc801\ud654 \uc804\ub7b5\uc740 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4:<\/p>\n
\uc774\ub7ec\ud55c \uc804\ub7b5\uc744 \ud1b5\ud574 MySQL\uc758 \uc778\ub371\uc2a4\ub97c \ud6a8\uacfc\uc801\uc73c\ub85c \ucd5c\uc801\ud654\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n
\uc778\ub371\uc2a4 \ucd5c\uc801\ud654\uc758 \ud6a8\uacfc\ub97c \ubcf4\uc5ec\uc8fc\ub294 \uc0ac\ub840 \uc5f0\uad6c\ub97c \uc0b4\ud3b4\ubcf4\uaca0\uc2b5\ub2c8\ub2e4. \ud55c \uc628\ub77c\uc778 \uc1fc\ud551\ubab0\uc5d0\uc11c\ub294 \uc81c\ud488 \uac80\uc0c9 \uae30\ub2a5\uc774 \ub290\ub824\uc838 \uc0ac\uc6a9\uc790 \uacbd\ud5d8\uc5d0 \ubd80\uc815\uc801\uc778 \uc601\ud5a5\uc744 \ubbf8\uce58\uace0 \uc788\uc5c8\uc2b5\ub2c8\ub2e4. \uc774 \ubb38\uc81c\ub97c \ud574\uacb0\ud558\uae30 \uc704\ud574 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc804\ubb38\uac00\uac00 \uc778\ub371\uc2a4\ub97c \ubd84\uc11d\ud558\uace0 \ucd5c\uc801\ud654 \uc791\uc5c5\uc744 \uc9c4\ud589\ud588\uc2b5\ub2c8\ub2e4.<\/p>\n
\uc6b0\uc120, EXPLAIN \uba85\ub839\uc5b4\ub97c \uc0ac\uc6a9\ud558\uc5ec \ucffc\ub9ac \uc2e4\ud589 \uacc4\ud68d\uc744 \ubd84\uc11d\ud55c \uacb0\uacfc, \ubd88\ud544\uc694\ud55c \uc778\ub371\uc2a4\uac00 \uc874\uc7ac\ud558\uace0 \uc788\uc74c\uc744 \ud655\uc778\ud588\uc2b5\ub2c8\ub2e4. \uc774\ud6c4 \uc804\ubb38\uac00 \ud300\uc740 \ub2e4\uc74c\uacfc \uac19\uc740 \uc870\uce58\ub97c \ucde8\ud588\uc2b5\ub2c8\ub2e4:<\/p>\n
\uc774\ub7ec\ud55c \uc870\uce58\ub97c \ud1b5\ud574 \uc81c\ud488 \uac80\uc0c9 \uc18d\ub3c4\uac00 50% \uc774\uc0c1 \ud5a5\uc0c1\ub418\uc5c8\uc73c\uba70, \uc0ac\uc6a9\uc790 \uacbd\ud5d8\uc774 \ud06c\uac8c \uac1c\uc120\ub418\uc5c8\uc2b5\ub2c8\ub2e4. \uc774 \uc0ac\ub840\ub294 \uc778\ub371\uc2a4 \ucd5c\uc801\ud654\uac00 \uc2e4\uc81c\ub85c \uc131\ub2a5 \ubb38\uc81c\ub97c \ud574\uacb0\ud558\ub294 \ub370 \uc5bc\ub9c8\ub098 \uc911\uc694\ud55c\uc9c0\ub97c \ubcf4\uc5ec\uc90d\ub2c8\ub2e4.<\/p>\n
MySQL\uc740 \uc9c0\uc18d\uc801\uc73c\ub85c \uc5c5\ub370\uc774\ud2b8\ub418\uba70 \uc0c8\ub85c\uc6b4 \uae30\ub2a5\uacfc \uac1c\uc120 \uc0ac\ud56d\uc774 \ucd94\uac00\ub418\uace0 \uc788\uc2b5\ub2c8\ub2e4. \ucd5c\uc2e0 \ubc84\uc804\uc5d0\uc11c\ub294 \uc778\ub371\uc2a4 \uad00\ub828 \uae30\ub2a5\ub3c4 \uac15\ud654\ub418\uc5c8\uc2b5\ub2c8\ub2e4. \uc608\ub97c \ub4e4\uc5b4, MySQL 8.0\uc5d0\uc11c\ub294 \ub2e4\uc74c\uacfc \uac19\uc740 \uc0c8\ub85c\uc6b4 \uae30\ub2a5\uc774 \ucd94\uac00\ub418\uc5c8\uc2b5\ub2c8\ub2e4:<\/p>\n
\uc774\ub7ec\ud55c \ucd5c\uc2e0 \uae30\ub2a5\ub4e4\uc740 MySQL\uc5d0\uc11c \uc778\ub371\uc2a4\ub97c \ub354\uc6b1 \ud6a8\uacfc\uc801\uc73c\ub85c \uad00\ub9ac\ud558\uace0 \ucd5c\uc801\ud654\ud558\ub294 \ub370 \ub3c4\uc6c0\uc744 \uc90d\ub2c8\ub2e4. \ub530\ub77c\uc11c \ucd5c\uc2e0 \ubc84\uc804\uc73c\ub85c \uc5c5\uadf8\ub808\uc774\ub4dc\ud558\ub294 \uac83\uc774 \uc88b\uc2b5\ub2c8\ub2e4.<\/p>\n
MySQL\uc758 \uc778\ub371\uc2a4 \ucd5c\uc801\ud654\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc131\ub2a5\uc744 \uadf9\ub300\ud654\ud558\uace0 \uc790\uc6d0\uc744 \ud6a8\uc728\uc801\uc73c\ub85c \uc0ac\uc6a9\ud558\ub294 \ub370 \ud544\uc218\uc801\uc785\ub2c8\ub2e4. \uc801\uc808\ud55c \uc778\ub371\uc2a4\ub97c \uc124\uacc4\ud558\uace0 \ucd5c\uc801\ud654\ud558\ub294 \uacfc\uc815\uc740 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \uc131\ub2a5 \ubb38\uc81c\ub97c \ud574\uacb0\ud558\ub294 \ub370 \ud070 \ub3c4\uc6c0\uc774 \ub429\ub2c8\ub2e4. \ubcf8 \uae00\uc5d0\uc11c \ub2e4\ub8ec \ub2e4\uc591\ud55c \uc804\ub7b5\uacfc \uc0ac\ub840 \uc5f0\uad6c\ub97c \ud1b5\ud574 \ub3c5\uc790 \uc5ec\ub7ec\ubd84\uc774 MySQL\uc758 \uc778\ub371\uc2a4\ub97c \ud6a8\uacfc\uc801\uc73c\ub85c \uad00\ub9ac\ud558\uace0 \ucd5c\uc801\ud654\ud560 \uc218 \uc788\uae30\ub97c \ubc14\ub78d\ub2c8\ub2e4.<\/p>\n
\uc778\ub371\uc2a4 \ucd5c\uc801\ud654\ub294 \ub2e8\uc21c\ud788 \uc131\ub2a5 \ud5a5\uc0c1\ubfd0\ub9cc \uc544\ub2c8\ub77c, \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc720\uc9c0 \uad00\ub9ac\uc640 \uc790\uc6d0 \uc808\uc57d\uc5d0\ub3c4 \uae30\uc5ec\ud569\ub2c8\ub2e4. \ub530\ub77c\uc11c \uc9c0\uc18d\uc801\uc778 \ubaa8\ub2c8\ud130\ub9c1\uacfc \ubd84\uc11d\uc744 \ud1b5\ud574 \ucd5c\uc801\uc758 \uc778\ub371\uc2a4\ub97c \uc720\uc9c0\ud558\ub294 \uac83\uc774 \uc911\uc694\ud569\ub2c8\ub2e4. MySQL\uc758 \ucd5c\uc2e0 \uae30\ub2a5\uc744 \ud65c\uc6a9\ud558\uc5ec \ub354\uc6b1 \ud6a8\uc728\uc801\uc778 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc6b4\uc601\uc744 \uc2e4\ud604\ud558\uc2dc\uae30 \ubc14\ub78d\ub2c8\ub2e4.<\/p>\n","protected":false},"excerpt":{"rendered":"
\ubaa9\ucc28 MySQL\uc758 \uc778\ub371\uc2a4 \ucd5c\uc801\ud654: \uc131\ub2a5 \ubb38\uc81c \ud574\uacb0\ud558\uae30 1. \uc778\ub371\uc2a4\uc758 \uae30\ubcf8 \uac1c\ub150 2. MySQL\uc5d0\uc11c \uc778\ub371\uc2a4\uc758 \uc885\ub958 […]<\/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":[2100,2805,2136],"class_list":["post-51610","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-development","tag-mysql","tag-order","tag-performance"],"acf":[],"_links":{"self":[{"href":"https:\/\/m9js.shop\/blog\/wp-json\/wp\/v2\/posts\/51610","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=51610"}],"version-history":[{"count":0,"href":"https:\/\/m9js.shop\/blog\/wp-json\/wp\/v2\/posts\/51610\/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=51610"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/m9js.shop\/blog\/wp-json\/wp\/v2\/categories?post=51610"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/m9js.shop\/blog\/wp-json\/wp\/v2\/tags?post=51610"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}