MySQL 5.6 upgrade increases memory usage

Discussion in 'Linux VPS/Dedicated - cPanel' started by Dan, Apr 24, 2014.

  1. Dan

    Dan Moderator

    Has anyone else upgraded to MySQL 5.6 and seen a very sizable memory increase? I updated yesterday and went from 5-6% memory usage on 5.5 to slightly more than 30% on 5.6.

    Everything seems to be running fine so I'm just trying to figure out if this is normal or if I should be looking around for resolutions to high memory usage.
     
  2. WebEndev

    WebEndev Member

    Hi Dan,

    I have not upgraded yet, but I read the EXACT same thing while doing some searching about 5.6. I don't have links to what I read now, but I do remember reading at least 2 or 3 different instances of people complaining about higher memory usage.

    I assume nothing else changed except the 5.6 upgrade?
     
  3. KH-Jonathan

    KH-Jonathan Director of Managed Services Staff Member

    MySQL 5.5 and lower would only allocate RAM as needed, with the maximum limits for each buffer/cache being those set in my.cnf. MySQL 5.6 now allocates this memory even if it's not actively needed, thus the memory footprint is higher when not utilized, but under full utilization should essentially be the same.
     
  4. Dan

    Dan Moderator

    @KH-Jonathan care to let us in on the settings to change to lower said footprint? One third of system memory is an awful lot...
     
  5. joel

    joel New Member

Share This Page