We are in process of upgrading our (Percona) Mysql 5.5 mysql servers to Mysql 5.6. We have upgraded all our slaves except one.
However, we have observed that for the same workload, 5.6 slaves are consuming more user CPU.
CPU utlization on 5.5 slave continues to be lower. For comparison, we have setup an additional slave on Oracle’s community Mysql 5.6. Here the cpu utilization is lower.
Does the percona Mysql 5.6 consumes more cpu than previous version (5.5) or Oracle community 5.6 ? Has anyone else observed similar behavior? In our environment this observation is consistent and reproducible. let me know if anyone has solution for it.
Slave upgraded to Percona 5.6 (EST Timezone)
01:20:01 PM CPU %user %nice %system %iowait %steal %idle
01:20:01 PM all 10.97 0.00 0.05 0.19 0.00 88.79
01:30:01 PM all 11.20 0.00 0.06 0.01 0.00 88.73
01:40:01 PM all 9.48 0.00 0.08 0.02 0.00 90.41
Slave still on 5.5:
10:20:01 AM CPU %user %nice %system %iowait %steal %idle
10:20:01 AM all 0.26 0.00 0.04 0.39 0.00 99.31
10:30:01 AM all 0.23 0.00 0.10 0.08 0.00 99.58
10:40:01 AM all 0.32 0.00 0.05 0.17 0.00 99.47
Slave upgraded to Oracle Mysql 5.6:
10:20:01 AM CPU %user %nice %system %iowait %steal %idle
10:20:01 AM all 0.26 0.00 0.04 0.39 0.00 99.31
10:30:01 AM all 0.23 0.00 0.10 0.08 0.00 99.58
10:40:01 AM all 0.32 0.00 0.05 0.17 0.00 99.47