InnoDB Flushing is simple – explained
Kedar
As a junior once I asked a seasoned MySQL DBA (Abuelo) “How do you stay so calm in critical situations?”Abuelo DBA then uttered golden words: “Son, I keep my dirty…
Browsing Tag
MySQL performance tuning
3 posts
MySQL Tools for Performance Tuning and Test Data Generation
As a MySQL consultant, I keep running into the same two problems: reviewing MySQL configurations and generating realistic test data for validation. So I built two focused MySQL tools to…
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…