MySQL Open File Limit
I received the following issue today in mysql log file.
This is a shared Web Hosting Server.
I performed the following as per link:
Errors seem to have gone away. It seems the default was on 4096 in mysql. I set it to 300000.
Is this smart or any other recommendations on this for shared hosting.
You can't change your mysql config file on shared hosting.
4096 files should be ok for most uses, unless theres a lot of things going on at the same time on the server - if its a shared host, it should be up to your provider to manage things like that for you. Contact them and tell them you are running into an open files limit and can they adjust the mysql settings?
Thanks I went for 4096 and will see how it goes.
Originally Posted by TimIgoe