From: Daniel Caune
Date: June 7 2007 1:34am
Subject: How to trace statements executed in a procedure called by a client?
List-Archive: http://lists.mysql.com/mysql/207277
Message-Id: <1E293D3FF63A3740B10AD5AAD88535D20509C675@UBIMAIL1.ubisoft.org>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

Hi,

First of all, I would like to apologize if I didn't send my message to
the right mailing list.

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()
  NOT DETERMINISTIC
  MODIFIES SQL DATA
  COMMENT 'Generate the required number of random battles'
BEGIN
  <statement 1>

  <statement 2>

  <statement 3>
END;

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
# User@Host: dbo[dbo] @ localhost []
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 2
SET last_insert_id=3D27274;
CALL foo();

Is there any way to configure mysqld to trace every statement executed
by MySQL?  For information, my current configuration is the following:

[mysqld]
user            =3D mysql
pid-file        =3D /var/run/mysqld/mysqld.pid
socket          =3D /var/run/mysqld/mysqld.sock
port            =3D 3306
basedir         =3D /usr
datadir         =3D /var/lib/mysql
tmpdir          =3D /tmp
language        =3D /usr/share/mysql/english
long_query_time =3D 1
log-queries-not-using-indexes
skip-external-locking
verbose
log_bin_trust_function_creators =3D 1

Thanks a lot!

--
Daniel