After upgrading from 5.5 to 5.7 everything went slow

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
Memory: 64Gb

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)

Can you validate if this difference exist in upstream (MySQL) too.

PXC code changes doesn’t touch optimizer or related area. Since you upgraded from 5.5 (5+ yrs old) to 5.7 (recent) I suspect there are lot of changes in MySQL upstream itself with this aspect. So please validate it against vanilla MySQL with some sample queries.