{"id":266,"date":"2009-04-29T20:23:29","date_gmt":"2009-04-29T11:23:29","guid":{"rendered":"https:\/\/deskplate.net\/blog\/2009\/04\/29\/mysql-max_connections\/"},"modified":"2009-04-29T20:23:29","modified_gmt":"2009-04-29T11:23:29","slug":"mysql-max_connections","status":"publish","type":"post","link":"https:\/\/deskplate.net\/blog\/archives\/266","title":{"rendered":"MySQL max_connections"},"content":{"rendered":"<p>Too many connections \u30a8\u30e9\u30fc<br \/>\nMySQL \u306b\u63a5\u7d9a\u3057\u3088\u3046\u3068\u3057\u3066 Too many connections \u30a8\u30e9\u30fc\u304c\u767a\u751f\u3059\u308b\u5834\u5408\u306f\u3001\u3059\u3067\u306b mysqld \u30b5\u30fc\u30d0\u306b\u63a5\u7d9a\u3057\u3066\u3044\u308b max_connections \u30af\u30e9\u30a4\u30a2\u30f3\u30c8\u304c\u5b58\u5728\u3057\u3066\u3044\u307e\u3059\u3002<br \/>\n\u30c7\u30d5\u30a9\u30eb\u30c8\uff08100\uff09\u3088\u308a\u591a\u3044\u63a5\u7d9a\u3092\u884c\u3046\u5834\u5408\u306f\u3001max_connections \u5909\u6570\u306e\u5024\u3092 100 \u3088\u308a\u5927\u304d\u304f\u3057\u3066\u3001mysqld \u3092\u518d\u8d77\u52d5\u3059\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002<br \/>\n\u300cmysqladmin -uroot -p variables | grep max_connections\u300d\u30b3\u30de\u30f3\u30c9\u3067\u78ba\u8a8d\u3067\u304d\u307e\u3059<br \/>\n\/etc\/my.cnf \u306e[mysqld] \u4ee5\u4e0b\u306e\u5909\u6570\u5b9a\u7fa9\u306b\u300cmax_connections=500\u300d\u3092\u8ffd\u52a0\u3057\u3066\u518d\u8d77\u52d5<br \/>\n# mysqladmin -uroot -p variables | grep max_connections<br \/>\n| max_connections                 | 500<br \/>\n\u4ed6\u3001\u78ba\u8a8d\u30b3\u30de\u30f3\u30c9<br \/>\nmysqladmin -uroot -p extended-status | egrep &#8216;Max|Threads&#8217;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Too many connections<\/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-266","post","type-post","status-publish","format-standard","hentry","category-mysql"],"_links":{"self":[{"href":"https:\/\/deskplate.net\/blog\/wp-json\/wp\/v2\/posts\/266","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=266"}],"version-history":[{"count":0,"href":"https:\/\/deskplate.net\/blog\/wp-json\/wp\/v2\/posts\/266\/revisions"}],"wp:attachment":[{"href":"https:\/\/deskplate.net\/blog\/wp-json\/wp\/v2\/media?parent=266"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/deskplate.net\/blog\/wp-json\/wp\/v2\/categories?post=266"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/deskplate.net\/blog\/wp-json\/wp\/v2\/tags?post=266"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}