{"id":51625,"date":"2024-08-15T02:46:43","date_gmt":"2024-08-14T17:46:43","guid":{"rendered":"https:\/\/m9js.shop\/blog\/development\/memory-problems-and-solutions-in-mysql-server"},"modified":"2024-08-15T02:46:43","modified_gmt":"2024-08-14T17:46:43","slug":"memory-problems-and-solutions-in-mysql-server","status":"publish","type":"post","link":"https:\/\/m9js.shop\/blog\/development\/memory-problems-and-solutions-in-mysql-server","title":{"rendered":"MySQL \uc11c\ubc84\uc758 \uba54\ubaa8\ub9ac \ubb38\uc81c\uc640 \ud574\uacb0 \ubc29\uc548"},"content":{"rendered":"

\ubaa9\ucc28<\/h2>\n

8. \uacb0\ub860 \ubc0f \uc694\uc57d<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n

MySQL \uc11c\ubc84\uc758 \uba54\ubaa8\ub9ac \ubb38\uc81c\uc640 \ud574\uacb0 \ubc29\uc548<\/h1>\n
MySQL\uc740 \uc138\uacc4\uc5d0\uc11c \uac00\uc7a5 \ub110\ub9ac \uc0ac\uc6a9\ub418\ub294 \uc624\ud508 \uc18c\uc2a4 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uad00\ub9ac \uc2dc\uc2a4\ud15c \uc911 \ud558\ub098\uc785\ub2c8\ub2e4. \uadf8\ub7ec\ub098 \ub9ce\uc740 \uc0ac\uc6a9\uc790\ub4e4\uc774 MySQL \uc11c\ubc84\ub97c \uc6b4\uc601\ud558\uba74\uc11c \uba54\ubaa8\ub9ac \ubb38\uc81c\uc5d0 \uc9c1\uba74\ud558\uac8c \ub429\ub2c8\ub2e4. \uc774\ub7ec\ud55c \ubb38\uc81c\ub294 \uc131\ub2a5 \uc800\ud558, \ub370\uc774\ud130 \uc190\uc2e4, \uc2dc\uc2a4\ud15c \ub2e4\uc6b4\ud0c0\uc784 \ub4f1 \uc5ec\ub7ec \uac00\uc9c0 \uc2ec\uac01\ud55c \uacb0\uacfc\ub97c \ucd08\ub798\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ubcf8 \uae00\uc5d0\uc11c\ub294 MySQL \uc11c\ubc84\uc758 \uba54\ubaa8\ub9ac \ubb38\uc81c\ub97c \uc9c4\ub2e8\ud558\uace0, \uc774\ub97c \ud574\uacb0\ud558\uae30 \uc704\ud55c \ub2e4\uc591\ud55c \ubc29\uc548\uc744 \uc81c\uc2dc\ud558\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n

1. MySQL \uba54\ubaa8\ub9ac \uad6c\uc870 \uc774\ud574\ud558\uae30<\/h2>\n

MySQL \uc11c\ubc84\ub294 \uc5ec\ub7ec \uac00\uc9c0 \uba54\ubaa8\ub9ac \uad6c\uc870\ub97c \uac00\uc9c0\uace0 \uc788\uc73c\uba70, \uc774\ub97c \uc774\ud574\ud558\ub294 \uac83\uc740 \uba54\ubaa8\ub9ac \ubb38\uc81c\ub97c \ud574\uacb0\ud558\ub294 \ub370 \ud544\uc218\uc801\uc785\ub2c8\ub2e4. MySQL\uc758 \uba54\ubaa8\ub9ac \uad6c\uc870\ub294 \ud06c\uac8c \ub2e4\uc74c\uacfc \uac19\uc740 \uc694\uc18c\ub85c \ub098\ub20c \uc218 \uc788\uc2b5\ub2c8\ub2e4:<\/p>\n

\ubc84\ud37c \ud480(Buffer Pool)<\/li>\n
\ucffc\ub9ac \uce90\uc2dc(Query Cache)<\/li>\n
\uc815\ub82c \ubc84\ud37c(Sort Buffer)<\/li>\n
\uc870\uc778 \ubc84\ud37c(Join Buffer)<\/li>\n

\uc2a4\ub808\ub4dc \uc2a4\ud0dd(Thread Stack)<\/li>\n<\/ul>\n

\uac01 \uc694\uc18c\ub294 MySQL\uc758 \uc131\ub2a5\uc5d0 \uc911\uc694\ud55c \uc5ed\ud560\uc744 \ud558\uba70, \uc801\uc808\ud55c \uc124\uc815\uc774 \ud544\uc694\ud569\ub2c8\ub2e4. \uc608\ub97c \ub4e4\uc5b4, \ubc84\ud37c \ud480\uc740 InnoDB \uc2a4\ud1a0\ub9ac\uc9c0 \uc5d4\uc9c4\uc5d0\uc11c \ub370\uc774\ud130\ub97c \uce90\uc2dc\ud558\ub294 \ub370 \uc0ac\uc6a9\ub418\uba70, \uc774 \ud06c\uae30\uac00 \ub108\ubb34 \uc791\uc73c\uba74 \ub514\uc2a4\ud06c I\/O\uac00 \uc99d\uac00\ud558\uc5ec \uc131\ub2a5\uc774 \uc800\ud558\ub420 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n

\ub610\ud55c, \ucffc\ub9ac \uce90\uc2dc\ub294 \uc790\uc8fc \uc2e4\ud589\ub418\ub294 \ucffc\ub9ac\uc758 \uacb0\uacfc\ub97c \uba54\ubaa8\ub9ac\uc5d0 \uc800\uc7a5\ud558\uc5ec \uc131\ub2a5\uc744 \ud5a5\uc0c1\uc2dc\ud0a4\ub294 \uc5ed\ud560\uc744 \ud569\ub2c8\ub2e4. \uadf8\ub7ec\ub098 \ucffc\ub9ac \uce90\uc2dc\uac00 \ube44\ud6a8\uc728\uc801\uc73c\ub85c \uc124\uc815\ub418\uba74 \uc624\ud788\ub824 \uc131\ub2a5\uc744 \uc800\ud558\uc2dc\ud0ac \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n

\uc774\ub7ec\ud55c \uba54\ubaa8\ub9ac \uad6c\uc870\ub97c \uc774\ud574\ud558\uace0 \uc801\uc808\ud788 \uc870\uc815\ud558\ub294 \uac83\uc774 MySQL \uc11c\ubc84\uc758 \uc131\ub2a5\uc744 \uadf9\ub300\ud654\ud558\ub294 \uccab\uac78\uc74c\uc785\ub2c8\ub2e4.<\/p>\n

2. \uba54\ubaa8\ub9ac \ubb38\uc81c\uc758 \uc6d0\uc778 \ubd84\uc11d<\/h2>\n

MySQL \uc11c\ubc84\uc5d0\uc11c \ubc1c\uc0dd\ud558\ub294 \uba54\ubaa8\ub9ac \ubb38\uc81c\ub294 \uc5ec\ub7ec \uac00\uc9c0 \uc6d0\uc778\uc5d0 \uc758\ud574 \ubc1c\uc0dd\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc77c\ubc18\uc801\uc778 \uc6d0\uc778\uc740 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4:<\/p>\n

\ubd80\uc801\uc808\ud55c \uc124\uc815<\/li>\n
\uacfc\ub3c4\ud55c \ub3d9\uc2dc \uc5f0\uacb0<\/li>\n
\ube44\ud6a8\uc728\uc801\uc778 \ucffc\ub9ac<\/li>\n
\uba54\ubaa8\ub9ac \ub204\uc218<\/li>\n

\ud558\ub4dc\uc6e8\uc5b4 \ud55c\uacc4<\/li>\n<\/ul>\n

\ubd80\uc801\uc808\ud55c \uc124\uc815\uc740 MySQL \uc11c\ubc84\uc758 \uc131\ub2a5\uc744 \uc800\ud558\uc2dc\ud0ac \uc218 \uc788\ub294 \uac00\uc7a5 \ud754\ud55c \uc6d0\uc778 \uc911 \ud558\ub098\uc785\ub2c8\ub2e4. \uc608\ub97c \ub4e4\uc5b4, \ubc84\ud37c \ud480 \ud06c\uae30\uac00 \ub108\ubb34 \uc791\uc73c\uba74 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \uc131\ub2a5\uc774 \uc800\ud558\ub420 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ub610\ud55c, \uacfc\ub3c4\ud55c \ub3d9\uc2dc \uc5f0\uacb0\uc740 \uc11c\ubc84\uc758 \uba54\ubaa8\ub9ac\ub97c \uc18c\ubaa8\ud558\uc5ec \uc131\ub2a5 \uc800\ud558\ub97c \ucd08\ub798\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n

\ube44\ud6a8\uc728\uc801\uc778 \ucffc\ub9ac\ub294 \uc11c\ubc84\uc758 \ub9ac\uc18c\uc2a4\ub97c \ub0ad\ube44\ud558\uac8c \ub9cc\ub4e4\uba70, \uc774\ub294 \uba54\ubaa8\ub9ac \ubb38\uc81c\ub85c \uc774\uc5b4\uc9c8 \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 \ub9ce\uc740 \uba54\ubaa8\ub9ac\ub97c \uc18c\ubaa8\ud558\uac8c \ub429\ub2c8\ub2e4.<\/p>\n

\uba54\ubaa8\ub9ac \ub204\uc218\ub294 \uc18c\ud504\ud2b8\uc6e8\uc5b4 \ubc84\uadf8\ub098 \uc798\ubabb\ub41c \uc124\uc815\uc73c\ub85c \uc778\ud574 \ubc1c\uc0dd\ud560 \uc218 \uc788\uc73c\uba70, \uc774\ub294 \uc2dc\uac04\uc774 \uc9c0\ub0a8\uc5d0 \ub530\ub77c \uc11c\ubc84\uc758 \uba54\ubaa8\ub9ac\ub97c \uace0\uac08\uc2dc\ud0ac \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ub9c8\uc9c0\ub9c9\uc73c\ub85c, \ud558\ub4dc\uc6e8\uc5b4 \ud55c\uacc4\ub294 \uc11c\ubc84\uac00 \ucc98\ub9ac\ud560 \uc218 \uc788\ub294 \ucd5c\ub300 \uba54\ubaa8\ub9ac \uc6a9\ub7c9\uc744 \ucd08\uacfc\ud560 \ub54c \ubc1c\uc0dd\ud569\ub2c8\ub2e4.<\/p>\n

3. MySQL \uba54\ubaa8\ub9ac \ubb38\uc81c \uc9c4\ub2e8\ud558\uae30<\/h2>\n

\uba54\ubaa8\ub9ac \ubb38\uc81c\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. MySQL\uc758 \uc131\ub2a5 \uc2a4\ud0a4\ub9c8(Performance Schema)\uc640 \uc815\ubcf4 \uc2a4\ud0a4\ub9c8(Information Schema)\ub294 \uc720\uc6a9\ud55c \uc815\ubcf4\ub97c \uc81c\uacf5\ud569\ub2c8\ub2e4. \ub2e4\uc74c\uc740 \uba54\ubaa8\ub9ac \ubb38\uc81c\ub97c \uc9c4\ub2e8\ud558\ub294 \ub370 \uc720\uc6a9\ud55c \uba87 \uac00\uc9c0 \ucffc\ub9ac\uc785\ub2c8\ub2e4:<\/p>\n

SHOW STATUS LIKE 'Threads_connected';\nSHOW STATUS LIKE 'Threads_running';\nSHOW VARIABLES LIKE 'innodb_buffer_pool_size';\nSHOW VARIABLES LIKE 'query_cache_size';<\/code><\/pre>\n\uc704 \ucffc\ub9ac\ub97c \ud1b5\ud574 \ud604\uc7ac \uc5f0\uacb0\ub41c \uc2a4\ub808\ub4dc \uc218, \uc2e4\ud589 \uc911\uc778 \uc2a4\ub808\ub4dc \uc218, InnoDB \ubc84\ud37c \ud480 \ud06c\uae30, \ucffc\ub9ac \uce90\uc2dc \ud06c\uae30 \ub4f1\uc744 \ud655\uc778\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc774\ub7ec\ud55c \uc815\ubcf4\ub97c \ubc14\ud0d5\uc73c\ub85c \uba54\ubaa8\ub9ac \ubb38\uc81c\uc758 \uc6d0\uc778\uc744 \ud30c\uc545\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n
\ub610\ud55c, MySQL\uc758 \ub85c\uadf8 \ud30c\uc77c\uc744 \ubd84\uc11d\ud558\ub294 \uac83\ub3c4 \uc911\uc694\ud569\ub2c8\ub2e4. \uc5d0\ub7ec \ub85c\uadf8\uc640 \uc77c\ubc18 \ucffc\ub9ac \ub85c\uadf8\ub97c \ud1b5\ud574 \uc5b4\ub5a4 \ucffc\ub9ac\uac00 \ubb38\uc81c\ub97c \uc77c\uc73c\ud0a4\uace0 \uc788\ub294\uc9c0 \ud655\uc778\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc774\ub97c \ud1b5\ud574 \ud2b9\uc815 \ucffc\ub9ac\ub97c \ucd5c\uc801\ud654\ud558\uac70\ub098 \uc778\ub371\uc2a4\ub97c \ucd94\uac00\ud558\ub294 \ub4f1\uc758 \uc870\uce58\ub97c \ucde8\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n
4. MySQL \uba54\ubaa8\ub9ac \ucd5c\uc801\ud654 \uae30\ubc95<\/h2>\n\uba54\ubaa8\ub9ac \ubb38\uc81c\ub97c \ud574\uacb0\ud558\uae30 \uc704\ud574\uc11c\ub294 MySQL \uc11c\ubc84\uc758 \uc124\uc815\uc744 \ucd5c\uc801\ud654\ud574\uc57c \ud569\ub2c8\ub2e4. \ub2e4\uc74c\uc740 \uba54\ubaa8\ub9ac \ucd5c\uc801\ud654\ub97c \uc704\ud55c \uba87 \uac00\uc9c0 \uae30\ubc95\uc785\ub2c8\ub2e4:<\/p>\n
\n\ubc84\ud37c \ud480 \ud06c\uae30 \uc870\uc815<\/li>\n
\ucffc\ub9ac \uce90\uc2dc \uc124\uc815<\/li>\n
\uc815\ub82c \ubc84\ud37c \ud06c\uae30 \uc870\uc815<\/li>\n
\uc870\uc778 \ubc84\ud37c \ud06c\uae30 \uc870\uc815<\/li>\n
\uc2a4\ub808\ub4dc \uc2a4\ud0dd \ud06c\uae30 \uc870\uc815<\/li>\n<\/ul>\n\ubc84\ud37c \ud480 \ud06c\uae30\ub97c \uc870\uc815\ud558\ub294 \uac83\uc740 InnoDB \uc2a4\ud1a0\ub9ac\uc9c0 \uc5d4\uc9c4\uc744 \uc0ac\uc6a9\ud558\ub294 \uacbd\uc6b0 \ub9e4\uc6b0 \uc911\uc694\ud569\ub2c8\ub2e4. \uc77c\ubc18\uc801\uc73c\ub85c \ubc84\ud37c \ud480 \ud06c\uae30\ub294 \uc11c\ubc84\uc758 \ucd1d \uba54\ubaa8\ub9ac\uc758 70-80%\ub85c \uc124\uc815\ud558\ub294 \uac83\uc774 \uc88b\uc2b5\ub2c8\ub2e4. \uc774\ub97c \ud1b5\ud574 \ub514\uc2a4\ud06c I\/O\ub97c \ucd5c\uc18c\ud654\ud558\uace0 \uc131\ub2a5\uc744 \ud5a5\uc0c1\uc2dc\ud0ac \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n
\ucffc\ub9ac \uce90\uc2dc \uc124\uc815\ub3c4 \uc911\uc694\ud569\ub2c8\ub2e4. \ucffc\ub9ac \uce90\uc2dc\ub294 \uc790\uc8fc \uc2e4\ud589\ub418\ub294 \ucffc\ub9ac\uc758 \uacb0\uacfc\ub97c \uc800\uc7a5\ud558\uc5ec \uc131\ub2a5\uc744 \ud5a5\uc0c1\uc2dc\ud0a4\uc9c0\ub9cc, \ube44\ud6a8\uc728\uc801\uc73c\ub85c \uc124\uc815\ub418\uba74 \uc624\ud788\ub824 \uc131\ub2a5\uc744 \uc800\ud558\uc2dc\ud0ac \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ub530\ub77c\uc11c \ucffc\ub9ac \uce90\uc2dc\ub97c \uc0ac\uc6a9\ud560\uc9c0 \uc5ec\ubd80\uc640 \uadf8 \ud06c\uae30\ub97c \uc2e0\uc911\ud558\uac8c \uacb0\uc815\ud574\uc57c \ud569\ub2c8\ub2e4.<\/p>\n
\uc815\ub82c \ubc84\ud37c\uc640 \uc870\uc778 \ubc84\ud37c\uc758 \ud06c\uae30\ub3c4 \uc870\uc815\ud574\uc57c \ud569\ub2c8\ub2e4. \uc774 \ub450 \ubc84\ud37c\ub294 \ub300\ub7c9\uc758 \ub370\uc774\ud130\ub97c \uc815\ub82c\ud558\uac70\ub098 \uc870\uc778\ud560 \ub54c \uc0ac\uc6a9\ub418\uba70, \ud06c\uae30\uac00 \ub108\ubb34 \uc791\uc73c\uba74 \uc131\ub2a5\uc774 \uc800\ud558\ub420 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ub530\ub77c\uc11c \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \ud2b9\uc131\uc5d0 \ub9de\uac8c \uc801\uc808\ud55c \ud06c\uae30\ub85c \uc124\uc815\ud574\uc57c \ud569\ub2c8\ub2e4.<\/p>\n
5. \ucffc\ub9ac \ucd5c\uc801\ud654 \ubc0f \uc778\ub371\uc2a4 \ud65c\uc6a9<\/h2>\n\uba54\ubaa8\ub9ac \ubb38\uc81c\ub97c \ud574\uacb0\ud558\uae30 \uc704\ud574\uc11c\ub294 \ucffc\ub9ac\ub97c \ucd5c\uc801\ud654\ud558\ub294 \uac83\ub3c4 \uc911\uc694\ud569\ub2c8\ub2e4. \ube44\ud6a8\uc728\uc801\uc778 \ucffc\ub9ac\ub294 \uc11c\ubc84\uc758 \ub9ac\uc18c\uc2a4\ub97c \ub0ad\ube44\ud558\uac8c \ub9cc\ub4e4\uba70, \uc774\ub294 \uba54\ubaa8\ub9ac \ubb38\uc81c\ub85c \uc774\uc5b4\uc9c8 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ub2e4\uc74c\uc740 \ucffc\ub9ac\ub97c \ucd5c\uc801\ud654\ud558\uae30 \uc704\ud55c \uba87 \uac00\uc9c0 \ubc29\ubc95\uc785\ub2c8\ub2e4:<\/p>\n
\n\uc778\ub371\uc2a4 \uc0ac\uc6a9<\/li>\n
\uc11c\ube0c\ucffc\ub9ac \ub300\uc2e0 \uc870\uc778 \uc0ac\uc6a9<\/li>\n
\ud544\uc694\ud55c \uc5f4\ub9cc \uc120\ud0dd<\/li>\n
GROUP BY\uc640 ORDER BY \ucd5c\uc801\ud654<\/li>\n
EXPLAIN \uba85\ub839\uc5b4 \uc0ac\uc6a9<\/li>\n<\/ul>\n\uc778\ub371\uc2a4\ub97c \uc0ac\uc6a9\ud558\uba74 \ub370\uc774\ud130 \uac80\uc0c9 \uc18d\ub3c4\ub97c \ud06c\uac8c \ud5a5\uc0c1\uc2dc\ud0ac \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc778\ub371\uc2a4\uac00 \uc5c6\ub294 \ud14c\uc774\ube14\uc5d0\uc11c \ub300\ub7c9\uc758 \ub370\uc774\ud130\ub97c \uac80\uc0c9\ud558\ub294 \uac83\uc740 \ub9ce\uc740 \uba54\ubaa8\ub9ac\ub97c \uc18c\ubaa8\ud558\uac8c \ub429\ub2c8\ub2e4. \ub530\ub77c\uc11c \uc790\uc8fc \uc870\ud68c\ub418\ub294 \uc5f4\uc5d0 \uc778\ub371\uc2a4\ub97c \ucd94\uac00\ud558\ub294 \uac83\uc774 \uc88b\uc2b5\ub2c8\ub2e4.<\/p>\n
\uc11c\ube0c\ucffc\ub9ac \ub300\uc2e0 \uc870\uc778\uc744 \uc0ac\uc6a9\ud558\ub294 \uac83\ub3c4 \uc131\ub2a5\uc744 \ud5a5\uc0c1\uc2dc\ud0a4\ub294 \ubc29\ubc95 \uc911 \ud558\ub098\uc785\ub2c8\ub2e4. \uc11c\ube0c\ucffc\ub9ac\ub294 \uc885\uc885 \ube44\ud6a8\uc728\uc801\uc774\uba70, \uc870\uc778\uc744 \uc0ac\uc6a9\ud558\uba74 \ub354 \ub098\uc740 \uc131\ub2a5\uc744 \uc5bb\uc744 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n
\ud544\uc694\ud55c \uc5f4\ub9cc \uc120\ud0dd\ud558\ub294 \uac83\ub3c4 \uc911\uc694\ud569\ub2c8\ub2e4. SELECT * \ub300\uc2e0 \ud544\uc694\ud55c \uc5f4\ub9cc \uc120\ud0dd\ud558\uba74 \ubd88\ud544\uc694\ud55c \ub370\uc774\ud130 \uc804\uc1a1\uc744 \uc904\uc77c \uc218 \uc788\uc5b4 \uba54\ubaa8\ub9ac\ub97c \uc808\uc57d\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n
6. \ud558\ub4dc\uc6e8\uc5b4 \uc5c5\uadf8\ub808\uc774\ub4dc \uace0\ub824\ud558\uae30<\/h2>\nMySQL \uc11c\ubc84\uc758 \uba54\ubaa8\ub9ac \ubb38\uc81c\uac00 \ud558\ub4dc\uc6e8\uc5b4 \ud55c\uacc4\ub85c \uc778\ud574 \ubc1c\uc0dd\ud558\ub294 \uacbd\uc6b0, \ud558\ub4dc\uc6e8\uc5b4 \uc5c5\uadf8\ub808\uc774\ub4dc\ub97c \uace0\ub824\ud574\uc57c \ud569\ub2c8\ub2e4. \ub2e4\uc74c\uc740 \ud558\ub4dc\uc6e8\uc5b4 \uc5c5\uadf8\ub808\uc774\ub4dc\ub97c \ud1b5\ud574 \uc131\ub2a5\uc744 \ud5a5\uc0c1\uc2dc\ud0ac \uc218 \uc788\ub294 \uba87 \uac00\uc9c0 \ubc29\ubc95\uc785\ub2c8\ub2e4:<\/p>\n
\nRAM \ucd94\uac00<\/li>\n
SSD\ub85c \uc804\ud658<\/li>\n
CPU \uc5c5\uadf8\ub808\uc774\ub4dc<\/li>\n
\ub124\ud2b8\uc6cc\ud06c \uc18d\ub3c4 \ud5a5\uc0c1<\/li>\n
\uc11c\ubc84 \ud074\ub7ec\uc2a4\ud130\ub9c1<\/li>\n<\/ul>\nRAM\uc744 \ucd94\uac00\ud558\uba74 MySQL \uc11c\ubc84\uac00 \ub354 \ub9ce\uc740 \ub370\uc774\ud130\ub97c \uba54\ubaa8\ub9ac\uc5d0 \uc800\uc7a5\ud560 \uc218 \uc788\uc5b4 \uc131\ub2a5\uc774 \ud5a5\uc0c1\ub429\ub2c8\ub2e4. \ub610\ud55c, SSD\ub85c \uc804\ud658\ud558\uba74 \ub514\uc2a4\ud06c I\/O \uc18d\ub3c4\uac00 \ud06c\uac8c \ud5a5\uc0c1\ub418\uc5b4 \uc804\uccb4\uc801\uc778 \uc131\ub2a5\uc774 \uac1c\uc120\ub429\ub2c8\ub2e4.<\/p>\n
CPU \uc5c5\uadf8\ub808\uc774\ub4dc\ub294 \ucffc\ub9ac \ucc98\ub9ac \uc18d\ub3c4\ub97c \ud5a5\uc0c1\uc2dc\ud0a4\uba70, \ub124\ud2b8\uc6cc\ud06c \uc18d\ub3c4\ub97c \ud5a5\uc0c1\uc2dc\ud0a4\uba74 \ub370\uc774\ud130 \uc804\uc1a1 \uc18d\ub3c4\uac00 \ube68\ub77c\uc838 \uc131\ub2a5\uc774 \uac1c\uc120\ub429\ub2c8\ub2e4. \ub9c8\uc9c0\ub9c9\uc73c\ub85c, \uc11c\ubc84 \ud074\ub7ec\uc2a4\ud130\ub9c1\uc744 \ud1b5\ud574 \ubd80\ud558 \ubd84\uc0b0\uc744 \ud560 \uc218 \uc788\uc5b4 \uc131\ub2a5\uc744 \ub354\uc6b1 \ud5a5\uc0c1\uc2dc\ud0ac \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n
7. \ubaa8\ub2c8\ud130\ub9c1 \ubc0f \uc720\uc9c0\ubcf4\uc218 \uc804\ub7b5<\/h2>\nMySQL \uc11c\ubc84\uc758 \uba54\ubaa8\ub9ac \ubb38\uc81c\ub97c \uc608\ubc29\ud558\uae30 \uc704\ud574\uc11c\ub294 \uc815\uae30\uc801\uc778 \ubaa8\ub2c8\ud130\ub9c1\uacfc \uc720\uc9c0\ubcf4\uc218\uac00 \ud544\uc694\ud569\ub2c8\ub2e4. \ub2e4\uc74c\uc740 \ud6a8\uacfc\uc801\uc778 \ubaa8\ub2c8\ud130\ub9c1 \ubc0f \uc720\uc9c0\ubcf4\uc218 \uc804\ub7b5\uc785\ub2c8\ub2e4:<\/p>\n
\n\uc131\ub2a5 \ubaa8\ub2c8\ud130\ub9c1 \ub3c4\uad6c \uc0ac\uc6a9<\/li>\n
\uc815\uae30\uc801\uc778 \ubc31\uc5c5 \uc218\ud589<\/li>\n
\ub85c\uadf8 \ud30c\uc77c \ubd84\uc11d<\/li>\n
\uc815\uae30\uc801\uc778 \uc5c5\ub370\uc774\ud2b8 \ubc0f \ud328\uce58 \uc801\uc6a9<\/li>\n
\uc0ac\uc6a9\uc790 \uad50\uc721 \ubc0f \ubb38\uc11c\ud654<\/li>\n<\/ul>\n\uc131\ub2a5 \ubaa8\ub2c8\ud130\ub9c1 \ub3c4\uad6c\ub97c \uc0ac\uc6a9\ud558\uba74 \uc11c\ubc84\uc758 \uc0c1\ud0dc\ub97c \uc2e4\uc2dc\uac04\uc73c\ub85c \ud655\uc778\ud560 \uc218 \uc788\uc5b4 \ubb38\uc81c\uac00 \ubc1c\uc0dd\ud558\uae30 \uc804\uc5d0 \uc608\ubc29\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc815\uae30\uc801\uc778 \ubc31\uc5c5\uc740 \ub370\uc774\ud130 \uc190\uc2e4\uc744 \ubc29\uc9c0\ud558\ub294 \ub370 \ud544\uc218\uc801\uc785\ub2c8\ub2e4.<\/p>\n
\ub85c\uadf8 \ud30c\uc77c \ubd84\uc11d\uc744 \ud1b5\ud574 \uc5b4\ub5a4 \ucffc\ub9ac\uac00 \ubb38\uc81c\ub97c \uc77c\uc73c\ud0a4\uace0 \uc788\ub294\uc9c0 \ud655\uc778\ud560 \uc218 \uc788\uc73c\uba70, \uc815\uae30\uc801\uc778 \uc5c5\ub370\uc774\ud2b8 \ubc0f \ud328\uce58\ub97c \uc801\uc6a9\ud558\uc5ec \ubcf4\uc548\uacfc \uc131\ub2a5\uc744 \uc720\uc9c0\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ub9c8\uc9c0\ub9c9\uc73c\ub85c, \uc0ac\uc6a9\uc790 \uad50\uc721\uacfc \ubb38\uc11c\ud654\ub97c \ud1b5\ud574 \ud300\uc6d0\ub4e4\uc774 MySQL \uc11c\ubc84\ub97c \ud6a8\uacfc\uc801\uc73c\ub85c \uad00\ub9ac\ud560 \uc218 \uc788\ub3c4\ub85d \ud574\uc57c \ud569\ub2c8\ub2e4.<\/p>\n
8. \uacb0\ub860 \ubc0f \uc694\uc57d<\/h2>\nMySQL \uc11c\ubc84\uc758 \uba54\ubaa8\ub9ac \ubb38\uc81c\ub294 \ub2e4\uc591\ud55c \uc6d0\uc778\uc5d0 \uc758\ud574 \ubc1c\uc0dd\ud560 \uc218 \uc788\uc73c\uba70, \uc774\ub97c \ud574\uacb0\ud558\uae30 \uc704\ud574\uc11c\ub294 \ucca0\uc800\ud55c \uc9c4\ub2e8\uacfc \ucd5c\uc801\ud654\uac00 \ud544\uc694\ud569\ub2c8\ub2e4. \ubcf8 \uae00\uc5d0\uc11c\ub294 MySQL\uc758 \uba54\ubaa8\ub9ac \uad6c\uc870\ub97c \uc774\ud574\ud558\uace0, \ubb38\uc81c\uc758 \uc6d0\uc778\uc744 \ubd84\uc11d\ud558\uba70, \ucd5c\uc801\ud654 \uae30\ubc95\uacfc \ucffc\ub9ac \ucd5c\uc801\ud654 \ubc29\ubc95, \ud558\ub4dc\uc6e8\uc5b4 \uc5c5\uadf8\ub808\uc774\ub4dc \ubc0f \ubaa8\ub2c8\ud130\ub9c1 \uc804\ub7b5\uc5d0 \ub300\ud574 \ub17c\uc758\ud588\uc2b5\ub2c8\ub2e4.<\/p>\n
\uba54\ubaa8\ub9ac \ubb38\uc81c\ub97c \ud574\uacb0\ud558\uae30 \uc704\ud574\uc11c\ub294 \ub2e4\uc74c\uacfc \uac19\uc740 \uc810\uc744 \uae30\uc5b5\ud574\uc57c \ud569\ub2c8\ub2e4:<\/p>\n
\nMySQL\uc758 \uba54\ubaa8\ub9ac \uad6c\uc870\ub97c \uc774\ud574\ud558\uace0 \uc801\uc808\ud788 \uc870\uc815\ud558\ub77c.<\/li>\n
\ubb38\uc81c\uc758 \uc6d0\uc778\uc744 \ucca0\uc800\ud788 \ubd84\uc11d\ud558\ub77c.<\/li>\n
\ucffc\ub9ac\ub97c \ucd5c\uc801\ud654\ud558\uace0 \uc778\ub371\uc2a4\ub97c \ud65c\uc6a9\ud558\ub77c.<\/li>\n
\ud558\ub4dc\uc6e8\uc5b4 \uc5c5\uadf8\ub808\uc774\ub4dc\ub97c \uace0\ub824\ud558\ub77c.<\/li>\n
\uc815\uae30\uc801\uc778 \ubaa8\ub2c8\ud130\ub9c1\uacfc \uc720\uc9c0\ubcf4\uc218\ub97c \uc218\ud589\ud558\ub77c.<\/li>\n<\/ul>\n\uc774\ub7ec\ud55c \uc804\ub7b5\uc744 \ud1b5\ud574 MySQL \uc11c\ubc84\uc758 \uc131\ub2a5\uc744 \uadf9\ub300\ud654\ud558\uace0, \uba54\ubaa8\ub9ac \ubb38\uc81c\ub97c \uc608\ubc29\ud560 \uc218 \uc788\uc744 \uac83\uc785\ub2c8\ub2e4. \uc9c0\uc18d\uc801\uc778 \ud559\uc2b5\uacfc \uac1c\uc120\uc774 \ud544\uc694\ud558\uba70, \uc774\ub97c \ud1b5\ud574 \uc548\uc815\uc801\uc774\uace0 \ud6a8\uc728\uc801\uc778 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc6b4\uc601\uc774 \uac00\ub2a5\ud574\uc9c8 \uac83\uc785\ub2c8\ub2e4.<\/p>\n","protected":false},"excerpt":{"rendered":"
\ubaa9\ucc28 MySQL \uc11c\ubc84\uc758 \uba54\ubaa8\ub9ac \ubb38\uc81c\uc640 \ud574\uacb0 \ubc29\uc548 1. MySQL \uba54\ubaa8\ub9ac \uad6c\uc870 \uc774\ud574\ud558\uae30 2. \uba54\ubaa8\ub9ac \ubb38\uc81c\uc758 […]<\/p>\n","protected":false},"author":1,"featured_media":33704,"comment_status":"","ping_status":"","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[1957],"tags":[2100,2136,2455],"class_list":["post-51625","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-development","tag-mysql","tag-performance","tag-query"],"acf":[],"_links":{"self":[{"href":"https:\/\/m9js.shop\/blog\/wp-json\/wp\/v2\/posts\/51625","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=51625"}],"version-history":[{"count":0,"href":"https:\/\/m9js.shop\/blog\/wp-json\/wp\/v2\/posts\/51625\/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=51625"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/m9js.shop\/blog\/wp-json\/wp\/v2\/categories?post=51625"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/m9js.shop\/blog\/wp-json\/wp\/v2\/tags?post=51625"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}