MySQL Forums
Forum List  »  General

need to capture slow queries within stored procedure
Posted by: Vaibhav Upadhyay
Date: July 11, 2017 08:32AM

Hi All,

Is there any way to capture slow queries which are part of stored procedure?

I want to trace slow queries within stored procedures. Here slow query log is not helpful since it only captures the "CALL started_rpocedure_name".

Also what if i have one stored procedure lets call it "A" and has many stored procedure within lets call it "b","c","d" etc. and further these procedures will be having many queries within. in this case i want to find out the slow query or queries.

Options: ReplyQuote


Subject
Written By
Posted
need to capture slow queries within stored procedure
July 11, 2017 08:32AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.