Bug #107610 Change default to innodb_flush_method=O_DIRECT
Submitted: 20 Jun 2022 16:00 Modified: 11 Aug 2024 9:04
Reporter: haochen he Email Updates:
Status: Closed Impact on me:
None 
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 
Description:
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:
N/A
[21 Jun 2022 6:01] MySQL Verification Team 
Hi haochen he,

Thank you for your feature request.

regards,
Umesh
[11 Aug 2024 9:04] Rahul Sisondia 
Posted by developer:
 
Fixed through WL#16179 8.4 onwards.