{"id":579,"date":"2013-04-05T09:16:30","date_gmt":"2013-04-05T00:16:30","guid":{"rendered":"http:\/\/www.freesens.com\/x\/?p=579"},"modified":"2024-01-16T09:46:51","modified_gmt":"2024-01-16T00:46:51","slug":"mysql-%ed%8c%81","status":"publish","type":"post","link":"http:\/\/www.freesens.com\/x\/?p=579","title":{"rendered":"MySQL \ud301"},"content":{"rendered":"<p>\uc9c0\ub09c 3\ub144\uac04 \ubc88\uac1c\uc7a5\ud130 \uc11c\ube44\uc2a4\ub97c \uc6b4\uc601\ud558\uba74\uc11c \uc5bb\uc740 MySQL \uc6b4\uc601 \ud301\uc744 \uc54c\ub824\ub4dc\ub9bd\ub2c8\ub2e4.<\/p>\n<p><strong>1. \uc11c\ube44\uc2a4 \uc911\uc778 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \ud14c\uc774\ube14\uc758 \uc2a4\ud0a4\ub9c8\ub97c \uc11c\ube44\uc2a4 \uc911\ub2e8 \uc5c6\uc774 \ubcc0\uacbd\ud558\ub824\uba74?<\/strong><\/p>\n<blockquote><p>InnoDB \uc2a4\ud1a0\ub9ac\uc9c0\uc758 \uacbd\uc6b0 \uc2a4\ud0a4\ub9c8\ub97c \ubcc0\uacbd\ud558\uba74 \ubcc0\uacbd\uc774 \uc644\ub8cc\ub420 \ub54c \uae4c\uc9c0 Lock \uc774 \uac78\ub9ac\uac8c \ub418\uc5b4 \uc11c\ube44\uc2a4\uac00 \uc7a0\uc2dc \uc911\ub2e8 \ub418\uc5b4\uc57c \ud588\uc2b5\ub2c8\ub2e4. \uadf8\ub798\uc11c \uc800\ud76c\ub294\u00a0<a href=\"http:\/\/www.percona.com\/doc\/percona-toolkit\/2.2\/\">Percona Toolkit<\/a>\u00a0\uc758 pt-online-schema-change \uae30\ub2a5\uc744 \uc0ac\uc6a9 \ud558\uc5ec \uc911\ub2e8 \uc5c6\uc774 \ubcc0\uacbd\ud569\ub2c8\ub2e4. \uc0ac\uc6a9 \ubc29\ubc95\ub3c4 \uac04\ub2e8\ud558\uace0 \ub098\ub984 \uc548\uc815\uc131\uc774 \uc788\ub2e4\uace0 \ud569\ub2c8\ub2e4. \uadf8\ub7ec\ub098 \ub2e8\uc810\uc73c\ub85c\ub294 \uae30\uc874\uc5d0 \ud2b8\ub9ac\uac70(Trigger)\uac00 \uac78\ub824 \uc788\ub294 \ud14c\uc774\ube14\uc5d0\ub294 \uc801\uc6a9\uc774 \ubd88\uac00\ub2a5 \ud569\ub2c8\ub2e4.<\/p>\n<p>\ub300\uc548\uc73c\ub85c, MySQL 5.6\uc744 \ub3c4\uc785\ud558\uac70\ub098 MySQL Cluster \uc640 \uac19\uc774 \uc2a4\ud0a4\ub9c8\ub97c \ubcc0\uacbd\ud558\ub294 \uac83\uc774 \uc790\uc720\ub85c\uc6b4 \uc81c\ud488\uc744 \uc120\ud0dd\ud558\ub294 \uac83\ub3c4 \ubc29\ubc95\uc774\uc9c0\ub9cc \uc544\uc9c1 \uac80\uc99d\uc774 \ub9ce\uc774 \ub418\uc9c0 \uc54a\uc544\uc11c \ubb38\uc81c\uac00 \uc788\uc2b5\ub2c8\ub2e4.<\/p><\/blockquote>\n<div><\/div>\n<div><\/div>\n<p><strong>2. \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc5f0\uacb0\uc774 \ub108\ubb34 \ub9ce\uc740\ub370 \uc5b4\ub5bb\uac8c \ud558\ub098\uc694?<\/strong><\/p>\n<blockquote><p>MySQL \ud074\ub77c\uc774\uc5b8\ud2b8\uc758 \ub3d9\uc2dc \uc811\uc18d \uac1c\uc218\uac00 1200\uac1c\ub97c \ub118\uc5b4\uac00\ub294 \uacbd\uc6b0\uac00 \uc0dd\uae30\uba74\uc11c \uae30\uc874 MySQL 5.5 \uc5d0\uc11c\u00a0<a href=\"http:\/\/forums.mysql.com\/read.php?24,283357,283357\">\uc4f0\ub808\ub4dc \uc0dd\uc131 \uc2e4\ud328\ud558\uc5ec \uc11c\ubc84\uac00 \uc8fd\uc5b4\ubc84\ub9ac\ub294 \ubb38\uc81c<\/a>\uac00 \ubc1c\uc0dd\ud558\uc600\uc2b5\ub2c8\ub2e4. \ud074\ub77c\uc774\uc5b8\ud2b8\uc5d0\uc11c \uc811\uc18d \uac1c\uc218\ub97c \uc904\uc774\ub3c4\ub85d \uc218\uc815\ud558\uc600\uc73c\ub098 \ud5a5\ud6c4\uc5d0\ub3c4 \uc720\uc0ac\ud55c \ubb38\uc81c\uac00 \ubc1c\uc0dd\ud560 \uac00\ub2a5\uc131\uc774 \uc788\uc5b4\uc11c Connection Pool \uae30\ub2a5\uc774 \uc81c\uacf5\ub418\ub294\u00a0<a href=\"https:\/\/mariadb.org\/\">MariaDB<\/a>\u00a05.5 \ub97c \ub3c4\uc785\ud558\uc600\uc2b5\ub2c8\ub2e4. \ub355\ubd84\uc5d0 \uc218\ucc9c\uac1c\uc758 \ub3d9\uc2dc \uc811\uc18d\uc774 \ub4e4\uc5b4\uc640\ub3c4 \uc11c\ubc84\uac00 \uc8fd\ub294 \uacbd\uc6b0\ub294 \uc608\ubc29\ud560 \uc218 \uc788\uc5c8\uc2b5\ub2c8\ub2e4.<\/p><\/blockquote>\n<div><\/div>\n<div><\/div>\n<div><\/div>\n<div><strong>3. \uc2e4\uc2dc\uac04 \ubc31\uc5c5 \/ \uc99d\ubd84 \ubc31\uc5c5\uc744 \ud558\uace0 \uc2f6\uc5b4\uc694<\/strong><\/div>\n<blockquote>\n<div><a href=\"http:\/\/www.percona.com\/doc\/percona-xtrabackup\/howtos\/setting_up_replication.html\">Xtrabackup<\/a>\u00a0\uc744 \uc0ac\uc6a9\ud558\uba74 \uc11c\ubc84\uac00 \ub3cc\uc544\uac00\ub294 \uc911\uac04\uc5d0\ub3c4 \ub370\uc774\ud130 \ubc31\uc5c5\uc744 \ud560 \uc218 \uc788\uc73c\uba70 \uc99d\ubd84 \ubc31\uc5c5\ub3c4 \uac00\ub2a5\ud569\ub2c8\ub2e4. \uc800\ud76c\ub3c4 \uc544\ubb34\ub7f0 \ubb38\uc81c \uc5c6\uc774 \uc0ac\uc6a9 \ud558\uace0 \uc788\uc9c0\ub9cc \ubc31\uc5c5\ub41c \ub370\uc774\ud130\uac00 \ubb38\uc81c \uc5c6\ub294\uc9c0 \ud655\uc778 \ud558\ub294 \uacfc\uc815\uc774 \ud544\uc694\ud569\ub2c8\ub2e4.<\/div>\n<\/blockquote>\n<blockquote>\n<div>Xtrabackup \uc758 \ub2e8\uc810\uc740 \ub370\uc774\ud130\ub97c \ud1b5\uc9f8\ub85c \ubc14\uc774\ub108\ub9ac \ud615\ud0dc\ub85c\ub9cc \ubf51\uc544\ub0bc \uc218 \uc788\ub2e4\ub294 \uc810\uc785\ub2c8\ub2e4. \uadf8\ub798\uc11c SQL \ud615\ud0dc\ub85c \ubf51\uc544\ub0b4\uace0 \uc2f6\uc740 \uacbd\uc6b0\uc5d0\ub294\u00a0<a href=\"https:\/\/launchpad.net\/mydumper\">Mydumper<\/a>\ub97c \ucd94\ucc9c\ud569\ub2c8\ub2e4.<\/div>\n<\/blockquote>\n<div><\/div>\n<div><\/div>\n<div><\/div>\n<div><strong>4. \uba87\ubc31\ub9cc\uac74\uc774 \ub118\uc5b4\uac00\ub294 \ud14c\uc774\ube14 \uad00\ub9ac\ud558\uae30<\/strong><\/div>\n<blockquote><p>\ud558\ub8e8\uc5d0 \uc218\uc2ed\ub9cc\uac74\uc529 \ucd94\uac00\ub418\ub294 \ud14c\uc774\ube14\uc740 \ud30c\ud2f0\uc154\ub2dd\uc744 \ud558\ub3c4\ub85d \uc124\uacc4\ud569\ub2c8\ub2e4. \uc6a9\ub3c4\uc5d0 \ub530\ub77c\uc11c \ub2e4\ub974\uaca0\uc9c0\ub9cc \uc800\ud76c\ub294 \ub300\uccb4\ub85c \uc2dc\uac04 \ub2e8\uc704\ub85c \ub370\uc774\ud130\ub97c \ubb3c\ub9ac\uc801\uc73c\ub85c \ubd84\ub9ac\ud574\uc11c \uc800\uc7a5\ud569\ub2c8\ub2e4. \uc801\uc808\ud788\ub9cc \uc0ac\uc6a9\ud574\ub3c4 \uc218\uc2ed\uc5b5\uac74\uc758 \ub370\uc774\ud130 \uad00\ub9ac\ub3c4 \ubd88\uac00\ub2a5 \ud558\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4.<\/p><\/blockquote>\n<p>&nbsp;<\/p>\n<p><strong>5. MyISAM\uc758 Fulltext \uac80\uc0c9\uc5d0 \ubd80\ud558\uac00 \uc2ec\ud574\uc694<\/strong><\/p>\n<blockquote>\n<div>\uc800\ud76c\ub294 myisam \uc2a4\ud1a0\ub9ac\uc9c0 \uc5d4\uc9c4\uc744 \uc0ac\uc6a9 \ud558\ub2e4\uac00 \uc5ec\ub7ec\uac00\uc9c0 \ubb38\uc81c\uc810 \ub54c\ubb38\uc5d0<a href=\"http:\/\/sphinxsearch.com\/\">Sphinx<\/a>\u00a0\uac80\uc0c9\uc5d4\uc9c4\uc744 \uc0ac\uc6a9 \ud558\uace0 \uc788\uc2b5\ub2c8\ub2e4.\u00a0\uc704\uce58\uac80\uc0c9, \ud55c\uae00 \uac80\uc0c9, \ube44 \ud14d\uc2a4\ud2b8 \uac80\uc0c9 \ubaa8\ub450\uc5d0\uc11c \ub9e4\uc6b0 \ube60\ub978 \uc131\ub2a5\uc744 \ubcf4\uc5ec\uc90d\ub2c8\ub2e4. \uac8c\ub2e4\uac00 \ud655\uc7a5\uc131\uc774 \uc88b\uc544\uc11c \uc800\uac00 \uc11c\ubc84\uc5d0 \ubd84\uc0b0 \ubc30\uce58\ud574\ub450\uc5c8\ub294\ub370 \ub85c\ub4dc\uac00 \uac70\uc758 \uc5c6\uc5c8\uc2b5\ub2c8\ub2e4.<\/div>\n<\/blockquote>\n<p>&nbsp;<\/p>\n<p><strong>6. \ub9c8\uc2a4\ud130 \uc11c\ubc84 \uc7a5\uc560 \ubcf5\uad6c \uc194\ub8e8\uc158\uc740 \ubb50\uac00 \uc88b\ub098\uc694?<\/strong><\/p>\n<blockquote>\n<div>\uc800\ud76c\ub294 MariaDB Galera \ub97c \uac80\ud1a0\uc911\uc5d0 \uc788\uc2b5\ub2c8\ub2e4. MySQL MHA, MySQL MMM \uc744 \uc0ac\uc6a9\ud558\ub294\uac83 \ubcf4\ub2e4 \uc124\uc815\uc774 \uac04\ud3b8\ud558\uace0 \ubcf5\uc7a1\ub3c4\uac00 \uc904\uc5b4\ub4ed\ub2c8\ub2e4.<a href=\"http:\/\/docs.linuxtone.org\/ebooks\/MySQL\/MySQL%20DRBD.pdf\">DRBD\uc640 Pacemaker\/Corosync \uc744 \uc774\uc6a9\ud55c \ubc29\ubc95<\/a>\uc5d0 \ube44\ud574\uc11c \uc4f0\uae30 \uc18d\ub3c4\uac00 \uc870\uae08 \ub5a8\uc5b4\uc9c0\uc9c0\ub9cc \uc77d\uae30 \uc18d\ub3c4\ub294 \uc11c\ubc84\ub97c \ucd94\uac00\ud560 \ub54c \ub9c8\ub2e4 \ub192\uc544\uc9d1\ub2c8\ub2e4.<\/div>\n<\/blockquote>\n<blockquote>\n<div><a href=\"http:\/\/www.percona.com\/files\/presentations\/percona-live\/london-2011\/PLUK2011-choosing-a-mysql-replication-high-availability-solution.pdf\">DRBD \uae30\ubc18\uacfc Galera \ub97c \ube44\uad50\ud55c \uc790\ub8cc<\/a>\ub97c \ucc38\uace0\ud558\uc138\uc694<\/div>\n<\/blockquote>\n<p>&nbsp;<\/p>\n<p><strong>7. \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \ubaa8\ub2c8\ud130\ub9c1 \ud558\ub294 \uc88b\uc740 \ubc29\ubc95\uc774 \ubb58\uae4c\uc694?<\/strong><\/p>\n<blockquote>\n<div>\n<div>\n<div>\n<div>\n<p><a href=\"http:\/\/www.webyog.com\/product\/monyog\">MONyog<\/a>\ub97c \ucd94\ucc9c\ud569\ub2c8\ub2e4.<\/p>\n<ul>\n<li>\uc2e4\uc2dc\uac04\uc73c\ub85c \ucffc\ub9ac\ub97c \ubd84\uc11d\ud558\uace0 \ub290\ub9b0 \ucffc\ub9ac\ub4e4\uc744 \ucde8\ud569\ud558\uc5ec \uac00\uc7a5 \ub290\ub9b0 \ucffc\ub9ac\ubd80\ud130 \uac1c\uc120\ud560 \uc218 \uc788\ub2e4.<\/li>\n<li>\uc5b4\ub5a4 \ucffc\ub9ac\uac00 Lock \uc744 \uc720\ubc1c\ud558\ub294\uc9c0 \uc54c \uc218 \uc788\ub2e4. \ub180\ub77c\uc6b4\uac83\uc740, \uc5b4\ub5a4 \ucffc\ub9ac\uac00 Lock\uc5d0 \uc601\ud5a5\uc744 \ubc1b\uc558\ub294\uc9c0 \uae4c\uc9c0 \uc54c \uc218 \uc788\ub2e4. \ud658\uc0c1\uc801\uc774\ub2e4.<\/li>\n<li>Cache Miss \uac19\uc740 \uac83\uc774 \uc5b4\ub5a4\uacf3\uc5d0\uc11c \ubc1c\uc0dd\ud558\ub294\uc9c0\ub97c \ubcf4\uace0 \uba54\ubaa8\ub9ac\ub97c \ub298\ub824\uc57c \ud558\ub294\uc9c0 \ub4f1\uc744 \uacb0\uc815\ud560 \uc218 \uc788\uac8c \ud574\uc900\ub2e4.<\/li>\n<li>Connection Refuse \uac00 \uc5bc\ub9c8\ub098 \uc77c\uc5b4\ub098\ub294\uc9c0 \ud655\uc778\uac00\ub2a5\ud558\ub2e4.<\/li>\n<li>\uc5b4\ub5a4 \ud14c\uc774\ube14\uc774 \ub9ce\uc774 \uc811\uadfc\ub418\ub294\uc9c0 \uc54c \uc218 \uc788\ub2e4. (\uac00\uc7a5 \uc811\uadfc\uc774 \ub9ce\uc740 \ud14c\uc774\ube14 \ubd80\ud130 \ucd5c\uc801\ud654\ub97c \ud560 \uc218 \uc788\ub2e4)<\/li>\n<\/ul>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/blockquote>\n<p><strong>8. \ud2b8\ub9ac\uac70(Trigger)\ub97c \uc0ac\uc6a9\ud574\uc57c \ud558\ub098 \ub9d0\uc544\uc57c \ud558\ub098?<\/strong><\/p>\n<blockquote><p>\uc694\uad6c\uc0ac\ud56d \ub9c8\ub2e4 \ub2e4\ub97c\uac83\uc785\ub2c8\ub2e4. \uc800\ud76c\uc758 \uacbd\ud5d8\uc73c\ub85c\ub294 \ud2b8\ub9ac\uac70\ub97c \uc0ac\uc6a9\ud558\uba74 \uad49\uc7a5\ud788 \uc77c\uc774 \ud3b8\ud574\uc9c0\uae34 \ud558\uc9c0\ub9cc \ud2b8\ub9ac\uac70\ub97c \ubcc0\uacbd\ud558\ub294 \ud574\uc57c\ud558\ub294 \uacbd\uc6b0 \uc0ad\uc81c\ud558\uace0 \ub2e4\uc2dc \uc0dd\uc131 \ud574\uc57c \ud558\ub294\ub370 Lock \uc774 \uac78\ub824\uc11c \uc11c\ube44\uc2a4\uac00 \uc7a0\uc2dc \uc911\ub2e8\ub418\ub294 \ubb38\uc81c\uac00 \uc788\uace0 \uc704\uc5d0\uc11c \uc5b8\uae09\ud55c \uac83 \ucc98\ub7fc \uc2e4\uc2dc\uac04\uc73c\ub85c \uc2a4\ud0a4\ub9c8\ub97c \ubcc0\uacbd\ud558\ub294\ub370 \uac78\ub9bc\ub3cc\uc774 \ub429\ub2c8\ub2e4. \uadf8\ub798\uc11c \uac00\ub2a5\ud558\uba74 \uc800\ud76c\ub294 \uc5b4\ud50c\ub9ac\ucf00\uc774\uc158 \ub2e8\uc5d0\uc11c \ud574\uacb0\ud558\ub824\uace0 \ud569\ub2c8\ub2e4.<\/p><\/blockquote>\n<p><strong>9. \ub85c\uadf8\uc131 \ub370\uc774\ud130 \uad00\ub9ac\ub294?<\/strong><\/p>\n<blockquote><p>\uc800\ud76c\ub294 Data-driven \ubc29\uc2dd\uc73c\ub85c \uc11c\ube44\uc2a4\ub97c \uac1c\uc120\ud574 \ub098\uac00\uace0 \uc788\uc2b5\ub2c8\ub2e4. \uadf8\ub7ec\uae30 \uc704\ud574\uc11c\ub294 \ub85c\uadf8\ub97c \uc798 \uc313\uc544\uc57c \ud558\ub294\ub370\uc694, Google Analytics \ub098 Flurry\ub97c \uc798\ub9cc \ud65c\uc6a9\ud558\uba74 \ub2e4\uc591\ud55c \ubd84\uc11d\uacfc \uace0\uac1d \uc138\ubd84\ud654 \uae4c\uc9c0 \ud560 \uc218\uac00 \uc788\uc2b5\ub2c8\ub2e4. \uadf8\ub7ec\ub098 \uc790\uccb4\uc801\uc73c\ub85c \ub370\uc774\ud130\ub97c \uc313\uc544\uc57c \ud558\ub294 \uacbd\uc6b0\uac00 \uc788\uc744 \ub54c\ub294\u00a0<a href=\"http:\/\/redis.io\/\" target=\"_blank\" rel=\"noopener\">Redis<\/a>\uc5d0 \uc21c\ucc28\uc801\uc73c\ub85c \uc800\uc7a5\ud558\uace0 1\ubd84\uc5d0 \ud55c\ubc88\uc529 MySQL\uc5d0 \ubc8c\ud06c\ub85c \uc800\uc7a5\ud569\ub2c8\ub2e4.<\/p><\/blockquote>\n<p><strong>\uc81c\uac00 \uc0dd\uac01\ud558\ub294 MySQL\uc758 \uc7a5\uc810<\/strong><\/p>\n<blockquote>\n<div>\n<div>\n<div>\n<div>\uc628\ub77c\uc778 \uc2a4\ud0a4\ub9c8 \ubcc0\uacbd, \uace0\uac00\uc6a9\uc131 \ub54c\ubb38\uc5d0 NoSQL\uc744 \uace0\ub824\ud55c\uc801\uc774 \ub9ce\uc558\uc73c\ub098 MySQL\uc5d0\uc11c \ud574\uacb0 \uac00\ub2a5\ud569\ub2c8\ub2e4.\u00a0NoSQL\uc740 \uc219\ub828\ub41c \uc778\ub825\uc744 \uad6c\ud558\uae30 \ud798\ub4e4\uae30 \ub54c\ubb38\uc5d0 \uac1c\ubc1c \ube44\uc6a9\uc774 \ub354 \uc62c\ub77c\uac08 \uc218 \uc788\uace0\u00a0\ub370\uc774\ud130 \ubd84\uc11d\uc5d0 SQL \ub9cc\ud07c \uc88b\uc740 \uc778\ud130\ud398\uc774\uc2a4\ub97c \uac00\uc9c4 \uac83\uc774 \ubcc4\ub85c \uc5c6\ub294\uac83 \uac19\uc2b5\ub2c8\ub2e4.\u00a0\uc6b0\ub9ac \ud68c\uc0ac\uc5d0\uc11c\ub294 \uac1c\ubc1c\uc790 \uc544\ub2cc \uc0ac\ub78c\ub4e4\uc774 \ubd84\uc11d\uc744 \ub9ce\uc774 \ud558\ub294\ub370 SQL\uc73c\ub85c \ubd84\uc11d\ud558\ub294\ub370\uc694 NoSQL\uc744 \uc0ac\uc6a9\ud588\ub2e4\uba74 \uc870\uae08 \ud798\ub4e4\uc9c0 \uc54a\uc558\uc744\uae4c\uc694? \uc2a4\ud0c0\ud2b8\uc5c5\uc5d0\uac8c MySQL \uc740 \uc88b\uc740 \uc120\ud0dd\uc778\uac83 \uac19\uc2b5\ub2c8\ub2e4.<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/blockquote>\n<div>\n<div><\/div>\n<div><strong>MySQL \ucd94\ucc9c \uc0ac\uc774\ud2b8<\/strong><\/div>\n<div>\n<ul>\n<li><a href=\"http:\/\/www.percona.com\/resources\/technical-presentations\/2013?sort_by=field_talk_date_value&amp;sort_order=DESC\">MySQL Technical Presentations 2013<\/a><\/li>\n<li><a href=\"http:\/\/www.percona.com\/\">http:\/\/www.percona.com\/<\/a><\/li>\n<li><a href=\"http:\/\/www.mariadb.org\/\">http:\/\/www.mariadb.org\/<\/a><\/li>\n<li><a href=\"https:\/\/code.google.com\/p\/shard-query\/\">https:\/\/code.google.com\/p\/shard-query\/<\/a><\/li>\n<\/ul>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>\uc9c0\ub09c 3\ub144\uac04 \ubc88\uac1c\uc7a5\ud130 \uc11c\ube44\uc2a4\ub97c \uc6b4\uc601\ud558\uba74\uc11c \uc5bb\uc740 MySQL \uc6b4\uc601 \ud301\uc744 \uc54c\ub824\ub4dc\ub9bd\ub2c8\ub2e4. 1. \uc11c\ube44\uc2a4 \uc911\uc778 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \ud14c\uc774\ube14\uc758 \uc2a4\ud0a4\ub9c8\ub97c \uc11c\ube44\uc2a4 \uc911\ub2e8 \uc5c6\uc774 \ubcc0\uacbd\ud558\ub824\uba74? InnoDB \uc2a4\ud1a0\ub9ac\uc9c0\uc758 \uacbd\uc6b0 \uc2a4\ud0a4\ub9c8\ub97c \ubcc0\uacbd\ud558\uba74 \ubcc0\uacbd\uc774 \uc644\ub8cc\ub420 \ub54c \uae4c\uc9c0 Lock \uc774 \uac78\ub9ac\uac8c \ub418\uc5b4 \uc11c\ube44\uc2a4\uac00 \uc7a0\uc2dc \uc911\ub2e8 \ub418\uc5b4\uc57c \ud588\uc2b5\ub2c8\ub2e4. \uadf8\ub798\uc11c \uc800\ud76c\ub294\u00a0Percona Toolkit\u00a0\uc758 pt-online-schema-change \uae30\ub2a5\uc744 \uc0ac\uc6a9 \ud558\uc5ec \uc911\ub2e8 \uc5c6\uc774 \ubcc0\uacbd\ud569\ub2c8\ub2e4. \uc0ac\uc6a9 \ubc29\ubc95\ub3c4 \uac04\ub2e8\ud558\uace0 \ub098\ub984 \uc548\uc815\uc131\uc774 \uc788\ub2e4\uace0 \ud569\ub2c8\ub2e4. &hellip; <a href=\"http:\/\/www.freesens.com\/x\/?p=579\" class=\"more-link\">Continue reading <span class=\"screen-reader-text\">MySQL \ud301<\/span> <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[17],"tags":[140,141],"class_list":["post-579","post","type-post","status-publish","format-standard","hentry","category-etc","tag-dbms","tag-mysql"],"_links":{"self":[{"href":"http:\/\/www.freesens.com\/x\/index.php?rest_route=\/wp\/v2\/posts\/579","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.freesens.com\/x\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.freesens.com\/x\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.freesens.com\/x\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.freesens.com\/x\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=579"}],"version-history":[{"count":2,"href":"http:\/\/www.freesens.com\/x\/index.php?rest_route=\/wp\/v2\/posts\/579\/revisions"}],"predecessor-version":[{"id":886,"href":"http:\/\/www.freesens.com\/x\/index.php?rest_route=\/wp\/v2\/posts\/579\/revisions\/886"}],"wp:attachment":[{"href":"http:\/\/www.freesens.com\/x\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=579"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.freesens.com\/x\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=579"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.freesens.com\/x\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=579"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}