J-F Gagné's MySQL Blog

Symlinks are Unsafe since MySQL 8.0.39 (and maybe even before)

Thanks AWS Open Source

Binary Log Compression is Safe since MySQL 8.0.34

Row Deletion Jobs Done Right

Mind the InnoDB Purge on Queue / Row Deletion Job (else slow queries)

More than Flushing (also Caching) for innodb_flush_method, and Missing Release Candidate

Undo Log Truncation Bug in 8.0 leads to Data Corruption

Slack is a Suboptimal Feed Reader (RSS / Atom)

Interesting Troubleshooting of a MySQL Crash : filling then freeing the disk

Interesting Binary Logging Optimization in MariaDB

Performance Regression in MySQL 8.0, Fixed in 8.4, Easy Workaround (innodb_doublewrite_pages)

Contrib RFC: Counters for Slow InnoDB Sync Reads

InnoDB Tablespace Duplicate Check Threads (and EBS Volumes for MySQL Startup with Many Tables)

Problematic Improved Offline Mode Error in MySQL 9

The Light MySQL Startup Optimization on EBS Volumes

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

Long and Silent / Stressful MySQL Startup with Many Tables

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

Faster MySQL Startup with Many Tables (1M+)

Trick to Simulate Higher Latency IOs on Linux

Trusting mysqldump and Insecure MySQL Client Lead to Remote Code Execution

RFC: Database / Schema in the Slow Query Log File

17 Years of Insecure MySQL Client !

dbdeployer Tutorial on Mac

Thoughts on the October 2023 MySQL Releases

Rows Examined Blindspot when Looking for non-Existing Data

Avoiding a STOP SLAVE Crash with MTR in Percona Server older than 5.7.37-40

Running and Mountain Climbing at Percona Live Denver

Planet for the MySQL Community Graduating from Beta

Free Page Consumption by InnoDB Table Compression (Percona backoff Algo. part #2)

Tail Latencies in Percona Server because of InnoDB Stalls on Empty Free List

Bad Optimizer Plan on Queries Combining WHERE, ORDER BY and LIMIT

Triggering Replication Lag for Testing a Script