MySQL 5.6 upgrade increases memory usage

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.
 
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?
 
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.
 
You must log in or register to reply here.
Top