[MDEV-9313] Add stored procedures invocation in User Statistics Created: 2015-12-22  Updated: 2015-12-22

Status: Open
Project: MariaDB Server
Component/s: None
Fix Version/s: None

Type: Task Priority: Minor
Reporter: Federico Razzoli Assignee: Unassigned
Resolution: Unresolved Votes: 1
Labels: stored_procedures, user_statistics


 Description   

Please add a table showing how much times each procedure/function have been invoked.

I made the same request to Percona:
https://bugs.launchpad.net/percona-server/+bug/1528600



 Comments   
Comment by roberto spadim [ 2015-12-22 ]

hum interesting, maybe we could include something like a profiler?
the best solution in my opnion is something like query_reponse_time plugin (function time histogram), it's a bomb to kill a bird, but usefull...
maybe include request count + total request time? or just request count? must check if this include many mutex or not, and if it create some contention (i think no, stored procedures normally aren't too fast to stop and cause problem with some single mutexes)

+1 for this request

Generated at Thu Feb 08 07:33:44 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.