Last week in mysql-server development (33)

[henrikingo-oracle]

In the past two weeks, 8 PRs have been submitted toward mysql-server.

Merged

• Simon Mudd merged Bug#120895: Add missing BuildRequires: for el8/el9…

Review

Alibaba's SongLibing had a busy week:

• NET::buff to reduce memory usage - #714
• Rollback Prepared Transactions Asynchronously During Binlog Crash Recover #711

Xueting Wu submitted the first pull request from Amazon:

• Optimize binlog handling of large transactions (BOLT) #722

Bug fixes (from Percona and independent contributors, thank you!)

• Matan Baruch: Bug#102586: multi-table DELETE with ON DELETE CASCADE breaks row-based replication - #719
• Przemyslaw Skibinski: InnoDB: Parallel DDL threads race in debug_sync on the shared THD - #713
• Catalin Besleaga: Bug#112704: Fix TempTable CTE clone handler mismatch when TempTable falls back to InnoDB - #672

In addition Gopal and Ridha worked through several PRs related to the GitHub PR process itself. In particular, it has been a recurring issue that anyone who submits a PR and is not an Oracle employee, will see most or all tests failing. This is related to GitHub’s security architecture when running automated tests, and the fact that 3rd parties submitting a PR can basically execute arbitrary code by modifying the tests. We are working on it.

In addition to the above there were 4 older PRs open.

Ongoing work

• [VI] Native Vector Index in MySQL
• Native VECTOR Store and VECTOR INDEX Support for MySQL #3
• [VI] Syntax Discussion for CREATE/DROP Vector Index mysql-server#702
• Project board
• [UDT] User Defined Type project
• [DDB] DuckDB as a columnar storage engine to MySQL

New Proposals

• Genze Wu: [Proposal]: Optimizing Replication Lag for Large Transactions and DDL #115

• Song Libing: [Proposal]: Performance Optimization for Binlog Commit #114

• Song Libing; [Proposal]: Rollback Prepared Transactions Asynchronously During Binlog Crash Recovery #100

• Vinicius Grippa: [Proposal]: Precise and observable primary switchover in Group Replication / InnoDB Cluster #97

• Niksa Skeledzija & Annamalaj Gurasami: [Proposal]: Add CSV file bulk load functionality to the community mysql version #94

• Jakub Lopusza: [Proposal]: IBD file offline examiner #93

• The worklog design for In-Memory Relay log was posted by Derrick Yang of AWS Aurora team. (The comment above has the slides for the presentation of this performance optimization.)

Community Slack

In the MySQL Community slack we created some chat rooms dedicated to synchronous communication between project contributors. Note that the primary channels remain the tools we have on GitHub: issues, pull requests, discussions and wiki. Discussions and definitely decisions done in smaller groups should be summarized in the relevant issue or discussion on GitHub.

#dev-mysql-server ¤
#dev-replication ¤
#dev-innodb ¤
#dev-se-duckdb ¤

MySQL Ecosystem Hub

Building upon work from Schlomi Noah and Alkin Teuzysal, Scott Stroz launched the Ecosystem Showcase with over 100 extensions and utilities now discoverable on Planet MySQL!

This is the starting point of the complementary part of our ecosystem strategy: We are bringing together and shining a light on all the cool 3rd party tools, utilities and plugins that are all part of the MySQL ecosystem.

In other news, the blog aggregator is now much more lively than it’s been in a long time, and you are welcome to advertise conferences, meetups and other MySQL events n the event calendar.

---

The goal for this newsletter is to give a high level status overview and link to all the different wikis and threads and code, with minimal commentary. If something significant is missing from this newsletter, please tell henrik.ingo@oracle.com