Is there room for more MySQL IO Optimization? This is an off-site link.  Please review our Terms of Service for additional information.

(Peter Zaitsev) I prefer to run MySQL with innodb_flush_method=O_DIRECT in most cases – it makes sure there is no overhead of double buffering and I can save the limited amount of file system cache I would normally have on database server for those things which need to be cached — system files, binary log, FRM files, MySQL MyISAM system tables etc.

Read this article...

comments powered by Disqus