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

Engine independent statistics

    XMLWordPrintable

Details

    • Task
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 10.0.1
    • None
    • None

    Description

      In a special mode the ANALYZE TABLE statement will collect statistics on table cardinality, table columns and table indexes. This statistics will be stored in tables table_stat, column_stat and index_stat in the mysql database.

      • For any database table the table table_stat will contain the number of rows in the table.
      • For any table column the table column_stat will contain the minimal and maximal values, the share of null values, the average length of a column value, and the the average frequency of the column values.
      • For any index defined on a database table the table index_stat will contain number of records per every key prefix.

      This task will be implemented in 3 steps:

      1. A pure back-port of the MySQL WL#4777 from mysql-5.4 code line will be performed.
      2. New possibility to collect statistics only on specified columns and/or indexes will be added.
      3. A new possibility to scan only a certain percentage of the table records in a pseudo-random manner will be added.

      References:

      1. WL#248: Collect engine independent statistics on table columns and indexes to store it in persistent system tables
      2. WL#250: Use the statistics from persistent statistical tables instead of the statistics provided by engine

      Attachments

        Issue Links

          Activity

            People

              igor Igor Babaev
              ratzpo Rasmus Johansson (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              2 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.