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

innodb_stats_traditional Equivalent for InnoDB Persistent Statistics

    XMLWordPrintable

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

            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.