mirror of
https://github.com/MariaDB/server.git
synced 2025-08-01 03:47:19 +03:00
420f8e24ab
We have innodb_use_native_aio=ON by default since the introduction of
that parameter in commit 2f9fb41b05
(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.
18 lines
426 B
Plaintext
18 lines
426 B
Plaintext
call mtr.add_suppression("InnoDB: Failed to set .*DIRECT");
|
|
select @@innodb_flush_method;
|
|
@@innodb_flush_method
|
|
O_DIRECT
|
|
create table t(a serial) engine=innodb;
|
|
FLUSH TABLES;
|
|
# restart: --innodb-flush-method=5
|
|
select @@innodb_flush_method;
|
|
@@innodb_flush_method
|
|
O_DIRECT_NO_FSYNC
|
|
insert into t values(0);
|
|
FLUSH TABLES;
|
|
# restart: --innodb-flush-method=0
|
|
select @@innodb_flush_method;
|
|
@@innodb_flush_method
|
|
fsync
|
|
drop table t;
|