Planet MariaDB Server
Server Metrics and InnoDB
Context This is why you need to learn about MySQL server metrics, especially InnoDB metrics: MySQL metrics are closely related to MySQL performance—that’s obvious. After all, the purpose of metrics…
Transactions and Data Locks
Context This is why you need to learn about MySQL transactions and data locks, which are closely related: MySQL has non-transactional storage engines, but InnoDB is the default and the…
Replication
Context This is why you need to learn the basics of MySQL replication, especially the cause of replication lag: Replication lag is the delay between the time when a write…
Cloud Performance
Context This is why you need to learn about the reality of using MySQL in the cloud: MySQL in the cloud is fundamentally the same MySQL that you know and…
Common Challenges
Context This is why you need to learn about common challenges when using MySQL: This chapter is a short but important laundry list of common MySQL challenges and how to…
Learn MySQL Performance
Every year new cohorts of programmers, DBAs, managers, and more learn MySQL. After MySQL and HeatWave Summit 2025 a few weeks ago, I realized what job needs to be done…
Progress report on pg_tde – GA extension is nearer every day!
Another week, another blogpost about the state of open source Transparent Data Encryption (TDE) for PostgreSQL. First off, thank you for all the feedback shared so far! Whether it’s reports…
Performance Regression in MySQL 8.0, Fixed in 8.4, Easy Workaround (innodb_doublewrite_pages)
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…
Performance Regression in MySQL 8.0, Fixed in 8.4, Easy Workaround (innodb_doublewrite_pages)
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…
An Efficient Path to Learn MySQL Performance
Conference Presentations Video Slides MySQL Performance for Application Developers @ MySQL and HeatWave Summit 2025 mysql-summit-2025.pdf MySQL Performance for Developers @ Percona Live 2023† PL23.pdf Efficient MySQL Performance @ Percona…
Going full-time as an open source developer
After careful consideration, I’ve decided to embark on a new chapter in my professional journey. I’ve left my position at AWS to dedicate at least the next six months to…
HOMELAB
Just for fun…Numerous options exist for testing MySQL and general database instances.This is just an example of how you can use Proxmox to have a simple fast setup for repeatable testing and…
MySQL and MariaDB client .so libraries on Linux
The MySQL library is libmysqlclient.so, the MariaDB library is libmariadbclient.so or libmariadb.so. I’ll list some quirks that I think are relatively unknown but good to know. I’ll end with a…
Debian Salsa CI in Google Summer of Code 2025
Are you a student aspiring to participate in the Google Summer of Code 2025? Would you like to improve the continuous integration pipeline used at salsa.debian.org, the Debian GitLab instance,…
Contrib RFC: Counters for Slow InnoDB Sync Reads
I just submitted a MySQL Contribution and I would like to gather feedback about it. Depending on the received feedback, I might submit an updated contribution. The contribution is Counters…