← Back to team overview

maria-developers team mailing list archive

WL#195 New (by Mdcallag): SHOW QUERY STATUS

 

-----------------------------------------------------------------------
                              WORKLOG TASK
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
TASK...........: SHOW QUERY STATUS
CREATION DATE..: Thu, 07 Apr 2011, 13:54
SUPERVISOR.....: 
IMPLEMENTOR....: 
COPIES TO......: 
CATEGORY.......: Server-RawIdeaBin
TASK ID........: 195 (http://askmonty.org/worklog/?tid=195)
VERSION........: WorkLog-4.0
STATUS.........: Un-Assigned
PRIORITY.......: 60
WORKED HOURS...: 0
ESTIMATE.......: 0 (hours remain)
ORIG. ESTIMATE.: 0

PROGRESS NOTES:



DESCRIPTION:

I want some performance counters to be maintained per-query in addition to per-
session. This could then be used to implement SHOW QUERY STATUS. It could also be 
used to augment slow query log output with additional performance data per 
statement. The Facebook patch and probably Percona already put more data per 
statement in the slow query log. With the Facebook patch the option --log-slow-
extra enables this. Unfortunately, that uses the session counters and can be 
confusing.

Some details on the use of this in the facebook patch are at:
https://www.facebook.com/note.php?note_id=390420710932


ESTIMATED WORK TIME

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