After upgrading from version 5.5 to 5.7 I’m having performance issues, it seems like it’s not using the primary key in queries.
I use the same my.cnf by removing some lines because of incompatibility between versions.
Server: PowerEdge R630
Version: Intel® Xeon® CPU E5-2630 v3 @ 2.40GHz
Raid: 10 SSD
From what we note the version 5.7 Explain plan runs completely different from version 5.5 …
Does anyone have any idea how to fix it?
pt-mysql-summary.txt (21 KB)