MySQL goes down everyday

[Deker]

Hey Guys,
Some of our customers reported that they are getting database errors such as "The MySQL server is currently offline" or "Database error The Database has encountered a problem" several times a day.
The issue resolves automatically after a few minutes. but it come back again after a while.
Please let me know what is causing this issue and how do I fix this?
We use cpanel/WHM and didn't change anything on the server recently (execpt cpanel automatic updates)

Your help will be appreciated

 

[cPanelMichael]

Hello

I recommend reviewing the MySQL error log (/var/lib/mysql/$hostname.err) and searching for the times MySQL has failed to see if there is any particular output that could help explain why it failed.

Thank you.

 

[storminternet]

If this error is specific to some of the users only then I doubt that it is mysql problem. Some of the applications might be exceeding mysql_connect time or wait_timeout in php.ini, my.cnf respectively.

Try to increase those values and test your applications. If the problem is still there then I would recommend you to optimize your mysql configuration.