Showing entries 11 to 20 of 43820
« 10 Newer Entries | 10 Older Entries »
How to use passkeys to authenticate to MySQL

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

The MySQL Hypergraph Optimizer Now Available in HeatWave MySQL

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.

Impressed by Disabling InnoDB Redo Logging for Creating Tables as Fast as Possible

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

MySQL NDB Cluster 8.4 - What's new

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.

MySQL Connector/J Observability with OpenTelemetry

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.

FOSDEM 2025 MySQL Devroom - call for participation

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

FOSDEM 2025 MySQL Devroom – call for participation

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 …
[Read more]
FOSDEM 2025 MySQL Devroom – call for participation

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, […]

MySQL: information_schema.tables performance regression

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

[Read more]
MySQL: dual passwords

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]
Showing entries 11 to 20 of 43820
« 10 Newer Entries | 10 Older Entries »