{"id":1061,"date":"2022-09-14T19:18:21","date_gmt":"2022-09-14T19:18:21","guid":{"rendered":"https:\/\/sunucucozumleri.com\/?p=1061"},"modified":"2022-10-09T19:11:24","modified_gmt":"2022-10-09T19:11:24","slug":"mysql-out-of-resources-when-opening-file-errcode-24","status":"publish","type":"post","link":"https:\/\/sunucucozumleri.com\/blog\/mysql-out-of-resources-when-opening-file-errcode-24\/","title":{"rendered":"MYSQL: Out of resources when opening file&#8230; (Errcode: 24)"},"content":{"rendered":"<p>Merhabalar,<br \/>\nE\u011fer kullanm\u0131\u015f oldu\u011funuz sunucularda a\u015fa\u011f\u0131daki gibi bir hata al\u0131yorsan\u0131z,<br \/>\n<strong>The mysql error: Out of resources when opening file<\/strong>&#8230; (Errcode: 24) indicates that the number of files that msyql is permitted to open has been exceeded. yap\u0131lmas\u0131 gereken i\u015flem ve<br \/>\n<strong>Out of resources when opening file<\/strong>hatas\u0131n\u0131n \u00e7\u00f6z\u00fcm\u00fc a\u015fa\u011f\u0131daki gibidir. 1. Ad\u0131m<\/p>\n<pre>nano -w \/etc\/my.cnf\r\n<\/pre>\n<p>2. Ad\u0131m<br \/>\nmy.cnf dosyam\u0131zda MySQL&#8217;in a\u00e7abilece\u011fi dosya say\u0131s\u0131n\u0131 d\u00fczenliyoruz. 5000 bir\u00e7ok site i\u00e7in ideal olacakt\u0131r.<\/p>\n<pre>[mysqld]\r\nopen_files_limit = 5000\r\n<\/pre>\n<p>3. Ad\u0131m<\/p>\n<pre>\/etc\/init.d\/mysql <a href=\"https:\/\/sunucucozumleri.com\/blog\/reboot-ve-restart-arasindaki-farklar-nedir\/\">restart<\/a>\r\nveya\r\n\/etc\/init.d\/mysqld restart\r\n<\/pre>\n<p>\u0130yi yay\u0131nlar dileriz.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Merhabalar, E\u011fer kullanm\u0131\u015f oldu\u011funuz sunucularda a\u015fa\u011f\u0131daki gibi bir hata al\u0131yorsan\u0131z, The mysql error: Out of resources when opening file&#8230; (Errcode: 24) indicates that the number of files that msyql is permitted to open has been exceeded. yap\u0131lmas\u0131 gereken i\u015flem ve Out of resources when opening filehatas\u0131n\u0131n \u00e7\u00f6z\u00fcm\u00fc a\u015fa\u011f\u0131daki gibidir. 1. Ad\u0131m nano -w \/etc\/my.cnf 2. &hellip;<\/p>\n","protected":false},"author":1,"featured_media":1456,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[5],"tags":[],"class_list":["post-1061","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-linux"],"acf":[],"_links":{"self":[{"href":"https:\/\/sunucucozumleri.com\/blog\/wp-json\/wp\/v2\/posts\/1061","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sunucucozumleri.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sunucucozumleri.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sunucucozumleri.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/sunucucozumleri.com\/blog\/wp-json\/wp\/v2\/comments?post=1061"}],"version-history":[{"count":0,"href":"https:\/\/sunucucozumleri.com\/blog\/wp-json\/wp\/v2\/posts\/1061\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/sunucucozumleri.com\/blog\/wp-json\/wp\/v2\/media\/1456"}],"wp:attachment":[{"href":"https:\/\/sunucucozumleri.com\/blog\/wp-json\/wp\/v2\/media?parent=1061"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sunucucozumleri.com\/blog\/wp-json\/wp\/v2\/categories?post=1061"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sunucucozumleri.com\/blog\/wp-json\/wp\/v2\/tags?post=1061"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}