MySQL variable innodb_flush_method – summarized
Kedar
innodb_flush_method variable specifies how InnoDB opens and flushes log and data files. In Innodb optimization, setting the variable innodb_flush_method tweaks the performance most of the times but there are cases…
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”