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

Engine-Independent statistics empty tables and use_stat_tables variable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Not a Bug
    • 10.5
    • N/A
    • Optimizer
    • Debian 11 - InnoDB

    Description

      We migrate from 10.3 to 10.5 version.
      The queries plan change with this upgrade with less performance.
      Engin independent tables statistics are empty.
      When we switch _ use_stat_tables='preferably_for_queries'_ to _ use_stat_tables='never'_ we get back good queries plan.

      Attachments

        Activity

          Transition Time In Source Status Execution Times
          Alice Sherepa made transition -
          Open Needs Feedback
          		23h 7m 1
          Alice Sherepa made transition -
          Needs Feedback Open
          		85d 7h 37m 1
          Alice Sherepa made transition -
          Open Closed
          		13s 1

          People

            Unassigned Unassigned
            nlange Nicolas Lange
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.