[MDEV-8305] Add ability to track "slow" stored procedures in slow query log Created: 2015-06-11 Updated: 2019-03-05 Resolved: 2018-05-22 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | Stored routines |
| Fix Version/s: | 10.3.1 |
| Type: | Task | Priority: | Major |
| Reporter: | Chris Calender (Inactive) | Assignee: | Michael Widenius |
| Resolution: | Fixed | Votes: | 4 |
| Labels: | None | ||
| Issue Links: |
|
||||||||||||
| Description |
|
Please add the ability to track "slow" stored procedures in slow query log. Perhaps this could be backported from Percona Server. They currently have the option: log_slow_sp_statements
There are quite a few more details listed there which may help shed light on the implementation, such as:
|
| Comments |
| Comment by Sergei Golubchik [ 2015-06-16 ] |
|
Few considerations:
|
| Comment by Colin Charles [ 2016-03-10 ] |
|
this is in Percona Server 5.5, 5.6 and 5.7 - we need to see this in MariaDB Server 10.2 please (https://www.percona.com/doc/percona-server/5.7/diagnostics/slow_extended.html) |
| Comment by Michael Widenius [ 2017-07-21 ] |
|
This functionality is now pushed to bb-10.3-monty to be included in next 10.3 alpha. The differences to the patch in Percona server are:
From the commit statement (I have omitted internal changes not relevant for end user): New functionallity:
Mapped some old variables to bitmaps (old variables can still be used)
|
| Comment by Michael Widenius [ 2018-05-22 ] |
|
Fixed and pushed a long time ago |