Upgrade Advisor
Paste SHOW GLOBAL VARIABLES output, pick your target MySQL version, and see which of
your variables are deprecated, renamed, or removed at that version. Everything runs in your
browser; nothing is uploaded.
Anything flagged Removed must come out of my.cnf
before the upgrade, or the server will not start.
Which target? 8.4 and 9.7 are both LTS lines; 9.7 (April 2026) is the newer one, and 8.4 LTS → 9.7 LTS is the supported jump. Upgrading from 8.0, check against 8.4 first — you cannot skip an LTS. Releases after 9.7 use calendar versioning, so 26.7 means July 2026; it is an Innovation release, maintained only until the next one ships. Coverage runs through 26.7.
Covers MySQL Server (Oracle) variable lifecycles only; MariaDB and Percona Server follow different schedules. This is a configuration-file check, not a full upgrade readiness review — also read the release notes for SQL, replication, and client-side changes.
| Status | Variable | Your value | What to do |
|---|