My question is related to MySQL administration, where I don't have any
particular experience. I would to trace every SQL statement executed
inside a procedure that is called by a client:
CREATE PROCEDURE foo()
MODIFIES SQL DATA
COMMENT 'Generate the required number of random battles'
The problem is that the mysql-slow.log file only contains a trace of
the call to the procedure; it does not provide any trace of every
subsequent statement executed by the procedure itself:
# Time: 070607 1:23:04
# UserHost: dbo[dbo] localhost 
# Query_time: 0 ...