Mysql keeps shutting down

gadalf

• April 19, 2015 08:01

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

  • April 19, 2015 15:10

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

  0
• 

  gadalf

  • April 19, 2015 21:00

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

  0
• 

  24x7server

  • April 20, 2015 15:32

  Please check :

  0
• 

  cPanelMichael

  • April 21, 2015 16:28

  Hello, What's the size of your eximstats database? EX:
  du -sh /var/lib/mysql/eximstats
  Thank you.

  0
• 

  gadalf

  • June 07, 2015 21:32

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

  0
• 

  sahostking

  • June 08, 2015 05:28

  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.

  0

Please sign in to leave a comment.