[#MDEV-28144] provide the way to identify the stored procedure name in show processlist

[MDEV-28144] provide the way to identify the stored procedure name in show processlist Created: 2022-03-22 Updated: 2023-11-30
Status:	Open
Project:	MariaDB Server
Component/s:	None
Fix Version/s:	11.5

Type:

New Feature

Priority:

Major

Reporter:

Allen Lee (Inactive)

Assignee:

Ralf Gebhardt

Resolution:

Unresolved

Votes:

Labels:

monitoring, stored_procedures

Description

customer is asking a way to identify the stored procedure name in `show processlist`.
show processlist only shows the currently running statement inside of stored process instead of `call <sp name>...`. If that is doable, it would be nice for a customer can identify which sp is running.

Comments

Comment by Oleksandr Byelkin [ 2023-01-16 ]

Of course the name of the procedure can be found, probably even all stack of calls (do they need it?, if no which procedure they want bottom-most of top-most?)

Generated at Thu Feb 08 09:58:24 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.

[MDEV-28144] provide the way to identify the stored procedure name in show processlist Created: 2022-03-22 Updated: 2023-11-30