Jim- you can try to port Oracles utldtree.sql
Caveat Emptor: Hasnt been worked on since 92 and is VERY buggy! Martin Gainty ______________________________________________ Disclaimer and confidentiality note Everything in this e-mail and any attachments relates to the official business of Sender. This transmission is of a confidential nature and Sender does not endorse distribution to any party other than intended recipient. Sender does not necessarily endorse content contained within this transmission. > Date: Mon, 26 Jan 2009 11:01:58 -0600 > Subject: how can trace stored procedure usage? > From: jlyons4...@gmail.com > To: mysql@lists.mysql.com > > 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 works > well for procedures that are called from the command line, but the general > log does not seem to report procedures called from within other procedures. > > Is there a way to do that? Is there a better overall way to track procedure > calls? What about function calls? > > Thanks, > Jim > > -- > Jim Lyons > Web developer / Database administrator > http://www.weblyons.com _________________________________________________________________ Windows Liveā¢: E-mail. Chat. Share. Get more ways to connect. http://windowslive.com/howitworks?ocid=TXT_TAGLM_WL_t2_allup_howitworks_012009