Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-32286

ANALYZE displays a huge number of InnoDB secondary index pages_accessed

    XMLWordPrintable

Details

    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

        Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-29151 Index choice depends on index definition order

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Task - A task that needs to be done. MDEV-31577 Make ANALYZE FORMAT=JSON print innodb stats

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-31589 Secondary index MVCC access is unnecessarily inefficient

          • Critical - Crashes, loss of data, severe memory leak.
          • Stalled

          Activity

            People

              vlad.lesin Vladislav Lesin
              oleg.smirnov Oleg Smirnov
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

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