{"id":277,"date":"2017-03-09T23:11:31","date_gmt":"2017-03-09T20:11:31","guid":{"rendered":"https:\/\/galaxydata.ru\/community\/?p=277"},"modified":"2025-07-23T00:17:16","modified_gmt":"2025-07-22T21:17:16","slug":"uvelichenie-limita-open-files-limit-v-mariadb-on-centos-7-s-pomoshhyu-systemd","status":"publish","type":"post","link":"https:\/\/galaxydata.ru\/community\/uvelichenie-limita-open-files-limit-v-mariadb-on-centos-7-s-pomoshhyu-systemd-277","title":{"rendered":"\u0423\u0432\u0435\u043b\u0438\u0447\u0435\u043d\u0438\u0435 \u043b\u0438\u043c\u0438\u0442\u0430 open-files-limit \u0432 MariaDB on CentOS 7 \u0441 \u043f\u043e\u043c\u043e\u0449\u044c\u044e systemd"},"content":{"rendered":"<p>Gone are the days where simply changing <code>\/etc\/my.cnf<\/code> would be sufficient. Enter the new systemd world.<span id=\"more-5955\"><\/span><\/p>\n<p>systemd itself has a limit that controls how many files a service can open, regardless if what you configure in <code>\/etc\/my.cnf<\/code> or <code>\/etc\/security\/limits.conf<\/code>.<\/p>\n<p>To increase the open files limit in MariaDB running on a RHEL or CentOS 7 with systemd, do the following.<\/p>\n<p>First, create a new directory that will hold the MariaDB service changes in systemd. By making your changes here, you&#8217;ll make sure that package upgrades that would\/could overwrite the <em>mariadb.service<\/em> file don&#8217;t remove your own changes.<\/p>\n<pre>$ mkdir -p \/etc\/systemd\/system\/mariadb.service.d\/<\/pre>\n<p>Next, configure systemd so that the MariaDB service can open more files.<\/p>\n<pre class=\"\">$ nano \/etc\/systemd\/system\/mariadb.service.d\/limits.conf\r\n[Service]\r\nLimitNOFILE=65535\r\n<\/pre>\n<p>In order for systemd to be aware of those changes, you have to reload the systemd daemon. This only reloads the configs that systemd knows about, it does not restart any actual service.<\/p>\n<pre>$ systemctl daemon-reload<\/pre>\n<p>The above tells systemd that MariaDB can open 10000 files of it wants. Restart the MariaDB service now to make those changes stick.<\/p>\n<pre class=\"\">$ systemctl restart mariadb<\/pre>\n<p>\u0412\u044b\u043f\u043e\u043b\u043d\u044f\u0435\u043c \u0437\u0430\u043f\u0440\u043e\u0441 \u043a \u0431\u0430\u0437\u0435 \u0434\u0430\u043d\u043d\u044b\u0445<\/p>\n<pre class=\"\">SHOW VARIABLES LIKE 'Open_files_limit';<\/pre>\n<p>\u041f\u043e\u043b\u0443\u0447\u0430\u0435\u043c \u0437\u043d\u0430\u0447\u0435\u043d\u0438\u0435<\/p>\n<pre class=\"lang:sh decode:true \">+------------------+-------+\r\n| Variable_name    | Value |\r\n+------------------+-------+\r\n| open_files_limit | 65535 |\r\n+------------------+-------+\r\n1 row in set (0.00 sec)<\/pre>\n<p>And you&#8217;re done.<br \/>\nIncrease the value in <code>\/etc\/systemd\/system\/mariadb.service.d\/limits.conf<\/code> if needed.<\/p>\n<p>These changes are also &#171;documented&#187; in the <code>mariadb.service<\/code> service file in systemd.<\/p>\n<pre>$ cat \/usr\/lib\/systemd\/system\/mariadb.service\r\n...\r\n# It's not recommended to modify this file in-place, because it will be\r\n# overwritten during package upgrades.  If you want to customize, the\r\n# best way is to create a file \"\/etc\/systemd\/system\/mariadb.service\",\r\n# containing\r\n#\t.include \/lib\/systemd\/system\/mariadb.service\r\n#\t...make your changes here...\r\n# or create a file \"\/etc\/systemd\/system\/mariadb.service.d\/foo.conf\",\r\n# which doesn't need to include \".include\" call and which will be parsed\r\n# after the file mariadb.service itself is parsed.\r\n#\r\n# For more info about custom unit files, see systemd.unit(5) or\r\n# http:\/\/fedoraproject.org\/wiki\/Systemd#How_do_I_customize_a_unit_file.2F_add_a_custom_unit_file.3F\r\n\r\n# For example, if you want to increase mariadb's open-files-limit to 10000,\r\n# you need to increase systemd's LimitNOFILE setting, so create a file named\r\n# \"\/etc\/systemd\/system\/mariadb.service.d\/limits.conf\" containing:\r\n#\t[Service]\r\n#\tLimitNOFILE=10000\r\n\r\n# Note: \/usr\/lib\/... is recommended in the .include line though \/lib\/...\r\n# still works.\r\n# Don't forget to reload systemd daemon after you change unit configuration:\r\n# root&gt; systemctl --system daemon-reload<\/pre>\n<p>Just another thing to keep in mind.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Gone are the days where simply changing \/etc\/my.cnf would be sufficient. Enter the new systemd world. systemd itself has a limit that controls how many files a service can open,&hellip; <\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[52,15],"tags":[23,22,17],"class_list":["post-277","post","type-post","status-publish","format-standard","hentry","category-application","category-database","tag-mariadb","tag-mysql","tag-plesk"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v25.4 (Yoast SEO v25.5) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>\u0423\u0432\u0435\u043b\u0438\u0447\u0435\u043d\u0438\u0435 \u043b\u0438\u043c\u0438\u0442\u0430 open-files-limit \u0432 MariaDB on CentOS 7 \u0441 \u043f\u043e\u043c\u043e\u0449\u044c\u044e systemd - GalaxyData Community<\/title>\n<meta name=\"description\" content=\"\u0423\u0437\u043d\u0430\u0439\u0442\u0435, \u043a\u0430\u043a \u0443\u0432\u0435\u043b\u0438\u0447\u0438\u0442\u044c \u043b\u0438\u043c\u0438\u0442 \u043e\u0442\u043a\u0440\u044b\u0442\u044b\u0445 \u0444\u0430\u0439\u043b\u043e\u0432 (`open_files_limit`) \u0432 MariaDB \u043d\u0430 CentOS 7 \u043f\u0443\u0442\u0435\u043c \u0440\u0435\u0434\u0430\u043a\u0442\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u044f \u043d\u0430\u0441\u0442\u0440\u043e\u0435\u043a `systemd`, \u043e\u0431\u0435\u0441\u043f\u0435\u0447\u0438\u0432 \u0441\u0442\u0430\u0431\u0438\u043b\u044c\u043d\u043e\u0441\u0442\u044c \u0438 \u043f\u0440\u043e\u0438\u0437\u0432\u043e\u0434\u0438\u0442\u0435\u043b\u044c\u043d\u043e\u0441\u0442\u044c \u0432\u0430\u0448\u0435\u0439 \u0431\u0430\u0437\u044b \u0434\u0430\u043d\u043d\u044b\u0445.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/galaxydata.ru\/community\/uvelichenie-limita-open-files-limit-v-mariadb-on-centos-7-s-pomoshhyu-systemd-277\" \/>\n<meta property=\"og:locale\" content=\"ru_RU\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u0423\u0432\u0435\u043b\u0438\u0447\u0435\u043d\u0438\u0435 \u043b\u0438\u043c\u0438\u0442\u0430 open-files-limit \u0432 MariaDB on CentOS 7 \u0441 \u043f\u043e\u043c\u043e\u0449\u044c\u044e systemd\" \/>\n<meta property=\"og:description\" content=\"\u0423\u0437\u043d\u0430\u0439\u0442\u0435, \u043a\u0430\u043a \u0443\u0432\u0435\u043b\u0438\u0447\u0438\u0442\u044c \u043b\u0438\u043c\u0438\u0442 \u043e\u0442\u043a\u0440\u044b\u0442\u044b\u0445 \u0444\u0430\u0439\u043b\u043e\u0432 (`open_files_limit`) \u0432 MariaDB \u043d\u0430 CentOS 7 \u043f\u0443\u0442\u0435\u043c \u0440\u0435\u0434\u0430\u043a\u0442\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u044f \u043d\u0430\u0441\u0442\u0440\u043e\u0435\u043a `systemd`, \u043e\u0431\u0435\u0441\u043f\u0435\u0447\u0438\u0432 \u0441\u0442\u0430\u0431\u0438\u043b\u044c\u043d\u043e\u0441\u0442\u044c \u0438 \u043f\u0440\u043e\u0438\u0437\u0432\u043e\u0434\u0438\u0442\u0435\u043b\u044c\u043d\u043e\u0441\u0442\u044c \u0432\u0430\u0448\u0435\u0439 \u0431\u0430\u0437\u044b \u0434\u0430\u043d\u043d\u044b\u0445.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/galaxydata.ru\/community\/uvelichenie-limita-open-files-limit-v-mariadb-on-centos-7-s-pomoshhyu-systemd-277\" \/>\n<meta property=\"og:site_name\" content=\"GalaxyData Community\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/vk.com\/galaxydata\" \/>\n<meta property=\"article:published_time\" content=\"2017-03-09T20:11:31+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-07-22T21:17:16+00:00\" \/>\n<meta name=\"author\" content=\"Eduard Yamaltdinov\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u041d\u0430\u043f\u0438\u0441\u0430\u043d\u043e \u0430\u0432\u0442\u043e\u0440\u043e\u043c\" \/>\n\t<meta name=\"twitter:data1\" content=\"Eduard Yamaltdinov\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u041f\u0440\u0438\u043c\u0435\u0440\u043d\u043e\u0435 \u0432\u0440\u0435\u043c\u044f \u0434\u043b\u044f \u0447\u0442\u0435\u043d\u0438\u044f\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 \u043c\u0438\u043d\u0443\u0442\u044b\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/galaxydata.ru\/community\/uvelichenie-limita-open-files-limit-v-mariadb-on-centos-7-s-pomoshhyu-systemd-277#article\",\"isPartOf\":{\"@id\":\"https:\/\/galaxydata.ru\/community\/uvelichenie-limita-open-files-limit-v-mariadb-on-centos-7-s-pomoshhyu-systemd-277\"},\"author\":{\"name\":\"Eduard Yamaltdinov\",\"@id\":\"https:\/\/galaxydata.ru\/community\/#\/schema\/person\/674f493b626af18d90fe784aa69dfd7b\"},\"headline\":\"\u0423\u0432\u0435\u043b\u0438\u0447\u0435\u043d\u0438\u0435 \u043b\u0438\u043c\u0438\u0442\u0430 open-files-limit \u0432 MariaDB on CentOS 7 \u0441 \u043f\u043e\u043c\u043e\u0449\u044c\u044e systemd\",\"datePublished\":\"2017-03-09T20:11:31+00:00\",\"dateModified\":\"2025-07-22T21:17:16+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/galaxydata.ru\/community\/uvelichenie-limita-open-files-limit-v-mariadb-on-centos-7-s-pomoshhyu-systemd-277\"},\"wordCount\":204,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/galaxydata.ru\/community\/#organization\"},\"keywords\":[\"mariadb\",\"mysql\",\"plesk\"],\"articleSection\":[\"Application\",\"Database\"],\"inLanguage\":\"ru-RU\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/galaxydata.ru\/community\/uvelichenie-limita-open-files-limit-v-mariadb-on-centos-7-s-pomoshhyu-systemd-277#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/galaxydata.ru\/community\/uvelichenie-limita-open-files-limit-v-mariadb-on-centos-7-s-pomoshhyu-systemd-277\",\"url\":\"https:\/\/galaxydata.ru\/community\/uvelichenie-limita-open-files-limit-v-mariadb-on-centos-7-s-pomoshhyu-systemd-277\",\"name\":\"\u0423\u0432\u0435\u043b\u0438\u0447\u0435\u043d\u0438\u0435 \u043b\u0438\u043c\u0438\u0442\u0430 open-files-limit \u0432 MariaDB on CentOS 7 \u0441 \u043f\u043e\u043c\u043e\u0449\u044c\u044e systemd - GalaxyData Community\",\"isPartOf\":{\"@id\":\"https:\/\/galaxydata.ru\/community\/#website\"},\"datePublished\":\"2017-03-09T20:11:31+00:00\",\"dateModified\":\"2025-07-22T21:17:16+00:00\",\"description\":\"\u0423\u0437\u043d\u0430\u0439\u0442\u0435, \u043a\u0430\u043a \u0443\u0432\u0435\u043b\u0438\u0447\u0438\u0442\u044c \u043b\u0438\u043c\u0438\u0442 \u043e\u0442\u043a\u0440\u044b\u0442\u044b\u0445 \u0444\u0430\u0439\u043b\u043e\u0432 (`open_files_limit`) \u0432 MariaDB \u043d\u0430 CentOS 7 \u043f\u0443\u0442\u0435\u043c \u0440\u0435\u0434\u0430\u043a\u0442\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u044f \u043d\u0430\u0441\u0442\u0440\u043e\u0435\u043a `systemd`, \u043e\u0431\u0435\u0441\u043f\u0435\u0447\u0438\u0432 \u0441\u0442\u0430\u0431\u0438\u043b\u044c\u043d\u043e\u0441\u0442\u044c \u0438 \u043f\u0440\u043e\u0438\u0437\u0432\u043e\u0434\u0438\u0442\u0435\u043b\u044c\u043d\u043e\u0441\u0442\u044c \u0432\u0430\u0448\u0435\u0439 \u0431\u0430\u0437\u044b \u0434\u0430\u043d\u043d\u044b\u0445.\",\"breadcrumb\":{\"@id\":\"https:\/\/galaxydata.ru\/community\/uvelichenie-limita-open-files-limit-v-mariadb-on-centos-7-s-pomoshhyu-systemd-277#breadcrumb\"},\"inLanguage\":\"ru-RU\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/galaxydata.ru\/community\/uvelichenie-limita-open-files-limit-v-mariadb-on-centos-7-s-pomoshhyu-systemd-277\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/galaxydata.ru\/community\/uvelichenie-limita-open-files-limit-v-mariadb-on-centos-7-s-pomoshhyu-systemd-277#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u0413\u043b\u0430\u0432\u043d\u0430\u044f \u0441\u0442\u0440\u0430\u043d\u0438\u0446\u0430\",\"item\":\"https:\/\/galaxydata.ru\/community\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u0423\u0432\u0435\u043b\u0438\u0447\u0435\u043d\u0438\u0435 \u043b\u0438\u043c\u0438\u0442\u0430 open-files-limit \u0432 MariaDB on CentOS 7 \u0441 \u043f\u043e\u043c\u043e\u0449\u044c\u044e systemd\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/galaxydata.ru\/community\/#website\",\"url\":\"https:\/\/galaxydata.ru\/community\/\",\"name\":\"GalaxyData Community\",\"description\":\"Tutorial for Cloud VDS\",\"publisher\":{\"@id\":\"https:\/\/galaxydata.ru\/community\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/galaxydata.ru\/community\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"ru-RU\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/galaxydata.ru\/community\/#organization\",\"name\":\"GalaxyData Community\",\"url\":\"https:\/\/galaxydata.ru\/community\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"ru-RU\",\"@id\":\"https:\/\/galaxydata.ru\/community\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/galaxydata.ru\/community\/wp-content\/uploads\/2025\/07\/favicon_from_logo_32x32_gd.png\",\"contentUrl\":\"https:\/\/galaxydata.ru\/community\/wp-content\/uploads\/2025\/07\/favicon_from_logo_32x32_gd.png\",\"width\":32,\"height\":32,\"caption\":\"GalaxyData Community\"},\"image\":{\"@id\":\"https:\/\/galaxydata.ru\/community\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/vk.com\/galaxydata\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/galaxydata.ru\/community\/#\/schema\/person\/674f493b626af18d90fe784aa69dfd7b\",\"name\":\"Eduard Yamaltdinov\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"ru-RU\",\"@id\":\"https:\/\/galaxydata.ru\/community\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/galaxydata.ru\/community\/wp-content\/uploads\/2016\/10\/cloud-server-150x150.png\",\"contentUrl\":\"https:\/\/galaxydata.ru\/community\/wp-content\/uploads\/2016\/10\/cloud-server-150x150.png\",\"caption\":\"Eduard Yamaltdinov\"},\"description\":\"Eduard Yamaltdinov \u2014 \u0430\u0432\u0442\u043e\u0440 \u0438 \u044d\u043a\u0441\u043f\u0435\u0440\u0442 \u0432 \u043e\u0431\u043b\u0430\u0441\u0442\u0438 \u0438\u043d\u0444\u043e\u0440\u043c\u0430\u0446\u0438\u043e\u043d\u043d\u044b\u0445 \u0442\u0435\u0445\u043d\u043e\u043b\u043e\u0433\u0438\u0439 \u0438 \u043f\u0440\u043e\u0433\u0440\u0430\u043c\u043c\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u044f. \u0415\u0441\u043b\u0438 \u0432\u0430\u043c \u0438\u043d\u0442\u0435\u0440\u0435\u0441\u043d\u043e \u0443\u0437\u043d\u0430\u0442\u044c \u0431\u043e\u043b\u044c\u0448\u0435 \u043e \u0435\u0433\u043e \u0440\u0430\u0431\u043e\u0442\u0430\u0445, \u043e\u043f\u044b\u0442\u0435 \u0438\u043b\u0438 \u043f\u0440\u043e\u0435\u043a\u0442\u0430\u0445, \u0441\u043e\u043e\u0431\u0449\u0438\u0442\u0435 \u043f\u043e\u0434\u0440\u043e\u0431\u043d\u0435\u0435, \u043a\u0430\u043a\u0443\u044e \u0438\u043c\u0435\u043d\u043d\u043e \u0438\u043d\u0444\u043e\u0440\u043c\u0430\u0446\u0438\u044e \u0445\u043e\u0442\u0438\u0442\u0435 \u043f\u043e\u043b\u0443\u0447\u0438\u0442\u044c.\",\"url\":\"https:\/\/galaxydata.ru\/community\/author\/galaxydata\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"\u0423\u0432\u0435\u043b\u0438\u0447\u0435\u043d\u0438\u0435 \u043b\u0438\u043c\u0438\u0442\u0430 open-files-limit \u0432 MariaDB on CentOS 7 \u0441 \u043f\u043e\u043c\u043e\u0449\u044c\u044e systemd - GalaxyData Community","description":"\u0423\u0437\u043d\u0430\u0439\u0442\u0435, \u043a\u0430\u043a \u0443\u0432\u0435\u043b\u0438\u0447\u0438\u0442\u044c \u043b\u0438\u043c\u0438\u0442 \u043e\u0442\u043a\u0440\u044b\u0442\u044b\u0445 \u0444\u0430\u0439\u043b\u043e\u0432 (`open_files_limit`) \u0432 MariaDB \u043d\u0430 CentOS 7 \u043f\u0443\u0442\u0435\u043c \u0440\u0435\u0434\u0430\u043a\u0442\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u044f \u043d\u0430\u0441\u0442\u0440\u043e\u0435\u043a `systemd`, \u043e\u0431\u0435\u0441\u043f\u0435\u0447\u0438\u0432 \u0441\u0442\u0430\u0431\u0438\u043b\u044c\u043d\u043e\u0441\u0442\u044c \u0438 \u043f\u0440\u043e\u0438\u0437\u0432\u043e\u0434\u0438\u0442\u0435\u043b\u044c\u043d\u043e\u0441\u0442\u044c \u0432\u0430\u0448\u0435\u0439 \u0431\u0430\u0437\u044b \u0434\u0430\u043d\u043d\u044b\u0445.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/galaxydata.ru\/community\/uvelichenie-limita-open-files-limit-v-mariadb-on-centos-7-s-pomoshhyu-systemd-277","og_locale":"ru_RU","og_type":"article","og_title":"\u0423\u0432\u0435\u043b\u0438\u0447\u0435\u043d\u0438\u0435 \u043b\u0438\u043c\u0438\u0442\u0430 open-files-limit \u0432 MariaDB on CentOS 7 \u0441 \u043f\u043e\u043c\u043e\u0449\u044c\u044e systemd","og_description":"\u0423\u0437\u043d\u0430\u0439\u0442\u0435, \u043a\u0430\u043a \u0443\u0432\u0435\u043b\u0438\u0447\u0438\u0442\u044c \u043b\u0438\u043c\u0438\u0442 \u043e\u0442\u043a\u0440\u044b\u0442\u044b\u0445 \u0444\u0430\u0439\u043b\u043e\u0432 (`open_files_limit`) \u0432 MariaDB \u043d\u0430 CentOS 7 \u043f\u0443\u0442\u0435\u043c \u0440\u0435\u0434\u0430\u043a\u0442\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u044f \u043d\u0430\u0441\u0442\u0440\u043e\u0435\u043a `systemd`, \u043e\u0431\u0435\u0441\u043f\u0435\u0447\u0438\u0432 \u0441\u0442\u0430\u0431\u0438\u043b\u044c\u043d\u043e\u0441\u0442\u044c \u0438 \u043f\u0440\u043e\u0438\u0437\u0432\u043e\u0434\u0438\u0442\u0435\u043b\u044c\u043d\u043e\u0441\u0442\u044c \u0432\u0430\u0448\u0435\u0439 \u0431\u0430\u0437\u044b \u0434\u0430\u043d\u043d\u044b\u0445.","og_url":"https:\/\/galaxydata.ru\/community\/uvelichenie-limita-open-files-limit-v-mariadb-on-centos-7-s-pomoshhyu-systemd-277","og_site_name":"GalaxyData Community","article_publisher":"https:\/\/vk.com\/galaxydata","article_published_time":"2017-03-09T20:11:31+00:00","article_modified_time":"2025-07-22T21:17:16+00:00","author":"Eduard Yamaltdinov","twitter_card":"summary_large_image","twitter_misc":{"\u041d\u0430\u043f\u0438\u0441\u0430\u043d\u043e \u0430\u0432\u0442\u043e\u0440\u043e\u043c":"Eduard Yamaltdinov","\u041f\u0440\u0438\u043c\u0435\u0440\u043d\u043e\u0435 \u0432\u0440\u0435\u043c\u044f \u0434\u043b\u044f \u0447\u0442\u0435\u043d\u0438\u044f":"2 \u043c\u0438\u043d\u0443\u0442\u044b"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/galaxydata.ru\/community\/uvelichenie-limita-open-files-limit-v-mariadb-on-centos-7-s-pomoshhyu-systemd-277#article","isPartOf":{"@id":"https:\/\/galaxydata.ru\/community\/uvelichenie-limita-open-files-limit-v-mariadb-on-centos-7-s-pomoshhyu-systemd-277"},"author":{"name":"Eduard Yamaltdinov","@id":"https:\/\/galaxydata.ru\/community\/#\/schema\/person\/674f493b626af18d90fe784aa69dfd7b"},"headline":"\u0423\u0432\u0435\u043b\u0438\u0447\u0435\u043d\u0438\u0435 \u043b\u0438\u043c\u0438\u0442\u0430 open-files-limit \u0432 MariaDB on CentOS 7 \u0441 \u043f\u043e\u043c\u043e\u0449\u044c\u044e systemd","datePublished":"2017-03-09T20:11:31+00:00","dateModified":"2025-07-22T21:17:16+00:00","mainEntityOfPage":{"@id":"https:\/\/galaxydata.ru\/community\/uvelichenie-limita-open-files-limit-v-mariadb-on-centos-7-s-pomoshhyu-systemd-277"},"wordCount":204,"commentCount":0,"publisher":{"@id":"https:\/\/galaxydata.ru\/community\/#organization"},"keywords":["mariadb","mysql","plesk"],"articleSection":["Application","Database"],"inLanguage":"ru-RU","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/galaxydata.ru\/community\/uvelichenie-limita-open-files-limit-v-mariadb-on-centos-7-s-pomoshhyu-systemd-277#respond"]}]},{"@type":"WebPage","@id":"https:\/\/galaxydata.ru\/community\/uvelichenie-limita-open-files-limit-v-mariadb-on-centos-7-s-pomoshhyu-systemd-277","url":"https:\/\/galaxydata.ru\/community\/uvelichenie-limita-open-files-limit-v-mariadb-on-centos-7-s-pomoshhyu-systemd-277","name":"\u0423\u0432\u0435\u043b\u0438\u0447\u0435\u043d\u0438\u0435 \u043b\u0438\u043c\u0438\u0442\u0430 open-files-limit \u0432 MariaDB on CentOS 7 \u0441 \u043f\u043e\u043c\u043e\u0449\u044c\u044e systemd - GalaxyData Community","isPartOf":{"@id":"https:\/\/galaxydata.ru\/community\/#website"},"datePublished":"2017-03-09T20:11:31+00:00","dateModified":"2025-07-22T21:17:16+00:00","description":"\u0423\u0437\u043d\u0430\u0439\u0442\u0435, \u043a\u0430\u043a \u0443\u0432\u0435\u043b\u0438\u0447\u0438\u0442\u044c \u043b\u0438\u043c\u0438\u0442 \u043e\u0442\u043a\u0440\u044b\u0442\u044b\u0445 \u0444\u0430\u0439\u043b\u043e\u0432 (`open_files_limit`) \u0432 MariaDB \u043d\u0430 CentOS 7 \u043f\u0443\u0442\u0435\u043c \u0440\u0435\u0434\u0430\u043a\u0442\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u044f \u043d\u0430\u0441\u0442\u0440\u043e\u0435\u043a `systemd`, \u043e\u0431\u0435\u0441\u043f\u0435\u0447\u0438\u0432 \u0441\u0442\u0430\u0431\u0438\u043b\u044c\u043d\u043e\u0441\u0442\u044c \u0438 \u043f\u0440\u043e\u0438\u0437\u0432\u043e\u0434\u0438\u0442\u0435\u043b\u044c\u043d\u043e\u0441\u0442\u044c \u0432\u0430\u0448\u0435\u0439 \u0431\u0430\u0437\u044b \u0434\u0430\u043d\u043d\u044b\u0445.","breadcrumb":{"@id":"https:\/\/galaxydata.ru\/community\/uvelichenie-limita-open-files-limit-v-mariadb-on-centos-7-s-pomoshhyu-systemd-277#breadcrumb"},"inLanguage":"ru-RU","potentialAction":[{"@type":"ReadAction","target":["https:\/\/galaxydata.ru\/community\/uvelichenie-limita-open-files-limit-v-mariadb-on-centos-7-s-pomoshhyu-systemd-277"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/galaxydata.ru\/community\/uvelichenie-limita-open-files-limit-v-mariadb-on-centos-7-s-pomoshhyu-systemd-277#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u0413\u043b\u0430\u0432\u043d\u0430\u044f \u0441\u0442\u0440\u0430\u043d\u0438\u0446\u0430","item":"https:\/\/galaxydata.ru\/community"},{"@type":"ListItem","position":2,"name":"\u0423\u0432\u0435\u043b\u0438\u0447\u0435\u043d\u0438\u0435 \u043b\u0438\u043c\u0438\u0442\u0430 open-files-limit \u0432 MariaDB on CentOS 7 \u0441 \u043f\u043e\u043c\u043e\u0449\u044c\u044e systemd"}]},{"@type":"WebSite","@id":"https:\/\/galaxydata.ru\/community\/#website","url":"https:\/\/galaxydata.ru\/community\/","name":"GalaxyData Community","description":"Tutorial for Cloud VDS","publisher":{"@id":"https:\/\/galaxydata.ru\/community\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/galaxydata.ru\/community\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"ru-RU"},{"@type":"Organization","@id":"https:\/\/galaxydata.ru\/community\/#organization","name":"GalaxyData Community","url":"https:\/\/galaxydata.ru\/community\/","logo":{"@type":"ImageObject","inLanguage":"ru-RU","@id":"https:\/\/galaxydata.ru\/community\/#\/schema\/logo\/image\/","url":"https:\/\/galaxydata.ru\/community\/wp-content\/uploads\/2025\/07\/favicon_from_logo_32x32_gd.png","contentUrl":"https:\/\/galaxydata.ru\/community\/wp-content\/uploads\/2025\/07\/favicon_from_logo_32x32_gd.png","width":32,"height":32,"caption":"GalaxyData Community"},"image":{"@id":"https:\/\/galaxydata.ru\/community\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/vk.com\/galaxydata"]},{"@type":"Person","@id":"https:\/\/galaxydata.ru\/community\/#\/schema\/person\/674f493b626af18d90fe784aa69dfd7b","name":"Eduard Yamaltdinov","image":{"@type":"ImageObject","inLanguage":"ru-RU","@id":"https:\/\/galaxydata.ru\/community\/#\/schema\/person\/image\/","url":"https:\/\/galaxydata.ru\/community\/wp-content\/uploads\/2016\/10\/cloud-server-150x150.png","contentUrl":"https:\/\/galaxydata.ru\/community\/wp-content\/uploads\/2016\/10\/cloud-server-150x150.png","caption":"Eduard Yamaltdinov"},"description":"Eduard Yamaltdinov \u2014 \u0430\u0432\u0442\u043e\u0440 \u0438 \u044d\u043a\u0441\u043f\u0435\u0440\u0442 \u0432 \u043e\u0431\u043b\u0430\u0441\u0442\u0438 \u0438\u043d\u0444\u043e\u0440\u043c\u0430\u0446\u0438\u043e\u043d\u043d\u044b\u0445 \u0442\u0435\u0445\u043d\u043e\u043b\u043e\u0433\u0438\u0439 \u0438 \u043f\u0440\u043e\u0433\u0440\u0430\u043c\u043c\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u044f. \u0415\u0441\u043b\u0438 \u0432\u0430\u043c \u0438\u043d\u0442\u0435\u0440\u0435\u0441\u043d\u043e \u0443\u0437\u043d\u0430\u0442\u044c \u0431\u043e\u043b\u044c\u0448\u0435 \u043e \u0435\u0433\u043e \u0440\u0430\u0431\u043e\u0442\u0430\u0445, \u043e\u043f\u044b\u0442\u0435 \u0438\u043b\u0438 \u043f\u0440\u043e\u0435\u043a\u0442\u0430\u0445, \u0441\u043e\u043e\u0431\u0449\u0438\u0442\u0435 \u043f\u043e\u0434\u0440\u043e\u0431\u043d\u0435\u0435, \u043a\u0430\u043a\u0443\u044e \u0438\u043c\u0435\u043d\u043d\u043e \u0438\u043d\u0444\u043e\u0440\u043c\u0430\u0446\u0438\u044e \u0445\u043e\u0442\u0438\u0442\u0435 \u043f\u043e\u043b\u0443\u0447\u0438\u0442\u044c.","url":"https:\/\/galaxydata.ru\/community\/author\/galaxydata"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/galaxydata.ru\/community\/wp-json\/wp\/v2\/posts\/277","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/galaxydata.ru\/community\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/galaxydata.ru\/community\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/galaxydata.ru\/community\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/galaxydata.ru\/community\/wp-json\/wp\/v2\/comments?post=277"}],"version-history":[{"count":1,"href":"https:\/\/galaxydata.ru\/community\/wp-json\/wp\/v2\/posts\/277\/revisions"}],"predecessor-version":[{"id":2014,"href":"https:\/\/galaxydata.ru\/community\/wp-json\/wp\/v2\/posts\/277\/revisions\/2014"}],"wp:attachment":[{"href":"https:\/\/galaxydata.ru\/community\/wp-json\/wp\/v2\/media?parent=277"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/galaxydata.ru\/community\/wp-json\/wp\/v2\/categories?post=277"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/galaxydata.ru\/community\/wp-json\/wp\/v2\/tags?post=277"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}