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 shutting down daily

Discussion in 'Database Discussions' started by saurabhpatil, Feb 17, 2015.

  1. saurabhpatil

    saurabhpatil Registered

    Joined:
    Nov 20, 2014
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    MySQL is shutting down/crashing everyday at 0000hrs. I am not aware what has caused this issue, but this started about a week back. I have to do a Graceful Reboot to normalise services. I am getting a mail everyday as per below :

    I have Reset MySQL password using WHM. Also as per the above mail, updated password in /root/.my.cnf, but it did not work. I just check the .my.cnf file and the password has changed to something else.

    Also, If I restart MySQL from Restart Services option in WHM, It shows the following log.

    Code:
    Log Messages
    150217 6:35:04 [Note] /usr/sbin/mysqld: ready for connections.
    150217 06:35:03 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
    150217 06:35:02 mysqld_safe mysqld from pid file /var/lib/mysql/zen.nextechsolutions.in.pid ended
    150217 6:35:02 [Note] /usr/sbin/mysqld: Shutdown complete
    150217 6:35:01 [Warning] /usr/sbin/mysqld: Forcing close of thread 104 user: 'eximstats'
    150217 6:34:59 [Note] /usr/sbin/mysqld: Normal shutdown
    150217 6:03:17 [Note] /usr/sbin/mysqld: ready for connections.
    150217 06:03:15 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
    150217 00:20:06 mysqld_safe mysqld from pid file /var/lib/mysql/zen.nextechsolutions.in.pid ended
    150217 0:20:06 [Note] /usr/sbin/mysqld: Shutdown complete
    150217 0:20:04 [Warning] /usr/sbin/mysqld: Forcing close of thread 62 user: 'eximstats'
    150217 0:20:04 [Warning] /usr/sbin/mysqld: Forcing close of thread 19294 user: 'leechprotect'
    150217 0:20:02 [Note] /usr/sbin/mysqld: Normal shutdown
    150215 6:35:14 [Note] /usr/sbin/mysqld: ready for connections.
    150215 06:35:13 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
    150215 00:18:58 mysqld_safe mysqld from pid file /var/lib/mysql/zen.nextechsolutions.in.pid ended
    150215 0:18:58 [Note] /usr/sbin/mysqld: Shutdown complete
    150215 0:18:57 [Warning] /usr/sbin/mysqld: Forcing close of thread 8 user: 'eximstats'
    150215 0:18:57 [Warning] /usr/sbin/mysqld: Forcing close of thread 7183 user: 'leechprotect'
    150215 0:18:55 [Note] /usr/sbin/mysqld: Normal shutdown
    150214 10:46:30 [Note] /usr/sbin/mysqld: ready for connections.
    150214 10:46:29 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
    150214 10:44:20 mysqld_safe mysqld from pid file /var/lib/mysql/zen.nextechsolutions.in.pid ended
    150214 10:44:19 [Note] /usr/sbin/mysqld: Shutdown complete
    150214 10:44:18 [Warning] /usr/sbin/mysqld: Forcing close of thread 45 user: 'eximstats'
    150214 10:44:18 [Warning] /usr/sbin/mysqld: Forcing close of thread 1873 user: 'leechprotect'
    If I am trying to Create an Account in Cpanel using a reseller account, it gives the following error :

    Account Creation Status: failed

    The MySQL service is down.

    Help would be appreciated.

    Thanks,
    Saurabh.
     
  2. 24x7server

    24x7server Well-Known Member

    Joined:
    Apr 17, 2013
    Messages:
    1,146
    Likes Received:
    34
    Trophy Points:
    48
    Location:
    India
    cPanel Access Level:
    Root Administrator
    Hello,

    You will have to monitor your server with the top and ps aufx command, May be due to insufficient memory, you are getting this issues. So please monitor it and try to optimize your MySQL with MySQLTuner-perl by major scripts.
     
  3. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,854
    Likes Received:
    675
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
Loading...

Share This Page