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

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

  1. gohighvoltage

    gohighvoltage Member

    Joined:
    Jan 8, 2012
    Messages:
    11
    Likes Received:
    0
    Trophy Points:
    1
    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:
    1
    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:
    30,678
    Likes Received:
    651
    Trophy Points:
    113
    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.
     
  4. gohighvoltage

    gohighvoltage Member

    Joined:
    Jan 8, 2012
    Messages:
    11
    Likes Received:
    0
    Trophy Points:
    1
    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:
    299
    Likes Received:
    1
    Trophy Points:
    18
    Location:
    Cape Town, South Africa
    cPanel Access Level:
    Root Administrator
Loading...

Share This Page