My mysql db keeps on crashing after few hours. i dont know why its happening. its was perfect before. when i installed w3 total cache and remove redis cache from easyengine then this issue is caused. please help me
every time i need to restart mysql to get website work properly.
Please help me guys i am loosing visitors

This can be due to many things but usually it means you have outgrown your server and the box is running out of memory. To keep the whole system from crashing the kernel OOM killer is invoked and kills the process with the worst memory score. Mysqld usually is on the top list of the kernel’s kill list so in such instances it will get squelched.

You have a couple of options:

*Upgrade I would strongly recommend you take this route

Set up swap this is not always possible especially OpenVPZ

Fiddle with settings to make sure mysqld doesn’t get killed. The kernel needs to kill something and it will continue to kill until order is restored this might mean nginx or some other critical process.

i found the issue. the issue was because of memory allocation so i created 4gb swap storage and i will now monitor my website and i hope i will not show database error.
by the way here is my.cnf file for 1gb ram if any thing i need to edit please tell me

Good to hear you are finally getting the hang of things. I hope the guide you followed when creating Swap told you to tune the swappiness by default the kernel will just ignore this swap until you tune swappiness.

Another bit of advice. Install monit on your server. This will restart any killed processes and alert you if something goes wrong by telling you exactly what processes have been killed if any.