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