[MDEV-24789] Performance regression after MDEV-24671 - Jira

XML

Word

Printable

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Blocker
Resolution: Fixed
Affects Version/s: 10.6
Fix Version/s: 10.6.0
Component/s: Storage Engine - InnoDB
Labels:
- performance
- regression

Description

The fix of ~~MDEV-24671~~ introduced a serious performance regression that is observable at 32 concurrent connections.

My current hypothesis based on some initial investigation is that the changed sizeof(trx->lock) caused an increase of cache misses.

Attachments

Issue Links

causes

MDEV-25016 Race condition between lock_sys_t::cancel() and page split or merge

Closed

MDEV-25371 Potential hang in wsrep_is_BF_lock_timeout()

Closed

MDEV-26883 InnoDB hang due to table lock conflict

Closed

is caused by

MDEV-24671 Assertion failure in lock_wait_table_reserve_slot()

Closed

relates to

MDEV-25016 Race condition between lock_sys_t::cancel() and page split or merge

Closed

Activity

People

Assignee:: Marko Mäkelä

Reporter:: Marko Mäkelä

Votes:: 0 Vote for this issue

Watchers:: 1 Start watching this issue

Dates

Created:: 2021-02-05 10:20

Updated:: 2022-12-20 14:56

Resolved:: 2021-03-02 12:41

Git Integration

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