maria-developers team mailing list archive

[worklog-noreply@xxxxxxxxxxxx]

-----------------------------------------------------------------------
                              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:

-=-=(Monty - Thu, 22 Oct 2009, 18:38)=-=-
High Level Description modified.
--- /tmp/wklog.60.old.17258     2009-10-22 15:38:47.000000000 +0000
+++ /tmp/wklog.60.new.17258     2009-10-22 15:38:47.000000000 +0000
@@ -1,12 +1,17 @@
 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"
+1)
+Change "show [table|index|user|client]_statistics" to
+"show [table|index|user|client] statistics"
 
-2) Add a "flush statistics" that flushes all statistics to the current "flush
-table statistics"
+Do the same change to the flush command
 
-3) Add where and like clauses to show statistics.
+2)
+Add a "flush statistics" as a synonym for
+flush table_statistics, index statistics..."
+
+3) Add where and like clauses to show XXXX_statistics.
 (only like: match most important column)
 
 This will be done as a patch to the 5.2 tree.



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|index|user|client]_statistics" to
"show [table|index|user|client] statistics"

Do the same change to the flush command

2)
Add a "flush statistics" as a synonym for
flush table_statistics, index statistics..."

3) Add where and like clauses to show XXXX_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)