Planet MariaDB Server

Problematic Improved Offline Mode Error in MySQL 9

I am writing this quick post to share what I think is a problematic new behavior of Offline Mode in MySQL 9.  Basically, the new default behavior in MySQL 9…

Jean-François Gagné J-F Gagné’s MySQL Blog 2024-12-02

Percona Monitoring and Management 3.0.0-Beta – Tech Preview

Percona Monitoring and Management 3.0.0 Beta – Tech Preview We’re excited to announce the Tech Preview (Beta) release of Percona Monitoring and Management (PMM) 3.0.0-Beta. This release is intended for…

Percona Community Blog – learn about MySQL, MariaDB, PostgreSQL, and MongoDB 2024-12-02

The Light MySQL Startup Optimization on EBS Volumes

In the last weeks / months, I have been working on understanding / improving MySQL startup with many tables.  I already wrote four posts on the subject, they are listed below.  In…

Jean-François Gagné J-F Gagné’s MySQL Blog 2024-11-26

The Light MySQL Startup Optimization on EBS Volumes

In the last weeks / months, I have been working on understanding / improving MySQL startup with many tables.  I already wrote four posts on the subject, they are listed below.  In…

Jean-François Gagné J-F Gagné’s MySQL Blog 2024-11-26

Percona Bug Report: October 2024

At Percona, we operate on the premise that full transparency makes a product better. We strive to build the best open-source database products, but also to help you manage any…

Percona Community Blog – learn about MySQL, MariaDB, PostgreSQL, and MongoDB 2024-11-25

Replica Preserve Commit Order and Measuring Lag

With multi-threaded replication (MTR), a replica can commit transactions in the same order as the source, or not. This is determined by sysvar replica_preserve_commit_order (RPCO). As of MySQL v8.0.27 (released…

Hack MySQL 2024-11-22

Understanding InnoDB Tablespace Duplicate Check (MySQL Startup with Many Tables)

This post is a little long, please bear with me as after the intro, you can skip to the essential.In the last weeks / months, I have been working on…

Jean-François Gagné J-F Gagné’s MySQL Blog 2024-11-19

Understanding InnoDB Tablespace Duplicate Check (MySQL Startup with Many Tables)

This post is a little long, please bear with me as after the intro, you can skip to the essential.In the last weeks / months, I have been working on…

Jean-François Gagné J-F Gagné’s MySQL Blog 2024-11-19

Talk: The implementation of MariaDB parallel replication

On November 6 2024 I presented a talk with the title: “The implementation of MariaDB parallel replication” at a local TeqHub meetup in Copenhagen. In the talk I first presented…

knielsen Kristian Nielsen’s blog 2024-11-12

Talk: The implementation of MariaDB parallel replication

On November 6 2024 I presented a talk with the title: “The implementation of MariaDB parallel replication” at a local TeqHub meetup in Copenhagen. In the talk I first presented…

knielsen Kristian Nielsen’s blog 2024-11-12

Long and Silent / Stressful MySQL Startup with Many Tables

In the last weeks / months, I have been working on understanding / improving MySQL startup with many tables.  I already wrote two posts on the subject, the links are below.  So…

Jean-François Gagné J-F Gagné’s MySQL Blog 2024-11-11

Long and Silent / Stressful MySQL Startup with Many Tables

In the last weeks / months, I have been working on understanding / improving MySQL startup with many tables.  I already wrote two posts on the subject, the links are below.  So…

Jean-François Gagné J-F Gagné’s MySQL Blog 2024-11-11

Release and version management is hard

In this post I will talk about release management with MySQL as example. Release management has to do with what to put in a release, how often to do a…

Daniël van Eeden Daniël’s Database Blog 2024-11-11

Release and version management is hard

In this post I will talk about release management with MySQL as example. Release management has to do with what to put in a release, how often to do a…

Daniël van Eeden Daniël’s Database Blog 2024-11-11

Efficient MySQL Performance In 10 Sentences

Don’t have time to read Efficient MySQL Performance? Here’s the book (10 chapters) in one-liners. Performance is query response time. Proper left-most indexing is required for performance. The less data,…

Hack MySQL 2024-11-09