MySQL 8.4 disables AHI – Why and What you need to know
Kedar
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…
One response to “MySQL variable innodb_flush_method – summarized”
Kedar,
Thanks a lot for info. But i have a question if you can answer that too, it’d be great.
Is there any disadvantages of setting innodb_flush_method=normal in Windows?
as with this option, we prevents mysql from using unbuffered IO OR native async IO.
Let me know of any disadvantages or harm that can possibly happens to mysql data by setting this option to “normal”