Comment 9 for bug 1093385
Revision history for this message
| Sergei Glushchenko (sergei.glushchenko) wrote | #9 |
© 2004
Canonical Ltd.
•
Terms of use
•
Data privacy
•
Contact Launchpad Support
•
Blog
•
Careers
•
System status
•
73416ba
(Get the code!)
Well, I don't see any way how POSIX_FADV_DONTNEED can harm InnoDB.
OS file cache is redundant for InnoDB. In fact page which exists in OS cache will likely exist in buffer pool too. And if page is absent in buffer pool it will likely absent in OS cache also. Redo logs are write-only unless we do recovery. There is also read ahead in InnoDB.
I believe that POSIX_FADV_DONTNEED should work just fine for Xtrabackup both for data and log files if we will not discard data cached by read-ahead.