From: Martin Gainty Date: January 26 2009 5:29pm Subject: RE: how can trace stored procedure usage? List-Archive: http://lists.mysql.com/mysql/216033 Message-Id: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="_4fd99520-0b0b-43a1-b0c4-8879510dbaaa_" --_4fd99520-0b0b-43a1-b0c4-8879510dbaaa_ Content-Type: text/plain; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable Jim- you can try to port Oracles utldtree.sql Caveat Emptor: Hasnt been worked on since 92 and is VERY buggy! Martin Gainty=20 ______________________________________________=20 Disclaimer and confidentiality note=20 Everything in this e-mail and any attachments relates to the official busin= ess of Sender. This transmission is of a confidential nature and Sender doe= s not endorse distribution to any party other than intended recipient. Send= er does not necessarily endorse content contained within this transmission.= =20 > Date: Mon=2C 26 Jan 2009 11:01:58 -0600 > Subject: how can trace stored procedure usage? > From: jlyons4435@stripped > To: mysql@stripped >=20 > I am trying to track the usage of stored procedures on our system. My > solution so far is to parse the general log for "call" queries. This wor= ks > well for procedures that are called from the command line=2C but the gene= ral > log does not seem to report procedures called from within other procedure= s. >=20 > Is there a way to do that? Is there a better overall way to track proced= ure > calls? What about function calls? >=20 > Thanks=2C > Jim >=20 > --=20 > Jim Lyons > Web developer / Database administrator > http://www.weblyons.com _________________________________________________________________ Windows Live=99: E-mail. Chat. Share. Get more ways to connect.=20 http://windowslive.com/howitworks?ocid=3DTXT_TAGLM_WL_t2_allup_howitworks_0= 12009= --_4fd99520-0b0b-43a1-b0c4-8879510dbaaa_--