A piece of database news that flew under the radar this month deserves a far louder reaction: on April 21 Oracle shipped MySQL 9.7.0 LTS — the first major Long-Term Support release since 8.4, and the one that quietly drained a decade of "Enterprise only" features into the Community Edition. If you run Laravel, WordPress, or any in-house IMS on top of MySQL, your second-half database roadmap needs a redraw.
1. The Real Headline: Hypergraph Optimizer in Community Edition
The classic MySQL optimizer treats a query as a sequence of tables to join. Hypergraph treats the whole query as a graph and uses dynamic programming to enumerate connected subplans. The practical differences are concrete: interesting orders are now part of the search, nested-loop versus hash join is a real cost-based choice, and bushy join plans become possible. For Laravel apps running OLAP reports or heavy multi-table JOIN pages, the same SQL can become 2–5x faster without a rewrite.
Caveat: Hypergraph is still off by default in 9.7. You have to flip it with SET optimizer_switch and A/B carefully.
2. In-Database JavaScript Stored Programs
You can now write stored routines in JavaScript inside MySQL, combined with JSON duality from 9.3, full DECIMAL/NUMERIC support, and prepared-statement bind() parameter support added in this release. For Laravel teams, the perennial "compute in PHP or in DB" debate finally has a real third answer: complex money math, schema validation, and JSON shape-shifting can now live in the data layer for real.
3. Security and the 8.0 End of Life
Dynamic data masking has been moved from Enterprise to Community, and native OpenID authentication has shipped. Meanwhile, MySQL 8.0.46 is the last 8.0 release — 8.0 is officially End-of-Life as of April 2026. If you are still on 8.0, you need a migration plan in writing this year.
My Take
The real meaning of MySQL 9.7 LTS is not any single feature; it is the deliberate narrowing of the gap between Enterprise and Community editions. For freelancers, SaaS startups, and mid-market companies that do not want to be locked into MySQL Enterprise, this is the most generous release in a decade. Schedule a 9.7 PoC this year — start with your most JOIN-heavy report pages and benchmark them against Hypergraph.
Sources
- MySQL 9.7: First Major LTS Since 8.4 Brings Enterprise Features to Community Edition — InfoQ
- MySQL 9.7.0 LTS Is Now Available — Oracle MySQL Blog
- The Hypergraph Optimizer Is Now Available in MySQL 9.7 Community Edition — Oracle MySQL Blog
- What's New in MySQL 9 — A DBA's Perspective — Bytebase