[MDEV-31048] InnoDB read_slots and write_slots are missing PERFORMANCE_SCHEMA instrumentation - Jira

XML

Word

Printable

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Fixed
Affects Version/s: 10.5(EOL), 10.6, 10.7(EOL), 10.8(EOL), 10.9(EOL), 10.10(EOL), 10.11, 11.0(EOL), 11.1(EOL)
Fix Version/s: 10.6.13, 10.8.8, 10.9.6, 10.10.4, 10.11.3, 11.0.2, 11.1.1
Component/s: Performance Schema, Storage Engine - InnoDB
Labels:
None

Description

For I/O intensive workloads, the mutexes protecting read_slots and write_slots could potentially become congestion points. This has been under the radar, because there is no PERFORMANCE_SCHEMA instrumentation for them.

Let us add wait/synch/mutex/innodb/tpool_cache_mutex for tracking them.

Attachments

Issue Links

relates to

MDEV-16264 Implement a common work queue for InnoDB background tasks

Closed

MDEV-26827 Make page flushing even faster

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:: 2023-04-13 12:09

Updated:: 2024-02-28 12:31

Resolved:: 2023-04-13 12:52

Time Tracking

Estimated:

Not Specified

Remaining:

Logged:

0.75h

Git Integration

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