|
Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com |
how can trace stored procedure usage?
From: Jim Lyons (jlyons4435
gmail.com)
Date: Mon Jan 26 2009 - 11:01:58 CST
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]