**Reported in Launchpad by Vlad Lesin last update 30-03-2016 12:04:21

It seems QUERY_RESPONSE_TIME feature counts total execution time wrong for stored procedures.

The first it counts statements execution time inside of stored procedure cumulatively. And it counts the total execution time of "call" statement twice - one for the statements inside stored procedure, second - for "CALL" itself. For example, if we have the following SP:

create procedure aaa()
begin
select sleep(2);
select sleep(2);
end

we expect the total 2(or 3?) queries with execution time between 1s and 10s and the total execution time of such queries is 4(or 8?) seconds.

But really we have 10 seconds which is counted as:

2 (the first sleep) + 4 (the first sleep + the second one) + 4 (the "call" itself) = 10.

We can check that behavior the following way:

mysql> call aaa();
----------

----------

----------
1 row in set (2.03 sec)

----------

----------

----------
1 row in set (4.32 sec)

Query OK, 0 rows affected (4.32 sec)

mysql> SELECT * from INFORMATION_SCHEMA.QUERY_RESPONSE_TIME;
---------------------------------------

---------------------------------------

---------------------------------------
14 rows in set (0.00 sec)