{"id":2739,"date":"2016-08-26T18:26:21","date_gmt":"2016-08-26T09:26:21","guid":{"rendered":"http:\/\/blog.rutake.com\/techmemo\/?p=2739"},"modified":"2016-08-26T18:26:21","modified_gmt":"2016-08-26T09:26:21","slug":"mysqlmariadb-%e7%8f%be%e5%9c%a8%e3%81%ae%e6%8e%a5%e7%b6%9a%e6%95%b0%e3%81%a8%e6%9c%80%e5%a4%a7%e6%8e%a5%e7%b6%9a%e5%8f%af%e8%83%bd%e6%95%b0%e3%82%92%e7%a2%ba%e8%aa%8d%e3%81%99%e3%82%8b","status":"publish","type":"post","link":"https:\/\/blog.rutake.com\/techmemo\/2016\/08\/26\/mysqlmariadb-%e7%8f%be%e5%9c%a8%e3%81%ae%e6%8e%a5%e7%b6%9a%e6%95%b0%e3%81%a8%e6%9c%80%e5%a4%a7%e6%8e%a5%e7%b6%9a%e5%8f%af%e8%83%bd%e6%95%b0%e3%82%92%e7%a2%ba%e8%aa%8d%e3%81%99%e3%82%8b\/","title":{"rendered":"MySQL(MariaDB) \u73fe\u5728\u306e\u63a5\u7d9a\u6570\u3068\u6700\u5927\u63a5\u7d9a\u53ef\u80fd\u6570\u3092\u78ba\u8a8d\u3059\u308b"},"content":{"rendered":"

MySQL\u3092\u5229\u7528\u3057\u3066\u3044\u308b\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u3067\u30b3\u30cd\u30af\u30b7\u30e7\u30f3\u306e\u63a5\u7d9a\u5f85\u3061\u304c\u767a\u751f\u3057\u3066\u3044\u305f\u3002
\n\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u306e\u8a2d\u5b9a\u306e\u6700\u5927\u6570\u306e\u53ef\u80fd\u6027\u3082\u3042\u308b\u304c\u3001MySQL\u5074\u3067\u3082\u6700\u5927\u30b3\u30cd\u30af\u30b7\u30e7\u30f3\u6570\u3092\u8a2d\u5b9a\u3067\u304d\u308b\u3002<\/p>\n

\u30b5\u30fc\u30d0\u30fc\u306e\u6700\u5927\u5024\u306e\u8a2d\u5b9a\u306fmax_connections\u3067\u78ba\u8a8d\u3067\u304d\u308b\u3002<\/p>\n

[sql]
\nMariaDB [(none)]> show global variables like ‘%connection%’;
\n+————————–+——————-+
\n| Variable_name | Value |
\n+————————–+——————-+
\n| character_set_connection | latin1 |
\n| collation_connection | latin1_swedish_ci |
\n| extra_max_connections | 1 |
\n| max_connections | 151 |
\n| max_user_connections | 0 |
\n+————————–+——————-+
\n5 rows in set (0.00 sec)
\n[\/sql]<\/p>\n

\u30c7\u30d5\u30a9\u30eb\u30c8\u306f151\u306e\u3088\u3046\u3060\u3002<\/p>\n

\u4eca\u73fe\u5728\u306e\u63a5\u7d9a\u6570\u306fshow status\u3067\u78ba\u8a8d<\/p>\n

[sql]
\nMariaDB [(none)]> show status like ‘Threads_connected’;
\n+——————-+——-+
\n| Variable_name | Value |
\n+——————-+——-+
\n| Threads_connected | 1 |
\n+——————-+——-+
\n1 row in set (0.00 sec)
\n[\/sql]<\/p>\n","protected":false},"excerpt":{"rendered":"

MySQL\u3092\u5229\u7528\u3057\u3066\u3044\u308b\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u3067\u30b3\u30cd\u30af\u30b7\u30e7\u30f3\u306e\u63a5\u7d9a\u5f85\u3061\u304c\u767a\u751f\u3057\u3066\u3044\u305f\u3002 … \u7d9a\u304d\u3092\u8aad\u3080 →<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[7,147],"tags":[],"_links":{"self":[{"href":"https:\/\/blog.rutake.com\/techmemo\/wp-json\/wp\/v2\/posts\/2739"}],"collection":[{"href":"https:\/\/blog.rutake.com\/techmemo\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.rutake.com\/techmemo\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.rutake.com\/techmemo\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.rutake.com\/techmemo\/wp-json\/wp\/v2\/comments?post=2739"}],"version-history":[{"count":1,"href":"https:\/\/blog.rutake.com\/techmemo\/wp-json\/wp\/v2\/posts\/2739\/revisions"}],"predecessor-version":[{"id":2740,"href":"https:\/\/blog.rutake.com\/techmemo\/wp-json\/wp\/v2\/posts\/2739\/revisions\/2740"}],"wp:attachment":[{"href":"https:\/\/blog.rutake.com\/techmemo\/wp-json\/wp\/v2\/media?parent=2739"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.rutake.com\/techmemo\/wp-json\/wp\/v2\/categories?post=2739"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.rutake.com\/techmemo\/wp-json\/wp\/v2\/tags?post=2739"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}