After upgrading from 5.5 to 5.7 everything went slow

MySQL & MariaDB Percona XtraDB Cluster 5.x
1

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(R) Xeon(R) 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?

tks

pt-mysql-summary.txt (21 KB)

Explain plan 5.7.jpeg
Explain plan 5.7.jpeg1057×209 52.5 KB

Explain plan 5.5.jpeg
Explain plan 5.5.jpeg1054×193 49.5 KB

mysql-dashboard.png
mysql-dashboard.png1039×727 74.3 KB

2

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.