{"id":1677,"date":"2014-06-11T18:56:53","date_gmt":"2014-06-11T14:56:53","guid":{"rendered":"http:\/\/yousite.ru\/?p=1677"},"modified":"2014-06-15T04:10:02","modified_gmt":"2014-06-15T00:10:02","slug":"mysql-%d0%b8-open_files_limit","status":"publish","type":"post","link":"https:\/\/yousite.ru\/?p=1677","title":{"rendered":"MySQL \u0438 open_files_limit"},"content":{"rendered":"<p><!--more--><\/p>\n<p>\u041f\u0440\u0438 \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u043d\u0438\u0438 Inndb MySQL \u043e\u0442\u043a\u0440\u044b\u0432\u0430\u0435\u0442 \u043c\u043d\u043e\u0433\u043e \u0444\u0430\u0439\u043b\u043e\u0432 \u0438 \u043f\u0430\u0434\u0430\u0435\u0442 -&gt; \u0443\u043f\u0438\u0440\u0430\u0435\u0442\u0441\u044f \u0432 \u043b\u0438\u043c\u0438\u0442 (1024 \u043e\u0442\u043a\u0440\u044b\u0442\u044b\u0445 \u0444\u0430\u0439\u043b\u043e\u0432).<br \/>\n\u0421\u043c\u043e\u0442\u0440\u0438\u043c \u0441\u043a\u043e\u043b\u044c\u043a\u043e \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u0443\u0435\u0442<\/p>\n<blockquote><p>lsof -u mysql | wc -l<\/p><\/blockquote>\n<p>\u0415\u0441\u043b\u0438 \u0436\u0435 \u043e\u043d\u043e \u043f\u0440\u0438\u0431\u043b\u0438\u0436\u0430\u0435\u0442\u0441\u044f \u043a 1024, \u0442\u043e \u0441\u0442\u043e\u0438\u0442 \u0432 \u0431\u043b\u043e\u043a [mysqld] \u0444\u0430\u0439\u043b\u0430 my.cnf \u0434\u043e\u0431\u0430\u0432\u0438\u0442\u044c \u0441\u043b\u0435\u0434\u0443\u044e\u0449\u0435\u0435:<\/p>\n<blockquote><p>open_files_limit = 8192<\/p><\/blockquote>\n<p>\u0418 \u043f\u0435\u0440\u0435\u0437\u0430\u043f\u0443\u0441\u0442\u0438\u0442\u044c \u0421\u0423\u0411\u0414:<\/p>\n<blockquote><p>\/etc\/init.d\/mysqld restart<\/p><\/blockquote>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":1678,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[16],"tags":[],"class_list":["post-1677","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-linux"],"_links":{"self":[{"href":"https:\/\/yousite.ru\/index.php?rest_route=\/wp\/v2\/posts\/1677","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/yousite.ru\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/yousite.ru\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/yousite.ru\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/yousite.ru\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1677"}],"version-history":[{"count":2,"href":"https:\/\/yousite.ru\/index.php?rest_route=\/wp\/v2\/posts\/1677\/revisions"}],"predecessor-version":[{"id":1698,"href":"https:\/\/yousite.ru\/index.php?rest_route=\/wp\/v2\/posts\/1677\/revisions\/1698"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/yousite.ru\/index.php?rest_route=\/wp\/v2\/media\/1678"}],"wp:attachment":[{"href":"https:\/\/yousite.ru\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1677"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/yousite.ru\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1677"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/yousite.ru\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1677"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}