1. Thread Pool in Percona Server and MySQL (Part 1)

    A post examines thread pooling in Percona Server and MySQL, describing its arrival in Community MySQL Server releases 26.7.0 and 9.7.2. The thread pool plugin had previously been exclusive to MySQL Enterprise Edition, according to the post.

  2. DISTANCE() and VECTOR_DISTANCE(): Vector Similarity in Percona Server for MySQL 9.7

    Percona Server for MySQL 9.7.2-2 adds the DISTANCE() function for scoring vector similarity directly in SQL, with COSINE, EUCLIDEAN, MANHATTAN, and DOT metrics. The function supplies the scoring layer for vector comparisons, while ANN indexing such as HNSW or IVF is identified as a later milestone for fast large-scale search.

  3. Introducing MySQL Workbench 26

    Oracle’s MySQL team introduces MySQL Workbench 26.7, the first release in a new generation of its MySQL administration and development GUI. It follows MySQL Workbench 8, whose C++ and platform architecture is described as old and end of life.

  4. Hardening EmergencyReparentShard in v25

    Vitess is hardening EmergencyReparentShard, its failover process for shards whose primary is dead or unreachable, in upcoming release v25. The changes are intended to make recovery safer, faster, and less brittle.

  5. MySQL 26.10.0 Early Access Is Here

    MySQL 26.10.0 Early Access is available for developers and database teams to preview and evaluate. The release invites feedback as users test application stacks and upgrade plans.

  6. Using DuckDB inside MySQL

    VillageSQL Server adds an extension that lets users run DuckDB queries from within MySQL and join the results with MySQL query results. The integration brings DuckDB’s columnar storage, vectorized execution, and embedded analytics engine to workflows involving formats such as Parquet.

  7. Too many GCache Page Files in MySQL Data Directory

    An investigation examines how thousands of gcache.page.* files accumulated in a Percona XtraDB Cluster data directory and gradually consumed disk space. It looks into why GCache did not appear to clean up the files as expected.

  8. Getting VECTOR capabilities in MySQL 8.4 using VillageSQL

    A verification demonstrates VECTOR capabilities in MySQL 8.4 using VillageSQL’s 0.0.7 development branch and the vsql-vector plugin. It recreates a Percona Live presentation and shows an example using SVECTOR(1024) embedded data.

  9. MySQL INSTANT DDL breaks EXCHANGE PARTITION

    Using ALGORITHM=INSTANT in MySQL can lead to ERROR 1731, “Non matching attribute INSTANT COLUMN(s),” when running EXCHANGE PARTITION. The technical account provides reasoning and fixtures for reproducing the issue.

  10. Five Things to Try in MySQL Workbench 26.7

    MySQL Workbench 26.7 introduces an updated technology base and an architecture built on the MySQL Shell foundation. The post highlights several features to try in the release rather than revisiting the architecture overview.