maria-developers team mailing list archive

[worklog-noreply@xxxxxxxxxxxx]

-----------------------------------------------------------------------
                              WORKLOG TASK
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
TASK...........: Query statistics
CREATION DATE..: Thu, 30 Jun 2011, 17:08
SUPERVISOR.....: 
IMPLEMENTOR....: 
COPIES TO......: 
CATEGORY.......: Server-RawIdeaBin
TASK ID........: 219 (http://askmonty.org/worklog/?tid=219)
VERSION........: WorkLog-4.0
STATUS.........: Un-Assigned
PRIORITY.......: 60
WORKED HOURS...: 0
ESTIMATE.......: 120 (hours remain)
ORIG. ESTIMATE.: 120

PROGRESS NOTES:



DESCRIPTION:

Log skeletons for queries in server (live from parser) but without constants
with statistics.

Things to consider:

* Should use a fixed memory size. Queries should be removed as FIFO
* Small CPU overhead
* IN(a,b,c) should be equal recorded as IN(#) (One constant)
* multi row inserts needs to be handled as one insert.

We also need a method to do regular expression replacement for table names. This
is needed to be able to recognize similar tables like log tables with a _YYMMDD
prefix.

Statistics to collect per query:
- Number of times executed
- Total time executed (in microseconds)
- Rows read, inserted, updated and deleted.



ESTIMATED WORK TIME

ESTIMATED COMPLETION DATE
-----------------------------------------------------------------------
WorkLog (v4.0.0)