Find:

Your Information Technology Answers are Here on SSWUG.ORG

SSWUG.ORG is the one of the largest community-driven sites that focuses on enterprise technology, as more than 570,000 members regularly visit our site for answers to their questions on data management, collaboration software, development tools and cloud computing.

Our staff works to issue relevant and in-depth articles, podcasts, webcasts, expos and classes to members and non-members alike.




DATABASES

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