[MDEV-30517] On windows 11, difference of innodb_flush_method=O_DIRECT vs. innodb_flush_method=unbuffered - Jira

XML

Word

Printable

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Not a Bug
Affects Version/s: 10.7.7
Fix Version/s: N/A
Component/s: Platform Windows, Storage Engine - InnoDB
Labels:
None
Environment:
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

Activity

People

Assignee:: Vladislav Vaintroub

Reporter:: Mitchell Lee

Votes:: 0 Vote for this issue

Watchers:: 1 Start watching this issue

Dates

Created:: 2023-01-31 04:40

Updated:: 2023-02-01 08:46

Resolved:: 2023-01-31 16:43

Git Integration

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.