Enhancement: Add support for not logging calls to stored procedure in the slow query log

Bug #1331849 reported by Swany
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Percona Server moved to https://jira.percona.com/projects/PS
Fix Released
Wishlist
Sergei Glushchenko
5.5
Fix Released
Wishlist
Sergei Glushchenko
5.6
Fix Released
Wishlist
Sergei Glushchenko

Bug Description

Customer would like to be able to avoid logging any calls to stored procedures to the slow query log.

From customer:
 ... in our case, our Stored Procedures iterate through a large input string and execute many SQL statements for each of the members of that input string. We know that the Stored Procedure can take several seconds to do all of that work, but we don't really care because we're saving literally millions of database roundtrips a day, and each individual INSERT or UPDATE only takes a millisecond or so. We'd still like to be aware of individual statements taking longer than 1 second (or whichever relevant time as configured by long_query_time). But we don't want 2 Gigabytes of slow_query.log output a day for CALLs to stored procedures we know will be longer than 1 second.

Tags: i43131

Related branches

tags: added: i43131
Revision history for this message
Valerii Kravchuk (valerii-kravchuk) wrote :

It makes perfect sense to add this to the wishlist. Not sure how easy it will be to still log slow queries inside stored routine though.

Revision history for this message
Shahriyar Rzayev (rzayev-sehriyar) wrote :

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PS-2449

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers