MySQL 5, stored procedure, mysql-slow.log

[Daniel Caune]

Hi,

 

Is there any configuration to be setup to get each query of a stored
procedure, called by a client, in the mysql-slow.log or mysql.log?  For
the moment, I just have the stored procedure call in the log file, but I
need to trace every SQL statement of this stored procedure.

 

# Time: 070605 21:59:01

# User@Host: dbo[dbo] @ localhost []

# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 1

CALL generate_random_battles();

 

Thanks,

  

 


Attachment: [text/html]

Attachment: [text/html]