\ubaa9\ucc28<\/h2>\n\n- MySQL \uc131\ub2a5 \uc800\ud558\uc758 \uc6d0\uc778\uacfc \ud6a8\uacfc\uc801\uc778 \ud574\uacb0 \ubc29\uc548<\/a><\/li>\n
- 1. MySQL \uc131\ub2a5 \uc800\ud558\uc758 \uc77c\ubc18\uc801\uc778 \uc6d0\uc778<\/a><\/li>\n
- 2. \ucffc\ub9ac \ucd5c\uc801\ud654 \ubc29\ubc95<\/a><\/li>\n
- 3. \ud558\ub4dc\uc6e8\uc5b4 \uc790\uc6d0 \uad00\ub9ac<\/a><\/li>\n
- 4. \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc124\uacc4 \ucd5c\uc801\ud654<\/a><\/li>\n
- 5. \ub3d9\uc2dc\uc131 \ubb38\uc81c \ud574\uacb0<\/a><\/li>\n
- 6. \uc11c\ubc84 \uc124\uc815 \ucd5c\uc801\ud654<\/a><\/li>\n
- 7. \ubaa8\ub2c8\ud130\ub9c1 \ubc0f \ud29c\ub2dd<\/a><\/li>\n
- 8. \uacb0\ub860 \ubc0f \uc694\uc57d<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n
MySQL \uc131\ub2a5 \uc800\ud558\uc758 \uc6d0\uc778\uacfc \ud6a8\uacfc\uc801\uc778 \ud574\uacb0 \ubc29\uc548<\/h1>\n
![\"MySQL](\"https:\/\/m9js.shop\/blog\/wp-content\/uploads\/2024\/08\/4f845ad77637c35ee0eeee2c2652c940.jpeg\")
<\/p>\n
MySQL\uc740 \uc138\uacc4\uc5d0\uc11c \uac00\uc7a5 \ub110\ub9ac \uc0ac\uc6a9\ub418\ub294 \uc624\ud508 \uc18c\uc2a4 \uad00\uacc4\ud615 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uad00\ub9ac \uc2dc\uc2a4\ud15c(RDBMS) \uc911 \ud558\ub098\uc785\ub2c8\ub2e4. \uadf8\ub7ec\ub098 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \uc131\ub2a5 \uc800\ud558\ub294 \ub9ce\uc740 \uc0ac\uc6a9\uc790\uc640 \uae30\uc5c5\uc5d0\uac8c \uc2ec\uac01\ud55c \ubb38\uc81c\ub85c \ub2e4\uac00\uc635\ub2c8\ub2e4. \uc131\ub2a5 \uc800\ud558\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \uc751\ub2f5 \uc18d\ub3c4, \ucc98\ub9ac\ub7c9, \uadf8\ub9ac\uace0 \uc804\uccb4\uc801\uc778 \uc2dc\uc2a4\ud15c\uc758 \ud6a8\uc728\uc131\uc5d0 \uc601\ud5a5\uc744 \ubbf8\uce58\uba70, \uc774\ub294 \uacb0\uad6d \ube44\uc988\ub2c8\uc2a4\uc758 \uc131\uacfc\uc5d0 \ubd80\uc815\uc801\uc778 \uc601\ud5a5\uc744 \ubbf8\uce60 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ubcf8 \uae00\uc5d0\uc11c\ub294 MySQL \uc131\ub2a5 \uc800\ud558\uc758 \uc6d0\uc778\uacfc \uc774\ub97c \ud574\uacb0\ud558\uae30 \uc704\ud55c \ud6a8\uacfc\uc801\uc778 \ubc29\uc548\uc744 \ub2e4\ub8e8\uace0\uc790 \ud569\ub2c8\ub2e4.<\/p>\n
1. MySQL \uc131\ub2a5 \uc800\ud558\uc758 \uc77c\ubc18\uc801\uc778 \uc6d0\uc778<\/h2>\n
MySQL \uc131\ub2a5 \uc800\ud558\uc758 \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
\n- \ucffc\ub9ac \ucd5c\uc801\ud654 \ubd80\uc871:<\/strong> \ube44\ud6a8\uc728\uc801\uc778 \ucffc\ub9ac\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc131\ub2a5\uc744 \ud06c\uac8c \uc800\ud558\uc2dc\ud0ac \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc608\ub97c \ub4e4\uc5b4, \uc778\ub371\uc2a4\uac00 \uc5c6\ub294 \ud14c\uc774\ube14\uc5d0\uc11c \ub300\ub7c9\uc758 \ub370\uc774\ud130\ub97c \uac80\uc0c9\ud558\ub294 \ucffc\ub9ac\ub294 \ub9e4\uc6b0 \ub290\ub9b4 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/li>\n
- \ud558\ub4dc\uc6e8\uc5b4 \uc790\uc6d0 \ubd80\uc871:<\/strong> CPU, \uba54\ubaa8\ub9ac, \ub514\uc2a4\ud06c I\/O \ub4f1\uc758 \ud558\ub4dc\uc6e8\uc5b4 \uc790\uc6d0\uc774 \ubd80\uc871\ud558\uba74 MySQL\uc758 \uc131\ub2a5\uc774 \uc800\ud558\ub420 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/li>\n
- \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc124\uacc4 \ubb38\uc81c:<\/strong> \uc798\ubabb\ub41c \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc124\uacc4\ub294 \uc131\ub2a5 \uc800\ud558\uc758 \uc8fc\uc694 \uc6d0\uc778 \uc911 \ud558\ub098\uc785\ub2c8\ub2e4. \uc815\uaddc\ud654\uac00 \uacfc\ub3c4\ud558\uac70\ub098 \ubd88\ud544\uc694\ud55c \uc870\uc778\uc774 \ub9ce\uc744 \uacbd\uc6b0 \uc131\ub2a5\uc774 \ub5a8\uc5b4\uc9c8 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/li>\n
- \ub3d9\uc2dc\uc131 \ubb38\uc81c:<\/strong> \uc5ec\ub7ec \uc0ac\uc6a9\uc790\uac00 \ub3d9\uc2dc\uc5d0 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0 \uc811\uadfc\ud560 \ub54c \ubc1c\uc0dd\ud558\ub294 \ub3d9\uc2dc\uc131 \ubb38\uc81c\ub294 \uc131\ub2a5 \uc800\ud558\ub97c \ucd08\ub798\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/li>\n
- \uc11c\ubc84 \uc124\uc815 \ubbf8\ube44:<\/strong> MySQL \uc11c\ubc84\uc758 \uc124\uc815\uc774 \ucd5c\uc801\ud654\ub418\uc9c0 \uc54a\uc73c\uba74 \uc131\ub2a5\uc774 \uc800\ud558\ub420 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc608\ub97c \ub4e4\uc5b4, \ubc84\ud37c \ud06c\uae30\ub098 \uce90\uc2dc \uc124\uc815\uc774 \uc801\uc808\ud558\uc9c0 \uc54a\uc73c\uba74 \ucffc\ub9ac \uc131\ub2a5\uc774 \ub5a8\uc5b4\uc9c8 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/li>\n<\/ul>\n
\uc774 \uc678\uc5d0\ub3c4 \ub2e4\uc591\ud55c \uc6d0\uc778\uc774 \uc874\uc7ac\ud558\uc9c0\ub9cc, \uc704\uc5d0\uc11c \uc5b8\uae09\ud55c \ub2e4\uc12f \uac00\uc9c0\ub294 \uac00\uc7a5 \ud754\ud558\uac8c \ubc1c\uc0dd\ud558\ub294 \ubb38\uc81c\ub4e4\uc785\ub2c8\ub2e4. \uc774\ub7ec\ud55c \uc6d0\uc778\uc744 \uc774\ud574\ud558\uace0 \ud574\uacb0\ud558\ub294 \uac83\uc774 MySQL \uc131\ub2a5\uc744 \uac1c\uc120\ud558\ub294 \uccab\uac78\uc74c\uc785\ub2c8\ub2e4.<\/p>\n
2. \ucffc\ub9ac \ucd5c\uc801\ud654 \ubc29\ubc95<\/h2>\n
\ucffc\ub9ac \ucd5c\uc801\ud654\ub294 MySQL \uc131\ub2a5\uc744 \uac1c\uc120\ud558\ub294 \ub370 \uc788\uc5b4 \uac00\uc7a5 \uc911\uc694\ud55c \uc694\uc18c \uc911 \ud558\ub098\uc785\ub2c8\ub2e4. \uc774 \uc139\uc158\uc5d0\uc11c\ub294 \ucffc\ub9ac\ub97c \ucd5c\uc801\ud654\ud558\uae30 \uc704\ud55c \ub2e4\uc591\ud55c \ubc29\ubc95\uc744 \uc18c\uac1c\ud569\ub2c8\ub2e4.<\/p>\n
\uccab \ubc88\uc9f8\ub85c, \uc778\ub371\uc2a4 \ud65c\uc6a9<\/strong>\uc785\ub2c8\ub2e4. \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 \uad6c\uc870\uc785\ub2c8\ub2e4. \uc778\ub371\uc2a4\ub97c \uc801\uc808\ud788 \uc0ac\uc6a9\ud558\uba74 \ucffc\ub9ac \uc131\ub2a5\uc744 \ud06c\uac8c \ud5a5\uc0c1\uc2dc\ud0ac \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc608\ub97c \ub4e4\uc5b4, \ub2e4\uc74c\uacfc \uac19\uc740 \ucffc\ub9ac\uac00 \uc788\ub2e4\uace0 \uac00\uc815\ud574 \ubcf4\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n
SELECT * FROM users WHERE last_name = 'Kim';<\/code><\/pre>\n\uc704 \ucffc\ub9ac\ub294 last_name \uceec\ub7fc\uc5d0 \uc778\ub371\uc2a4\uac00 \uc5c6\ub2e4\uba74 \uc804\uccb4 \ud14c\uc774\ube14\uc744 \uc2a4\uce94\ud574\uc57c \ud558\ubbc0\ub85c \uc131\ub2a5\uc774 \uc800\ud558\ub420 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ub530\ub77c\uc11c last_name \uceec\ub7fc\uc5d0 \uc778\ub371\uc2a4\ub97c \ucd94\uac00\ud558\ub294 \uac83\uc774 \uc88b\uc2b5\ub2c8\ub2e4.<\/p>\n
CREATE INDEX idx_last_name ON users(last_name);<\/code><\/pre>\n\ub450 \ubc88\uc9f8\ub85c, \uc11c\ube0c\ucffc\ub9ac \ub300\uc2e0 \uc870\uc778 \uc0ac\uc6a9<\/strong>\uc785\ub2c8\ub2e4. \uc11c\ube0c\ucffc\ub9ac\ub294 \uc885\uc885 \ube44\ud6a8\uc728\uc801\uc77c \uc218 \uc788\uc73c\uba70, \uc870\uc778\uc744 \uc0ac\uc6a9\ud558\uba74 \uc131\ub2a5\uc744 \uac1c\uc120\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc608\ub97c \ub4e4\uc5b4, \ub2e4\uc74c\uacfc \uac19\uc740 \uc11c\ube0c\ucffc\ub9ac\ub97c \uace0\ub824\ud574 \ubcf4\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n
SELECT * FROM orders WHERE user_id IN (SELECT id FROM users WHERE last_name = 'Kim');<\/code><\/pre>\n\uc704 \ucffc\ub9ac\ub294 \uc870\uc778\uc73c\ub85c \ubcc0\uacbd\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n
SELECT o.* FROM orders o JOIN users u ON o.user_id = u.id WHERE u.last_name = 'Kim';<\/code><\/pre>\n\uc138 \ubc88\uc9f8\ub85c, \ubd88\ud544\uc694\ud55c \ub370\uc774\ud130 \uc120\ud0dd \ud53c\ud558\uae30<\/strong>\uc785\ub2c8\ub2e4. SELECT * \ub300\uc2e0 \ud544\uc694\ud55c \uceec\ub7fc\ub9cc \uc120\ud0dd\ud558\ub294 \uac83\uc774 \uc88b\uc2b5\ub2c8\ub2e4. \uc608\ub97c \ub4e4\uc5b4, \ub2e4\uc74c\uacfc \uac19\uc740 \ucffc\ub9ac\ub97c \uace0\ub824\ud574 \ubcf4\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n
SELECT * FROM products;<\/code><\/pre>\n\uc704 \ucffc\ub9ac\ub294 \ubaa8\ub4e0 \uceec\ub7fc\uc744 \uc120\ud0dd\ud558\ubbc0\ub85c \ubd88\ud544\uc694\ud55c \ub370\uc774\ud130\ub97c \uac00\uc838\uc624\uac8c \ub429\ub2c8\ub2e4. \ud544\uc694\ud55c \uceec\ub7fc\ub9cc \uc120\ud0dd\ud558\ub294 \uac83\uc774 \uc88b\uc2b5\ub2c8\ub2e4.<\/p>\n
SELECT id, name, price FROM products;<\/code><\/pre>\n\ucffc\ub9ac \ucd5c\uc801\ud654\ub294 MySQL \uc131\ub2a5\uc744 \uac1c\uc120\ud558\ub294 \ub370 \uc788\uc5b4 \ub9e4\uc6b0 \uc911\uc694\ud55c \uc694\uc18c\uc785\ub2c8\ub2e4. \uc704\uc5d0\uc11c \uc5b8\uae09\ud55c \ubc29\ubc95\ub4e4\uc744 \ud1b5\ud574 \ucffc\ub9ac\ub97c \ucd5c\uc801\ud654\ud558\uba74 \uc131\ub2a5\uc744 \ud06c\uac8c \ud5a5\uc0c1\uc2dc\ud0ac \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n
3. \ud558\ub4dc\uc6e8\uc5b4 \uc790\uc6d0 \uad00\ub9ac<\/h2>\n
MySQL \uc131\ub2a5 \uc800\ud558\uc758 \ub610 \ub2e4\ub978 \uc8fc\uc694 \uc6d0\uc778\uc740 \ud558\ub4dc\uc6e8\uc5b4 \uc790\uc6d0\uc758 \ubd80\uc871\uc785\ub2c8\ub2e4. \uc774 \uc139\uc158\uc5d0\uc11c\ub294 \ud558\ub4dc\uc6e8\uc5b4 \uc790\uc6d0\uc744 \ud6a8\uacfc\uc801\uc73c\ub85c \uad00\ub9ac\ud558\ub294 \ubc29\ubc95\uc744 \uc0b4\ud3b4\ubcf4\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n
\uccab \ubc88\uc9f8\ub85c, CPU \uc5c5\uadf8\ub808\uc774\ub4dc<\/strong>\uc785\ub2c8\ub2e4. MySQL\uc740 CPU \uc9d1\uc57d\uc801\uc778 \uc791\uc5c5\uc774 \ub9ce\uae30 \ub54c\ubb38\uc5d0 CPU \uc131\ub2a5\uc774 \uc911\uc694\ud569\ub2c8\ub2e4. CPU\ub97c \uc5c5\uadf8\ub808\uc774\ub4dc\ud558\uba74 \ucffc\ub9ac \ucc98\ub9ac \uc18d\ub3c4\uac00 \ud5a5\uc0c1\ub420 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n
\ub450 \ubc88\uc9f8\ub85c, \uba54\ubaa8\ub9ac \uc99d\uc124<\/strong>\uc785\ub2c8\ub2e4. MySQL\uc740 \uba54\ubaa8\ub9ac\ub97c \ub9ce\uc774 \uc0ac\uc6a9\ud558\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc785\ub2c8\ub2e4. \uba54\ubaa8\ub9ac\ub97c \uc99d\uc124\ud558\uba74 \uce90\uc2dc\ub97c \ub354 \ub9ce\uc774 \uc0ac\uc6a9\ud560 \uc218 \uc788\uc5b4 \uc131\ub2a5\uc774 \ud5a5\uc0c1\ub429\ub2c8\ub2e4. \uc608\ub97c \ub4e4\uc5b4, MySQL\uc758 innodb_buffer_pool_size<\/code> \uc124\uc815\uc744 \uc870\uc815\ud558\uc5ec \uba54\ubaa8\ub9ac\ub97c \ucd5c\uc801\ud654\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n
SET GLOBAL innodb_buffer_pool_size = 2 * 1024 * 1024 * 1024; -- 2GB\ub85c \uc124\uc815<\/code><\/pre>\n\uc138 \ubc88\uc9f8\ub85c, \ub514\uc2a4\ud06c I\/O \ucd5c\uc801\ud654<\/strong>\uc785\ub2c8\ub2e4. SSD\ub97c \uc0ac\uc6a9\ud558\uba74 \ub514\uc2a4\ud06c I\/O \uc18d\ub3c4\uac00 \ud5a5\uc0c1\ub418\uc5b4 MySQL \uc131\ub2a5\uc774 \uac1c\uc120\ub420 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ub610\ud55c RAID \uad6c\uc131\uc744 \ud1b5\ud574 \ub370\uc774\ud130\uc758 \uc548\uc804\uc131\uc744 \ub192\uc774\uace0 \uc131\ub2a5\uc744 \ud5a5\uc0c1\uc2dc\ud0ac \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n
\ud558\ub4dc\uc6e8\uc5b4 \uc790\uc6d0 \uad00\ub9ac\ub294 MySQL \uc131\ub2a5\uc744 \uac1c\uc120\ud558\ub294 \ub370 \uc788\uc5b4 \ub9e4\uc6b0 \uc911\uc694\ud55c \uc694\uc18c\uc785\ub2c8\ub2e4. \uc801\uc808\ud55c \ud558\ub4dc\uc6e8\uc5b4 \uc790\uc6d0 \uad00\ub9ac\ub97c \ud1b5\ud574 \uc131\ub2a5\uc744 \uadf9\ub300\ud654\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n
4. \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc124\uacc4 \ucd5c\uc801\ud654<\/h2>\n\ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc124\uacc4\ub294 MySQL \uc131\ub2a5\uc5d0 \ud070 \uc601\ud5a5\uc744 \ubbf8\uce69\ub2c8\ub2e4. \uc774 \uc139\uc158\uc5d0\uc11c\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc124\uacc4\ub97c \ucd5c\uc801\ud654\ud558\ub294 \ubc29\ubc95\uc744 \uc0b4\ud3b4\ubcf4\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n
\uccab \ubc88\uc9f8\ub85c, \uc815\uaddc\ud654\uc640 \ube44\uc815\uaddc\ud654\uc758 \uade0\ud615<\/strong>\uc785\ub2c8\ub2e4. \uc815\uaddc\ud654\ub294 \ub370\uc774\ud130 \uc911\ubcf5\uc744 \uc904\uc774\uace0 \ubb34\uacb0\uc131\uc744 \uc720\uc9c0\ud558\ub294 \ub370 \ub3c4\uc6c0\uc774 \ub429\ub2c8\ub2e4. \uadf8\ub7ec\ub098 \uacfc\ub3c4\ud55c \uc815\uaddc\ud654\ub294 \uc870\uc778\uc744 \uc99d\uac00\uc2dc\ucf1c \uc131\ub2a5\uc744 \uc800\ud558\uc2dc\ud0ac \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ub530\ub77c\uc11c \uc801\uc808\ud55c \uc218\uc900\uc758 \ube44\uc815\uaddc\ud654\ub97c \ud1b5\ud574 \uc131\ub2a5\uc744 \uac1c\uc120\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n
\ub450 \ubc88\uc9f8\ub85c, \uc801\uc808\ud55c \ub370\uc774\ud130 \ud0c0\uc785 \uc120\ud0dd<\/strong>\uc785\ub2c8\ub2e4. \ub370\uc774\ud130 \ud0c0\uc785\uc744 \uc801\uc808\ud788 \uc120\ud0dd\ud558\uba74 \uc800\uc7a5 \uacf5\uac04\uc744 \uc808\uc57d\ud558\uace0 \uc131\ub2a5\uc744 \ud5a5\uc0c1\uc2dc\ud0ac \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc608\ub97c \ub4e4\uc5b4, \uc815\uc218\ud615 \ub370\uc774\ud130\ub97c \uc800\uc7a5\ud560 \ub54c TINYINT<\/code>, SMALLINT<\/code>, INT<\/code>, BIGINT<\/code> \uc911\uc5d0\uc11c \uc801\uc808\ud55c \ud0c0\uc785\uc744 \uc120\ud0dd\ud574\uc57c \ud569\ub2c8\ub2e4.<\/p>\n
\uc138 \ubc88\uc9f8\ub85c, \uc778\ub371\uc2a4 \uc124\uacc4<\/strong>\uc785\ub2c8\ub2e4. \uc778\ub371\uc2a4\ub294 \ub370\uc774\ud130 \uac80\uc0c9 \uc18d\ub3c4\ub97c \ud5a5\uc0c1\uc2dc\ud0a4\ub294 \ub370 \uc911\uc694\ud55c \uc5ed\ud560\uc744 \ud569\ub2c8\ub2e4. \uadf8\ub7ec\ub098 \uc778\ub371\uc2a4\uac00 \ub108\ubb34 \ub9ce\uc73c\uba74 \uc4f0\uae30 \uc791\uc5c5\uc774 \ub290\ub824\uc9c8 \uc218 \uc788\uc73c\ubbc0\ub85c \uc801\uc808\ud55c \uc778\ub371\uc2a4\ub97c \uc124\uacc4\ud574\uc57c \ud569\ub2c8\ub2e4.<\/p>\n
\ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc124\uacc4 \ucd5c\uc801\ud654\ub294 MySQL \uc131\ub2a5\uc744 \uac1c\uc120\ud558\ub294 \ub370 \uc788\uc5b4 \ub9e4\uc6b0 \uc911\uc694\ud55c \uc694\uc18c\uc785\ub2c8\ub2e4. \uc801\uc808\ud55c \uc124\uacc4\ub97c \ud1b5\ud574 \uc131\ub2a5\uc744 \uadf9\ub300\ud654\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n
5. \ub3d9\uc2dc\uc131 \ubb38\uc81c \ud574\uacb0<\/h2>\n\ub3d9\uc2dc\uc131 \ubb38\uc81c\ub294 \uc5ec\ub7ec \uc0ac\uc6a9\uc790\uac00 \ub3d9\uc2dc\uc5d0 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0 \uc811\uadfc\ud560 \ub54c \ubc1c\uc0dd\ud558\ub294 \ubb38\uc81c\uc785\ub2c8\ub2e4. \uc774 \uc139\uc158\uc5d0\uc11c\ub294 \ub3d9\uc2dc\uc131 \ubb38\uc81c\ub97c \ud574\uacb0\ud558\ub294 \ubc29\ubc95\uc744 \uc0b4\ud3b4\ubcf4\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n
\uccab \ubc88\uc9f8\ub85c, \ud2b8\ub79c\uc7ad\uc158 \uad00\ub9ac<\/strong>\uc785\ub2c8\ub2e4. \ud2b8\ub79c\uc7ad\uc158\uc740 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \uc77c\uad00\uc131\uc744 \uc720\uc9c0\ud558\ub294 \ub370 \uc911\uc694\ud55c \uc5ed\ud560\uc744 \ud569\ub2c8\ub2e4. \ud2b8\ub79c\uc7ad\uc158\uc744 \uc801\uc808\ud788 \uad00\ub9ac\ud558\uba74 \ub3d9\uc2dc\uc131 \ubb38\uc81c\ub97c \uc904\uc77c \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n
\ub450 \ubc88\uc9f8\ub85c, \ub77d(Lock) \uad00\ub9ac<\/strong>\uc785\ub2c8\ub2e4. MySQL\uc740 \uc5ec\ub7ec \uc885\ub958\uc758 \ub77d\uc744 \uc9c0\uc6d0\ud569\ub2c8\ub2e4. \uc801\uc808\ud55c \ub77d \uad00\ub9ac\ub97c \ud1b5\ud574 \ub3d9\uc2dc\uc131 \ubb38\uc81c\ub97c \ud574\uacb0\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc608\ub97c \ub4e4\uc5b4, SELECT ... FOR UPDATE<\/code> \uad6c\ubb38\uc744 \uc0ac\uc6a9\ud558\uc5ec \ud2b9\uc815 \ud589\uc5d0 \ub300\ud55c \ub77d\uc744 \uc124\uc815\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n
SELECT * FROM accounts WHERE id = 1 FOR UPDATE;<\/code><\/pre>\n\uc138 \ubc88\uc9f8\ub85c, \ucffc\ub9ac \ubd84\uc0b0 \ucc98\ub9ac<\/strong>\uc785\ub2c8\ub2e4. \uc5ec\ub7ec \uc11c\ubc84\uc5d0 \ucffc\ub9ac\ub97c \ubd84\uc0b0 \ucc98\ub9ac\ud558\uba74 \ub3d9\uc2dc\uc131 \ubb38\uc81c\ub97c \uc904\uc77c \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc774\ub97c \uc704\ud574 \ub85c\ub4dc \ubc38\ub7f0\uc11c\ub97c \uc0ac\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n
\ub3d9\uc2dc\uc131 \ubb38\uc81c \ud574\uacb0\uc740 MySQL \uc131\ub2a5\uc744 \uac1c\uc120\ud558\ub294 \ub370 \uc788\uc5b4 \ub9e4\uc6b0 \uc911\uc694\ud55c \uc694\uc18c\uc785\ub2c8\ub2e4. \uc801\uc808\ud55c \ub3d9\uc2dc\uc131 \uad00\ub9ac \ubc29\ubc95\uc744 \ud1b5\ud574 \uc131\ub2a5\uc744 \uadf9\ub300\ud654\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n
6. \uc11c\ubc84 \uc124\uc815 \ucd5c\uc801\ud654<\/h2>\nMySQL \uc11c\ubc84\uc758 \uc124\uc815\uc740 \uc131\ub2a5\uc5d0 \ud070 \uc601\ud5a5\uc744 \ubbf8\uce69\ub2c8\ub2e4. \uc774 \uc139\uc158\uc5d0\uc11c\ub294 \uc11c\ubc84 \uc124\uc815\uc744 \ucd5c\uc801\ud654\ud558\ub294 \ubc29\ubc95\uc744 \uc0b4\ud3b4\ubcf4\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n
\uccab \ubc88\uc9f8\ub85c, \ubc84\ud37c \ud06c\uae30 \uc870\uc815<\/strong>\uc785\ub2c8\ub2e4. MySQL\uc740 \ub2e4\uc591\ud55c \ubc84\ud37c\ub97c \uc0ac\uc6a9\ud558\uc5ec \ub370\uc774\ud130\ub97c \ucc98\ub9ac\ud569\ub2c8\ub2e4. \ubc84\ud37c \ud06c\uae30\ub97c \uc801\uc808\ud788 \uc870\uc815\ud558\uba74 \uc131\ub2a5\uc744 \ud5a5\uc0c1\uc2dc\ud0ac \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc608\ub97c \ub4e4\uc5b4, innodb_buffer_pool_size<\/code>\uc640 \uac19\uc740 \uc124\uc815\uc744 \uc870\uc815\ud574\uc57c \ud569\ub2c8\ub2e4.<\/p>\n
[mysqld]\ninnodb_buffer_pool_size = 1G -- 1GB\ub85c \uc124\uc815\n<\/code><\/pre>\n\ub450 \ubc88\uc9f8\ub85c, \ucffc\ub9ac \uce90\uc2dc \ud65c\uc131\ud654<\/strong>\uc785\ub2c8\ub2e4. \ucffc\ub9ac \uce90\uc2dc\ub294 \ub3d9\uc77c\ud55c \ucffc\ub9ac\uc5d0 \ub300\ud55c \uacb0\uacfc\ub97c \uc800\uc7a5\ud558\uc5ec \uc131\ub2a5\uc744 \ud5a5\uc0c1\uc2dc\ud0b5\ub2c8\ub2e4. \ucffc\ub9ac \uce90\uc2dc\ub97c \ud65c\uc131\ud654\ud558\uba74 \ubc18\ubcf5\uc801\uc778 \ucffc\ub9ac\uc758 \uc131\ub2a5\uc774 \uac1c\uc120\ub420 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n
[mysqld]\nquery_cache_type = 1\nquery_cache_size = 128M -- 128MB\ub85c \uc124\uc815\n<\/code><\/pre>\n\uc138 \ubc88\uc9f8\ub85c, \ub85c\uadf8 \uc124\uc815 \uc870\uc815<\/strong>\uc785\ub2c8\ub2e4. MySQL\uc740 \ub2e4\uc591\ud55c \ub85c\uadf8\ub97c \uc0dd\uc131\ud569\ub2c8\ub2e4. \ub85c\uadf8 \uc124\uc815\uc744 \uc870\uc815\ud558\uc5ec \ubd88\ud544\uc694\ud55c \ub85c\uadf8 \uc0dd\uc131\uc744 \uc904\uc774\uba74 \uc131\ub2a5\uc774 \ud5a5\uc0c1\ub420 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n
\uc11c\ubc84 \uc124\uc815 \ucd5c\uc801\ud654\ub294 MySQL \uc131\ub2a5\uc744 \uac1c\uc120\ud558\ub294 \ub370 \uc788\uc5b4 \ub9e4\uc6b0 \uc911\uc694\ud55c \uc694\uc18c\uc785\ub2c8\ub2e4. \uc801\uc808\ud55c \uc124\uc815\uc744 \ud1b5\ud574 \uc131\ub2a5\uc744 \uadf9\ub300\ud654\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n
7. \ubaa8\ub2c8\ud130\ub9c1 \ubc0f \ud29c\ub2dd<\/h2>\nMySQL \uc131\ub2a5\uc744 \uc9c0\uc18d\uc801\uc73c\ub85c \ubaa8\ub2c8\ud130\ub9c1\ud558\uace0 \ud29c\ub2dd\ud558\ub294 \uac83\uc740 \ub9e4\uc6b0 \uc911\uc694\ud569\ub2c8\ub2e4. \uc774 \uc139\uc158\uc5d0\uc11c\ub294 \ubaa8\ub2c8\ud130\ub9c1 \ubc0f \ud29c\ub2dd \ubc29\ubc95\uc744 \uc0b4\ud3b4\ubcf4\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n
\uccab \ubc88\uc9f8\ub85c, \uc131\ub2a5 \uc2a4\ud0a4\ub9c8 \ud65c\uc6a9<\/strong>\uc785\ub2c8\ub2e4. MySQL\uc758 \uc131\ub2a5 \uc2a4\ud0a4\ub9c8\ub294 \ub2e4\uc591\ud55c \uc131\ub2a5 \uad00\ub828 \uc815\ubcf4\ub97c \uc81c\uacf5\ud569\ub2c8\ub2e4. \uc774\ub97c \ud65c\uc6a9\ud558\uc5ec \ucffc\ub9ac \uc131\ub2a5\uc744 \ubd84\uc11d\ud558\uace0 \ud29c\ub2dd\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n
\ub450 \ubc88\uc9f8\ub85c, EXPLAIN \uba85\ub839\uc5b4 \uc0ac\uc6a9<\/strong>\uc785\ub2c8\ub2e4. EXPLAIN \uba85\ub839\uc5b4\ub97c \uc0ac\uc6a9\ud558\uba74 \ucffc\ub9ac \uc2e4\ud589 \uacc4\ud68d\uc744 \ud655\uc778\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc774\ub97c \ud1b5\ud574 \ucffc\ub9ac\ub97c \ucd5c\uc801\ud654\ud560 \uc218 \uc788\ub294 \uae30\ud68c\ub97c \ucc3e\uc744 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n
EXPLAIN SELECT * FROM users WHERE last_name = 'Kim';<\/code><\/pre>\n\uc138 \ubc88\uc9f8\ub85c, \ubaa8\ub2c8\ud130\ub9c1 \ub3c4\uad6c \ud65c\uc6a9<\/strong>\uc785\ub2c8\ub2e4. \ub2e4\uc591\ud55c \ubaa8\ub2c8\ud130\ub9c1 \ub3c4\uad6c\ub97c \uc0ac\uc6a9\ud558\uc5ec MySQL \uc131\ub2a5\uc744 \ubaa8\ub2c8\ud130\ub9c1\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc608\ub97c \ub4e4\uc5b4, Percona Monitoring and Management(PMM)\uc640 \uac19\uc740 \ub3c4\uad6c\ub97c \uc0ac\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n
\ubaa8\ub2c8\ud130\ub9c1 \ubc0f \ud29c\ub2dd\uc740 MySQL \uc131\ub2a5\uc744 \uc9c0\uc18d\uc801\uc73c\ub85c \uac1c\uc120\ud558\ub294 \ub370 \uc788\uc5b4 \ub9e4\uc6b0 \uc911\uc694\ud55c \uc694\uc18c\uc785\ub2c8\ub2e4. \uc815\uae30\uc801\uc778 \ubaa8\ub2c8\ud130\ub9c1\uacfc \ud29c\ub2dd\uc744 \ud1b5\ud574 \uc131\ub2a5\uc744 \uadf9\ub300\ud654\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n
8. \uacb0\ub860 \ubc0f \uc694\uc57d<\/h2>\nMySQL \uc131\ub2a5 \uc800\ud558\ub294 \ub2e4\uc591\ud55c \uc6d0\uc778\uc73c\ub85c \uc778\ud574 \ubc1c\uc0dd\ud560 \uc218 \uc788\uc73c\uba70, \uc774\ub97c \ud574\uacb0\ud558\uae30 \uc704\ud55c \uc5ec\ub7ec \uac00\uc9c0 \ubc29\ubc95\uc774 \uc874\uc7ac\ud569\ub2c8\ub2e4. \ubcf8 \uae00\uc5d0\uc11c\ub294 \ucffc\ub9ac \ucd5c\uc801\ud654, \ud558\ub4dc\uc6e8\uc5b4 \uc790\uc6d0 \uad00\ub9ac, \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc124\uacc4 \ucd5c\uc801\ud654, \ub3d9\uc2dc\uc131 \ubb38\uc81c \ud574\uacb0, \uc11c\ubc84 \uc124\uc815 \ucd5c\uc801\ud654, \ubaa8\ub2c8\ud130\ub9c1 \ubc0f \ud29c\ub2dd \ub4f1 \ub2e4\uc591\ud55c \uce21\uba74\uc5d0\uc11c MySQL \uc131\ub2a5 \uac1c\uc120 \ubc29\uc548\uc744 \ub2e4\ub8e8\uc5c8\uc2b5\ub2c8\ub2e4.<\/p>\n
MySQL\uc758 \uc131\ub2a5\uc744 \uac1c\uc120\ud558\uae30 \uc704\ud574\uc11c\ub294 \ub2e4\uc74c\uacfc \uac19\uc740 \uc810\ub4e4\uc744 \uc720\ub150\ud574\uc57c \ud569\ub2c8\ub2e4:<\/p>\n
\n- \ucffc\ub9ac \ucd5c\uc801\ud654:<\/strong> \uc778\ub371\uc2a4 \ud65c\uc6a9 \ubc0f \ubd88\ud544\uc694\ud55c \ub370\uc774\ud130 \uc120\ud0dd \ud53c\ud558\uae30<\/li>\n
- \ud558\ub4dc\uc6e8\uc5b4 \uc790\uc6d0 \uad00\ub9ac:<\/strong> CPU \ubc0f \uba54\ubaa8\ub9ac \uc5c5\uadf8\ub808\uc774\ub4dc<\/li>\n
- \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc124\uacc4:<\/strong> \uc815\uaddc\ud654\uc640 \ube44\uc815\uaddc\ud654\uc758 \uade0\ud615 \uc720\uc9c0<\/li>\n
- \ub3d9\uc2dc\uc131 \ubb38\uc81c \ud574\uacb0:<\/strong> \ud2b8\ub79c\uc7ad\uc158 \ubc0f \ub77d \uad00\ub9ac<\/li>\n
- \uc11c\ubc84 \uc124\uc815 \ucd5c\uc801\ud654:<\/strong> \ubc84\ud37c \ud06c\uae30 \ubc0f \ucffc\ub9ac \uce90\uc2dc \uc870\uc815<\/li>\n
- \ubaa8\ub2c8\ud130\ub9c1 \ubc0f \ud29c\ub2dd:<\/strong> \uc131\ub2a5 \uc2a4\ud0a4\ub9c8 \ubc0f EXPLAIN \uba85\ub839\uc5b4 \ud65c\uc6a9<\/li>\n<\/ul>\n
MySQL \uc131\ub2a5 \uac1c\uc120\uc740 \uc9c0\uc18d\uc801\uc778 \ub178\ub825\uacfc \uad00\ub9ac\uac00 \ud544\uc694\ud55c \uacfc\uc815\uc785\ub2c8\ub2e4. \uc704\uc5d0\uc11c \uc5b8\uae09\ud55c \ubc29\ubc95\ub4e4\uc744 \ud1b5\ud574 MySQL\uc758 \uc131\ub2a5\uc744 \uadf9\ub300\ud654\ud558\uace0 \ube44\uc988\ub2c8\uc2a4\uc758 \uc131\uacf5\uc5d0 \uae30\uc5ec\ud560 \uc218 \uc788\uae30\ub97c \ubc14\ub78d\ub2c8\ub2e4.<\/p>\n","protected":false},"excerpt":{"rendered":"
\ubaa9\ucc28 MySQL \uc131\ub2a5 \uc800\ud558\uc758 \uc6d0\uc778\uacfc \ud6a8\uacfc\uc801\uc778 \ud574\uacb0 \ubc29\uc548 1. MySQL \uc131\ub2a5 \uc800\ud558\uc758 \uc77c\ubc18\uc801\uc778 \uc6d0\uc778 2. […]<\/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":[2351,2208,2100],"class_list":["post-51564","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-development","tag-management","tag-monitoring","tag-mysql"],"acf":[],"_links":{"self":[{"href":"https:\/\/m9js.shop\/blog\/wp-json\/wp\/v2\/posts\/51564","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=51564"}],"version-history":[{"count":0,"href":"https:\/\/m9js.shop\/blog\/wp-json\/wp\/v2\/posts\/51564\/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=51564"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/m9js.shop\/blog\/wp-json\/wp\/v2\/categories?post=51564"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/m9js.shop\/blog\/wp-json\/wp\/v2\/tags?post=51564"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
MySQL \uc131\ub2a5 \uc800\ud558\uc758 \uc6d0\uc778\uacfc \ud6a8\uacfc\uc801\uc778 \ud574\uacb0 \ubc29\uc548<\/h1>\n
<\/p>\n
MySQL\uc740 \uc138\uacc4\uc5d0\uc11c \uac00\uc7a5 \ub110\ub9ac \uc0ac\uc6a9\ub418\ub294 \uc624\ud508 \uc18c\uc2a4 \uad00\uacc4\ud615 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uad00\ub9ac \uc2dc\uc2a4\ud15c(RDBMS) \uc911 \ud558\ub098\uc785\ub2c8\ub2e4. \uadf8\ub7ec\ub098 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \uc131\ub2a5 \uc800\ud558\ub294 \ub9ce\uc740 \uc0ac\uc6a9\uc790\uc640 \uae30\uc5c5\uc5d0\uac8c \uc2ec\uac01\ud55c \ubb38\uc81c\ub85c \ub2e4\uac00\uc635\ub2c8\ub2e4. \uc131\ub2a5 \uc800\ud558\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \uc751\ub2f5 \uc18d\ub3c4, \ucc98\ub9ac\ub7c9, \uadf8\ub9ac\uace0 \uc804\uccb4\uc801\uc778 \uc2dc\uc2a4\ud15c\uc758 \ud6a8\uc728\uc131\uc5d0 \uc601\ud5a5\uc744 \ubbf8\uce58\uba70, \uc774\ub294 \uacb0\uad6d \ube44\uc988\ub2c8\uc2a4\uc758 \uc131\uacfc\uc5d0 \ubd80\uc815\uc801\uc778 \uc601\ud5a5\uc744 \ubbf8\uce60 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ubcf8 \uae00\uc5d0\uc11c\ub294 MySQL \uc131\ub2a5 \uc800\ud558\uc758 \uc6d0\uc778\uacfc \uc774\ub97c \ud574\uacb0\ud558\uae30 \uc704\ud55c \ud6a8\uacfc\uc801\uc778 \ubc29\uc548\uc744 \ub2e4\ub8e8\uace0\uc790 \ud569\ub2c8\ub2e4.<\/p>\n
1. MySQL \uc131\ub2a5 \uc800\ud558\uc758 \uc77c\ubc18\uc801\uc778 \uc6d0\uc778<\/h2>\n
MySQL \uc131\ub2a5 \uc800\ud558\uc758 \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
- \n
- \ucffc\ub9ac \ucd5c\uc801\ud654 \ubd80\uc871:<\/strong> \ube44\ud6a8\uc728\uc801\uc778 \ucffc\ub9ac\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc131\ub2a5\uc744 \ud06c\uac8c \uc800\ud558\uc2dc\ud0ac \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc608\ub97c \ub4e4\uc5b4, \uc778\ub371\uc2a4\uac00 \uc5c6\ub294 \ud14c\uc774\ube14\uc5d0\uc11c \ub300\ub7c9\uc758 \ub370\uc774\ud130\ub97c \uac80\uc0c9\ud558\ub294 \ucffc\ub9ac\ub294 \ub9e4\uc6b0 \ub290\ub9b4 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/li>\n
- \ud558\ub4dc\uc6e8\uc5b4 \uc790\uc6d0 \ubd80\uc871:<\/strong> CPU, \uba54\ubaa8\ub9ac, \ub514\uc2a4\ud06c I\/O \ub4f1\uc758 \ud558\ub4dc\uc6e8\uc5b4 \uc790\uc6d0\uc774 \ubd80\uc871\ud558\uba74 MySQL\uc758 \uc131\ub2a5\uc774 \uc800\ud558\ub420 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/li>\n
- \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc124\uacc4 \ubb38\uc81c:<\/strong> \uc798\ubabb\ub41c \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc124\uacc4\ub294 \uc131\ub2a5 \uc800\ud558\uc758 \uc8fc\uc694 \uc6d0\uc778 \uc911 \ud558\ub098\uc785\ub2c8\ub2e4. \uc815\uaddc\ud654\uac00 \uacfc\ub3c4\ud558\uac70\ub098 \ubd88\ud544\uc694\ud55c \uc870\uc778\uc774 \ub9ce\uc744 \uacbd\uc6b0 \uc131\ub2a5\uc774 \ub5a8\uc5b4\uc9c8 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/li>\n
- \ub3d9\uc2dc\uc131 \ubb38\uc81c:<\/strong> \uc5ec\ub7ec \uc0ac\uc6a9\uc790\uac00 \ub3d9\uc2dc\uc5d0 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0 \uc811\uadfc\ud560 \ub54c \ubc1c\uc0dd\ud558\ub294 \ub3d9\uc2dc\uc131 \ubb38\uc81c\ub294 \uc131\ub2a5 \uc800\ud558\ub97c \ucd08\ub798\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/li>\n
- \uc11c\ubc84 \uc124\uc815 \ubbf8\ube44:<\/strong> MySQL \uc11c\ubc84\uc758 \uc124\uc815\uc774 \ucd5c\uc801\ud654\ub418\uc9c0 \uc54a\uc73c\uba74 \uc131\ub2a5\uc774 \uc800\ud558\ub420 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc608\ub97c \ub4e4\uc5b4, \ubc84\ud37c \ud06c\uae30\ub098 \uce90\uc2dc \uc124\uc815\uc774 \uc801\uc808\ud558\uc9c0 \uc54a\uc73c\uba74 \ucffc\ub9ac \uc131\ub2a5\uc774 \ub5a8\uc5b4\uc9c8 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/li>\n<\/ul>\n
\uc774 \uc678\uc5d0\ub3c4 \ub2e4\uc591\ud55c \uc6d0\uc778\uc774 \uc874\uc7ac\ud558\uc9c0\ub9cc, \uc704\uc5d0\uc11c \uc5b8\uae09\ud55c \ub2e4\uc12f \uac00\uc9c0\ub294 \uac00\uc7a5 \ud754\ud558\uac8c \ubc1c\uc0dd\ud558\ub294 \ubb38\uc81c\ub4e4\uc785\ub2c8\ub2e4. \uc774\ub7ec\ud55c \uc6d0\uc778\uc744 \uc774\ud574\ud558\uace0 \ud574\uacb0\ud558\ub294 \uac83\uc774 MySQL \uc131\ub2a5\uc744 \uac1c\uc120\ud558\ub294 \uccab\uac78\uc74c\uc785\ub2c8\ub2e4.<\/p>\n
2. \ucffc\ub9ac \ucd5c\uc801\ud654 \ubc29\ubc95<\/h2>\n
\ucffc\ub9ac \ucd5c\uc801\ud654\ub294 MySQL \uc131\ub2a5\uc744 \uac1c\uc120\ud558\ub294 \ub370 \uc788\uc5b4 \uac00\uc7a5 \uc911\uc694\ud55c \uc694\uc18c \uc911 \ud558\ub098\uc785\ub2c8\ub2e4. \uc774 \uc139\uc158\uc5d0\uc11c\ub294 \ucffc\ub9ac\ub97c \ucd5c\uc801\ud654\ud558\uae30 \uc704\ud55c \ub2e4\uc591\ud55c \ubc29\ubc95\uc744 \uc18c\uac1c\ud569\ub2c8\ub2e4.<\/p>\n
\uccab \ubc88\uc9f8\ub85c, \uc778\ub371\uc2a4 \ud65c\uc6a9<\/strong>\uc785\ub2c8\ub2e4. \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 \uad6c\uc870\uc785\ub2c8\ub2e4. \uc778\ub371\uc2a4\ub97c \uc801\uc808\ud788 \uc0ac\uc6a9\ud558\uba74 \ucffc\ub9ac \uc131\ub2a5\uc744 \ud06c\uac8c \ud5a5\uc0c1\uc2dc\ud0ac \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc608\ub97c \ub4e4\uc5b4, \ub2e4\uc74c\uacfc \uac19\uc740 \ucffc\ub9ac\uac00 \uc788\ub2e4\uace0 \uac00\uc815\ud574 \ubcf4\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n
SELECT * FROM users WHERE last_name = 'Kim';<\/code><\/pre>\n\uc704 \ucffc\ub9ac\ub294 last_name \uceec\ub7fc\uc5d0 \uc778\ub371\uc2a4\uac00 \uc5c6\ub2e4\uba74 \uc804\uccb4 \ud14c\uc774\ube14\uc744 \uc2a4\uce94\ud574\uc57c \ud558\ubbc0\ub85c \uc131\ub2a5\uc774 \uc800\ud558\ub420 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ub530\ub77c\uc11c last_name \uceec\ub7fc\uc5d0 \uc778\ub371\uc2a4\ub97c \ucd94\uac00\ud558\ub294 \uac83\uc774 \uc88b\uc2b5\ub2c8\ub2e4.<\/p>\n
CREATE INDEX idx_last_name ON users(last_name);<\/code><\/pre>\n\ub450 \ubc88\uc9f8\ub85c, \uc11c\ube0c\ucffc\ub9ac \ub300\uc2e0 \uc870\uc778 \uc0ac\uc6a9<\/strong>\uc785\ub2c8\ub2e4. \uc11c\ube0c\ucffc\ub9ac\ub294 \uc885\uc885 \ube44\ud6a8\uc728\uc801\uc77c \uc218 \uc788\uc73c\uba70, \uc870\uc778\uc744 \uc0ac\uc6a9\ud558\uba74 \uc131\ub2a5\uc744 \uac1c\uc120\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc608\ub97c \ub4e4\uc5b4, \ub2e4\uc74c\uacfc \uac19\uc740 \uc11c\ube0c\ucffc\ub9ac\ub97c \uace0\ub824\ud574 \ubcf4\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n
SELECT * FROM orders WHERE user_id IN (SELECT id FROM users WHERE last_name = 'Kim');<\/code><\/pre>\n\uc704 \ucffc\ub9ac\ub294 \uc870\uc778\uc73c\ub85c \ubcc0\uacbd\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n
SELECT o.* FROM orders o JOIN users u ON o.user_id = u.id WHERE u.last_name = 'Kim';<\/code><\/pre>\n\uc138 \ubc88\uc9f8\ub85c, \ubd88\ud544\uc694\ud55c \ub370\uc774\ud130 \uc120\ud0dd \ud53c\ud558\uae30<\/strong>\uc785\ub2c8\ub2e4. SELECT * \ub300\uc2e0 \ud544\uc694\ud55c \uceec\ub7fc\ub9cc \uc120\ud0dd\ud558\ub294 \uac83\uc774 \uc88b\uc2b5\ub2c8\ub2e4. \uc608\ub97c \ub4e4\uc5b4, \ub2e4\uc74c\uacfc \uac19\uc740 \ucffc\ub9ac\ub97c \uace0\ub824\ud574 \ubcf4\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n
SELECT * FROM products;<\/code><\/pre>\n\uc704 \ucffc\ub9ac\ub294 \ubaa8\ub4e0 \uceec\ub7fc\uc744 \uc120\ud0dd\ud558\ubbc0\ub85c \ubd88\ud544\uc694\ud55c \ub370\uc774\ud130\ub97c \uac00\uc838\uc624\uac8c \ub429\ub2c8\ub2e4. \ud544\uc694\ud55c \uceec\ub7fc\ub9cc \uc120\ud0dd\ud558\ub294 \uac83\uc774 \uc88b\uc2b5\ub2c8\ub2e4.<\/p>\n
SELECT id, name, price FROM products;<\/code><\/pre>\n\ucffc\ub9ac \ucd5c\uc801\ud654\ub294 MySQL \uc131\ub2a5\uc744 \uac1c\uc120\ud558\ub294 \ub370 \uc788\uc5b4 \ub9e4\uc6b0 \uc911\uc694\ud55c \uc694\uc18c\uc785\ub2c8\ub2e4. \uc704\uc5d0\uc11c \uc5b8\uae09\ud55c \ubc29\ubc95\ub4e4\uc744 \ud1b5\ud574 \ucffc\ub9ac\ub97c \ucd5c\uc801\ud654\ud558\uba74 \uc131\ub2a5\uc744 \ud06c\uac8c \ud5a5\uc0c1\uc2dc\ud0ac \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n
3. \ud558\ub4dc\uc6e8\uc5b4 \uc790\uc6d0 \uad00\ub9ac<\/h2>\n
MySQL \uc131\ub2a5 \uc800\ud558\uc758 \ub610 \ub2e4\ub978 \uc8fc\uc694 \uc6d0\uc778\uc740 \ud558\ub4dc\uc6e8\uc5b4 \uc790\uc6d0\uc758 \ubd80\uc871\uc785\ub2c8\ub2e4. \uc774 \uc139\uc158\uc5d0\uc11c\ub294 \ud558\ub4dc\uc6e8\uc5b4 \uc790\uc6d0\uc744 \ud6a8\uacfc\uc801\uc73c\ub85c \uad00\ub9ac\ud558\ub294 \ubc29\ubc95\uc744 \uc0b4\ud3b4\ubcf4\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n
\uccab \ubc88\uc9f8\ub85c, CPU \uc5c5\uadf8\ub808\uc774\ub4dc<\/strong>\uc785\ub2c8\ub2e4. MySQL\uc740 CPU \uc9d1\uc57d\uc801\uc778 \uc791\uc5c5\uc774 \ub9ce\uae30 \ub54c\ubb38\uc5d0 CPU \uc131\ub2a5\uc774 \uc911\uc694\ud569\ub2c8\ub2e4. CPU\ub97c \uc5c5\uadf8\ub808\uc774\ub4dc\ud558\uba74 \ucffc\ub9ac \ucc98\ub9ac \uc18d\ub3c4\uac00 \ud5a5\uc0c1\ub420 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n
\ub450 \ubc88\uc9f8\ub85c, \uba54\ubaa8\ub9ac \uc99d\uc124<\/strong>\uc785\ub2c8\ub2e4. MySQL\uc740 \uba54\ubaa8\ub9ac\ub97c \ub9ce\uc774 \uc0ac\uc6a9\ud558\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc785\ub2c8\ub2e4. \uba54\ubaa8\ub9ac\ub97c \uc99d\uc124\ud558\uba74 \uce90\uc2dc\ub97c \ub354 \ub9ce\uc774 \uc0ac\uc6a9\ud560 \uc218 \uc788\uc5b4 \uc131\ub2a5\uc774 \ud5a5\uc0c1\ub429\ub2c8\ub2e4. \uc608\ub97c \ub4e4\uc5b4, MySQL\uc758
innodb_buffer_pool_size<\/code> \uc124\uc815\uc744 \uc870\uc815\ud558\uc5ec \uba54\ubaa8\ub9ac\ub97c \ucd5c\uc801\ud654\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\nSET GLOBAL innodb_buffer_pool_size = 2 * 1024 * 1024 * 1024; -- 2GB\ub85c \uc124\uc815<\/code><\/pre>\n\uc138 \ubc88\uc9f8\ub85c, \ub514\uc2a4\ud06c I\/O \ucd5c\uc801\ud654<\/strong>\uc785\ub2c8\ub2e4. SSD\ub97c \uc0ac\uc6a9\ud558\uba74 \ub514\uc2a4\ud06c I\/O \uc18d\ub3c4\uac00 \ud5a5\uc0c1\ub418\uc5b4 MySQL \uc131\ub2a5\uc774 \uac1c\uc120\ub420 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ub610\ud55c RAID \uad6c\uc131\uc744 \ud1b5\ud574 \ub370\uc774\ud130\uc758 \uc548\uc804\uc131\uc744 \ub192\uc774\uace0 \uc131\ub2a5\uc744 \ud5a5\uc0c1\uc2dc\ud0ac \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n
\ud558\ub4dc\uc6e8\uc5b4 \uc790\uc6d0 \uad00\ub9ac\ub294 MySQL \uc131\ub2a5\uc744 \uac1c\uc120\ud558\ub294 \ub370 \uc788\uc5b4 \ub9e4\uc6b0 \uc911\uc694\ud55c \uc694\uc18c\uc785\ub2c8\ub2e4. \uc801\uc808\ud55c \ud558\ub4dc\uc6e8\uc5b4 \uc790\uc6d0 \uad00\ub9ac\ub97c \ud1b5\ud574 \uc131\ub2a5\uc744 \uadf9\ub300\ud654\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n
4. \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc124\uacc4 \ucd5c\uc801\ud654<\/h2>\n
\ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc124\uacc4\ub294 MySQL \uc131\ub2a5\uc5d0 \ud070 \uc601\ud5a5\uc744 \ubbf8\uce69\ub2c8\ub2e4. \uc774 \uc139\uc158\uc5d0\uc11c\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc124\uacc4\ub97c \ucd5c\uc801\ud654\ud558\ub294 \ubc29\ubc95\uc744 \uc0b4\ud3b4\ubcf4\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n
\uccab \ubc88\uc9f8\ub85c, \uc815\uaddc\ud654\uc640 \ube44\uc815\uaddc\ud654\uc758 \uade0\ud615<\/strong>\uc785\ub2c8\ub2e4. \uc815\uaddc\ud654\ub294 \ub370\uc774\ud130 \uc911\ubcf5\uc744 \uc904\uc774\uace0 \ubb34\uacb0\uc131\uc744 \uc720\uc9c0\ud558\ub294 \ub370 \ub3c4\uc6c0\uc774 \ub429\ub2c8\ub2e4. \uadf8\ub7ec\ub098 \uacfc\ub3c4\ud55c \uc815\uaddc\ud654\ub294 \uc870\uc778\uc744 \uc99d\uac00\uc2dc\ucf1c \uc131\ub2a5\uc744 \uc800\ud558\uc2dc\ud0ac \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ub530\ub77c\uc11c \uc801\uc808\ud55c \uc218\uc900\uc758 \ube44\uc815\uaddc\ud654\ub97c \ud1b5\ud574 \uc131\ub2a5\uc744 \uac1c\uc120\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n
\ub450 \ubc88\uc9f8\ub85c, \uc801\uc808\ud55c \ub370\uc774\ud130 \ud0c0\uc785 \uc120\ud0dd<\/strong>\uc785\ub2c8\ub2e4. \ub370\uc774\ud130 \ud0c0\uc785\uc744 \uc801\uc808\ud788 \uc120\ud0dd\ud558\uba74 \uc800\uc7a5 \uacf5\uac04\uc744 \uc808\uc57d\ud558\uace0 \uc131\ub2a5\uc744 \ud5a5\uc0c1\uc2dc\ud0ac \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc608\ub97c \ub4e4\uc5b4, \uc815\uc218\ud615 \ub370\uc774\ud130\ub97c \uc800\uc7a5\ud560 \ub54c
TINYINT<\/code>,SMALLINT<\/code>,INT<\/code>,BIGINT<\/code> \uc911\uc5d0\uc11c \uc801\uc808\ud55c \ud0c0\uc785\uc744 \uc120\ud0dd\ud574\uc57c \ud569\ub2c8\ub2e4.<\/p>\n\uc138 \ubc88\uc9f8\ub85c, \uc778\ub371\uc2a4 \uc124\uacc4<\/strong>\uc785\ub2c8\ub2e4. \uc778\ub371\uc2a4\ub294 \ub370\uc774\ud130 \uac80\uc0c9 \uc18d\ub3c4\ub97c \ud5a5\uc0c1\uc2dc\ud0a4\ub294 \ub370 \uc911\uc694\ud55c \uc5ed\ud560\uc744 \ud569\ub2c8\ub2e4. \uadf8\ub7ec\ub098 \uc778\ub371\uc2a4\uac00 \ub108\ubb34 \ub9ce\uc73c\uba74 \uc4f0\uae30 \uc791\uc5c5\uc774 \ub290\ub824\uc9c8 \uc218 \uc788\uc73c\ubbc0\ub85c \uc801\uc808\ud55c \uc778\ub371\uc2a4\ub97c \uc124\uacc4\ud574\uc57c \ud569\ub2c8\ub2e4.<\/p>\n\ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc124\uacc4 \ucd5c\uc801\ud654\ub294 MySQL \uc131\ub2a5\uc744 \uac1c\uc120\ud558\ub294 \ub370 \uc788\uc5b4 \ub9e4\uc6b0 \uc911\uc694\ud55c \uc694\uc18c\uc785\ub2c8\ub2e4. \uc801\uc808\ud55c \uc124\uacc4\ub97c \ud1b5\ud574 \uc131\ub2a5\uc744 \uadf9\ub300\ud654\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n5. \ub3d9\uc2dc\uc131 \ubb38\uc81c \ud574\uacb0<\/h2>\n\ub3d9\uc2dc\uc131 \ubb38\uc81c\ub294 \uc5ec\ub7ec \uc0ac\uc6a9\uc790\uac00 \ub3d9\uc2dc\uc5d0 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0 \uc811\uadfc\ud560 \ub54c \ubc1c\uc0dd\ud558\ub294 \ubb38\uc81c\uc785\ub2c8\ub2e4. \uc774 \uc139\uc158\uc5d0\uc11c\ub294 \ub3d9\uc2dc\uc131 \ubb38\uc81c\ub97c \ud574\uacb0\ud558\ub294 \ubc29\ubc95\uc744 \uc0b4\ud3b4\ubcf4\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n
\uccab \ubc88\uc9f8\ub85c, \ud2b8\ub79c\uc7ad\uc158 \uad00\ub9ac<\/strong>\uc785\ub2c8\ub2e4. \ud2b8\ub79c\uc7ad\uc158\uc740 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \uc77c\uad00\uc131\uc744 \uc720\uc9c0\ud558\ub294 \ub370 \uc911\uc694\ud55c \uc5ed\ud560\uc744 \ud569\ub2c8\ub2e4. \ud2b8\ub79c\uc7ad\uc158\uc744 \uc801\uc808\ud788 \uad00\ub9ac\ud558\uba74 \ub3d9\uc2dc\uc131 \ubb38\uc81c\ub97c \uc904\uc77c \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n
\ub450 \ubc88\uc9f8\ub85c, \ub77d(Lock) \uad00\ub9ac<\/strong>\uc785\ub2c8\ub2e4. MySQL\uc740 \uc5ec\ub7ec \uc885\ub958\uc758 \ub77d\uc744 \uc9c0\uc6d0\ud569\ub2c8\ub2e4. \uc801\uc808\ud55c \ub77d \uad00\ub9ac\ub97c \ud1b5\ud574 \ub3d9\uc2dc\uc131 \ubb38\uc81c\ub97c \ud574\uacb0\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc608\ub97c \ub4e4\uc5b4,
SELECT ... FOR UPDATE<\/code> \uad6c\ubb38\uc744 \uc0ac\uc6a9\ud558\uc5ec \ud2b9\uc815 \ud589\uc5d0 \ub300\ud55c \ub77d\uc744 \uc124\uc815\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\nSELECT * FROM accounts WHERE id = 1 FOR UPDATE;<\/code><\/pre>\n\uc138 \ubc88\uc9f8\ub85c, \ucffc\ub9ac \ubd84\uc0b0 \ucc98\ub9ac<\/strong>\uc785\ub2c8\ub2e4. \uc5ec\ub7ec \uc11c\ubc84\uc5d0 \ucffc\ub9ac\ub97c \ubd84\uc0b0 \ucc98\ub9ac\ud558\uba74 \ub3d9\uc2dc\uc131 \ubb38\uc81c\ub97c \uc904\uc77c \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc774\ub97c \uc704\ud574 \ub85c\ub4dc \ubc38\ub7f0\uc11c\ub97c \uc0ac\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n
\ub3d9\uc2dc\uc131 \ubb38\uc81c \ud574\uacb0\uc740 MySQL \uc131\ub2a5\uc744 \uac1c\uc120\ud558\ub294 \ub370 \uc788\uc5b4 \ub9e4\uc6b0 \uc911\uc694\ud55c \uc694\uc18c\uc785\ub2c8\ub2e4. \uc801\uc808\ud55c \ub3d9\uc2dc\uc131 \uad00\ub9ac \ubc29\ubc95\uc744 \ud1b5\ud574 \uc131\ub2a5\uc744 \uadf9\ub300\ud654\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n
6. \uc11c\ubc84 \uc124\uc815 \ucd5c\uc801\ud654<\/h2>\n
MySQL \uc11c\ubc84\uc758 \uc124\uc815\uc740 \uc131\ub2a5\uc5d0 \ud070 \uc601\ud5a5\uc744 \ubbf8\uce69\ub2c8\ub2e4. \uc774 \uc139\uc158\uc5d0\uc11c\ub294 \uc11c\ubc84 \uc124\uc815\uc744 \ucd5c\uc801\ud654\ud558\ub294 \ubc29\ubc95\uc744 \uc0b4\ud3b4\ubcf4\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n
\uccab \ubc88\uc9f8\ub85c, \ubc84\ud37c \ud06c\uae30 \uc870\uc815<\/strong>\uc785\ub2c8\ub2e4. MySQL\uc740 \ub2e4\uc591\ud55c \ubc84\ud37c\ub97c \uc0ac\uc6a9\ud558\uc5ec \ub370\uc774\ud130\ub97c \ucc98\ub9ac\ud569\ub2c8\ub2e4. \ubc84\ud37c \ud06c\uae30\ub97c \uc801\uc808\ud788 \uc870\uc815\ud558\uba74 \uc131\ub2a5\uc744 \ud5a5\uc0c1\uc2dc\ud0ac \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc608\ub97c \ub4e4\uc5b4,
innodb_buffer_pool_size<\/code>\uc640 \uac19\uc740 \uc124\uc815\uc744 \uc870\uc815\ud574\uc57c \ud569\ub2c8\ub2e4.<\/p>\n[mysqld]\ninnodb_buffer_pool_size = 1G -- 1GB\ub85c \uc124\uc815\n<\/code><\/pre>\n\ub450 \ubc88\uc9f8\ub85c, \ucffc\ub9ac \uce90\uc2dc \ud65c\uc131\ud654<\/strong>\uc785\ub2c8\ub2e4. \ucffc\ub9ac \uce90\uc2dc\ub294 \ub3d9\uc77c\ud55c \ucffc\ub9ac\uc5d0 \ub300\ud55c \uacb0\uacfc\ub97c \uc800\uc7a5\ud558\uc5ec \uc131\ub2a5\uc744 \ud5a5\uc0c1\uc2dc\ud0b5\ub2c8\ub2e4. \ucffc\ub9ac \uce90\uc2dc\ub97c \ud65c\uc131\ud654\ud558\uba74 \ubc18\ubcf5\uc801\uc778 \ucffc\ub9ac\uc758 \uc131\ub2a5\uc774 \uac1c\uc120\ub420 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n
[mysqld]\nquery_cache_type = 1\nquery_cache_size = 128M -- 128MB\ub85c \uc124\uc815\n<\/code><\/pre>\n\uc138 \ubc88\uc9f8\ub85c, \ub85c\uadf8 \uc124\uc815 \uc870\uc815<\/strong>\uc785\ub2c8\ub2e4. MySQL\uc740 \ub2e4\uc591\ud55c \ub85c\uadf8\ub97c \uc0dd\uc131\ud569\ub2c8\ub2e4. \ub85c\uadf8 \uc124\uc815\uc744 \uc870\uc815\ud558\uc5ec \ubd88\ud544\uc694\ud55c \ub85c\uadf8 \uc0dd\uc131\uc744 \uc904\uc774\uba74 \uc131\ub2a5\uc774 \ud5a5\uc0c1\ub420 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n
\uc11c\ubc84 \uc124\uc815 \ucd5c\uc801\ud654\ub294 MySQL \uc131\ub2a5\uc744 \uac1c\uc120\ud558\ub294 \ub370 \uc788\uc5b4 \ub9e4\uc6b0 \uc911\uc694\ud55c \uc694\uc18c\uc785\ub2c8\ub2e4. \uc801\uc808\ud55c \uc124\uc815\uc744 \ud1b5\ud574 \uc131\ub2a5\uc744 \uadf9\ub300\ud654\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n
7. \ubaa8\ub2c8\ud130\ub9c1 \ubc0f \ud29c\ub2dd<\/h2>\n
MySQL \uc131\ub2a5\uc744 \uc9c0\uc18d\uc801\uc73c\ub85c \ubaa8\ub2c8\ud130\ub9c1\ud558\uace0 \ud29c\ub2dd\ud558\ub294 \uac83\uc740 \ub9e4\uc6b0 \uc911\uc694\ud569\ub2c8\ub2e4. \uc774 \uc139\uc158\uc5d0\uc11c\ub294 \ubaa8\ub2c8\ud130\ub9c1 \ubc0f \ud29c\ub2dd \ubc29\ubc95\uc744 \uc0b4\ud3b4\ubcf4\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n
\uccab \ubc88\uc9f8\ub85c, \uc131\ub2a5 \uc2a4\ud0a4\ub9c8 \ud65c\uc6a9<\/strong>\uc785\ub2c8\ub2e4. MySQL\uc758 \uc131\ub2a5 \uc2a4\ud0a4\ub9c8\ub294 \ub2e4\uc591\ud55c \uc131\ub2a5 \uad00\ub828 \uc815\ubcf4\ub97c \uc81c\uacf5\ud569\ub2c8\ub2e4. \uc774\ub97c \ud65c\uc6a9\ud558\uc5ec \ucffc\ub9ac \uc131\ub2a5\uc744 \ubd84\uc11d\ud558\uace0 \ud29c\ub2dd\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n
\ub450 \ubc88\uc9f8\ub85c, EXPLAIN \uba85\ub839\uc5b4 \uc0ac\uc6a9<\/strong>\uc785\ub2c8\ub2e4. EXPLAIN \uba85\ub839\uc5b4\ub97c \uc0ac\uc6a9\ud558\uba74 \ucffc\ub9ac \uc2e4\ud589 \uacc4\ud68d\uc744 \ud655\uc778\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc774\ub97c \ud1b5\ud574 \ucffc\ub9ac\ub97c \ucd5c\uc801\ud654\ud560 \uc218 \uc788\ub294 \uae30\ud68c\ub97c \ucc3e\uc744 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n
EXPLAIN SELECT * FROM users WHERE last_name = 'Kim';<\/code><\/pre>\n\uc138 \ubc88\uc9f8\ub85c, \ubaa8\ub2c8\ud130\ub9c1 \ub3c4\uad6c \ud65c\uc6a9<\/strong>\uc785\ub2c8\ub2e4. \ub2e4\uc591\ud55c \ubaa8\ub2c8\ud130\ub9c1 \ub3c4\uad6c\ub97c \uc0ac\uc6a9\ud558\uc5ec MySQL \uc131\ub2a5\uc744 \ubaa8\ub2c8\ud130\ub9c1\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc608\ub97c \ub4e4\uc5b4, Percona Monitoring and Management(PMM)\uc640 \uac19\uc740 \ub3c4\uad6c\ub97c \uc0ac\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n
\ubaa8\ub2c8\ud130\ub9c1 \ubc0f \ud29c\ub2dd\uc740 MySQL \uc131\ub2a5\uc744 \uc9c0\uc18d\uc801\uc73c\ub85c \uac1c\uc120\ud558\ub294 \ub370 \uc788\uc5b4 \ub9e4\uc6b0 \uc911\uc694\ud55c \uc694\uc18c\uc785\ub2c8\ub2e4. \uc815\uae30\uc801\uc778 \ubaa8\ub2c8\ud130\ub9c1\uacfc \ud29c\ub2dd\uc744 \ud1b5\ud574 \uc131\ub2a5\uc744 \uadf9\ub300\ud654\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n
8. \uacb0\ub860 \ubc0f \uc694\uc57d<\/h2>\n
MySQL \uc131\ub2a5 \uc800\ud558\ub294 \ub2e4\uc591\ud55c \uc6d0\uc778\uc73c\ub85c \uc778\ud574 \ubc1c\uc0dd\ud560 \uc218 \uc788\uc73c\uba70, \uc774\ub97c \ud574\uacb0\ud558\uae30 \uc704\ud55c \uc5ec\ub7ec \uac00\uc9c0 \ubc29\ubc95\uc774 \uc874\uc7ac\ud569\ub2c8\ub2e4. \ubcf8 \uae00\uc5d0\uc11c\ub294 \ucffc\ub9ac \ucd5c\uc801\ud654, \ud558\ub4dc\uc6e8\uc5b4 \uc790\uc6d0 \uad00\ub9ac, \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc124\uacc4 \ucd5c\uc801\ud654, \ub3d9\uc2dc\uc131 \ubb38\uc81c \ud574\uacb0, \uc11c\ubc84 \uc124\uc815 \ucd5c\uc801\ud654, \ubaa8\ub2c8\ud130\ub9c1 \ubc0f \ud29c\ub2dd \ub4f1 \ub2e4\uc591\ud55c \uce21\uba74\uc5d0\uc11c MySQL \uc131\ub2a5 \uac1c\uc120 \ubc29\uc548\uc744 \ub2e4\ub8e8\uc5c8\uc2b5\ub2c8\ub2e4.<\/p>\n
MySQL\uc758 \uc131\ub2a5\uc744 \uac1c\uc120\ud558\uae30 \uc704\ud574\uc11c\ub294 \ub2e4\uc74c\uacfc \uac19\uc740 \uc810\ub4e4\uc744 \uc720\ub150\ud574\uc57c \ud569\ub2c8\ub2e4:<\/p>\n
- \n
- \ucffc\ub9ac \ucd5c\uc801\ud654:<\/strong> \uc778\ub371\uc2a4 \ud65c\uc6a9 \ubc0f \ubd88\ud544\uc694\ud55c \ub370\uc774\ud130 \uc120\ud0dd \ud53c\ud558\uae30<\/li>\n
- \ud558\ub4dc\uc6e8\uc5b4 \uc790\uc6d0 \uad00\ub9ac:<\/strong> CPU \ubc0f \uba54\ubaa8\ub9ac \uc5c5\uadf8\ub808\uc774\ub4dc<\/li>\n
- \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc124\uacc4:<\/strong> \uc815\uaddc\ud654\uc640 \ube44\uc815\uaddc\ud654\uc758 \uade0\ud615 \uc720\uc9c0<\/li>\n
- \ub3d9\uc2dc\uc131 \ubb38\uc81c \ud574\uacb0:<\/strong> \ud2b8\ub79c\uc7ad\uc158 \ubc0f \ub77d \uad00\ub9ac<\/li>\n
- \uc11c\ubc84 \uc124\uc815 \ucd5c\uc801\ud654:<\/strong> \ubc84\ud37c \ud06c\uae30 \ubc0f \ucffc\ub9ac \uce90\uc2dc \uc870\uc815<\/li>\n
- \ubaa8\ub2c8\ud130\ub9c1 \ubc0f \ud29c\ub2dd:<\/strong> \uc131\ub2a5 \uc2a4\ud0a4\ub9c8 \ubc0f EXPLAIN \uba85\ub839\uc5b4 \ud65c\uc6a9<\/li>\n<\/ul>\n
MySQL \uc131\ub2a5 \uac1c\uc120\uc740 \uc9c0\uc18d\uc801\uc778 \ub178\ub825\uacfc \uad00\ub9ac\uac00 \ud544\uc694\ud55c \uacfc\uc815\uc785\ub2c8\ub2e4. \uc704\uc5d0\uc11c \uc5b8\uae09\ud55c \ubc29\ubc95\ub4e4\uc744 \ud1b5\ud574 MySQL\uc758 \uc131\ub2a5\uc744 \uadf9\ub300\ud654\ud558\uace0 \ube44\uc988\ub2c8\uc2a4\uc758 \uc131\uacf5\uc5d0 \uae30\uc5ec\ud560 \uc218 \uc788\uae30\ub97c \ubc14\ub78d\ub2c8\ub2e4.<\/p>\n","protected":false},"excerpt":{"rendered":"
\ubaa9\ucc28 MySQL \uc131\ub2a5 \uc800\ud558\uc758 \uc6d0\uc778\uacfc \ud6a8\uacfc\uc801\uc778 \ud574\uacb0 \ubc29\uc548 1. MySQL \uc131\ub2a5 \uc800\ud558\uc758 \uc77c\ubc18\uc801\uc778 \uc6d0\uc778 2. […]<\/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":[2351,2208,2100],"class_list":["post-51564","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-development","tag-management","tag-monitoring","tag-mysql"],"acf":[],"_links":{"self":[{"href":"https:\/\/m9js.shop\/blog\/wp-json\/wp\/v2\/posts\/51564","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=51564"}],"version-history":[{"count":0,"href":"https:\/\/m9js.shop\/blog\/wp-json\/wp\/v2\/posts\/51564\/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=51564"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/m9js.shop\/blog\/wp-json\/wp\/v2\/categories?post=51564"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/m9js.shop\/blog\/wp-json\/wp\/v2\/tags?post=51564"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}