BestHub
Sign in
Tagged articles

JSON Duality View

2 articles · Page 1 of 1
Architect's Tech Stack
Architect's Tech Stack
Oct 22, 2026 · Databases

MySQL 9.7 LTS Deep Dive: Free Enterprise Features, Hypergraph Optimizer, JSON DML

MySQL 9.7 LTS brings five enterprise features to community edition, introduces the Hypergraph optimizer with 22% geometric mean speedup on TPC-DS, adds DML support to JSON Duality Views, improves rolling upgrades and container CPU detection, and switches password hashing to PBKDF2-SHA512, while vector search remains experimental.

Hypergraph optimizerJSON Duality ViewLTS
0 likes · 10 min read
MySQL 9.7 LTS Deep Dive: Free Enterprise Features, Hypergraph Optimizer, JSON DML
Architect's Tech Stack
Architect's Tech Stack
Oct 19, 2026 · Databases

MySQL 9.7 LTS: OpenTelemetry, JSON Duality Writes & Hypergraph Optimizer Now in Community

MySQL 9.7.0 LTS brings enterprise-grade OpenTelemetry tracing, writable JSON Duality Views, and the Hypergraph optimizer to the community edition, while changing versioning to year-month format; the article details configuration steps, upgrade caveats, and default changes affecting replication and InnoDB logging.

Hypergraph optimizerJSON Duality ViewLTS
0 likes · 11 min read
MySQL 9.7 LTS: OpenTelemetry, JSON Duality Writes & Hypergraph Optimizer Now in Community