← Back to team overview

maria-developers team mailing list archive

WL#177 New (by Mdcallag): add server-side error logging

 

-----------------------------------------------------------------------
                              WORKLOG TASK
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
TASK...........: add server-side error logging
CREATION DATE..: Tue, 22 Feb 2011, 19:42
SUPERVISOR.....: 
IMPLEMENTOR....: 
COPIES TO......: 
CATEGORY.......: Server-RawIdeaBin
TASK ID........: 177 (http://askmonty.org/worklog/?tid=177)
VERSION........: WorkLog-4.0
STATUS.........: Un-Assigned
PRIORITY.......: 60
WORKED HOURS...: 0
ESTIMATE.......: 0 (hours remain)
ORIG. ESTIMATE.: 0

PROGRESS NOTES:



DESCRIPTION:

I want to log all or a sample of errors on the server side into a new log file 
(not general, error or slow query log) and into a file that can be rotated. In the 
facebook patch I added code to sample query errors into the slow query log using -
-log-sample-error-rate:
* when 0 do not sample
* when 1 then log all errors
* when > 1 then sample 1 of --log-sample-error-rate queries

This should have:
* query text
* username
* timestamp
* database
* errno
* error text
* client IP

The log should support rotation and possibly auto-rotation when it reaches a 
certain size. 


ESTIMATED WORK TIME

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