MySQL Open File Limit

Hi Guys,

I received the following issue today in mysql log file.
This is a shared Web Hosting Server.

I performed the following as per link:
http://info.solomonson.com/content/how-fix-errno-24-mysql

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.