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 restarts every 5 mins after installing 11.32.2.27

Discussion in 'General Discussion' started by znypan, May 4, 2012.

  1. znypan

    znypan Member

    Joined:
    Oct 18, 2011
    Messages:
    12
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Website Owner
    From the mysql error log:
    This happens every 5 minutes. I'm completely lost where this is coming from. It started after updating to build .27

    MySQL 5.5.22
    my.cnf
     
    #1 znypan, May 4, 2012
    Last edited: May 4, 2012
  2. cPanelTristan

    cPanelTristan Quality Assurance Analyst
    Staff Member

    Joined:
    Oct 2, 2010
    Messages:
    7,623
    Likes Received:
    21
    Trophy Points:
    38
    Location:
    somewhere over the rainbow
    cPanel Access Level:
    Root Administrator
    Could you try moving the existing /etc/my.cnf to /etc/my.cnf.bak120504 and then putting just this into the new one:

    Code:
    [mysqld]
    default-storage-engine=MyISAM
    character-set-server=utf8
    collation-server=utf8_unicode_ci
    slow_query_log
    Then restart MySQL again. I've kept only the options that you'd really need to have because of setting the character set and default storage engine would be an issue for any new databases. If this results in a stable MySQL where it isn't restarting, then slowly add the other variables other than ignore_builtin_innodb back one at a time. The ignore_builtin_innodb is specifically erroring in the log.
     
  3. znypan

    znypan Member

    Joined:
    Oct 18, 2011
    Messages:
    12
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Website Owner
    Will do. Thanks!
     
  4. znypan

    znypan Member

    Joined:
    Oct 18, 2011
    Messages:
    12
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Website Owner
    Same thing happens with the "clean" my.cnf
    Be advised I already forced a re-install of mysql and easyapache afterwards. Didn't solve the problem.
     
  5. cPanelTristan

    cPanelTristan Quality Assurance Analyst
    Staff Member

    Joined:
    Oct 2, 2010
    Messages:
    7,623
    Likes Received:
    21
    Trophy Points:
    38
    Location:
    somewhere over the rainbow
    cPanel Access Level:
    Root Administrator
    Go ahead and open up a ticket as this is a major service disruption to have MySQL keep restarting. You can open one in WHM > Support Center > Contact cPanel or using the link in my signature. Please post the ticket number here after submitting so we can track the ticket.
     
  6. znypan

    znypan Member

    Joined:
    Oct 18, 2011
    Messages:
    12
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Website Owner
    Thanks. Request id is: 2591515.
     
Loading...

Share This Page