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.

Daily crashing of MySQL on cPanel new dedicated server

Discussion in 'Database Discussions' started by webservers, Nov 3, 2014.

  1. webservers

    webservers Active Member

    Joined:
    Nov 3, 2014
    Messages:
    26
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    This is a continuation of this thread: http://forums.cpanel.net/f354/server-mysql-crash-328931.html

    I'm having the same issue - myql crashes daily taking down sites on one of my cpanels created through WHM (the other cPanel I made in WHM doesn't seem to be crashing).

    The .err file in /var/lib/mysql/ gave tons of errors:
    I've been dealing with this for about a week now, ever since installing the cPanel trial on my new dedicated server running CentOS 6.6.

    I did run the sql to see open files, after following your instructions to increase the limit.
    Here is the output of running that sql command (via SSH) to see open files:

    I'm hoping this solves the issue, but if anyone has more ideas please let me know.
     
  2. webservers

    webservers Active Member

    Joined:
    Nov 3, 2014
    Messages:
    26
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Just want to update that it's been about a week or so since I increased the open files limit.

    I have not done anything with the server since that update, and MySQL has not crashed a single time.

    Thus, my conclusion, is that this solved the issue. Hope it helps you too!
     
  3. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

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

Share This Page