Bug #26150 Omitting meaningess lines from err-logfile
Submitted: 7 Feb 2007 14:46 Modified: 29 May 2012 13:51
Reporter: Christian Starka Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Stored Routines Severity:S4 (Feature request)
Version:5.1.14 beta OS:Any
Assigned to: CPU Architecture:Any

[7 Feb 2007 14:46] Christian Starka
Description:
With every cyclic start of an event, two lines are added to the err-logfile indicating the successfull start and run of the event. In my opinion the err-logfile should hold errors/warnings etc. but not every successfull start of an event (I also do not get an OK message for each successfull SQL-statement !).

How to repeat:
DELIMITER |

CREATE EVENT WEBSQL.E_MOVE_LTA_DATA
 ON SCHEDULE EVERY 1 MINUTE
 DO
  BEGIN
   SELECT now();
  END |

DELIMITER ;

Suggested fix:
Omit those lines in the logfile (default) or use a further startargument to specify if messages should be written to the logfile.
[29 May 2012 13:51] Valeriy Kravchuk
Thank you for the feature request.