MySQL Forums
Forum List  »  MySQL Administrator

General Log & Stored Procedures
Posted by: Sean OMahony
Date: February 13, 2013 06:18AM


I have recently enabled my general log file (general-log = 1) to help debug some production performance issues. Since enabling them, I have noticed the log file is filling up rapidly. It seems that where a SQL statement calls a stored procedure, mysql outputs the SQL statement once but also outputs every SET command of the stored procedure along with the values used.
This makes the log file very large and unusable.

Has anyone experienced this issue? is it an issue with stored procedures in mysql?

thanks for any assistance,

Edited 1 time(s). Last edit at 02/13/2013 07:25AM by Sean OMahony.

Options: ReplyQuote

Written By
General Log & Stored Procedures
February 13, 2013 06:18AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.