How to fix write latency in MySQL 8.4 Upgrade
During any MySQL major version upgrade, especially when moving from 8.0 to 8.4, it’s not just about compatibility checks. Subtle default changes can directly impact MySQL performance tuning, and if…
MySQL 8.4 disables AHI – Why and What you need to know
MySQL 8.4 changed the InnoDB adaptive hash index (innodb_adaptive_hash_index) default from ON to OFF, a major shift after years of it being enabled by default. Note that the MySQL adaptive hash index (AHI) feature remains fully available…
How to checksum on AWS RDS for MySQL Replication 8.0 > 8.4
During a MySQL upgrade process the RDS replication between MySQL 8.0 and 8.4 was configured. I wanted to ensure the data was consistent for any random reason. This post is…
What MySQL configuration you hate the most?
Ever spent your weekend debugging a MySQL production issue that could have been avoided with better configuration? I have, and it’s beyond frustrating. I have prepared my list of the…
MySQL Podcast: InnoDB Cluster Group Replication
I’m working on sharing MySQL tips, tricks, and other related tech topics in my MySQL podcast. It’s a bit of a challenge to stay consistent, but I’m pushing through. Finally…
How to use tmux, a cheat sheet
I think we know that screen is officially old news and most modern Linux systems switched to tmux as the recommended multiplexer with RHEL 8. Recently I had a discussion…