The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

MySQL service stops after every 24 hours

Discussion in 'Database Discussions' started by aashishbhargava, Jan 11, 2015.

  1. aashishbhargava

    aashishbhargava Registered

    Joined:
    Jan 11, 2015
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Noida, India, India
    cPanel Access Level:
    Root Administrator
    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
     
  2. Infopro

    Infopro cPanel Sr. Product Evangelist
    Staff Member

    Joined:
    May 20, 2003
    Messages:
    14,450
    Likes Received:
    195
    Trophy Points:
    63
    Location:
    Pennsylvania
    cPanel Access Level:
    Root Administrator
    Twitter:
    Are these options selected? WHM » Service Configuration » Service Manager, MySQL Server
     
  3. triantech

    triantech Well-Known Member

    Joined:
    Jul 1, 2014
    Messages:
    145
    Likes Received:
    1
    Trophy Points:
    18
    Location:
    Kochi, India, India
    cPanel Access Level:
    Root Administrator
    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.
     
  4. kamall

    kamall Active Member

    Joined:
    Mar 17, 2012
    Messages:
    40
    Likes Received:
    0
    Trophy Points:
    6
    Location:
    Bethune France
    cPanel Access Level:
    Root Administrator
    Twitter:
    Memoriy isse! I think so! Please check by root ssh top which will saw you which process is using a lot of memory.
     
Loading...

Share This Page