sql out of recources

Hi
I have the problem that my sites stop working with this error code

Code:

sql out of recources

I have only 4 sites on my server, all joomla. If Iget the error all stop working and even ISPConfig and mail etc stops.
Okay I understand they all depend on the database.
I did a clean install of my server just to be save and for a couple of days all was fine.
I searched for an solution for this problem and found this:

now I cant find the file mentioned on that path but in the directory msql it is...
So do I just ad that line : open_files_limit to it?
Or am I in need of upgrading my server, now I have a vps with 2 Intel Xeon cores and just 4.096 MB.
I can imagine that might not be enough.

Hopefully I made my self clear

Thanks

Appie

 

https://blog.schaal-24.de/server/error-error-in-accept-too-many-open-files/?lang=en

 

Florian,
Thanks for that have added the lines etc to my setup..
So lets hope its going to be okay now.... Time will tell.

btw any thoughts about my server setup? To little?
I have to say never had any problems before, but now I have more traffic and more database requests..?

Appie

 

4gb should be enough. You can check the ram with "free -m".