Details

    • Type: Task
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Fix Version/s: 10.0.1
    • Component/s: None
    • Labels:
      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

              • Assignee:
                igor Igor Babaev
                Reporter:
                ratzpo Rasmus Johansson
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: