Mysql keeps shutting down

[gadalf]

I am getting :
Database connection error (2): Could not connect to MySQL.
Times after time. So I need to restart MySql time after time.
How to investigate which website is causing the problem?

 

[ravijas]

Hi,

Please check /var/lib/mysql/hostname.com.err error logs to get more information about it.

Thanks,

RaviJas

 

[gadalf]

Thank you very much,
Here is a screenshot of what i got. I am trying to understand it but ...

 

[24x7server]

Please check : http://forums.cpanel.net/threads/mysql-keeps-failing.464801/

 

[cPanelMichael]

Hello,

What's the size of your eximstats database? EX:

du -sh /var/lib/mysql/eximstats

Thank you.

 

[gadalf]

I am starting to have again this error:
exim stats database size 114 M

 

[sahostking]

Also enable mysql.slow log in my.cnf to catch those slow mysql queries from websites.

Also try running mysqladmin processlist a random times to see - you can even create a php script to check every minute and to inform you of this occurring at the exact time.