Strange MySQL Problem

[AgoraHosting]

Hello,

We have a strange problem with MySQL service.
When we restart the server, MySQL service runs fine and serves websites without any problem.

However after 3 or 4 days, the web sites can not access the MySQL service and it becomes unavailable. However when we check from the Direct Admin's Service Monitor, it shows the PIDs of MySQL service and shows it as a running service.

When we stop the service and restart it, the problem disappears but happens again in 3-4 days again.

Does anyone have an answer for this problem?

Thanks in advance!

 

[fusionictnl]

Check you're logs, this will most likely give you an answer.

What error does the PHP scripts give when connecting to the Database when it's "down"?

 

[AgoraHosting]

PHP scripts give an error like this:

cannot connect to MySQL database
or
MySQL connection failed

However, we see that mysql service is running after we get these errors on several sites.

If we restart the service the problem dissapears but happens again after approximately 48 hours