{"id":1048,"date":"2012-11-27T22:11:32","date_gmt":"2012-11-27T13:11:32","guid":{"rendered":"http:\/\/www.mogumagu.com\/wp\/wordpress\/?p=1048"},"modified":"2012-11-27T22:11:32","modified_gmt":"2012-11-27T13:11:32","slug":"mysql%e3%81%ae%e3%83%90%e3%82%a4%e3%83%8a%e3%83%aa%e3%83%ad%e3%82%b0%e3%81%ae%e8%a8%ad%e5%ae%9a%e3%81%a8%e3%83%90%e3%82%a4%e3%83%8a%e3%83%aa%e3%83%ad%e3%82%b0%e3%82%92%e8%a6%8b%e3%82%8b%e3%82%b3","status":"publish","type":"post","link":"https:\/\/www.mogumagu.com\/wp\/wordpress\/archives\/1048","title":{"rendered":"mysql\u306e\u30d0\u30a4\u30ca\u30ea\u30ed\u30b0\u306e\u8a2d\u5b9a\u3068\u30d0\u30a4\u30ca\u30ea\u30ed\u30b0\u3092\u898b\u308b\u30b3\u30de\u30f3\u30c9\u30e1\u30e2"},"content":{"rendered":"<div class=\"65a9d09a7d046572b7ae2e4674a406ee\" data-index=\"1\" style=\"float: none; margin:10px 0 10px 0; text-align:center;\">\n<script type=\"text\/javascript\"><!--\r\ngoogle_ad_client = \"ca-pub-0496250084394782\";\r\ngoogle_ad_slot = \"5624605187\";\r\ngoogle_ad_width = 300;\r\ngoogle_ad_height = 250;\r\n\/\/-->\r\n<\/script>\r\n<script type=\"text\/javascript\"\r\nsrc=\"https:\/\/pagead2.googlesyndication.com\/pagead\/show_ads.js\">\r\n<\/script>\n<\/div>\n<h2>mysql\u306e\u30d0\u30a4\u30ca\u30ea\u30ed\u30b0\u306e\u8a2d\u5b9a\u3068\u30d0\u30a4\u30ca\u30ea\u30ed\u30b0\u3092\u898b\u308b\u30b3\u30de\u30f3\u30c9\u30e1\u30e2<\/h2>\n<p>\u8a2d\u5b9a\u3057\u3066\u308b\u304f\u305b\u306b\u3088\u304f\u5fd8\u308c\u308b\u306e\u3067\u3002<\/p>\n<p>my.cnf\u306e\u8a2d\u5b9a<br \/>\n\u25a0\u30d0\u30a4\u30ca\u30ea\u30ed\u30b0\u3092\u6709\u52b9\u306b\u3059\u308b<\/p>\n<pre class=\"brush: plain; title: ; notranslate\" title=\"\">\r\n[mysqld]\r\n#\u30d0\u30a4\u30ca\u30ea\u30ed\u30b0\u6709\u52b9\u5316\r\nlog-bin=mysql-bin\r\n<\/pre>\n<p>mysql\u306e\u518d\u8d77\u52d5\u3059\u308b\u3002<\/p>\n<p>\u3069\u3053\u306b\u51fa\u529b\u3055\u308c\u3066\u308b\u306e\u304b\uff1f<\/p>\n<pre class=\"brush: plain; title: ; notranslate\" title=\"\">\r\n# pwd\r\n\/var\/lib\/mysql\r\n# ls -al | grep mysql-bin\r\n-rw-rw----   1 mysql mysql    19791 11\u6708 21 17:22 2012 mysql-bin.000001\r\n-rw-rw----   1 mysql mysql   744930 11\u6708 21 17:22 2012 mysql-bin.000002\r\n-rw-rw----   1 mysql mysql      441 11\u6708 21 17:24 2012 mysql-bin.000003\r\n-rw-rw----   1 mysql mysql   335058 11\u6708 27 17:27 2012 mysql-bin.000004\r\n-rw-rw----   1 mysql mysql      106 11\u6708 27 17:27 2012 mysql-bin.000005\r\n-rw-rw----   1 mysql mysql       95 11\u6708 27 17:27 2012 mysql-bin.index\r\n<\/pre>\n<p>\u3053\u3093\u306a\u611f\u3058\u3067\u30d5\u30a1\u30a4\u30eb\u306b\u51fa\u308b\u3002<\/p>\n<pre class=\"brush: plain; title: ; notranslate\" title=\"\">\r\n# mysqlbinlog mysql-bin.000005\r\nmysqlbinlog: unknown variable 'default-character-set=utf8'\r\n<\/pre>\n<p>\u3053\u3093\u306a\u30a8\u30e9\u30fc\u304c\u3067\u305f\u3089\u3002\u3002<\/p>\n<pre class=\"brush: plain; title: ; notranslate\" title=\"\">\r\n# mysqlbinlog --no-defaults mysql-bin.000005\r\n<\/pre>\n<p>\u3068\u3059\u308b\u3068\u3044\u3044\u307f\u305f\u3044\u3002<br \/>\n\u3053\u308c\u306fmy.cnf \u306e [client] \u30bb\u30af\u30b7\u30e7\u30f3\u306b default-character-set \u304c\u3042\u308b\u306e\u304c\u554f\u984c\u3089\u3057\u3044\u3067\u3059\u3002<\/p>\n<p>\u25a0\u30af\u30a8\u30ea\u30ed\u30b0\u3092\u6709\u52b9\u306b\u3059\u308b<\/p>\n<pre class=\"brush: plain; title: ; notranslate\" title=\"\">\r\n[mysqld]\r\n#\u30af\u30a8\u30ea\u30ed\u30b0\u8a2d\u5b9a\r\nlog=\/var\/lib\/mysql\/mysql_querry.log\r\n<\/pre>\n<p>mysql\u306e\u518d\u8d77\u52d5\u3059\u308b\u3002<\/p>\n<p>\u3069\u3053\u306b\u51fa\u529b\u3055\u308c\u3066\u308b\u306e\u304b\uff1f\uff08\u6307\u5b9a\u3057\u3066\u308b\u3051\u3069\u30fb\u30fb\u30fb\uff09<\/p>\n<pre class=\"brush: plain; title: ; notranslate\" title=\"\">\r\n# pwd\r\n\/var\/lib\/mysql\r\n# ls -al | grep mysql_querry\r\n-rw-rw----   1 mysql mysql   156836 11\u6708 27 17:41 2012 mysql_querry.log\r\n<\/pre>\n<p>\u672c\u756a\u904b\u7528\u3059\u308b\u5834\u5408\u306f\u30ed\u30b0\u306e\u5bb9\u91cf\u304c\u5927\u304d\u304f\u306a\u308b\u306e\u3067\u30af\u30a8\u30ea\u30ed\u30b0\u306f<br \/>\n\u51fa\u529b\u3057\u306a\u3044\u307b\u3046\u304c\u3044\u3044\u307f\u305f\u3044\u3002\u3042\u304f\u307e\u3067\u30c7\u30d0\u30c3\u30b0\u7528\u3067\u3002<\/p>\n<p>\u25a0\u53c2\u8003\u30b5\u30a4\u30c8<br \/>\n<a href=\"http:\/\/open-groove.net\/mysql\/mysql-binlog\/\" target=\"_blank\">MySQL\u30d0\u30a4\u30ca\u30ea\u30ed\u30b0\u306e\u4ed5\u69d8<\/a><\/p>\n<p><a href=\"http:\/\/dev.mysql.com\/doc\/refman\/5.1\/ja\/mysqlbinlog.html\" target=\"_blank\">7.10. mysqlbinlog \u2014 \u30d0\u30a4\u30ca\u30ea\u30ed\u30b0\u30d5\u30a1\u30a4\u30eb\u3092\u51e6\u7406\u3059\u308b\u305f\u3081\u306e\u30e6\u30fc\u30c6\u30a3\u30ea\u30c6\u30a3<\/a><\/p>\n<p><a href=\"http:\/\/satospo.sakura.ne.jp\/blog_archives\/tech\/linux_server\/mysql_log.html\" target=\"_blank\">MySQL\u3068\u30ed\u30b0<\/a><\/p>\n<p><a href=\"http:\/\/www.mysql.gr.jp\/mysqlml\/mysql\/msg\/12904\" target=\"_blank\">Subject: [mysql 12904] Re: mysqlbinlog\u306e\u52d5\u4f5c\u306b\u3064\u3044\u3066<\/a><\/p>\n<p><iframe loading=\"lazy\" style=\"width: 120px; height: 240px;\" src=\"http:\/\/rcm-jp.amazon.co.jp\/e\/cm?lt1=_blank&amp;bc1=000000&amp;IS2=1&amp;bg1=FFFFFF&amp;fc1=000000&amp;lc1=0000FF&amp;t=lax34weddojp-22&amp;o=9&amp;p=8&amp;l=as4&amp;m=amazon&amp;f=ifr&amp;ref=ss_til&amp;asins=4774150207\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\" width=\"320\" height=\"240\"><\/iframe><\/p>\n<p>\u3042\u30fc\u9f3b\u6c34\u6b62\u307e\u3089\u306a\u3044\u3002\u306e\u3069\u75db\u3044\u3002<\/p>\n<div class=\"65a9d09a7d046572b7ae2e4674a406ee\" data-index=\"3\" style=\"float: none; margin:10px 0 10px 0; text-align:center;\">\n<script type=\"text\/javascript\"><!--\r\namazon_ad_tag = \"lax34weddojp-22\"; amazon_ad_width = \"468\"; amazon_ad_height = \"60\"; amazon_ad_link_target = \"new\"; amazon_ad_border = \"hide\";\/\/--><\/script>\r\n<script type=\"text\/javascript\" src=\"https:\/\/www.assoc-amazon.jp\/s\/ads.js\"><\/script>\n<\/div>\n\n<div style=\"font-size: 0px; height: 0px; line-height: 0px; margin: 0; padding: 0; clear: both;\"><\/div>","protected":false},"excerpt":{"rendered":"<p>mysql\u306e\u30d0\u30a4\u30ca\u30ea\u30ed\u30b0\u306e\u8a2d\u5b9a\u3068\u30d0\u30a4\u30ca\u30ea\u30ed\u30b0\u3092\u898b\u308b\u30b3\u30de\u30f3\u30c9\u30e1\u30e2 \u8a2d\u5b9a\u3057\u3066\u308b\u304f\u305b\u306b\u3088\u304f\u5fd8\u308c\u308b\u306e\u3067\u3002 my.cnf\u306e\u8a2d\u5b9a \u25a0\u30d0\u30a4\u30ca\u30ea\u30ed\u30b0\u3092\u6709\u52b9\u306b\u3059\u308b mysql\u306e\u518d\u8d77\u52d5\u3059\u308b\u3002 \u3069\u3053\u306b\u51fa\u529b\u3055\u308c\u3066\u308b\u306e\u304b\uff1f \u3053\u3093\u306a\u611f\u3058\u3067\u30d5\u30a1\u30a4\u30eb\u306b [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_mi_skip_tracking":false},"categories":[9,25],"tags":[],"_links":{"self":[{"href":"https:\/\/www.mogumagu.com\/wp\/wordpress\/wp-json\/wp\/v2\/posts\/1048"}],"collection":[{"href":"https:\/\/www.mogumagu.com\/wp\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.mogumagu.com\/wp\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.mogumagu.com\/wp\/wordpress\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.mogumagu.com\/wp\/wordpress\/wp-json\/wp\/v2\/comments?post=1048"}],"version-history":[{"count":6,"href":"https:\/\/www.mogumagu.com\/wp\/wordpress\/wp-json\/wp\/v2\/posts\/1048\/revisions"}],"predecessor-version":[{"id":1054,"href":"https:\/\/www.mogumagu.com\/wp\/wordpress\/wp-json\/wp\/v2\/posts\/1048\/revisions\/1054"}],"wp:attachment":[{"href":"https:\/\/www.mogumagu.com\/wp\/wordpress\/wp-json\/wp\/v2\/media?parent=1048"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.mogumagu.com\/wp\/wordpress\/wp-json\/wp\/v2\/categories?post=1048"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.mogumagu.com\/wp\/wordpress\/wp-json\/wp\/v2\/tags?post=1048"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}