[MDEV-28537] Unused or useless InnoDB counters num_index_pages_written, num_non_index_pages_written - Jira

XML

Word

Printable

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Fixed
Affects Version/s: 10.2.2, 10.3.0, 10.4.0, 10.5.0, 10.8.0, 10.6.0, 10.7.0, 10.9.0
Fix Version/s: 10.3.35, 10.4.25, 10.5.16, 10.6.8, 10.7.4, 10.8.3, 10.9.1
Component/s: Storage Engine - InnoDB
Labels:
- performance

Description

The InnoDB counters num_index_pages_written and num_non_index_pages_written were added in MariaDB Server 10.1.0 and inadvertently disabled in MariaDB Server 10.2.2 when the instructions to increment these counters were removed from the function fil_io().

Let us remove these counters that never reported anything useful. If such statistics are really needed in a special case, they can be obtained by instrumenting the code by some means, such as eBPF or a source code patch.

Attachments

Issue Links

relates to

MDEV-28541 Unused counter Innodb_encryption_key_rotation_list_length

Closed

MDEV-21212 buf_page_get_gen -> buf_pool->stat.n_page_gets++ is a cpu waste (0.5-1%)

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:: 2022-05-11 08:28

Updated:: 2022-05-23 05:04

Resolved:: 2022-05-16 11:11

Git Integration

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