maria-developers team mailing list archive
-
maria-developers team
-
Mailing list archive
-
Message #04036
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)