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

Have analyze store 'empty_space' in table_stats and index_stats

    XMLWordPrintable

Details

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

    Description

      Empty space is here defined as % of space that is unused/reserved on row pages and index pages.

      This information can be helpful for the optimizer to estimate how many rows /keys there is per page and also give the DB's some information that can be used to determinate if 'optimize table' should be run to recover disk space.

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              monty Michael Widenius
              Votes:
              0 Vote for this issue
              Watchers:
              3 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.