We have set our innodb buffer pool 80% of total memory. Mysql page allocation gets stalled sometimes when page cache is occupying memory. Now since mysql is caching table rows and indexes and follows a lifecycle to flush them, doesn't OS page cache have the same data in terms of files? Doesn't it cause cache duplicity and increase in memory usage? If data is duplicated can we assume flushing OS page cache we would have no impact on performance of mysql as innodb buffer pool has hot/active data?


Hence the recommendation of using O_DIRECT.

Your Answer

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

Not the answer you're looking for? Browse other questions tagged or ask your own question.