Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

MySQL 5.5 upgrade reliability

Discussion in 'Database Discussion' started by lbeachmike, Oct 8, 2012.

  1. lbeachmike

    lbeachmike Well-Known Member

    Joined:
    Dec 27, 2001
    Messages:
    306
    Likes Received:
    1
    Trophy Points:
    316
    Location:
    Long Beach, NY
    cPanel Access Level:
    Root Administrator
    Hi there -

    I'd like to upgrade our servers from 5.1 to 5.5 and seeking feedback on reliability/stability of doing so. I'd like to do the upgrade if I'm confident that 5.5 support is relatively stable and reliable at this point and if probability of introducing any new issues is extremely low.

    Over the past months, I've seen various cpanel releases mentioning 5.5-related fixes, but haven't noticed those lately so I suppose that must be a good sign.

    Thanks.

    Mike
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  2. cPanelTristan

    cPanelTristan Quality Assurance Analyst
    Staff Member

    Joined:
    Oct 2, 2010
    Messages:
    7,609
    Likes Received:
    32
    Trophy Points:
    238
    Location:
    somewhere over the rainbow
    cPanel Access Level:
    Root Administrator
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. lbeachmike

    lbeachmike Well-Known Member

    Joined:
    Dec 27, 2001
    Messages:
    306
    Likes Received:
    1
    Trophy Points:
    316
    Location:
    Long Beach, NY
    cPanel Access Level:
    Root Administrator
    Thanks Tristan. Is it understood why the open files limits are being reached when moving to 5.5? Perhaps this relates to the way it uses multiple cores more efficiently and thus is processing more threads in parallel? Or perhaps it is simply that some users who migrate are not re-optimizing mysql after migrating ... ?
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  4. cPanelTristan

    cPanelTristan Quality Assurance Analyst
    Staff Member

    Joined:
    Oct 2, 2010
    Messages:
    7,609
    Likes Received:
    32
    Trophy Points:
    238
    Location:
    somewhere over the rainbow
    cPanel Access Level:
    Root Administrator
    It doesn't have to do with MySQL Optimization so far as I've been able to determine. It has to do with a system limit being placed on MySQL that the newer MySQL 5.5 appears to reach far easier than prior versions. I don't know if this is due to speed improvements and MySQL opening more files or not. I do know that we've seen a large number of tickets on it.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  5. LeadDogGraphics

    LeadDogGraphics Well-Known Member

    Joined:
    Feb 25, 2012
    Messages:
    97
    Likes Received:
    1
    Trophy Points:
    58
    Location:
    West Palm Beach, FL
    cPanel Access Level:
    Root Administrator
    I've been running mysql 5.5 for some time and have had no issues with it. I have not had the open files problem, however I would imagine that all depends on how large your database is, so YMMV.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
Loading...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice