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

XML

Word

Printable

Details

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

Sprint:
Q3/2026 Server Maintenance, Q3/2026 Server Development

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:: Alessandro Vetere

Reporter:: Oleg Smirnov

Votes:: 1 Vote for this issue

Watchers:: 7 Start watching this issue

Dates

Created:: 2023-09-29 06:25

Updated:: 3 days ago 17:04

Time Tracking

Estimated:

0.45d

Remaining:

1d 1h 50m

Logged:

3d 5.5h

Git Integration

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