Skip to content
Tagged articles

MySQL 9.7

5 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
Coder Trainee
Coder Trainee
Oct 5, 2026 · Databases

MySQL 9.7 LTS: Writable JSON Duality Views & Hypergraph Optimizer for Community Edition

MySQL 9.7 LTS introduces writable JSON Duality Views and the Hypergraph optimizer in the community edition, enhances replication observability and high‑availability automation, adds audit log rotation and stronger password hashing, but warns that the new optimizer requires regression testing due to mixed performance impact.

Group ReplicationHypergraph optimizerJSON Duality Views
0 likes · 6 min read
MySQL 9.7 LTS: Writable JSON Duality Views & Hypergraph Optimizer for Community Edition
java1234
java1234
Sep 29, 2026 · Databases

MySQL 9.7 Explored: Vector Search, JavaScript Stored Procedures & Bulk Import Gains

This article explores MySQL 9.7's key innovations including native VECTOR type for semantic search, JavaScript stored procedures for in-database logic, parallel bulk import from object storage, and security upgrades like mandatory caching_sha2_password, with practical code examples and upgrade guidance.

Innovation releaseJavaScript stored proceduresMySQL 9.7
0 likes · 18 min read
MySQL 9.7 Explored: Vector Search, JavaScript Stored Procedures & Bulk Import Gains