how can trace stored procedure usage?

2009-01-26 Thread Jim Lyons 
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

RE: how can trace stored procedure usage?

2009-01-26 Thread Martin Gainty 

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