[MDEV-32286] ANALYZE displays a huge number of InnoDB secondary index pages_accessed - Jira

XML

Word

Printable

Details

Type: Bug
Status: Confirmed (View Workflow)
Priority: Critical
Resolution: Unresolved
Affects Version/s: 10.6, 10.11, 11.1(EOL), 11.2, 10.10(EOL), 11.0(EOL)
Fix Version/s: 10.6, 10.11, 11.2
Component/s: Storage Engine - InnoDB
Labels:
- performance

Description

When a table is accessed by an index, "pages_accessed" in the "r_engine_stats" of ANALYZE FORMAT=JSON output displays suspiciously large numbers. See the test case attached and compare pages_accessed=14 for full table scan against pages_accessed=2003 for an access by index.

Attachments

- Sort By Name
- Sort By Date
- Ascending
- Descending
- Thumbnails
- List
- Download All

innodb-pages-accessed.test
2 kB
2023-09-29 06:22

Issue Links

relates to

MDEV-29151 Index choice depends on index definition order

Closed

MDEV-31577 Make ANALYZE FORMAT=JSON print innodb stats

Closed

MDEV-31589 Secondary index MVCC access is unnecessarily inefficient

Stalled

Activity

People

Assignee:: Vladislav Lesin

Reporter:: Oleg Smirnov

Votes:: 0 Vote for this issue

Watchers:: 4 Start watching this issue

Dates

Created:: 2023-09-29 06:25

Updated:: 2024-09-27 09:03

Git Integration

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