{"id":313,"date":"2010-02-11T16:45:50","date_gmt":"2010-02-11T07:45:50","guid":{"rendered":"https:\/\/deskplate.net\/blog\/2010\/02\/11\/mysql-%e6%9c%80%e5%a4%a7%e6%8e%a5%e7%b6%9a%e6%95%b0%e5%a4%89%e6%9b%b4\/"},"modified":"2010-02-11T16:45:50","modified_gmt":"2010-02-11T07:45:50","slug":"mysql-%e6%9c%80%e5%a4%a7%e6%8e%a5%e7%b6%9a%e6%95%b0%e5%a4%89%e6%9b%b4","status":"publish","type":"post","link":"https:\/\/deskplate.net\/blog\/archives\/313","title":{"rendered":"MySQL \u6700\u5927\u63a5\u7d9a\u6570\u5909\u66f4"},"content":{"rendered":"

\u3053\u3093\u306a\u98a8\u306b\u3059\u308b
\nmysql> show variables like ‘%connection%’;
\n+————————–+—————–+
\n| Variable_name | Value |
\n+————————–+—————–+
\n| character_set_connection | utf8 |
\n| collation_connection | utf8_general_ci |
\n| max_connections | 100 |
\n| max_user_connections | 0 |
\n+————————–+—————–+
\n4 rows in set (0.00 sec)
\nmysql> set global max_connections=512;
\nQuery OK, 0 rows affected (0.00 sec)
\nmysql> show variables like ‘%connection%’;
\n+————————–+—————–+
\n| Variable_name | Value |
\n+————————–+—————–+
\n| character_set_connection | utf8 |
\n| collation_connection | utf8_general_ci |
\n| max_connections | 512 |
\n| max_user_connections | 0 |
\n+————————–+—————–+
\n4 rows in set (0.00 sec)<\/p>\n","protected":false},"excerpt":{"rendered":"

\u3053\u3093\u306a\u98a8\u306b\u3059\u308b mysql> show <\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[12],"tags":[],"class_list":["post-313","post","type-post","status-publish","format-standard","hentry","category-mysql"],"_links":{"self":[{"href":"https:\/\/deskplate.net\/blog\/wp-json\/wp\/v2\/posts\/313","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/deskplate.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/deskplate.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/deskplate.net\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/deskplate.net\/blog\/wp-json\/wp\/v2\/comments?post=313"}],"version-history":[{"count":0,"href":"https:\/\/deskplate.net\/blog\/wp-json\/wp\/v2\/posts\/313\/revisions"}],"wp:attachment":[{"href":"https:\/\/deskplate.net\/blog\/wp-json\/wp\/v2\/media?parent=313"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/deskplate.net\/blog\/wp-json\/wp\/v2\/categories?post=313"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/deskplate.net\/blog\/wp-json\/wp\/v2\/tags?post=313"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}