# Resolving query plan regressions after a MySQL engine upgrade

DevFeed: [Resolving query plan regressions after a MySQL engine upgrade](<https://devfeed.tech/articles/resolving-query-plan-regressions-after-a-mysql-engine-upgrade-61368.md>)

Original publisher: [Read original article](<https://aws.amazon.com/blogs/database/resolving-query-plan-regressions-after-a-mysql-engine-upgrade/>)

Author: CHANDANA DA

Published: 2026-09-28T17:22:48Z

Content type: tutorial

Language: en

Sources: [AWS Database Blog](<https://devfeed.tech/sources/aws-database-blog.md>)

Topics: [MySQL](<https://devfeed.tech/topics/mysql.md>), [Amazon Aurora](<https://devfeed.tech/topics/amazon-aurora.md>), [RDS for PostgreSQL](<https://devfeed.tech/topics/rds-for-postgresql.md>)

Tags: [advanced-300](<https://devfeed.tech/tags/advanced-300.md>), [amazon-aurora](<https://devfeed.tech/tags/amazon-aurora.md>), [best-practices](<https://devfeed.tech/tags/best-practices.md>), [mysql](<https://devfeed.tech/tags/mysql.md>), [mysql-compatible](<https://devfeed.tech/tags/mysql-compatible.md>), [query](<https://devfeed.tech/tags/query.md>), [rds](<https://devfeed.tech/tags/rds.md>), [rds-for-mysql](<https://devfeed.tech/tags/rds-for-mysql.md>), [upgrade](<https://devfeed.tech/tags/upgrade.md>), [version](<https://devfeed.tech/tags/version.md>)

## AI overview

After a major version upgrade on Amazon Aurora MySQL or Amazon RDS for MySQL, query performance can regress as optimizer cost models, defaults, and execution strategies change. The post outlines a diagnostic workflow for identifying which version change affected a query and finding an appropriate fix.

## Source excerpt

After a major or minor version upgrade on Amazon Aurora MySQL or Amazon RDS for MySQL, some queries regress because the optimizer's cost models, defaults, and execution strategies change. This post walks through a diagnostic workflow that traces each regression to the specific version change behind it and applies the right fix.