MySQL goes down everyday

Deker

• June 22, 2014 06:16

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

  • June 23, 2014 15:09

  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.

  0
• 

  storminternet

  • June 23, 2014 17:24

  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.

  0
• 

  neoistone

  • February 25, 2024 09:54

  same issue with my server also i am losing my customer there any solution old server good performance mariadb new server is mysql

  Old server configuration : 

  os : centos 7

  ram : 64 GB 

  4tb ssd storage

  New server configuration : 

  os : rockylinux 8

  ram : 32gb

  1tb ssd storage

  0
• 

  cPRex Jurassic Moderator

  • February 26, 2024 15:45

  neoistone - please start a new thread with the output from "mysqladmin proc status" and we can help there.

  0
• 

  neoistone

  • March 10, 2024 11:02

   

  

  0
• 

  cPRex Jurassic Moderator

  • March 11, 2024 13:54

  That doesn't show anything too interesting - what does the error log show around the time the system goes offline?

  0

Please sign in to leave a comment.