• Marko Mäkelä's avatar
    MDEV-24854: Change innodb_flush_method=O_DIRECT by default · 420f8e24
    Marko Mäkelä authored
    We have innodb_use_native_aio=ON by default since the introduction of
    that parameter in commit 2f9fb41b
    (MySQL 5.5 and MariaDB 5.5).
    
    However, to really benefit from the setting, the files should be
    opened in O_DIRECT mode, to bypass the file system cache.
    In this way, the reads and writes can be submitted with DMA, using
    the InnoDB buffer pool directly, and no processor cycles need to be
    used for copying data. The use of O_DIRECT benefits not only the
    current libaio implementation, but also liburing.
    
    os_file_set_nocache(): Test innodb_flush_method in the function,
    not in the callers.
    420f8e24
fil0fil.h 58.8 KB