This worklog has been replaced with mariadb.org/jira

This site is here for historical purposes only. Do not add or edit tasks here!

 
 
 

WorkLog Frontpage Log in / Register
High-Level Description | Task Dependencies | High-Level Specification | Low-Level Design | File Attachments | User Comments | Time Estimates | Funding and Votes | Progress Reports

 Collect engine independent statistics on table columns and indexes to store it in persistent system tables
Title
Task ID248
Queue
Version
Status
Priority
Copies toIgor
Knielsen
Monty
Psergey
Sanja
Sergei
Timour
Wlad

Created byIgor04 Jan 2012Done
Supervisor   
Lead Architect    
Architecture Review  
Implementor  
Code Review  
QA  
Documentation  
 High-Level Description
In a special mode the ANALYZE command will collect statistics on table
cardinality, table columns and table indexes. This statistics will be stored in
system tables table_stat, column_stat and index_stat.

For any database table the system table table_stat will contain the number of
rows in the table.
For any table column the system table column_stat will contain min and max value,
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 system 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 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.

The collected statistics is supposed to be used by the optimizer, but this will
be an objective of some other task.
 Task Dependencies
Others waiting for Task 248Task 248 is waiting forGraph
 
 High-Level Specification
 Low-Level Design
 File Attachments
 NameTypeSizeByDate
 User Comments
 Time Estimates
NameHours WorkedLast Updated
Total0 
 Hrs WorkedProgressCurrentOriginal
This Task0120120
Total0120120
 
 Funding and Votes
Votes: 0: 0%
 Make vote: Useless    Nice to have    Important    Very important    

Funding: 0 offers, total 0 Euro
 Progress Reports


Report Generator:
 
Saved Reports:

WorkLog v4.0.0
  © 2010  Sergei Golubchik and Monty Program AB
  © 2004  Andrew Sweger <yDNA@perlocity.org> and Addnorya
  © 2003  Matt Wagner <matt@mysql.com> and MySQL AB