Bug #107610 Change default to innodb_flush_method=O_DIRECT
Submitted: 20 Jun 2022 16:00 Modified: 21 Jun 2022 6:01
Reporter: haochen he Email Updates:
Status: Verified Impact on me:
Category:MySQL Server: InnoDB storage engine Severity:S4 (Feature request)
Version:8.0 OS:Linux
Assigned to: CPU Architecture:Any
Tags: performance

[20 Jun 2022 16:00] haochen he
MySQL use innodb_use_native_aio=on as default. However, using libaio together with OS page cache falls back to sync I/O. Since MySQL has the buffer management itself, why not bypass the OS cache.

Just as what have just been done recently in mariaDB (jira.mariadb.org/browse/MDEV-24854)

How to repeat:
[21 Jun 2022 6:01] MySQL Verification Team
Hi haochen he,

Thank you for your feature request.