Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.
Sign up to join this community
My question is simple, is there any way to calculate, number of times a stored procedure is called on applications or executed on MySQL server.
For example:
Procedure name: sptest
Executing procedure: call sptest(1);
Is there any way to identify number of time the statement CALL sptest(1) executed on server.
Thanks in advance.
Look I do it this way in an audit table, each time this function is executed I put it at the foot of the procedure and called each time the query is run.
and consultation is : update audit set calls = calls + 1 where func = 'sptest' ;
In this way you can already know how many times was called and the date
You can create a mapping table with two columns, one key (a string containing the called procedure name plus arguments if you need that) and one value (an integer containing the number of times the corresponding procedure has been called).
The first thing you do in your procedure you want to monitor is to update the mapping table to record the procedure call (by incrementing the counter). This logic you can encapsulate in another stored procedure.
This approach will be inconvenient if you need to monitor a large number of stored procedures, but will work for a small number.
