From: Martin Gainty (mgaintyhotmail.com)
Date: Mon Jan 26 2009 - 11:29:19 CST

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

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: jlyons4435gmail.com
> To: mysqllists.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

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]