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

Analyze table on sequences should be prohibited

    XMLWordPrintable

Details

    • Task
    • Status: In Progress (View Workflow)
    • Major
    • Resolution: Unresolved
    • 11.6
    • Sequences
    • None

    Description

      A sequence table has always only on row.
      It is pointless to do ANALYZE TABLE to collect statistics on it (The main usable value is always out of date).

      The task is to have 'analyze table' on sequences 'do nothing' and we should not try to fetch persistent index or column statistics for sequences.

      Attachments

        Activity

          People

            monty Michael Widenius
            monty Michael Widenius
            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.