you can try to port Oracles utldtree.sql
Caveat Emptor: Hasnt been worked on since 92 and is VERY buggy!
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: jlyons4435@stripped
> To: mysql@stripped
> 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?
> Jim Lyons
> Web developer / Database administrator
Windows Live™: E-mail. Chat. Share. Get more ways to connect.