← Back to team overview

maria-developers team mailing list archive

New (by Bothorsen): Improve the show statistics (60)

 

-----------------------------------------------------------------------
                              WORKLOG TASK
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
TASK...........: Improve the show statistics
CREATION DATE..: Thu, 22 Oct 2009, 17:42
SUPERVISOR.....: Monty
IMPLEMENTOR....: Bothorsen
COPIES TO......: 
CATEGORY.......: Server-RawIdeaBin
TASK ID........: 60 (http://askmonty.org/worklog/?tid=60)
VERSION........: WorkLog-3.4
STATUS.........: Assigned
PRIORITY.......: 60
WORKED HOURS...: 0
ESTIMATE.......: 0 (hours remain)
ORIG. ESTIMATE.: 0

PROGRESS NOTES:



DESCRIPTION:

In the MariaDB 5.2 branch, some new parts to show statistics have been added.
Monty wants these to be improved upon.

1) Change "show table_statistics" to "show table statistics"

2) Add a "flush statistics" that flushes all statistics to the current "flush
table statistics"

3) Add where and like clauses to show statistics.
(only like: match most important column)

This will be done as a patch to the 5.2 tree.

Interesting files for this patch are: sql_show.cc, sql_yacc.yy and lex.h.


ESTIMATED WORK TIME

ESTIMATED COMPLETION DATE
-----------------------------------------------------------------------
WorkLog (v3.5.9)