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

innodb_stats_traditional Equivalent for InnoDB Persistent Statistics

Details

    Description

      The relatively new innodb_stats_traditional variable allows the number of pages used while calculating statistics to scale with table size to give more accurate statistics. However, it only works with transient statistics. It would be nice to have that variable also affect persistent statistics or create a new variable to use the same behavior with persistent statistics.

      Attachments

        Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-7084 innodb index stats inadequate using constant innodb_stats_sample_pages

          • Major - Major loss of function.
          • Closed

          Task - A task that needs to be done. MDEV-7196 ANALYZE TABLE should do complete table scan

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Open

          Task - A task that needs to be done. MDEV-7197 different random pages pulled for each index when updating stats

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Open

          Activity

            danblack Daniel Black added a comment -

            The algorithm for number of pages scanned is significantly different https://github.com/MariaDB/server/blob/10.2/storage/innobase/dict/dict0stats.cc#L2193 and appears be increased with the number of levels. It doesn't seem to be critical to log scale it. Have you observed a problem?

            Alternately with MDEV-7901 Has analyze table with low impact now so perhaps time for MDEV-7196 Analyze table to do full table scan?

            danblack Daniel Black added a comment - The algorithm for number of pages scanned is significantly different https://github.com/MariaDB/server/blob/10.2/storage/innobase/dict/dict0stats.cc#L2193 and appears be increased with the number of levels. It doesn't seem to be critical to log scale it. Have you observed a problem? Alternately with MDEV-7901 Has analyze table with low impact now so perhaps time for MDEV-7196 Analyze table to do full table scan?

            People

              Unassigned Unassigned
              bradjorgensen Brad Jorgensen
              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.