MySQL 8.4 introduces a new privilege, FLUSH_PRIVILEGES, which allows database users to execute FLUSH PRIVILEGES statement without the need of RELOAD privilege.

MySQL 9.1 adds support for Windows Hello. And this supports passkeys stored on the OS store. Check how to set up and use one of these instead of the hardware based FIDO2 devices

Starting with MySQL 9.0, users of HeatWave MySQL can now try the new hypergraph optimizer. Read on to learn how to enable the hypergraph optimizer, and to understand what it means for your query plans.

In the last weeks / months, I have been working on understanding / improving MySQL startup with many tables.  I already wrote a post about my work (Faster MySQL Startup with Many Tables).  In that post, I link to a bug report (Bug #115988 : Too Much Disk Read on Startup, penalizing deployments with many tables).  In that bug report, I write, without much details, that the

The MySQL NDB Cluster Development team is quite happy to announce that MySQL NDB Cluster 8.4 (LTS) is available for download. This release includes new features made available before under Innovation Releases - 8.1, 8.2 and 8.3 - and new features made available in 8.4.

The OpenTelemetry project is an open-source, vendor-neutral observability framework, providing a common observability standard. It enables users to instrument their applications in order to export observability data: traces, metrics, and logs, enabling increased granularity of debugging and testing. MySQL Connector/J now supports producing observability data, baked into the driver code, offering a more comprehensive and tightly integrated solution with the MySQL Enterprise Server.

This is the call for participation for the FOSDEM 2025 MySQL Devroom

We are pleased to announce the Call for Participation (CfP) for the FOSDEM 2025 MySQL Devroom. The Devroom will be held on February 2 (Sunday), 2025 in Brussels, Belgium. The submission deadline for talk proposals is December 1, 2024.

FOSDEM is a free event for software developers to meet, share ideas, and collaborate. Every year, thousands of developers of free and open source software from all over the world gather at the event in
Brussels.

The MySQL Devroom aims to provide a dedicated space for presentations covering the most popular open source database and celebrate the 30th anniversary of MySQL.

Key dates

• Proposals can be submitted by October the 30th, 2024
• Submission deadline: 1st December 2024 Brussels time
• Announcement of the selection …

We are pleased to announce the Call for Participation (CfP) for the FOSDEM 2025 MySQL Devroom. The Devroom will be held on February 2 (Sunday), 2025 in Brussels, Belgium. The submission deadline for talk proposals is December 1, 2024. FOSDEM is a free event for software developers to meet, share ideas, and collaborate. Every year, […]

In IRC libera:#mysql somebody asked about the performance of SHOW TABLES LIKE 'name' in MySQL 8.0, which was slow for them, but fast in 5.7. They pointed to a forum article from 2022

that had a similar problem with a select-statement on I_S.TABLES.

Both cases had in common a large number of tables in a single schema. The person in IRC had around 40k tables, the person in the forum article 500k tables.

I wrote about the Million Challenge

in 2021, but was unable to follow through for personal reasons. This question prompted me to pick this up.

Making a million tables

…