Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Not a Bug
-
10.7.7
-
None
-
Windows 11 22H2
Description
Questioning to highlight the issue to fix better
On the Windows 11 22H2, again, on the Windows latest version
Those two configuration working for main DB engine without error mesages.
- innodb_flush_method=O_DIRECT
- innodb_flush_method=unbuffered
Thing is that the option innodb_flush_method=unbuffered seems may make more delay when IO intensive situation while innodb_flush_method=O_DIRECT working with not so much of delay or waiting.
innodb_flush_method=unbuffered makes obvious waiting.
Please look in to it what makes difference since innodb_flush_method=O_DIRECT makes NO error on the Windows.
Attachments
Issue Links
- relates to
-
MDEV-30474 Crash when after massively repeated C,U,D(especially INSERT with duplicated update) with ZERO SELECT
-
- Closed
-
-
MDEV-30492 Crash when use mariabackup.exe with config 'innodb_flush_method=async_unbuffered'
-
- Closed
-
-
MDEV-30500 Drop statement not droped in specific circumstances
-
- Closed
-
-
MDEV-30512 mysqldump.exe not working with 'innodb_flush_method=unbuffered'
-
- Closed
-
Surprisingly, there is no difference between O_DIRECT and unbuffered in the recent versions of MariaDB.
Originally, on Unixen O_DIRECT means that data files are not cached, but the redo log is cached.
On Windows, neither data files, nor redo log is cached in this case (unless innodb_flush_log_at_trx_commit=2), which makes O_DIRECT method equal to unbuffered/async_unbuffered.
Having, caching redo log in the file system makes no sense anyway, as every write is followed by flush.