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