[MDEV-19738] Doublewrite buffer is unnecessarily used for newly (re)initialized pages - Jira

XML

Word

Printable

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Critical
Resolution: Fixed
Affects Version/s: 10.2(EOL), 10.3(EOL), 10.4(EOL), 10.5
Fix Version/s: 10.5.0
Component/s: Storage Engine - InnoDB
Labels:
- performance
- recovery

Description

Thanks to ~~MDEV-12699~~, the doublewrite buffer will only be needed in those cases when a page is being updated in the data file. If the page had never been written to the data file since it was initialized, then recovery will be able to reconstruct the page based solely on the contents of the redo log files.

The doublewrite buffer is only really needed when recovery needs to read the page in order to apply redo log.

Avoiding unnecessary use of the doublewrite buffer should improve the write performance of InnoDB.

Attachments

Issue Links

is blocked by

MDEV-12699 Improve crash recovery of corrupted data pages

Closed

relates to

MDEV-19739 Avoid unnecessary page reads on recovery with innodb_log_optimize_ddl=ON

Closed

MDEV-19747 Deprecate and ignore innodb_log_optimize_ddl

Closed

MDEV-31816 buf_LRU_free_page() does not preserve ROW_FORMAT=COMPRESSED block state

Closed

MDEV-11125 Introduce a reduced doublewrite mode, handling error detection only

Closed

MDEV-22369 Assertion `err == DB_SUCCESS' failed. in btr_block_get_func during crash recovery

Closed

(1 relates to)

Activity

People

Assignee:: Marko Mäkelä

Reporter:: Marko Mäkelä

Votes:: 0 Vote for this issue

Watchers:: 4 Start watching this issue

Dates

Created:: 2019-04-18 14:20

Updated:: 2024-06-05 09:53

Resolved:: 2019-06-12 17:33

Git Integration

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