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.
…
[Read more]Account password rotation is often a regulatory requirement. For that very reason, MySQL allows you to have multiple passwords on a single account.
I have written about this in Rotating Accounts or Passwords?
.
Of course, if something is a regulatory requirement, you also need to prove that you are meeting it.
So Percona has a nice article Tracking Dual Passwords in MySQL
which shows how can (not) track dual password usage.
While it is somewhat possible to generate a report that shows you which accounts have dual passwords, other things are hard. Finding out which accounts have used what password last, or if an old account password is still being used (and from what machine) is either painful or …
[Read more]