MySQL service stops after every 24 hours

aashishbhargava

• January 11, 2015 00:46

hello everyone! I have a Godaddy WHM VPS with 6 sites on it. I am new to WHM environment. MySQL service stops in every 20-24 hours time. I have no clue why. I have to login and restart MySQL service manually to make my websites work. Earlier it used to stop in around 15 days, therefore I did not pay much attention to it. However, now I want to what could be the reason for the service to stop. And is there a way to configure it to restart automatically after stopping. This is how the process looks like right now. Id User Host db Command Time State Info 531 root localhost NULL Query 0 NULL SHOW PROCESSLIST Thanks in advance, Aashish

• 

  Infopro

  • January 11, 2015 08:16

  Are these options selected? WHM " Service Configuration " Service Manager, MySQL Server

  0
• 

  triantech

  • January 11, 2015 17:33

  Hey, Since you are on a VPS, it might be that your MySQL process is getting killed due to over-usage of system memory ? You might need to check the overall memory usage in your VPS when this happens.

  0
• 

  kamall

  • January 29, 2015 13:45

  Memoriy isse! I think so! Please check by root ssh top which will saw you which process is using a lot of memory.

  0

Please sign in to leave a comment.