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 5.5 upgrade reliability

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

  1. lbeachmike

    lbeachmike Well-Known Member

    Joined:
    Dec 27, 2001
    Messages:
    313
    Likes Received:
    0
    Trophy Points:
    16
    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
     
  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
  3. lbeachmike

    lbeachmike Well-Known Member

    Joined:
    Dec 27, 2001
    Messages:
    313
    Likes Received:
    0
    Trophy Points:
    16
    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 ... ?
     
  4. 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
    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.
     
  5. LeadDogGraphics

    LeadDogGraphics Well-Known Member

    Joined:
    Feb 25, 2012
    Messages:
    97
    Likes Received:
    1
    Trophy Points:
    8
    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.
     
Loading...

Share This Page