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

          Ascending order - Click to sort in descending order
          alice Alice Sherepa added a comment -

          Could you please illustrate the problem with an example ( create table, analyze, etc.)?

          alice Alice Sherepa added a comment - Could you please illustrate the problem with an example ( create table, analyze, etc.)?
          elenst Elena Stepanova added a comment -

          Engine independent statistics would naturally be empty at first, you need to run ANALYZE ... PERSISTENT FOR ALL on tables to collect the statistics.
          Does the problem persist after collecting the statistics?

          elenst Elena Stepanova added a comment - Engine independent statistics would naturally be empty at first, you need to run ANALYZE ... PERSISTENT FOR ALL on tables to collect the statistics. Does the problem persist after collecting the statistics?
          nlange Nicolas Lange added a comment -

          On huge database in production, it's not easy to collect the statistics. We try with a slave for some tables but it's to complexe to manage.
          But we'll make some test just switch to use_stat_tables='preferably_for_queries' and collecte what analyzes change.

          nlange Nicolas Lange added a comment - On huge database in production, it's not easy to collect the statistics. We try with a slave for some tables but it's to complexe to manage. But we'll make some test just switch to use_stat_tables='preferably_for_queries' and collecte what analyzes change.
          nlange Nicolas Lange added a comment -

          Finally we don't reproduce the issue, I think you can close it.
          Regards.

          nlange Nicolas Lange added a comment - Finally we don't reproduce the issue, I think you can close it. Regards.

          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.