MySQL 5.6 upgrade increases memory usage

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.
 

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?
 

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.
 
Top