J-F Gagné's MySQL Blog

I have known for some times that there is an interesting improvement in MySQL 8.0.17 regarding GTID Crash Safety, but I have not had the time nor the need to look into it before.

This MySQL replication error — fatal error 1236 / Replica has more GTIDs than the source has, using the source's SERVER_UUID — shows the importance of thinking before acting.

Today, I was reminded of a MySQL Best Practice, probably generalizable to all databases : using simple types, not complex types.

This lesson should have been learned with the CREATE TABLE of death, but it is worth a refresh.

A few months ago, I was asking myself how to insert in two tables in a single round-trip to the database.

You read this right, symbolic links (symlinks) are unsafe in MySQL since at least 8.0.39.

I would like to thank AWS Open Source for their support.

This is a quick one.

I am continuing my blog post series on using indexes — or tables — as queues.

I am starting a blog post series on using indexes — or tables — as queues.

Something changed in MySQL 8.4 related to caching, and it is easy to miss, so it deserves a post.

I am upset about this one : I have a hard time not seeing this as negligence, and it starts to become a pattern...

This is a MySQL Blog, why am I posting about Slack, Feed Readers, RSS and Atom ?

I recently troubleshoot an interesting MySQL crash, and I think it is worth sharing (with the related bugs).

As I wrote in a LinkedIn post, I am working on a blog post related to binary logging of big transactions.

While doing benchmarks on 5.7 and 8.0, I came across a performance regression in MySQL 8.0 over 5.7 and opened a bug (Bug #111353 : 3x Performance Regression from 5.7 to 8.0 on ALTER TABLE FORCE).

I just submitted a MySQL Contribution and I would like to gather feedback about it.

In the last weeks / months, I have been working on understanding / improving MySQL startup with many tables.

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

In the last weeks / months, I have been working on understanding / improving 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 understanding / improving MySQL startup with many tables.

In the last weeks / months, I have been working on understanding / improving MySQL startup with many tables.

In the last weeks / months, I have been working on understanding / improving MySQL startup with many tables.

I have been scratching my head about MySQL startup for some time.

When running tests, it is sometimes useful to slow down IOs to clearly show the impact of reading from the disk.