MySQL\uc740 \uc804 \uc138\uacc4\uc801\uc73c\ub85c \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 MySQL\uc744 \uc6b4\uc601\ud558\uba74\uc11c \ub514\uc2a4\ud06c I\/O \ubb38\uc81c\ub294 \ube48\ubc88\ud558\uac8c \ubc1c\uc0dd\ud560 \uc218 \uc788\uc73c\uba70, \uc774\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc131\ub2a5\uc5d0 \uc2ec\uac01\ud55c \uc601\ud5a5\uc744 \ubbf8\uce60 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc774 \uae00\uc5d0\uc11c\ub294 MySQL\uc5d0\uc11c\uc758 \ub514\uc2a4\ud06c I\/O \ubb38\uc81c\ub97c \uc2ec\uce35\uc801\uc73c\ub85c \ubd84\uc11d\ud558\uace0, \uc774\ub97c \ud574\uacb0\ud558\uae30 \uc704\ud55c \ub2e4\uc591\ud55c \ubc29\ubc95\uc744 \uc81c\uc2dc\ud558\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n
\ub514\uc2a4\ud06c I\/O(Input\/Output)\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uac00 \ub514\uc2a4\ud06c\uc640 \uc0c1\ud638\uc791\uc6a9\ud558\ub294 \ubc29\uc2dd\uc744 \uc758\ubbf8\ud569\ub2c8\ub2e4. MySQL\uc740 \ub370\uc774\ud130\ub97c \ub514\uc2a4\ud06c\uc5d0 \uc800\uc7a5\ud558\uace0 \ud544\uc694\ud560 \ub54c \uc774\ub97c \uc77d\uc5b4\uc624\ub294 \ubc29\uc2dd\uc73c\ub85c \uc791\ub3d9\ud569\ub2c8\ub2e4. \uc774 \uacfc\uc815\uc5d0\uc11c \ubc1c\uc0dd\ud558\ub294 I\/O \uc791\uc5c5\uc740 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc131\ub2a5\uc5d0 \ud070 \uc601\ud5a5\uc744 \ubbf8\uce60 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n
\ub514\uc2a4\ud06c I\/O\ub294 \ud06c\uac8c \ub450 \uac00\uc9c0\ub85c \ub098\ub20c \uc218 \uc788\uc2b5\ub2c8\ub2e4: \uc77d\uae30 \uc791\uc5c5\uacfc \uc4f0\uae30 \uc791\uc5c5\uc785\ub2c8\ub2e4. \uc77d\uae30 \uc791\uc5c5\uc740 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uac00 \ub514\uc2a4\ud06c\uc5d0\uc11c \ub370\uc774\ud130\ub97c \uac00\uc838\uc624\ub294 \uacfc\uc815\uc774\uba70, \uc4f0\uae30 \uc791\uc5c5\uc740 \ub370\uc774\ud130\ub97c \ub514\uc2a4\ud06c\uc5d0 \uc800\uc7a5\ud558\ub294 \uacfc\uc815\uc785\ub2c8\ub2e4. \uc774 \ub450 \uc791\uc5c5\uc740 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \uc131\ub2a5\uc744 \uacb0\uc815\uc9d3\ub294 \uc911\uc694\ud55c \uc694\uc18c\uc785\ub2c8\ub2e4.<\/p>\n
\ub514\uc2a4\ud06c I\/O\uac00 \ub290\ub824\uc9c0\uba74 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ucffc\ub9ac\uc758 \uc751\ub2f5 \uc2dc\uac04\uc774 \uc99d\uac00\ud558\uace0, \uc774\ub294 \uc0ac\uc6a9\uc790 \uacbd\ud5d8\uc5d0 \ubd80\uc815\uc801\uc778 \uc601\ud5a5\uc744 \ubbf8\uce60 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ub530\ub77c\uc11c \ub514\uc2a4\ud06c I\/O \ubb38\uc81c\ub97c \ud574\uacb0\ud558\ub294 \uac83\uc740 MySQL \uc131\ub2a5 \ucd5c\uc801\ud654\uc758 \ud575\uc2ec\uc785\ub2c8\ub2e4.<\/p>\n
\ub514\uc2a4\ud06c I\/O \ubb38\uc81c\ub294 \uc5ec\ub7ec \uac00\uc9c0 \uc6d0\uc778\uc73c\ub85c \ubc1c\uc0dd\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc5ec\uae30\uc11c\ub294 \uac00\uc7a5 \uc77c\ubc18\uc801\uc778 \uc6d0\uc778\ub4e4\uc744 \uc0b4\ud3b4\ubcf4\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n
\uc774\ub7ec\ud55c \uc6d0\uc778\ub4e4\uc740 \ub2e8\ub3c5\uc73c\ub85c \ub610\ub294 \ubcf5\ud569\uc801\uc73c\ub85c \uc791\uc6a9\ud558\uc5ec \ub514\uc2a4\ud06c I\/O \ubb38\uc81c\ub97c \uc77c\uc73c\ud0ac \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ub530\ub77c\uc11c \ubb38\uc81c\ub97c \ud574\uacb0\ud558\uae30 \uc704\ud574\uc11c\ub294 \uc6d0\uc778\uc744 \uc815\ud655\ud788 \ud30c\uc545\ud558\ub294 \uac83\uc774 \uc911\uc694\ud569\ub2c8\ub2e4.<\/p>\n
\ub514\uc2a4\ud06c I\/O \ubb38\uc81c\ub97c \ud574\uacb0\ud558\uae30 \uc704\ud574\uc11c\ub294 \uba3c\uc800 \ubb38\uc81c\ub97c \uc9c4\ub2e8\ud574\uc57c \ud569\ub2c8\ub2e4. MySQL\uc5d0\uc11c\ub294 \ub2e4\uc591\ud55c \ub3c4\uad6c\uc640 \uba85\ub839\uc5b4\ub97c \ud1b5\ud574 I\/O \uc131\ub2a5\uc744 \ubaa8\ub2c8\ud130\ub9c1\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n
\uac00\uc7a5 \uae30\ubcf8\uc801\uc778 \ubc29\ubc95\uc740 SHOW STATUS<\/code> \uba85\ub839\uc5b4\ub97c \uc0ac\uc6a9\ud558\ub294 \uac83\uc785\ub2c8\ub2e4. \uc774 \uba85\ub839\uc5b4\ub294 MySQL \uc11c\ubc84\uc758 \uc0c1\ud0dc \uc815\ubcf4\ub97c \ubcf4\uc5ec\uc90d\ub2c8\ub2e4. \ud2b9\ud788 Handler_read_rnd<\/code>, Handler_read_rnd_next<\/code>, Handler_read_first<\/code> \ub4f1\uc758 \uc9c0\ud45c\ub97c \ud1b5\ud574 \uc77d\uae30 \uc791\uc5c5\uc758 \ud6a8\uc728\uc131\uc744 \ud3c9\uac00\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n
SHOW STATUS LIKE 'Handler%';<\/code><\/pre>\n\ub610\ud55c, iostat<\/code>\uc640 \uac19\uc740 \uc2dc\uc2a4\ud15c \ub3c4\uad6c\ub97c \uc0ac\uc6a9\ud558\uc5ec \ub514\uc2a4\ud06c I\/O \uc131\ub2a5\uc744 \ubaa8\ub2c8\ud130\ub9c1\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc774 \ub3c4\uad6c\ub294 \ub514\uc2a4\ud06c\uc758 \uc77d\uae30 \ubc0f \uc4f0\uae30 \uc18d\ub3c4\ub97c \uce21\uc815\ud558\uc5ec \uc131\ub2a5 \ubcd1\ubaa9 \ud604\uc0c1\uc744 \ud30c\uc545\ud558\ub294 \ub370 \uc720\uc6a9\ud569\ub2c8\ub2e4.<\/p>\n
MySQL\uc758 slow query log<\/code> \uae30\ub2a5\uc744 \ud65c\uc131\ud654\ud558\uba74 \ub290\ub9b0 \ucffc\ub9ac\ub97c \uae30\ub85d\ud558\uc5ec \ubd84\uc11d\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc774\ub97c \ud1b5\ud574 \uc5b4\ub5a4 \ucffc\ub9ac\uac00 I\/O \ubb38\uc81c\ub97c \uc77c\uc73c\ud0a4\ub294\uc9c0 \ud30c\uc545\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n
SET GLOBAL slow_query_log = 'ON';<\/code><\/pre>\n\uc774 \uc678\uc5d0\ub3c4 EXPLAIN<\/code> \uba85\ub839\uc5b4\ub97c \uc0ac\uc6a9\ud558\uc5ec \ucffc\ub9ac \uc2e4\ud589 \uacc4\ud68d\uc744 \ubd84\uc11d\ud558\uace0, \uc778\ub371\uc2a4 \uc0ac\uc6a9 \uc5ec\ubd80\ub97c \ud655\uc778\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc774\ub97c \ud1b5\ud574 \ucffc\ub9ac \ucd5c\uc801\ud654\ub97c \uc704\ud55c \uae30\ucd08 \uc790\ub8cc\ub97c \ud655\ubcf4\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n
4. \ud558\ub4dc\uc6e8\uc5b4 \uc5c5\uadf8\ub808\uc774\ub4dc<\/h2>\n\ub514\uc2a4\ud06c I\/O \ubb38\uc81c\uc758 \uac00\uc7a5 \uac04\ub2e8\ud55c \ud574\uacb0\ucc45 \uc911 \ud558\ub098\ub294 \ud558\ub4dc\uc6e8\uc5b4\ub97c \uc5c5\uadf8\ub808\uc774\ub4dc\ud558\ub294 \uac83\uc785\ub2c8\ub2e4. \ud2b9\ud788 SSD(Solid State Drive)\ub294 HDD(Hard Disk Drive)\uc5d0 \ube44\ud574 \ud6e8\uc52c \ube60\ub978 \uc77d\uae30 \ubc0f \uc4f0\uae30 \uc18d\ub3c4\ub97c \uc81c\uacf5\ud569\ub2c8\ub2e4. SSD\ub85c \uc5c5\uadf8\ub808\uc774\ub4dc\ud558\uba74 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \uc804\ubc18\uc801\uc778 \uc131\ub2a5\uc774 \ud06c\uac8c \ud5a5\uc0c1\ub420 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n
\ub610\ud55c, RAID(Redundant Array of Independent Disks) \uad6c\uc131\uc744 \ud1b5\ud574 \uc5ec\ub7ec \uac1c\uc758 \ub514\uc2a4\ud06c\ub97c \ubcd1\ub82c\ub85c \uc0ac\uc6a9\ud558\uba74 I\/O \uc131\ub2a5\uc744 \ub354\uc6b1 \ud5a5\uc0c1\uc2dc\ud0ac \uc218 \uc788\uc2b5\ub2c8\ub2e4. RAID 0\uc740 \uc131\ub2a5\uc744 \uadf9\ub300\ud654\ud558\uc9c0\ub9cc \ub370\uc774\ud130 \uc548\uc804\uc131\uc774 \ub5a8\uc5b4\uc9c0\ubbc0\ub85c, RAID 10\uacfc \uac19\uc740 \uad6c\uc131\uc744 \uace0\ub824\ud558\ub294 \uac83\uc774 \uc88b\uc2b5\ub2c8\ub2e4.<\/p>\n
\ud558\ub4dc\uc6e8\uc5b4 \uc5c5\uadf8\ub808\uc774\ub4dc\ub294 \ube44\uc6a9\uc774 \ubc1c\uc0dd\ud558\uc9c0\ub9cc, \uc7a5\uae30\uc801\uc73c\ub85c \ubcfc \ub54c \uc131\ub2a5 \ud5a5\uc0c1\uacfc \uc548\uc815\uc131\uc744 \uace0\ub824\ud560 \ub54c \ud22c\uc790\ud560 \uac00\uce58\uac00 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n
5. \ucffc\ub9ac \ucd5c\uc801\ud654<\/h2>\n
\ucffc\ub9ac \ucd5c\uc801\ud654\ub294 \ub514\uc2a4\ud06c I\/O \ubb38\uc81c\ub97c \ud574\uacb0\ud558\ub294 \ub370 \uc788\uc5b4 \ub9e4\uc6b0 \uc911\uc694\ud55c \uc694\uc18c\uc785\ub2c8\ub2e4. \ube44\ud6a8\uc728\uc801\uc778 \ucffc\ub9ac\ub294 \ubd88\ud544\uc694\ud55c I\/O \uc791\uc5c5\uc744 \ucd08\ub798\ud558\uc5ec \uc131\ub2a5\uc744 \uc800\ud558\uc2dc\ud0ac \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n
\ucffc\ub9ac\ub97c \ucd5c\uc801\ud654\ud558\uae30 \uc704\ud574\uc11c\ub294 \ub2e4\uc74c\uacfc \uac19\uc740 \ubc29\ubc95\uc744 \uace0\ub824\ud574\uc57c \ud569\ub2c8\ub2e4:<\/p>\n
\n- \uc778\ub371\uc2a4 \uc0ac\uc6a9:<\/strong> \uc801\uc808\ud55c \uc778\ub371\uc2a4\ub97c \uc0ac\uc6a9\ud558\uba74 \ucffc\ub9ac \uc131\ub2a5\uc744 \ud06c\uac8c \ud5a5\uc0c1\uc2dc\ud0ac \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc778\ub371\uc2a4\ub294 \ub370\uc774\ud130 \uac80\uc0c9 \uc18d\ub3c4\ub97c \ub192\uc5ec\uc8fc\uba70, \ubd88\ud544\uc694\ud55c \ub514\uc2a4\ud06c I\/O\ub97c \uc904\uc5ec\uc90d\ub2c8\ub2e4.<\/li>\n
- SELECT \uc808 \ucd5c\uc801\ud654:<\/strong> \ud544\uc694\ud55c \uceec\ub7fc\ub9cc \uc120\ud0dd\ud558\uc5ec \ubd88\ud544\uc694\ud55c \ub370\uc774\ud130\ub97c \uc77d\uc9c0 \uc54a\ub3c4\ub85d \ud569\ub2c8\ub2e4. \uc608\ub97c \ub4e4\uc5b4,
SELECT * FROM table<\/code> \ub300\uc2e0 \ud544\uc694\ud55c \uceec\ub7fc\ub9cc \uc120\ud0dd\ud558\ub294 \uac83\uc774 \uc88b\uc2b5\ub2c8\ub2e4.<\/li>\n JOIN \ucd5c\uc801\ud654:<\/strong> JOIN \uc5f0\uc0b0\uc740 \ub9ce\uc740 I\/O \uc791\uc5c5\uc744 \ubc1c\uc0dd\uc2dc\ud0ac \uc218 \uc788\uc2b5\ub2c8\ub2e4. JOIN \uc870\uac74\uc744 \ucd5c\uc801\ud654\ud558\uace0, \ud544\uc694\ud55c \uacbd\uc6b0 \uc11c\ube0c\ucffc\ub9ac\ub97c \uc0ac\uc6a9\ud558\ub294 \uac83\uc774 \uc88b\uc2b5\ub2c8\ub2e4.<\/li>\nWHERE \uc808 \ucd5c\uc801\ud654:<\/strong> WHERE \uc808\uc744 \ud1b5\ud574 \ubd88\ud544\uc694\ud55c \ub370\uc774\ud130 \uac80\uc0c9\uc744 \uc904\uc77c \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc870\uac74\uc744 \uba85\ud655\ud788 \ud558\uc5ec \uac80\uc0c9 \ubc94\uc704\ub97c \uc881\ud788\ub294 \uac83\uc774 \uc911\uc694\ud569\ub2c8\ub2e4.<\/li>\n<\/ul>\n\ucffc\ub9ac \ucd5c\uc801\ud654\ub294 \uc9c0\uc18d\uc801\uc778 \uacfc\uc815\uc774\uba70, \uc8fc\uae30\uc801\uc73c\ub85c \ucffc\ub9ac\ub97c \ubd84\uc11d\ud558\uace0 \uac1c\uc120\ud558\ub294 \ub178\ub825\uc774 \ud544\uc694\ud569\ub2c8\ub2e4.<\/p>\n
6. \uce90\uc2dc \ud65c\uc6a9<\/h2>\n
MySQL\uc740 \uba54\ubaa8\ub9ac \uce90\uc2dc\ub97c \ud65c\uc6a9\ud558\uc5ec \ub514\uc2a4\ud06c I\/O\ub97c \uc904\uc774\ub294 \ub370 \ud070 \uc5ed\ud560\uc744 \ud569\ub2c8\ub2e4. InnoDB \uc2a4\ud1a0\ub9ac\uc9c0 \uc5d4\uc9c4\uc740 Buffer Pool\uc774\ub77c\ub294 \uba54\ubaa8\ub9ac \uc601\uc5ed\uc744 \uc0ac\uc6a9\ud558\uc5ec \uc790\uc8fc \uc0ac\uc6a9\ud558\ub294 \ub370\uc774\ud130\ub97c \uba54\ubaa8\ub9ac\uc5d0 \uc800\uc7a5\ud569\ub2c8\ub2e4. \uc774\ub97c \ud1b5\ud574 \ub514\uc2a4\ud06c\uc5d0\uc11c \uc9c1\uc811 \ub370\uc774\ud130\ub97c \uc77d\ub294 \ud69f\uc218\ub97c \uc904\uc77c \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n
Buffer Pool\uc758 \ud06c\uae30\ub97c \uc870\uc815\ud558\uc5ec \uce90\uc2dc \ud6a8\uc728\uc131\uc744 \ub192\uc77c \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc77c\ubc18\uc801\uc73c\ub85c Buffer Pool\uc758 \ud06c\uae30\ub294 \uc804\uccb4 \uc2dc\uc2a4\ud15c \uba54\ubaa8\ub9ac\uc758 70-80%\ub85c \uc124\uc815\ud558\ub294 \uac83\uc774 \uc88b\uc2b5\ub2c8\ub2e4. \uc774\ub97c \ud1b5\ud574 \ub354 \ub9ce\uc740 \ub370\uc774\ud130\ub97c \uba54\ubaa8\ub9ac\uc5d0 \uc800\uc7a5\ud558\uace0, \ub514\uc2a4\ud06c I\/O\ub97c \uc904\uc77c \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n
SET GLOBAL innodb_buffer_pool_size = 8 * 1024 * 1024 * 1024; -- 8GB\ub85c \uc124\uc815<\/code><\/pre>\n\ub610\ud55c, \ucffc\ub9ac \uce90\uc2dc\ub97c \ud65c\uc6a9\ud558\uc5ec \ub3d9\uc77c\ud55c \ucffc\ub9ac\uc5d0 \ub300\ud55c \uacb0\uacfc\ub97c \uba54\ubaa8\ub9ac\uc5d0 \uc800\uc7a5\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc774\ub97c \ud1b5\ud574 \ubc18\ubcf5\uc801\uc778 \ucffc\ub9ac \uc2e4\ud589 \uc2dc \uc131\ub2a5\uc744 \ud5a5\uc0c1\uc2dc\ud0ac \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n
7. \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc124\uacc4 \ucd5c\uc801\ud654<\/h2>\n
\ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc124\uacc4\ub294 \uc131\ub2a5\uc5d0 \ud070 \uc601\ud5a5\uc744 \ubbf8\uce69\ub2c8\ub2e4. \uc798\ubabb\ub41c \uc124\uacc4\ub294 \ubd88\ud544\uc694\ud55c I\/O \uc791\uc5c5\uc744 \ucd08\ub798\ud560 \uc218 \uc788\uc73c\uba70, \uc774\ub294 \uc131\ub2a5 \uc800\ud558\ub85c \uc774\uc5b4\uc9c8 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n
\ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc124\uacc4\ub97c \ucd5c\uc801\ud654\ud558\uae30 \uc704\ud574\uc11c\ub294 \ub2e4\uc74c\uacfc \uac19\uc740 \ubc29\ubc95\uc744 \uace0\ub824\ud574\uc57c \ud569\ub2c8\ub2e4:<\/p>\n
\n- \uc815\uaddc\ud654:<\/strong> \ub370\uc774\ud130 \uc911\ubcf5\uc744 \uc904\uc774\uace0, \ub370\uc774\ud130 \ubb34\uacb0\uc131\uc744 \uc720\uc9c0\ud558\uae30 \uc704\ud574 \uc815\uaddc\ud654\ub97c \uc218\ud589\ud569\ub2c8\ub2e4. \uadf8\ub7ec\ub098 \uacfc\ub3c4\ud55c \uc815\uaddc\ud654\ub294 JOIN \uc5f0\uc0b0\uc744 \uc99d\uac00\uc2dc\ucf1c \uc131\ub2a5 \uc800\ud558\ub97c \ucd08\ub798\ud560 \uc218 \uc788\uc73c\ubbc0\ub85c \uc801\uc808\ud55c \uade0\ud615\uc774 \ud544\uc694\ud569\ub2c8\ub2e4.<\/li>\n
- \ud30c\ud2f0\uc154\ub2dd:<\/strong> \ub300\ub7c9\uc758 \ub370\uc774\ud130\ub97c \ub2e4\ub8f0 \ub54c\ub294 \ud30c\ud2f0\uc154\ub2dd\uc744 \ud1b5\ud574 \ub370\uc774\ud130\ub97c \ubd84\ud560\ud558\uc5ec \uad00\ub9ac\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc774\ub97c \ud1b5\ud574 \ud2b9\uc815 \ud30c\ud2f0\uc158\uc5d0 \ub300\ud55c \ucffc\ub9ac \uc131\ub2a5\uc744 \ud5a5\uc0c1\uc2dc\ud0ac \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/li>\n
- \ub370\uc774\ud130 \ud0c0\uc785 \ucd5c\uc801\ud654:<\/strong> \uc801\uc808\ud55c \ub370\uc774\ud130 \ud0c0\uc785\uc744 \uc120\ud0dd\ud558\uc5ec \uc800\uc7a5 \uacf5\uac04\uc744 \uc808\uc57d\ud558\uace0, I\/O \uc791\uc5c5\uc744 \uc904\uc77c \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc608\ub97c \ub4e4\uc5b4, \uc815\uc218\ud615 \ub370\uc774\ud130\ub294 \uac00\ub2a5\ud55c \ud55c \uc791\uc740 \ud06c\uae30\uc758 \ub370\uc774\ud130 \ud0c0\uc785\uc744 \uc0ac\uc6a9\ud558\ub294 \uac83\uc774 \uc88b\uc2b5\ub2c8\ub2e4.<\/li>\n<\/ul>\n
\ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc124\uacc4 \ucd5c\uc801\ud654\ub294 \ucd08\uae30 \ub2e8\uacc4\uc5d0\uc11c\ubd80\ud130 \uace0\ub824\ud574\uc57c \ud558\uba70, \uc9c0\uc18d\uc801\uc778 \uac80\ud1a0\uc640 \uac1c\uc120\uc774 \ud544\uc694\ud569\ub2c8\ub2e4.<\/p>\n
8. \ubaa8\ub2c8\ud130\ub9c1 \ubc0f \uc720\uc9c0\ubcf4\uc218<\/h2>\n
\ub514\uc2a4\ud06c I\/O \ubb38\uc81c\ub97c \uc608\ubc29\ud558\uae30 \uc704\ud574\uc11c\ub294 \uc9c0\uc18d\uc801\uc778 \ubaa8\ub2c8\ud130\ub9c1\uacfc \uc720\uc9c0\ubcf4\uc218\uac00 \ud544\uc694\ud569\ub2c8\ub2e4. MySQL\uc5d0\uc11c\ub294 \ub2e4\uc591\ud55c \ubaa8\ub2c8\ud130\ub9c1 \ub3c4\uad6c\ub97c \uc81c\uacf5\ud558\uc5ec \uc131\ub2a5\uc744 \uc2e4\uc2dc\uac04\uc73c\ub85c \ud655\uc778\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n
\uc608\ub97c \ub4e4\uc5b4, MySQL Enterprise Monitor<\/code>\uc640 \uac19\uc740 \ub3c4\uad6c\ub97c \uc0ac\uc6a9\ud558\uba74 MySQL \uc11c\ubc84\uc758 \uc0c1\ud0dc\ub97c \uc2e4\uc2dc\uac04\uc73c\ub85c \ubaa8\ub2c8\ud130\ub9c1\ud558\uace0, \uc131\ub2a5 \uc800\ud558\ub97c \uc0ac\uc804\uc5d0 \uac10\uc9c0\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n
\ub610\ud55c, \uc815\uae30\uc801\uc778 \ubc31\uc5c5\uacfc \ubcf5\uad6c \ud14c\uc2a4\ud2b8\ub97c \ud1b5\ud574 \ub370\uc774\ud130 \uc190\uc2e4\uc744 \uc608\ubc29\ud558\uace0, \uc2dc\uc2a4\ud15c \uc548\uc815\uc131\uc744 \uc720\uc9c0\ud574\uc57c \ud569\ub2c8\ub2e4. \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \ud06c\uae30\uac00 \ucee4\uc9c8\uc218\ub85d \ubc31\uc5c5 \ubc0f \ubcf5\uad6c \uc791\uc5c5\uc740 \ub354\uc6b1 \uc911\uc694\ud574\uc9d1\ub2c8\ub2e4.<\/p>\n
\ub9c8\uc9c0\ub9c9\uc73c\ub85c, MySQL\uc758 \ucd5c\uc2e0 \ubc84\uc804\uc744 \uc720\uc9c0\ud558\uc5ec \ubcf4\uc548 \ubc0f \uc131\ub2a5 \uac1c\uc120 \uc0ac\ud56d\uc744 \uc801\uc6a9\ud558\ub294 \uac83\uc774 \uc911\uc694\ud569\ub2c8\ub2e4. \uc0c8\ub85c\uc6b4 \ubc84\uc804\uc5d0\uc11c\ub294 \ub2e4\uc591\ud55c \uc131\ub2a5 \uac1c\uc120 \uae30\ub2a5\uc774 \ucd94\uac00\ub418\ubbc0\ub85c, \uc774\ub97c \ud65c\uc6a9\ud558\uc5ec \ub514\uc2a4\ud06c I\/O \ubb38\uc81c\ub97c \ucd5c\uc18c\ud654\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n
\uacb0\ub860<\/h2>\nMySQL\uc5d0\uc11c\uc758 \ub514\uc2a4\ud06c I\/O \ubb38\uc81c\ub294 \ub2e4\uc591\ud55c \uc6d0\uc778\uc73c\ub85c \ubc1c\uc0dd\ud560 \uc218 \uc788\uc73c\uba70, \uc774\ub97c \ud574\uacb0\ud558\uae30 \uc704\ud574\uc11c\ub294 \ud558\ub4dc\uc6e8\uc5b4 \uc5c5\uadf8\ub808\uc774\ub4dc, \ucffc\ub9ac \ucd5c\uc801\ud654, \uce90\uc2dc \ud65c\uc6a9, \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc124\uacc4 \ucd5c\uc801\ud654 \ub4f1 \ub2e4\uc591\ud55c \uc811\uadfc \ubc29\ubc95\uc774 \ud544\uc694\ud569\ub2c8\ub2e4. \ub610\ud55c, \uc9c0\uc18d\uc801\uc778 \ubaa8\ub2c8\ud130\ub9c1\uacfc \uc720\uc9c0\ubcf4\uc218\ub97c \ud1b5\ud574 \ubb38\uc81c\ub97c \uc0ac\uc804\uc5d0 \uc608\ubc29\ud558\ub294 \uac83\uc774 \uc911\uc694\ud569\ub2c8\ub2e4.<\/p>\n
\uc774 \uae00\uc5d0\uc11c \uc81c\uc2dc\ud55c \ubc29\ubc95\ub4e4\uc744 \ud1b5\ud574 MySQL\uc758 \ub514\uc2a4\ud06c I\/O \ubb38\uc81c\ub97c \ud6a8\uacfc\uc801\uc73c\ub85c \ud574\uacb0\ud558\uace0, \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc131\ub2a5\uc744 \uadf9\ub300\ud654\ud560 \uc218 \uc788\uae30\ub97c \ubc14\ub78d\ub2c8\ub2e4.<\/p>\n","protected":false},"excerpt":{"rendered":"
\ubaa9\ucc28 MySQL\uc5d0\uc11c\uc758 \ub514\uc2a4\ud06c I\/O \ubb38\uc81c\uc640 \ud574\uacb0 \ubc29\ubc95 1. \ub514\uc2a4\ud06c I\/O\uc758 \uc774\ud574 2. \ub514\uc2a4\ud06c I\/O \ubb38\uc81c\uc758 […]<\/p>\n","protected":false},"author":1,"featured_media":51462,"comment_status":"","ping_status":"","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[1957],"tags":[2100,471],"class_list":["post-51643","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-development","tag-mysql","tag-state"],"acf":[],"_links":{"self":[{"href":"https:\/\/m9js.shop\/blog\/wp-json\/wp\/v2\/posts\/51643","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=51643"}],"version-history":[{"count":0,"href":"https:\/\/m9js.shop\/blog\/wp-json\/wp\/v2\/posts\/51643\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/m9js.shop\/blog\/wp-json\/wp\/v2\/media\/51462"}],"wp:attachment":[{"href":"https:\/\/m9js.shop\/blog\/wp-json\/wp\/v2\/media?parent=51643"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/m9js.shop\/blog\/wp-json\/wp\/v2\/categories?post=51643"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/m9js.shop\/blog\/wp-json\/wp\/v2\/tags?post=51643"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}