Bug #21947 | innodb_flush_method = O_DIRECT may degrade performance of InnoDB on SAN | ||
---|---|---|---|
Submitted: | 31 Aug 2006 13:22 | Modified: | 6 Sep 2006 16:36 |
Reporter: | Valeriy Kravchuk | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | MySQL Server: Documentation | Severity: | S2 (Serious) |
Version: | OS: | Any | |
Assigned to: | Paul DuBois | CPU Architecture: | Any |
[31 Aug 2006 13:22]
Valeriy Kravchuk
[6 Sep 2006 16:36]
Paul DuBois
Thank you for your bug report. This issue has been addressed in the documentation. The updated documentation will appear on our website shortly, and will be included in the next release of the relevant products. Note added to innodb_flush_method description: Different values of this variable can have a marked effect on InnoDB performance. For example, on some systems where InnoDB data and log files are located on a SAN, it has been found that setting innodb_flush_method to O_DIRECT can degrade performance of simple SELETE statements by a factor of three.