Instructions for increasing Open File Limit
Hi, I have an increasingly busy website which is more and more frequently experiencing problems with MySQL hitting the Open File Limit. The error report emailed to me says the limit is 10000 - it clearly needs to be much, much higher than this as the database is affected about every 2-4 hours now! I've checked Tweak Settings and it is set to "allow cPanel & WHM to determine the best value for your MySQL open_files_limit configuration". I've searched for instructions on how to manually set the Open File Limit and am getting nowhere fast. Is there a link I can refer to for instructions on how to resolve this issue, or can someone kindly bullet point the process for me, please?
Many thanks in advance.
Kelly
-
This thread may be of some use to you: Change open files limit mysql 0 -
Thanks for your reply. This presents a bit of an experimental process, doesn't it? The thread is 15 years old and the OP had a good deal of problems reaching a solution! I can do without my server being down for hours while I fumble around working out what to do next, with a MUCH newer version of everything to work with! I assume it goes something like this: - ]
- Stop the server
- Change Tweak Settings> SQL > "allow cPanel & WHM to determine the best value for your MySQL open_files_limit configuration" to disallow.
- Modify the /etc/my.cnf file with the new value
- Restart the server
0 -
That thread was started a year ago and is updated on page 2 that it was resolved there. 0 -
I've been able to increase the Open File limit via the route detailed here... So far so good. cpanelplesk.com/how-to-increase-max-open-file-limit-in-linux-system/ 0
Please sign in to leave a comment.
Comments
4 comments