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

Allow a configurable percentage threshold for InnoDB persistent statistics auto recalc (currently hard coded at 10%)

Details

    • New Feature
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • None
    • None
    • None

    Description

      Currently InnoDB performs an automatic statistics update reaching an hard coded value of 10% of modified rows counter.
      It's maybe reasonable to have a parameter for such functionality.
      E.g.:

      innodb_stats_persistent_auto_recalc_threshold

      Attachments

        Issue Links

          duplicates

          New Feature - A new feature of the product, which has yet to be developed. MDEV-28724 innodb_stats_persistent_sample_pages accepting percentage value

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-36068 InnoDB did not trigger an automatic statistics recalculation

          • Major - Major loss of function.
          • Closed

          Activity

            There are no comments yet on this issue.

            People

              Unassigned Unassigned
              claudio.nanni Claudio Nanni
              Votes:
              0 Vote for this issue
              Watchers:
              5 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.