MySQL stops every night ~0:10 - ~0:16 hour

Hello dear people,

I hope you can help me with with the following.

1 server, centos 6 + directadmin
Every day about between 0:10 - 0:16 hour MySQL hangs.....

In the list of current tasks there are a lot of tasks httpd.

Most times when i click restart MySQL it works for a new day but I have enough of these manual restarts.
What is the cause of this hanging MySQL. I rebuild /all several times but the error keeps occuring.

Please help me out.

Hello,

Try:


- How to track which site is using the apache processes and causing load
- How to track MySQL Load

Thanks Zeiter,

Can you tell me why it stops around 0:10 am? Is there a job running that that can cause this?

I was thinking about statistics / tally?
Could that be it?

Directadmin does not have tasks to stop, reload or restart MySQL.

If MySQL hangs: it is due to either MySQL stops running or is having too many active connections, and can not handle them all.... you should read MySQL logs.

Use the links I've posted above to see what is behind the scenes, it is even possible to a set a crontasks to save output of the suggested scripts into a text file, if you can't what them live.

And if it is something that you are not familiar and have not time to learn it you'd better hire somebody for this job (for example I've available for it).