{"id":1782,"date":"2016-09-13T23:12:04","date_gmt":"2016-09-13T14:12:04","guid":{"rendered":"http:\/\/blog.4star.link\/?p=1782"},"modified":"2016-09-13T23:12:47","modified_gmt":"2016-09-13T14:12:47","slug":"mysql-%e3%80%8e%e3%83%ad%e3%83%83%e3%82%af%e9%96%a2%e9%80%a3%e3%80%8f%e3%81%ae%e5%85%a5%e9%96%80%e3%83%a1%e3%83%a2","status":"publish","type":"post","link":"https:\/\/blog.4star.link\/?p=1782","title":{"rendered":"MySQL \u300e\u30ed\u30c3\u30af\u95a2\u9023\u300f\u306e\u5165\u9580\u30e1\u30e2"},"content":{"rendered":"<p>\u305f\u307e\u306b\u3057\u304b\u4f7f\u308f\u306a\u3044\u306e\u3067\u3001\u3088\u304f\u5fd8\u308c\u3066\u3057\u307e\u3046MySQL\u306e\u30ed\u30c3\u30af\u51e6\u7406\u3002<\/p>\n<p>\u3053\u306e\u6a5f\u4f1a\u30e1\u30e2\uff01<\/p>\n<h3>mysqldump \u6642\u306bread lock \uff08\u8aad\u307f\u8fbc\u307f\u306e\u307f\u8a31\u53ef\uff09\u3092\u3059\u308b\u969b\u306f\u3001\u4e0b\u8a18\u30aa\u30d7\u30b7\u30e7\u30f3\u3092\u3064\u3051\u308b\u3002<\/h3>\n<pre><code><br \/>mysqldump -u root -p --lock-all-tables -A &gt; dump20110120.sql\n\n<\/code><\/pre>\n<p>\u300c&#8211;lock-all-tables\u300d\u3000\uff1d\u3000FLUSH TABLES WITH READ LOCK\u3068\u540c\u3058\u3002\uff08\u5168\u30c6\u30fc\u30d6\u30eb\u3092read\u30ed\u30c3\u30af\uff09<\/p>\n<h3>\u30c6\u30fc\u30d6\u30eb\u3092read\u30ed\u30c3\u30af<\/h3>\n<pre><code><br \/>mysql&gt; LOCK TABLES friends READ;    READ\u30ed\u30c3\u30af\u3092\u53d6\u5f97\n\n<\/code><\/pre>\n<pre><code><br \/>mysql&gt; LOCK TABLES friends WRITE;   WRITE\u30ed\u30c3\u30af\u3092\u53d6\u5f97\n\n<\/code><\/pre>\n<pre><code><br \/>mysql&gt; LOCK TABLES table_a READ, table_b WRITE;  \u8907\u6570\u306e\u30c6\u30fc\u30d6\u30eb\u3092\u540c\u6642\u306b\u30ed\u30c3\u30af\n\n<\/code><\/pre>\n<h3>\u30c6\u30fc\u30d6\u30eb\u306e\u30ed\u30c3\u30af\u3092\u89e3\u9664\u3059\u308b\u5834\u5408\u306f\u3001\u4ee5\u4e0b\u306e\u3088\u3046\u306b\u3059\u308b\u3002<\/h3>\n<pre><code><br \/>mysql&gt; UNLOCK TABLES;\n\n<\/code><\/pre>\n<p>\u203b\u30ed\u30c3\u30af\u4e2d\u306f\u3001\u6319\u52d5\u3068\u3057\u3066select\u3084update\u3092\u3057\u305f\u969b\u306b\u3001\u30ed\u30c3\u30af\u304c\u306f\u305a\u308c\u308b\u307e\u3067\u5fdc\u7b54\u3092\u307e\u3064\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u305f\u307e\u306b\u3057\u304b\u4f7f\u308f\u306a\u3044\u306e\u3067\u3001\u3088\u304f\u5fd8\u308c\u3066\u3057\u307e\u3046MySQL\u306e\u30ed\u30c3\u30af\u51e6\u7406\u3002 \u3053\u306e\u6a5f\u4f1a\u30e1\u30e2\uff01 mysqldump \u6642\u306bread lock \uff08\u8aad\u307f\u8fbc\u307f\u306e\u307f\u8a31\u53ef\uff09\u3092\u3059\u308b\u969b\u306f\u3001\u4e0b\u8a18\u30aa\u30d7\u30b7\u30e7\u30f3\u3092\u3064\u3051\u308b\u3002 mysqldump -u root  &hellip; <\/p>\n<p class=\"link-more\"><a href=\"https:\/\/blog.4star.link\/?p=1782\" class=\"more-link\"><span class=\"screen-reader-text\">&#8220;MySQL \u300e\u30ed\u30c3\u30af\u95a2\u9023\u300f\u306e\u5165\u9580\u30e1\u30e2&#8221; \u306e<\/span>\u7d9a\u304d\u3092\u8aad\u3080<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[223,263],"tags":[31],"class_list":["post-1782","post","type-post","status-publish","format-standard","hentry","category-223","category-263","tag-mysql"],"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/blog.4star.link\/index.php?rest_route=\/wp\/v2\/posts\/1782"}],"collection":[{"href":"https:\/\/blog.4star.link\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.4star.link\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.4star.link\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.4star.link\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1782"}],"version-history":[{"count":1,"href":"https:\/\/blog.4star.link\/index.php?rest_route=\/wp\/v2\/posts\/1782\/revisions"}],"predecessor-version":[{"id":1783,"href":"https:\/\/blog.4star.link\/index.php?rest_route=\/wp\/v2\/posts\/1782\/revisions\/1783"}],"wp:attachment":[{"href":"https:\/\/blog.4star.link\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1782"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.4star.link\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1782"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.4star.link\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1782"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}