Members Members   Search Search   Help Help   Register Register   Login Login   Home Home
Home » Performance » MySQL » Experience with innodb_flush_method setting
Experience with innodb_flush_method setting [message #1803] Wed, 12 September 2007 12:08 Go to previous message
chriswest is currently offline chriswest
Messages: 14
Registered: August 2007
Junior Member
I just wanted to ask about your experience with the innodb_flush_method setting since I usually went with 
innodb_flush_method             = O_DIRECT


Recently, while working with new machines, same kernel but a different Raid Controller / HD Setup, I've noticed a heavy performance drop while using O_DIRECT. Trying O_DSYNC was the same. Using the default flush method (not using the innodb_flush_method setting) worked well instead...

Any suggestions or experiences about this setting on different setups (linux kernel versions, raid setups, etc.)?
Report message to a moderator
[Message index]

Read Message
Read Message
Read Message
Read Message
Previous Topic:4GB limit on 32 bit os?
Next Topic:Can't change key_buffer_size
Goto Forum:

  

[ Generate printable PDF ] [ Syndicate this forum (XML) ] [ ]

Current Time: Sun Jul 5 15:11:28 EDT 2009

Total time taken to generate the page: 0.01227 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 2.7.7.
Copyright ©2001-2007 FUD Forum Bulletin Board Software

MySQL is a trademark of Sun Microsystems.
InnoDB is a trademark of Oracle Corp.

Percona Performance Forums are a service of Percona, Inc.
Not affiliated with Sun Microsystems or Oracle Corp.