Not the answer you need?
Register and ask your own question!

After upgrading from 5.5 to 5.7 everything went slow

bdelmedicobdelmedico ContributorCurrent User Role Beginner
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

Comments

  • krunalbauskarkrunalbauskar Advisor Inactive User Role Novice
    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.
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.