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 To 5.6 Upgrade - Using Much higher memory?

Discussion in 'Database Discussion' started by gohighvoltage, Feb 27, 2014.

  1. gohighvoltage

    gohighvoltage Member

    Joined:
    Jan 8, 2012
    Messages:
    11
    Likes Received:
    0
    Trophy Points:
    51
    cPanel Access Level:
    Reseller Owner
    Hi, I just upgraded my server from mysql 5.5 to 5.6. My server memory would always be around 975mb idle. Now after the upgrade it is 1.4gb idle. What is causing this? Does 5.6 use substantially more memory?


    THank you!
     
  2. gohighvoltage

    gohighvoltage Member

    Joined:
    Jan 8, 2012
    Messages:
    11
    Likes Received:
    0
    Trophy Points:
    51
    cPanel Access Level:
    Reseller Owner
    I turned off performance_schema in my.cnf and my memory went back down to close to normal. I didn't realize performance schema was a memory hog.
     
  3. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    44,367
    Likes Received:
    1,855
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Note that memory usage itself isn't necessarily a bad thing if you don't notice any performance degradation. You can also check out our "Optimization" forum if you would like help optimizing your /etc/my.cnf file.

    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  4. gohighvoltage

    gohighvoltage Member

    Joined:
    Jan 8, 2012
    Messages:
    11
    Likes Received:
    0
    Trophy Points:
    51
    cPanel Access Level:
    Reseller Owner
    What is the recommendations as far as performance_schema, better on or better off? Anyone?
     
  5. sahostking

    sahostking Well-Known Member

    Joined:
    May 15, 2012
    Messages:
    329
    Likes Received:
    3
    Trophy Points:
    68
    Location:
    Cape Town, South Africa
    cPanel Access Level:
    Root Administrator
    I'd also like to know
     
    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