Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

Collect Stored Procedure details from slow query log

Description

Hi, 

At the moment we do not collect if a query was running inside a stored procedure or not. This is a Percona Server specific feature. 

There is a line in the slow log: Stored_routine: db.procedure

Tasks

  1. We should also parse and store the Stored_routine

  2. We should provide ability display only the queries from a specific Stored_routine item, so that a User could inspect all the queries from a sample SP execution

How to test

None

How to document

None

Smart Checklist

Activity

Show:

Tibor Korocz (Percona) November 1, 2019 at 4:07 PM

Hi, 

This is maybe even easier than we thought we should just use Performance Schema for that, honestly I did not know we can find this details in P_S.

https://mablomy.blogspot.com/2015/03/profiling-stored-procedures-in-mysql-57.html

So we can easily query which queries belong to which stored procedure and QAN could display that... 

 

 

 

Tibor Korocz (Percona) September 27, 2019 at 9:27 PM

Hi, Any news on this ticket?

RobF October 5, 2018 at 9:46 PM

Hello - this feature would be very valuable to me as well. Along with the ability to see how often procedures are called, by name. Right now I trawl the slow log for that information. Thanks!

Roma Novikov February 8, 2018 at 8:46 PM

as a reminder about  ideas to this  FR :   auto applied "Labels" to  Query  .. and in this case it  will be :  

"Stored_routine: ccg.TransactionCreateTransaction" label  for example 

 

Kenny Gryp January 12, 2018 at 12:22 AM

: this is listed in the ClickHouse for QAN EPIC, why is that? Seems unrelated.

Details

Assignee

Reporter

Priority

Components

Labels

Needs QA

Yes

Needs Doc

Yes

Story Points

Smart Checklist

Created December 7, 2017 at 12:37 PM
Updated November 13, 2024 at 8:33 AM
Configure