{"title":" table_cache, max_connections, open_files_limit \u306e\u95a2\u4fc2","version":"1.0","provider_url":"https://hatena.blog","provider_name":"Hatena Blog","author_url":"https://blog.hatena.ne.jp/tmtms/","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fblog.tmtms.net%2Fentry%2F20090605%2F1244215294\" title=\" table_cache, max_connections, open_files_limit \u306e\u95a2\u4fc2 - tmtms \u306e\u30e1\u30e2\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","blog_title":"tmtms \u306e\u30e1\u30e2","type":"rich","description":"\u6614\u306f\u30de\u30cb\u30e5\u30a2\u30eb\u306b\u66f8\u3044\u3066\u3042\u3063\u305f\u3088\u3046\u306a\u6c17\u304c\u3057\u305f\u3051\u3069\u3001\u6700\u8fd1\u306e\u30de\u30cb\u30e5\u30a2\u30eb\u306b\u306f\u898b\u5f53\u305f\u3089\u306a\u3044\u306e\u3067\u30e1\u30e2\u3002mysqld \u304c\u540c\u6642\u306b\u4f7f\u7528\u53ef\u80fd\u306a\u30d5\u30a1\u30a4\u30eb\u6570\u306f open_files_limit \u3068\u3044\u3046\u30d1\u30e9\u30e1\u30fc\u30bf\u3067\u6307\u5b9a\u3057\u307e\u3059\u3002\u305f\u3060\u3057\u3001mysqld \u306f\u6700\u4f4e\u3067\u3082 table_cache*2+max_connections+10 --- (a) \u306f\u5fc5\u8981\u3060\u3068\u8003\u3048\u308b\u306e\u3067\u3001open_files_limit \u304c (a) \u3088\u308a\u3082\u5c0f\u3055\u3051\u308c\u3070\u3001\u9ed9\u3063\u3066 (a) \u306e\u5024\u307e\u3067\u5927\u304d\u304f\u3057\u307e\u3059\u3002table_cache \u30922\u500d\u3057\u3066\u3044\u308b\u306e\u306f\u3001MyISAM \u304c1\u30c6\u30fc\u30d6\u30eb\u306b\u3064\u304d2\u30d5\u30a1\u30a4\u30eb\u4f7f\u7528\u3059\u308b\u305f\u3081\u3067\u3057\u3087\u3046\u300210 \u3092\u8db3\u3057\u3066\u3044\u308b\u306e\u306f\u6a19\u6e96\u5165\u51fa\u529b\u30a8\u30e9\u30fc\u51fa\u529b\u3068\u3001\u30ed\u30b0\u30d5\u2026","published":"2009-06-05 00:21:34","height":"190","url":"https://blog.tmtms.net/entry/20090605/1244215294","width":"100%","categories":["MySQL"],"blog_url":"https://blog.tmtms.net/","author_name":"tmtms","image_url":null}