Percona Server moved to https://jira.percona.com/projects/PS

Merge lp:~tsarev/percona-server/5.5_fix_bug_855312 into lp:percona-server/5.5

  1. 5.5_fix_bug_855312
  2. Merge into 5.5
Proposed by Oleg Tsarev
Status: Superseded
Proposed branch: lp:~tsarev/percona-server/5.5_fix_bug_855312
Merge into: lp:percona-server/5.5
Diff against target: 1774 lines (+1017/-92) (has conflicts)
1 file modified
patches/response_time_distribution.patch (+1017/-92)
Text conflict in patches/response_time_distribution.patch
To merge this branch: bzr merge lp:~tsarev/percona-server/5.5_fix_bug_855312
Reviewer Review Type Date Requested Status
Percona developers Pending
Review via email: mp+76346@code.launchpad.net

This proposal has been superseded by a proposal from 2011-09-22.

Description of the change

Fix bug #855312: QUERY_RESPONSE_TIME doesn't respect QUERY_RESPONSE_TIME_STATS
Fix: add check of opt_query_response_time_stats before call query_response_time_collect

To post a comment you must log in.
Revision history for this message
Oleg Tsarev (tsarev) wrote :

http://jenkins.percona.com/view/Percona%20Server%205.5/job/percona-server-5.5-param/117/

Revision history for this message
Oleg Tsarev (tsarev) wrote :

http://jenkins.percona.com/view/Percona%20Server%205.5/job/percona-server-5.5-param/118/

Preview Diff

[H/L] Next/Prev Comment, [J/K] Next/Prev File, [N/P] Next/Prev Hunk
=== modified file 'patches/response_time_distribution.patch'
--- patches/response_time_distribution.patch 2011-09-21 08:35:45 +0000
+++ patches/response_time_distribution.patch 2011-09-21 08:37:28 +0000
@@ -48,12 +48,14 @@
48+enable_query_log;48+enable_query_log;
49--- /dev/null49--- /dev/null
50+++ b/mysql-test/include/query_response_time.inc50+++ b/mysql-test/include/query_response_time.inc
51@@ -0,0 +1,39 @@51@@ -0,0 +1,41 @@
52+SET SESSION query_exec_time=0.1;52+SET SESSION query_exec_time=0.1;
53+53+
54+SET GLOBAL QUERY_RESPONSE_TIME_STATS=0;54+SET GLOBAL QUERY_RESPONSE_TIME_STATS=0;
55+EVAL SET GLOBAL QUERY_RESPONSE_TIME_RANGE_BASE=$base;55+EVAL SET GLOBAL QUERY_RESPONSE_TIME_RANGE_BASE=$base;
56+FLUSH QUERY_RESPONSE_TIME;56+FLUSH QUERY_RESPONSE_TIME;
57+SHOW QUERY_RESPONSE_TIME;
58+SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME;
57+SET GLOBAL QUERY_RESPONSE_TIME_STATS=1;59+SET GLOBAL QUERY_RESPONSE_TIME_STATS=1;
58+60+
59+SET SESSION query_exec_time=0.31; SELECT 1;61+SET SESSION query_exec_time=0.31; SELECT 1;
@@ -90,7 +92,7 @@
90+SET SESSION query_exec_time=default;92+SET SESSION query_exec_time=default;
91--- /dev/null93--- /dev/null
92+++ b/mysql-test/include/query_response_time-replication.inc94+++ b/mysql-test/include/query_response_time-replication.inc
93@@ -0,0 +1,57 @@95@@ -0,0 +1,59 @@
94+connection master;96+connection master;
95+97+
96+CREATE TABLE t(id INT);98+CREATE TABLE t(id INT);
@@ -106,6 +108,8 @@
106+SET GLOBAL QUERY_RESPONSE_TIME_STATS=0;108+SET GLOBAL QUERY_RESPONSE_TIME_STATS=0;
107+--eval SET GLOBAL QUERY_RESPONSE_TIME_RANGE_BASE=$base109+--eval SET GLOBAL QUERY_RESPONSE_TIME_RANGE_BASE=$base
108+FLUSH QUERY_RESPONSE_TIME;110+FLUSH QUERY_RESPONSE_TIME;
111+SHOW QUERY_RESPONSE_TIME;
112+SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME;
109+SET GLOBAL QUERY_RESPONSE_TIME_STATS=1;113+SET GLOBAL QUERY_RESPONSE_TIME_STATS=1;
110+114+
111+connection master;115+connection master;
@@ -150,12 +154,14 @@
150+sync_slave_with_master;154+sync_slave_with_master;
151--- /dev/null155--- /dev/null
152+++ b/mysql-test/include/query_response_time-stored.inc156+++ b/mysql-test/include/query_response_time-stored.inc
153@@ -0,0 +1,37 @@157@@ -0,0 +1,39 @@
154+SET SESSION query_exec_time=0.1;158+SET SESSION query_exec_time=0.1;
155+159+
156+SET GLOBAL QUERY_RESPONSE_TIME_STATS=0;160+SET GLOBAL QUERY_RESPONSE_TIME_STATS=0;
157+EVAL SET GLOBAL QUERY_RESPONSE_TIME_RANGE_BASE=$base;161+EVAL SET GLOBAL QUERY_RESPONSE_TIME_RANGE_BASE=$base;
158+FLUSH QUERY_RESPONSE_TIME;162+FLUSH QUERY_RESPONSE_TIME;
163+SHOW QUERY_RESPONSE_TIME;
164+SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME;
159+SET GLOBAL QUERY_RESPONSE_TIME_STATS=1;165+SET GLOBAL QUERY_RESPONSE_TIME_STATS=1;
160+166+
161+CALL test_f(0.31);167+CALL test_f(0.31);
@@ -190,7 +196,7 @@
190+SET SESSION query_exec_time=default;196+SET SESSION query_exec_time=default;
191--- /dev/null197--- /dev/null
192+++ b/mysql-test/r/percona_query_response_time-replication.result198+++ b/mysql-test/r/percona_query_response_time-replication.result
193@@ -0,0 +1,727 @@199@@ -0,0 +1,1031 @@
194+SET GLOBAL query_exec_time=0.1;200+SET GLOBAL query_exec_time=0.1;
195+include/master-slave.inc201+include/master-slave.inc
196+[connection master]202+[connection master]
@@ -203,6 +209,98 @@
203+Warnings:209+Warnings:
204+Warning 1292 Truncated incorrect query_response_time_range_base value: '1'210+Warning 1292 Truncated incorrect query_response_time_range_base value: '1'
205+FLUSH QUERY_RESPONSE_TIME;211+FLUSH QUERY_RESPONSE_TIME;
212+SHOW QUERY_RESPONSE_TIME;
213+
214+ 0.000001 0 0.000000
215+ 0.000003 0 0.000000
216+ 0.000007 0 0.000000
217+ 0.000015 0 0.000000
218+ 0.000030 0 0.000000
219+ 0.000061 0 0.000000
220+ 0.000122 0 0.000000
221+ 0.000244 0 0.000000
222+ 0.000488 0 0.000000
223+ 0.000976 0 0.000000
224+ 0.001953 0 0.000000
225+ 0.003906 0 0.000000
226+ 0.007812 0 0.000000
227+ 0.015625 0 0.000000
228+ 0.031250 0 0.000000
229+ 0.062500 0 0.000000
230+ 0.125000 0 0.000000
231+ 0.250000 0 0.000000
232+ 0.500000 0 0.000000
233+ 1.000000 0 0.000000
234+ 2.000000 0 0.000000
235+ 4.000000 0 0.000000
236+ 8.000000 0 0.000000
237+ 16.000000 0 0.000000
238+ 32.000000 0 0.000000
239+ 64.000000 0 0.000000
240+ 128.000000 0 0.000000
241+ 256.000000 0 0.000000
242+ 512.000000 0 0.000000
243+ 1024.000000 0 0.000000
244+ 2048.000000 0 0.000000
245+ 4096.000000 0 0.000000
246+ 8192.000000 0 0.000000
247+ 16384.000000 0 0.000000
248+ 32768.000000 0 0.000000
249+ 65536.000000 0 0.000000
250+ 131072.000000 0 0.000000
251+ 262144.000000 0 0.000000
252+ 524288.000000 0 0.000000
253+ 1048576.00000 0 0.000000
254+ 2097152.00000 0 0.000000
255+ 4194304.00000 0 0.000000
256+ 8388608.00000 0 0.000000
257+TOO LONG 0 TOO LONG
258+SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME;
259+time count total
260+ 0.000001 0 0.000000
261+ 0.000003 0 0.000000
262+ 0.000007 0 0.000000
263+ 0.000015 0 0.000000
264+ 0.000030 0 0.000000
265+ 0.000061 0 0.000000
266+ 0.000122 0 0.000000
267+ 0.000244 0 0.000000
268+ 0.000488 0 0.000000
269+ 0.000976 0 0.000000
270+ 0.001953 0 0.000000
271+ 0.003906 0 0.000000
272+ 0.007812 0 0.000000
273+ 0.015625 0 0.000000
274+ 0.031250 0 0.000000
275+ 0.062500 0 0.000000
276+ 0.125000 0 0.000000
277+ 0.250000 0 0.000000
278+ 0.500000 0 0.000000
279+ 1.000000 0 0.000000
280+ 2.000000 0 0.000000
281+ 4.000000 0 0.000000
282+ 8.000000 0 0.000000
283+ 16.000000 0 0.000000
284+ 32.000000 0 0.000000
285+ 64.000000 0 0.000000
286+ 128.000000 0 0.000000
287+ 256.000000 0 0.000000
288+ 512.000000 0 0.000000
289+ 1024.000000 0 0.000000
290+ 2048.000000 0 0.000000
291+ 4096.000000 0 0.000000
292+ 8192.000000 0 0.000000
293+ 16384.000000 0 0.000000
294+ 32768.000000 0 0.000000
295+ 65536.000000 0 0.000000
296+ 131072.000000 0 0.000000
297+ 262144.000000 0 0.000000
298+ 524288.000000 0 0.000000
299+ 1048576.00000 0 0.000000
300+ 2097152.00000 0 0.000000
301+ 4194304.00000 0 0.000000
302+ 8388608.00000 0 0.000000
303+TOO LONG 0 TOO LONG
206+SET GLOBAL QUERY_RESPONSE_TIME_STATS=1;304+SET GLOBAL QUERY_RESPONSE_TIME_STATS=1;
207+SET SESSION query_exec_time = 0.31;305+SET SESSION query_exec_time = 0.31;
208+INSERT INTO t VALUES(1);306+INSERT INTO t VALUES(1);
@@ -254,7 +352,7 @@
254+query_response_time_range_base 2352+query_response_time_range_base 2
255+SHOW QUERY_RESPONSE_TIME;353+SHOW QUERY_RESPONSE_TIME;
256+ 354+
257+ 0.000001 2 0.000000355+ 0.000001 1 0.000000
258+ 0.000003 0 0.000000356+ 0.000003 0 0.000000
259+ 0.000007 0 0.000000357+ 0.000007 0 0.000000
260+ 0.000015 0 0.000000358+ 0.000015 0 0.000000
@@ -270,7 +368,7 @@
270+ 0.015625 0 0.000000368+ 0.015625 0 0.000000
271+ 0.031250 0 0.000000369+ 0.031250 0 0.000000
272+ 0.062500 0 0.000000370+ 0.062500 0 0.000000
273+ 0.125000 3 0.300000371+ 0.125000 1 0.100000
274+ 0.250000 0 0.000000372+ 0.250000 0 0.000000
275+ 0.500000 30 10.650000373+ 0.500000 30 10.650000
276+ 1.000000 3 1.500000374+ 1.000000 3 1.500000
@@ -300,7 +398,7 @@
300+TOO LONG 0 TOO LONG398+TOO LONG 0 TOO LONG
301+SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME;399+SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME;
302+time count total400+time count total
303+ 0.000001 2 0.000000401+ 0.000001 1 0.000000
304+ 0.000003 0 0.000000402+ 0.000003 0 0.000000
305+ 0.000007 0 0.000000403+ 0.000007 0 0.000000
306+ 0.000015 0 0.000000404+ 0.000015 0 0.000000
@@ -316,7 +414,7 @@
316+ 0.015625 0 0.000000414+ 0.015625 0 0.000000
317+ 0.031250 0 0.000000415+ 0.031250 0 0.000000
318+ 0.062500 0 0.000000416+ 0.062500 0 0.000000
319+ 0.125000 4 0.400000417+ 0.125000 1 0.100000
320+ 0.250000 0 0.000000418+ 0.250000 0 0.000000
321+ 0.500000 30 10.650000419+ 0.500000 30 10.650000
322+ 1.000000 3 1.500000420+ 1.000000 3 1.500000
@@ -354,6 +452,98 @@
354+SET GLOBAL QUERY_RESPONSE_TIME_STATS=0;452+SET GLOBAL QUERY_RESPONSE_TIME_STATS=0;
355+SET GLOBAL QUERY_RESPONSE_TIME_RANGE_BASE=2;453+SET GLOBAL QUERY_RESPONSE_TIME_RANGE_BASE=2;
356+FLUSH QUERY_RESPONSE_TIME;454+FLUSH QUERY_RESPONSE_TIME;
455+SHOW QUERY_RESPONSE_TIME;
456+
457+ 0.000001 0 0.000000
458+ 0.000003 0 0.000000
459+ 0.000007 0 0.000000
460+ 0.000015 0 0.000000
461+ 0.000030 0 0.000000
462+ 0.000061 0 0.000000
463+ 0.000122 0 0.000000
464+ 0.000244 0 0.000000
465+ 0.000488 0 0.000000
466+ 0.000976 0 0.000000
467+ 0.001953 0 0.000000
468+ 0.003906 0 0.000000
469+ 0.007812 0 0.000000
470+ 0.015625 0 0.000000
471+ 0.031250 0 0.000000
472+ 0.062500 0 0.000000
473+ 0.125000 0 0.000000
474+ 0.250000 0 0.000000
475+ 0.500000 0 0.000000
476+ 1.000000 0 0.000000
477+ 2.000000 0 0.000000
478+ 4.000000 0 0.000000
479+ 8.000000 0 0.000000
480+ 16.000000 0 0.000000
481+ 32.000000 0 0.000000
482+ 64.000000 0 0.000000
483+ 128.000000 0 0.000000
484+ 256.000000 0 0.000000
485+ 512.000000 0 0.000000
486+ 1024.000000 0 0.000000
487+ 2048.000000 0 0.000000
488+ 4096.000000 0 0.000000
489+ 8192.000000 0 0.000000
490+ 16384.000000 0 0.000000
491+ 32768.000000 0 0.000000
492+ 65536.000000 0 0.000000
493+ 131072.000000 0 0.000000
494+ 262144.000000 0 0.000000
495+ 524288.000000 0 0.000000
496+ 1048576.00000 0 0.000000
497+ 2097152.00000 0 0.000000
498+ 4194304.00000 0 0.000000
499+ 8388608.00000 0 0.000000
500+TOO LONG 0 TOO LONG
501+SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME;
502+time count total
503+ 0.000001 0 0.000000
504+ 0.000003 0 0.000000
505+ 0.000007 0 0.000000
506+ 0.000015 0 0.000000
507+ 0.000030 0 0.000000
508+ 0.000061 0 0.000000
509+ 0.000122 0 0.000000
510+ 0.000244 0 0.000000
511+ 0.000488 0 0.000000
512+ 0.000976 0 0.000000
513+ 0.001953 0 0.000000
514+ 0.003906 0 0.000000
515+ 0.007812 0 0.000000
516+ 0.015625 0 0.000000
517+ 0.031250 0 0.000000
518+ 0.062500 0 0.000000
519+ 0.125000 0 0.000000
520+ 0.250000 0 0.000000
521+ 0.500000 0 0.000000
522+ 1.000000 0 0.000000
523+ 2.000000 0 0.000000
524+ 4.000000 0 0.000000
525+ 8.000000 0 0.000000
526+ 16.000000 0 0.000000
527+ 32.000000 0 0.000000
528+ 64.000000 0 0.000000
529+ 128.000000 0 0.000000
530+ 256.000000 0 0.000000
531+ 512.000000 0 0.000000
532+ 1024.000000 0 0.000000
533+ 2048.000000 0 0.000000
534+ 4096.000000 0 0.000000
535+ 8192.000000 0 0.000000
536+ 16384.000000 0 0.000000
537+ 32768.000000 0 0.000000
538+ 65536.000000 0 0.000000
539+ 131072.000000 0 0.000000
540+ 262144.000000 0 0.000000
541+ 524288.000000 0 0.000000
542+ 1048576.00000 0 0.000000
543+ 2097152.00000 0 0.000000
544+ 4194304.00000 0 0.000000
545+ 8388608.00000 0 0.000000
546+TOO LONG 0 TOO LONG
357+SET GLOBAL QUERY_RESPONSE_TIME_STATS=1;547+SET GLOBAL QUERY_RESPONSE_TIME_STATS=1;
358+SET SESSION query_exec_time = 0.31;548+SET SESSION query_exec_time = 0.31;
359+INSERT INTO t VALUES(1);549+INSERT INTO t VALUES(1);
@@ -405,7 +595,7 @@
405+query_response_time_range_base 2595+query_response_time_range_base 2
406+SHOW QUERY_RESPONSE_TIME;596+SHOW QUERY_RESPONSE_TIME;
407+ 597+
408+ 0.000001 2 0.000000598+ 0.000001 1 0.000000
409+ 0.000003 0 0.000000599+ 0.000003 0 0.000000
410+ 0.000007 0 0.000000600+ 0.000007 0 0.000000
411+ 0.000015 0 0.000000601+ 0.000015 0 0.000000
@@ -421,7 +611,7 @@
421+ 0.015625 0 0.000000611+ 0.015625 0 0.000000
422+ 0.031250 0 0.000000612+ 0.031250 0 0.000000
423+ 0.062500 0 0.000000613+ 0.062500 0 0.000000
424+ 0.125000 3 0.300000614+ 0.125000 1 0.100000
425+ 0.250000 0 0.000000615+ 0.250000 0 0.000000
426+ 0.500000 30 10.650000616+ 0.500000 30 10.650000
427+ 1.000000 3 1.500000617+ 1.000000 3 1.500000
@@ -451,7 +641,7 @@
451+TOO LONG 0 TOO LONG641+TOO LONG 0 TOO LONG
452+SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME;642+SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME;
453+time count total643+time count total
454+ 0.000001 2 0.000000644+ 0.000001 1 0.000000
455+ 0.000003 0 0.000000645+ 0.000003 0 0.000000
456+ 0.000007 0 0.000000646+ 0.000007 0 0.000000
457+ 0.000015 0 0.000000647+ 0.000015 0 0.000000
@@ -467,7 +657,7 @@
467+ 0.015625 0 0.000000657+ 0.015625 0 0.000000
468+ 0.031250 0 0.000000658+ 0.031250 0 0.000000
469+ 0.062500 0 0.000000659+ 0.062500 0 0.000000
470+ 0.125000 4 0.400000660+ 0.125000 1 0.100000
471+ 0.250000 0 0.000000661+ 0.250000 0 0.000000
472+ 0.500000 30 10.650000662+ 0.500000 30 10.650000
473+ 1.000000 3 1.500000663+ 1.000000 3 1.500000
@@ -505,6 +695,38 @@
505+SET GLOBAL QUERY_RESPONSE_TIME_STATS=0;695+SET GLOBAL QUERY_RESPONSE_TIME_STATS=0;
506+SET GLOBAL QUERY_RESPONSE_TIME_RANGE_BASE=10;696+SET GLOBAL QUERY_RESPONSE_TIME_RANGE_BASE=10;
507+FLUSH QUERY_RESPONSE_TIME;697+FLUSH QUERY_RESPONSE_TIME;
698+SHOW QUERY_RESPONSE_TIME;
699+
700+ 0.000001 0 0.000000
701+ 0.000010 0 0.000000
702+ 0.000100 0 0.000000
703+ 0.001000 0 0.000000
704+ 0.010000 0 0.000000
705+ 0.100000 0 0.000000
706+ 1.000000 0 0.000000
707+ 10.000000 0 0.000000
708+ 100.000000 0 0.000000
709+ 1000.000000 0 0.000000
710+ 10000.000000 0 0.000000
711+ 100000.000000 0 0.000000
712+ 1000000.00000 0 0.000000
713+TOO LONG 0 TOO LONG
714+SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME;
715+time count total
716+ 0.000001 0 0.000000
717+ 0.000010 0 0.000000
718+ 0.000100 0 0.000000
719+ 0.001000 0 0.000000
720+ 0.010000 0 0.000000
721+ 0.100000 0 0.000000
722+ 1.000000 0 0.000000
723+ 10.000000 0 0.000000
724+ 100.000000 0 0.000000
725+ 1000.000000 0 0.000000
726+ 10000.000000 0 0.000000
727+ 100000.000000 0 0.000000
728+ 1000000.00000 0 0.000000
729+TOO LONG 0 TOO LONG
508+SET GLOBAL QUERY_RESPONSE_TIME_STATS=1;730+SET GLOBAL QUERY_RESPONSE_TIME_STATS=1;
509+SET SESSION query_exec_time = 0.31;731+SET SESSION query_exec_time = 0.31;
510+INSERT INTO t VALUES(1);732+INSERT INTO t VALUES(1);
@@ -556,13 +778,13 @@
556+query_response_time_range_base 10778+query_response_time_range_base 10
557+SHOW QUERY_RESPONSE_TIME;779+SHOW QUERY_RESPONSE_TIME;
558+ 780+
559+ 0.000001 2 0.000000781+ 0.000001 1 0.000000
560+ 0.000010 0 0.000000782+ 0.000010 0 0.000000
561+ 0.000100 0 0.000000783+ 0.000100 0 0.000000
562+ 0.001000 0 0.000000784+ 0.001000 0 0.000000
563+ 0.010000 0 0.000000785+ 0.010000 0 0.000000
564+ 0.100000 0 0.000000786+ 0.100000 0 0.000000
565+ 1.000000 36 12.450000787+ 1.000000 34 12.250000
566+ 10.000000 33 77.099997788+ 10.000000 33 77.099997
567+ 100.000000 0 0.000000789+ 100.000000 0 0.000000
568+ 1000.000000 0 0.000000790+ 1000.000000 0 0.000000
@@ -572,13 +794,13 @@
572+TOO LONG 0 TOO LONG794+TOO LONG 0 TOO LONG
573+SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME;795+SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME;
574+time count total796+time count total
575+ 0.000001 2 0.000000797+ 0.000001 1 0.000000
576+ 0.000010 0 0.000000798+ 0.000010 0 0.000000
577+ 0.000100 0 0.000000799+ 0.000100 0 0.000000
578+ 0.001000 0 0.000000800+ 0.001000 0 0.000000
579+ 0.010000 0 0.000000801+ 0.010000 0 0.000000
580+ 0.100000 0 0.000000802+ 0.100000 0 0.000000
581+ 1.000000 37 12.550000803+ 1.000000 34 12.250000
582+ 10.000000 33 77.099997804+ 10.000000 33 77.099997
583+ 100.000000 0 0.000000805+ 100.000000 0 0.000000
584+ 1000.000000 0 0.000000806+ 1000.000000 0 0.000000
@@ -596,6 +818,44 @@
596+SET GLOBAL QUERY_RESPONSE_TIME_STATS=0;818+SET GLOBAL QUERY_RESPONSE_TIME_STATS=0;
597+SET GLOBAL QUERY_RESPONSE_TIME_RANGE_BASE=7;819+SET GLOBAL QUERY_RESPONSE_TIME_RANGE_BASE=7;
598+FLUSH QUERY_RESPONSE_TIME;820+FLUSH QUERY_RESPONSE_TIME;
821+SHOW QUERY_RESPONSE_TIME;
822+
823+ 0.000001 0 0.000000
824+ 0.000008 0 0.000000
825+ 0.000059 0 0.000000
826+ 0.000416 0 0.000000
827+ 0.002915 0 0.000000
828+ 0.020408 0 0.000000
829+ 0.142857 0 0.000000
830+ 1.000000 0 0.000000
831+ 7.000000 0 0.000000
832+ 49.000000 0 0.000000
833+ 343.000000 0 0.000000
834+ 2401.000000 0 0.000000
835+ 16807.000000 0 0.000000
836+ 117649.000000 0 0.000000
837+ 823543.000000 0 0.000000
838+ 5764801.00000 0 0.000000
839+TOO LONG 0 TOO LONG
840+SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME;
841+time count total
842+ 0.000001 0 0.000000
843+ 0.000008 0 0.000000
844+ 0.000059 0 0.000000
845+ 0.000416 0 0.000000
846+ 0.002915 0 0.000000
847+ 0.020408 0 0.000000
848+ 0.142857 0 0.000000
849+ 1.000000 0 0.000000
850+ 7.000000 0 0.000000
851+ 49.000000 0 0.000000
852+ 343.000000 0 0.000000
853+ 2401.000000 0 0.000000
854+ 16807.000000 0 0.000000
855+ 117649.000000 0 0.000000
856+ 823543.000000 0 0.000000
857+ 5764801.00000 0 0.000000
858+TOO LONG 0 TOO LONG
599+SET GLOBAL QUERY_RESPONSE_TIME_STATS=1;859+SET GLOBAL QUERY_RESPONSE_TIME_STATS=1;
600+SET SESSION query_exec_time = 0.31;860+SET SESSION query_exec_time = 0.31;
601+INSERT INTO t VALUES(1);861+INSERT INTO t VALUES(1);
@@ -647,13 +907,13 @@
647+query_response_time_range_base 7907+query_response_time_range_base 7
648+SHOW QUERY_RESPONSE_TIME;908+SHOW QUERY_RESPONSE_TIME;
649+ 909+
650+ 0.000001 2 0.000000910+ 0.000001 1 0.000000
651+ 0.000008 0 0.000000911+ 0.000008 0 0.000000
652+ 0.000059 0 0.000000912+ 0.000059 0 0.000000
653+ 0.000416 0 0.000000913+ 0.000416 0 0.000000
654+ 0.002915 0 0.000000914+ 0.002915 0 0.000000
655+ 0.020408 0 0.000000915+ 0.020408 0 0.000000
656+ 0.142857 3 0.300000916+ 0.142857 1 0.100000
657+ 1.000000 33 12.150000917+ 1.000000 33 12.150000
658+ 7.000000 33 77.099997918+ 7.000000 33 77.099997
659+ 49.000000 0 0.000000919+ 49.000000 0 0.000000
@@ -666,13 +926,13 @@
666+TOO LONG 0 TOO LONG926+TOO LONG 0 TOO LONG
667+SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME;927+SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME;
668+time count total928+time count total
669+ 0.000001 2 0.000000929+ 0.000001 1 0.000000
670+ 0.000008 0 0.000000930+ 0.000008 0 0.000000
671+ 0.000059 0 0.000000931+ 0.000059 0 0.000000
672+ 0.000416 0 0.000000932+ 0.000416 0 0.000000
673+ 0.002915 0 0.000000933+ 0.002915 0 0.000000
674+ 0.020408 0 0.000000934+ 0.020408 0 0.000000
675+ 0.142857 4 0.400000935+ 0.142857 1 0.100000
676+ 1.000000 33 12.150000936+ 1.000000 33 12.150000
677+ 7.000000 33 77.099997937+ 7.000000 33 77.099997
678+ 49.000000 0 0.000000938+ 49.000000 0 0.000000
@@ -693,6 +953,24 @@
693+SET GLOBAL QUERY_RESPONSE_TIME_STATS=0;953+SET GLOBAL QUERY_RESPONSE_TIME_STATS=0;
694+SET GLOBAL QUERY_RESPONSE_TIME_RANGE_BASE=156;954+SET GLOBAL QUERY_RESPONSE_TIME_RANGE_BASE=156;
695+FLUSH QUERY_RESPONSE_TIME;955+FLUSH QUERY_RESPONSE_TIME;
956+SHOW QUERY_RESPONSE_TIME;
957+
958+ 0.000041 0 0.000000
959+ 0.006410 0 0.000000
960+ 1.000000 0 0.000000
961+ 156.000000 0 0.000000
962+ 24336.000000 0 0.000000
963+ 3796416.00000 0 0.000000
964+TOO LONG 0 TOO LONG
965+SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME;
966+time count total
967+ 0.000041 0 0.000000
968+ 0.006410 0 0.000000
969+ 1.000000 0 0.000000
970+ 156.000000 0 0.000000
971+ 24336.000000 0 0.000000
972+ 3796416.00000 0 0.000000
973+TOO LONG 0 TOO LONG
696+SET GLOBAL QUERY_RESPONSE_TIME_STATS=1;974+SET GLOBAL QUERY_RESPONSE_TIME_STATS=1;
697+SET SESSION query_exec_time = 0.31;975+SET SESSION query_exec_time = 0.31;
698+INSERT INTO t VALUES(1);976+INSERT INTO t VALUES(1);
@@ -744,18 +1022,18 @@
744+query_response_time_range_base 1561022+query_response_time_range_base 156
745+SHOW QUERY_RESPONSE_TIME;1023+SHOW QUERY_RESPONSE_TIME;
746+ 1024+
747+ 0.000041 2 0.0000001025+ 0.000041 1 0.000000
748+ 0.006410 0 0.0000001026+ 0.006410 0 0.000000
749+ 1.000000 36 12.4500001027+ 1.000000 34 12.250000
750+ 156.000000 33 77.0999971028+ 156.000000 33 77.099997
751+ 24336.000000 0 0.0000001029+ 24336.000000 0 0.000000
752+ 3796416.00000 0 0.0000001030+ 3796416.00000 0 0.000000
753+TOO LONG 0 TOO LONG1031+TOO LONG 0 TOO LONG
754+SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME;1032+SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME;
755+time count total1033+time count total
756+ 0.000041 2 0.0000001034+ 0.000041 1 0.000000
757+ 0.006410 0 0.0000001035+ 0.006410 0 0.000000
758+ 1.000000 37 12.5500001036+ 1.000000 34 12.250000
759+ 156.000000 33 77.0999971037+ 156.000000 33 77.099997
760+ 24336.000000 0 0.0000001038+ 24336.000000 0 0.000000
761+ 3796416.00000 0 0.0000001039+ 3796416.00000 0 0.000000
@@ -770,6 +1048,22 @@
770+SET GLOBAL QUERY_RESPONSE_TIME_STATS=0;1048+SET GLOBAL QUERY_RESPONSE_TIME_STATS=0;
771+SET GLOBAL QUERY_RESPONSE_TIME_RANGE_BASE=1000;1049+SET GLOBAL QUERY_RESPONSE_TIME_RANGE_BASE=1000;
772+FLUSH QUERY_RESPONSE_TIME;1050+FLUSH QUERY_RESPONSE_TIME;
1051+SHOW QUERY_RESPONSE_TIME;
1052+
1053+ 0.000001 0 0.000000
1054+ 0.001000 0 0.000000
1055+ 1.000000 0 0.000000
1056+ 1000.000000 0 0.000000
1057+ 1000000.00000 0 0.000000
1058+TOO LONG 0 TOO LONG
1059+SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME;
1060+time count total
1061+ 0.000001 0 0.000000
1062+ 0.001000 0 0.000000
1063+ 1.000000 0 0.000000
1064+ 1000.000000 0 0.000000
1065+ 1000000.00000 0 0.000000
1066+TOO LONG 0 TOO LONG
773+SET GLOBAL QUERY_RESPONSE_TIME_STATS=1;1067+SET GLOBAL QUERY_RESPONSE_TIME_STATS=1;
774+SET SESSION query_exec_time = 0.31;1068+SET SESSION query_exec_time = 0.31;
775+INSERT INTO t VALUES(1);1069+INSERT INTO t VALUES(1);
@@ -821,17 +1115,17 @@
821+query_response_time_range_base 10001115+query_response_time_range_base 1000
822+SHOW QUERY_RESPONSE_TIME;1116+SHOW QUERY_RESPONSE_TIME;
823+ 1117+
824+ 0.000001 2 0.0000001118+ 0.000001 1 0.000000
825+ 0.001000 0 0.0000001119+ 0.001000 0 0.000000
826+ 1.000000 36 12.4500001120+ 1.000000 34 12.250000
827+ 1000.000000 33 77.0999971121+ 1000.000000 33 77.099997
828+ 1000000.00000 0 0.0000001122+ 1000000.00000 0 0.000000
829+TOO LONG 0 TOO LONG1123+TOO LONG 0 TOO LONG
830+SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME;1124+SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME;
831+time count total1125+time count total
832+ 0.000001 2 0.0000001126+ 0.000001 1 0.000000
833+ 0.001000 0 0.0000001127+ 0.001000 0 0.000000
834+ 1.000000 37 12.5500001128+ 1.000000 34 12.250000
835+ 1000.000000 33 77.0999971129+ 1000.000000 33 77.099997
836+ 1000000.00000 0 0.0000001130+ 1000000.00000 0 0.000000
837+TOO LONG 0 TOO LONG1131+TOO LONG 0 TOO LONG
@@ -847,6 +1141,22 @@
847+Warnings:1141+Warnings:
848+Warning 1292 Truncated incorrect query_response_time_range_base value: '1001'1142+Warning 1292 Truncated incorrect query_response_time_range_base value: '1001'
849+FLUSH QUERY_RESPONSE_TIME;1143+FLUSH QUERY_RESPONSE_TIME;
1144+SHOW QUERY_RESPONSE_TIME;
1145+
1146+ 0.000001 0 0.000000
1147+ 0.001000 0 0.000000
1148+ 1.000000 0 0.000000
1149+ 1000.000000 0 0.000000
1150+ 1000000.00000 0 0.000000
1151+TOO LONG 0 TOO LONG
1152+SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME;
1153+time count total
1154+ 0.000001 0 0.000000
1155+ 0.001000 0 0.000000
1156+ 1.000000 0 0.000000
1157+ 1000.000000 0 0.000000
1158+ 1000000.00000 0 0.000000
1159+TOO LONG 0 TOO LONG
850+SET GLOBAL QUERY_RESPONSE_TIME_STATS=1;1160+SET GLOBAL QUERY_RESPONSE_TIME_STATS=1;
851+SET SESSION query_exec_time = 0.31;1161+SET SESSION query_exec_time = 0.31;
852+INSERT INTO t VALUES(1);1162+INSERT INTO t VALUES(1);
@@ -898,17 +1208,17 @@
898+query_response_time_range_base 10001208+query_response_time_range_base 1000
899+SHOW QUERY_RESPONSE_TIME;1209+SHOW QUERY_RESPONSE_TIME;
900+ 1210+
901+ 0.000001 2 0.0000001211+ 0.000001 1 0.000000
902+ 0.001000 0 0.0000001212+ 0.001000 0 0.000000
903+ 1.000000 36 12.4500001213+ 1.000000 34 12.250000
904+ 1000.000000 33 77.0999971214+ 1000.000000 33 77.099997
905+ 1000000.00000 0 0.0000001215+ 1000000.00000 0 0.000000
906+TOO LONG 0 TOO LONG1216+TOO LONG 0 TOO LONG
907+SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME;1217+SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME;
908+time count total1218+time count total
909+ 0.000001 2 0.0000001219+ 0.000001 1 0.000000
910+ 0.001000 0 0.0000001220+ 0.001000 0 0.000000
911+ 1.000000 37 12.5500001221+ 1.000000 34 12.250000
912+ 1000.000000 33 77.0999971222+ 1000.000000 33 77.099997
913+ 1000000.00000 0 0.0000001223+ 1000000.00000 0 0.000000
914+TOO LONG 0 TOO LONG1224+TOO LONG 0 TOO LONG
@@ -920,13 +1230,105 @@
920+SET GLOBAL query_exec_time=default;1230+SET GLOBAL query_exec_time=default;
921--- /dev/null1231--- /dev/null
922+++ b/mysql-test/r/percona_query_response_time.result1232+++ b/mysql-test/r/percona_query_response_time.result
923@@ -0,0 +1,1003 @@1233@@ -0,0 +1,1307 @@
924+SET SESSION query_exec_time=0.1;1234+SET SESSION query_exec_time=0.1;
925+SET GLOBAL QUERY_RESPONSE_TIME_STATS=0;1235+SET GLOBAL QUERY_RESPONSE_TIME_STATS=0;
926+SET GLOBAL QUERY_RESPONSE_TIME_RANGE_BASE=1;1236+SET GLOBAL QUERY_RESPONSE_TIME_RANGE_BASE=1;
927+Warnings:1237+Warnings:
928+Warning 1292 Truncated incorrect query_response_time_range_base value: '1'1238+Warning 1292 Truncated incorrect query_response_time_range_base value: '1'
929+FLUSH QUERY_RESPONSE_TIME;1239+FLUSH QUERY_RESPONSE_TIME;
1240+SHOW QUERY_RESPONSE_TIME;
1241+
1242+ 0.000001 0 0.000000
1243+ 0.000003 0 0.000000
1244+ 0.000007 0 0.000000
1245+ 0.000015 0 0.000000
1246+ 0.000030 0 0.000000
1247+ 0.000061 0 0.000000
1248+ 0.000122 0 0.000000
1249+ 0.000244 0 0.000000
1250+ 0.000488 0 0.000000
1251+ 0.000976 0 0.000000
1252+ 0.001953 0 0.000000
1253+ 0.003906 0 0.000000
1254+ 0.007812 0 0.000000
1255+ 0.015625 0 0.000000
1256+ 0.031250 0 0.000000
1257+ 0.062500 0 0.000000
1258+ 0.125000 0 0.000000
1259+ 0.250000 0 0.000000
1260+ 0.500000 0 0.000000
1261+ 1.000000 0 0.000000
1262+ 2.000000 0 0.000000
1263+ 4.000000 0 0.000000
1264+ 8.000000 0 0.000000
1265+ 16.000000 0 0.000000
1266+ 32.000000 0 0.000000
1267+ 64.000000 0 0.000000
1268+ 128.000000 0 0.000000
1269+ 256.000000 0 0.000000
1270+ 512.000000 0 0.000000
1271+ 1024.000000 0 0.000000
1272+ 2048.000000 0 0.000000
1273+ 4096.000000 0 0.000000
1274+ 8192.000000 0 0.000000
1275+ 16384.000000 0 0.000000
1276+ 32768.000000 0 0.000000
1277+ 65536.000000 0 0.000000
1278+ 131072.000000 0 0.000000
1279+ 262144.000000 0 0.000000
1280+ 524288.000000 0 0.000000
1281+ 1048576.00000 0 0.000000
1282+ 2097152.00000 0 0.000000
1283+ 4194304.00000 0 0.000000
1284+ 8388608.00000 0 0.000000
1285+TOO LONG 0 TOO LONG
1286+SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME;
1287+time count total
1288+ 0.000001 0 0.000000
1289+ 0.000003 0 0.000000
1290+ 0.000007 0 0.000000
1291+ 0.000015 0 0.000000
1292+ 0.000030 0 0.000000
1293+ 0.000061 0 0.000000
1294+ 0.000122 0 0.000000
1295+ 0.000244 0 0.000000
1296+ 0.000488 0 0.000000
1297+ 0.000976 0 0.000000
1298+ 0.001953 0 0.000000
1299+ 0.003906 0 0.000000
1300+ 0.007812 0 0.000000
1301+ 0.015625 0 0.000000
1302+ 0.031250 0 0.000000
1303+ 0.062500 0 0.000000
1304+ 0.125000 0 0.000000
1305+ 0.250000 0 0.000000
1306+ 0.500000 0 0.000000
1307+ 1.000000 0 0.000000
1308+ 2.000000 0 0.000000
1309+ 4.000000 0 0.000000
1310+ 8.000000 0 0.000000
1311+ 16.000000 0 0.000000
1312+ 32.000000 0 0.000000
1313+ 64.000000 0 0.000000
1314+ 128.000000 0 0.000000
1315+ 256.000000 0 0.000000
1316+ 512.000000 0 0.000000
1317+ 1024.000000 0 0.000000
1318+ 2048.000000 0 0.000000
1319+ 4096.000000 0 0.000000
1320+ 8192.000000 0 0.000000
1321+ 16384.000000 0 0.000000
1322+ 32768.000000 0 0.000000
1323+ 65536.000000 0 0.000000
1324+ 131072.000000 0 0.000000
1325+ 262144.000000 0 0.000000
1326+ 524288.000000 0 0.000000
1327+ 1048576.00000 0 0.000000
1328+ 2097152.00000 0 0.000000
1329+ 4194304.00000 0 0.000000
1330+ 8388608.00000 0 0.000000
1331+TOO LONG 0 TOO LONG
930+SET GLOBAL QUERY_RESPONSE_TIME_STATS=1;1332+SET GLOBAL QUERY_RESPONSE_TIME_STATS=1;
931+SET SESSION query_exec_time=0.31;1333+SET SESSION query_exec_time=0.31;
932+SELECT 1;1334+SELECT 1;
@@ -1023,7 +1425,7 @@
1023+query_response_time_range_base 21425+query_response_time_range_base 2
1024+SHOW QUERY_RESPONSE_TIME;1426+SHOW QUERY_RESPONSE_TIME;
1025+ 1427+
1026+ 0.000001 25 0.0000001428+ 0.000001 24 0.000000
1027+ 0.000003 0 0.0000001429+ 0.000003 0 0.000000
1028+ 0.000007 0 0.0000001430+ 0.000007 0 0.000000
1029+ 0.000015 0 0.0000001431+ 0.000015 0 0.000000
@@ -1039,7 +1441,7 @@
1039+ 0.015625 0 0.0000001441+ 0.015625 0 0.000000
1040+ 0.031250 0 0.0000001442+ 0.031250 0 0.000000
1041+ 0.062500 0 0.0000001443+ 0.062500 0 0.000000
1042+ 0.125000 2 0.2000001444+ 0.125000 0 0.000000
1043+ 0.250000 0 0.0000001445+ 0.250000 0 0.000000
1044+ 0.500000 10 3.5500001446+ 0.500000 10 3.550000
1045+ 1.000000 1 0.5000001447+ 1.000000 1 0.500000
@@ -1069,7 +1471,7 @@
1069+TOO LONG 0 TOO LONG1471+TOO LONG 0 TOO LONG
1070+SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME;1472+SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME;
1071+time count total1473+time count total
1072+ 0.000001 25 0.0000001474+ 0.000001 24 0.000000
1073+ 0.000003 0 0.0000001475+ 0.000003 0 0.000000
1074+ 0.000007 0 0.0000001476+ 0.000007 0 0.000000
1075+ 0.000015 0 0.0000001477+ 0.000015 0 0.000000
@@ -1085,7 +1487,7 @@
1085+ 0.015625 0 0.0000001487+ 0.015625 0 0.000000
1086+ 0.031250 0 0.0000001488+ 0.031250 0 0.000000
1087+ 0.062500 0 0.0000001489+ 0.062500 0 0.000000
1088+ 0.125000 3 0.3000001490+ 0.125000 0 0.000000
1089+ 0.250000 0 0.0000001491+ 0.250000 0 0.000000
1090+ 0.500000 10 3.5500001492+ 0.500000 10 3.550000
1091+ 1.000000 1 0.5000001493+ 1.000000 1 0.500000
@@ -1118,6 +1520,98 @@
1118+SET GLOBAL QUERY_RESPONSE_TIME_STATS=0;1520+SET GLOBAL QUERY_RESPONSE_TIME_STATS=0;
1119+SET GLOBAL QUERY_RESPONSE_TIME_RANGE_BASE=2;1521+SET GLOBAL QUERY_RESPONSE_TIME_RANGE_BASE=2;
1120+FLUSH QUERY_RESPONSE_TIME;1522+FLUSH QUERY_RESPONSE_TIME;
1523+SHOW QUERY_RESPONSE_TIME;
1524+
1525+ 0.000001 0 0.000000
1526+ 0.000003 0 0.000000
1527+ 0.000007 0 0.000000
1528+ 0.000015 0 0.000000
1529+ 0.000030 0 0.000000
1530+ 0.000061 0 0.000000
1531+ 0.000122 0 0.000000
1532+ 0.000244 0 0.000000
1533+ 0.000488 0 0.000000
1534+ 0.000976 0 0.000000
1535+ 0.001953 0 0.000000
1536+ 0.003906 0 0.000000
1537+ 0.007812 0 0.000000
1538+ 0.015625 0 0.000000
1539+ 0.031250 0 0.000000
1540+ 0.062500 0 0.000000
1541+ 0.125000 0 0.000000
1542+ 0.250000 0 0.000000
1543+ 0.500000 0 0.000000
1544+ 1.000000 0 0.000000
1545+ 2.000000 0 0.000000
1546+ 4.000000 0 0.000000
1547+ 8.000000 0 0.000000
1548+ 16.000000 0 0.000000
1549+ 32.000000 0 0.000000
1550+ 64.000000 0 0.000000
1551+ 128.000000 0 0.000000
1552+ 256.000000 0 0.000000
1553+ 512.000000 0 0.000000
1554+ 1024.000000 0 0.000000
1555+ 2048.000000 0 0.000000
1556+ 4096.000000 0 0.000000
1557+ 8192.000000 0 0.000000
1558+ 16384.000000 0 0.000000
1559+ 32768.000000 0 0.000000
1560+ 65536.000000 0 0.000000
1561+ 131072.000000 0 0.000000
1562+ 262144.000000 0 0.000000
1563+ 524288.000000 0 0.000000
1564+ 1048576.00000 0 0.000000
1565+ 2097152.00000 0 0.000000
1566+ 4194304.00000 0 0.000000
1567+ 8388608.00000 0 0.000000
1568+TOO LONG 0 TOO LONG
1569+SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME;
1570+time count total
1571+ 0.000001 0 0.000000
1572+ 0.000003 0 0.000000
1573+ 0.000007 0 0.000000
1574+ 0.000015 0 0.000000
1575+ 0.000030 0 0.000000
1576+ 0.000061 0 0.000000
1577+ 0.000122 0 0.000000
1578+ 0.000244 0 0.000000
1579+ 0.000488 0 0.000000
1580+ 0.000976 0 0.000000
1581+ 0.001953 0 0.000000
1582+ 0.003906 0 0.000000
1583+ 0.007812 0 0.000000
1584+ 0.015625 0 0.000000
1585+ 0.031250 0 0.000000
1586+ 0.062500 0 0.000000
1587+ 0.125000 0 0.000000
1588+ 0.250000 0 0.000000
1589+ 0.500000 0 0.000000
1590+ 1.000000 0 0.000000
1591+ 2.000000 0 0.000000
1592+ 4.000000 0 0.000000
1593+ 8.000000 0 0.000000
1594+ 16.000000 0 0.000000
1595+ 32.000000 0 0.000000
1596+ 64.000000 0 0.000000
1597+ 128.000000 0 0.000000
1598+ 256.000000 0 0.000000
1599+ 512.000000 0 0.000000
1600+ 1024.000000 0 0.000000
1601+ 2048.000000 0 0.000000
1602+ 4096.000000 0 0.000000
1603+ 8192.000000 0 0.000000
1604+ 16384.000000 0 0.000000
1605+ 32768.000000 0 0.000000
1606+ 65536.000000 0 0.000000
1607+ 131072.000000 0 0.000000
1608+ 262144.000000 0 0.000000
1609+ 524288.000000 0 0.000000
1610+ 1048576.00000 0 0.000000
1611+ 2097152.00000 0 0.000000
1612+ 4194304.00000 0 0.000000
1613+ 8388608.00000 0 0.000000
1614+TOO LONG 0 TOO LONG
1121+SET GLOBAL QUERY_RESPONSE_TIME_STATS=1;1615+SET GLOBAL QUERY_RESPONSE_TIME_STATS=1;
1122+SET SESSION query_exec_time=0.31;1616+SET SESSION query_exec_time=0.31;
1123+SELECT 1;1617+SELECT 1;
@@ -1214,7 +1708,7 @@
1214+query_response_time_range_base 21708+query_response_time_range_base 2
1215+SHOW QUERY_RESPONSE_TIME;1709+SHOW QUERY_RESPONSE_TIME;
1216+ 1710+
1217+ 0.000001 25 0.0000001711+ 0.000001 24 0.000000
1218+ 0.000003 0 0.0000001712+ 0.000003 0 0.000000
1219+ 0.000007 0 0.0000001713+ 0.000007 0 0.000000
1220+ 0.000015 0 0.0000001714+ 0.000015 0 0.000000
@@ -1230,7 +1724,7 @@
1230+ 0.015625 0 0.0000001724+ 0.015625 0 0.000000
1231+ 0.031250 0 0.0000001725+ 0.031250 0 0.000000
1232+ 0.062500 0 0.0000001726+ 0.062500 0 0.000000
1233+ 0.125000 2 0.2000001727+ 0.125000 0 0.000000
1234+ 0.250000 0 0.0000001728+ 0.250000 0 0.000000
1235+ 0.500000 10 3.5500001729+ 0.500000 10 3.550000
1236+ 1.000000 1 0.5000001730+ 1.000000 1 0.500000
@@ -1260,7 +1754,7 @@
1260+TOO LONG 0 TOO LONG1754+TOO LONG 0 TOO LONG
1261+SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME;1755+SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME;
1262+time count total1756+time count total
1263+ 0.000001 25 0.0000001757+ 0.000001 24 0.000000
1264+ 0.000003 0 0.0000001758+ 0.000003 0 0.000000
1265+ 0.000007 0 0.0000001759+ 0.000007 0 0.000000
1266+ 0.000015 0 0.0000001760+ 0.000015 0 0.000000
@@ -1276,7 +1770,7 @@
1276+ 0.015625 0 0.0000001770+ 0.015625 0 0.000000
1277+ 0.031250 0 0.0000001771+ 0.031250 0 0.000000
1278+ 0.062500 0 0.0000001772+ 0.062500 0 0.000000
1279+ 0.125000 3 0.3000001773+ 0.125000 0 0.000000
1280+ 0.250000 0 0.0000001774+ 0.250000 0 0.000000
1281+ 0.500000 10 3.5500001775+ 0.500000 10 3.550000
1282+ 1.000000 1 0.5000001776+ 1.000000 1 0.500000
@@ -1309,6 +1803,38 @@
1309+SET GLOBAL QUERY_RESPONSE_TIME_STATS=0;1803+SET GLOBAL QUERY_RESPONSE_TIME_STATS=0;
1310+SET GLOBAL QUERY_RESPONSE_TIME_RANGE_BASE=10;1804+SET GLOBAL QUERY_RESPONSE_TIME_RANGE_BASE=10;
1311+FLUSH QUERY_RESPONSE_TIME;1805+FLUSH QUERY_RESPONSE_TIME;
1806+SHOW QUERY_RESPONSE_TIME;
1807+
1808+ 0.000001 0 0.000000
1809+ 0.000010 0 0.000000
1810+ 0.000100 0 0.000000
1811+ 0.001000 0 0.000000
1812+ 0.010000 0 0.000000
1813+ 0.100000 0 0.000000
1814+ 1.000000 0 0.000000
1815+ 10.000000 0 0.000000
1816+ 100.000000 0 0.000000
1817+ 1000.000000 0 0.000000
1818+ 10000.000000 0 0.000000
1819+ 100000.000000 0 0.000000
1820+ 1000000.00000 0 0.000000
1821+TOO LONG 0 TOO LONG
1822+SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME;
1823+time count total
1824+ 0.000001 0 0.000000
1825+ 0.000010 0 0.000000
1826+ 0.000100 0 0.000000
1827+ 0.001000 0 0.000000
1828+ 0.010000 0 0.000000
1829+ 0.100000 0 0.000000
1830+ 1.000000 0 0.000000
1831+ 10.000000 0 0.000000
1832+ 100.000000 0 0.000000
1833+ 1000.000000 0 0.000000
1834+ 10000.000000 0 0.000000
1835+ 100000.000000 0 0.000000
1836+ 1000000.00000 0 0.000000
1837+TOO LONG 0 TOO LONG
1312+SET GLOBAL QUERY_RESPONSE_TIME_STATS=1;1838+SET GLOBAL QUERY_RESPONSE_TIME_STATS=1;
1313+SET SESSION query_exec_time=0.31;1839+SET SESSION query_exec_time=0.31;
1314+SELECT 1;1840+SELECT 1;
@@ -1405,13 +1931,13 @@
1405+query_response_time_range_base 101931+query_response_time_range_base 10
1406+SHOW QUERY_RESPONSE_TIME;1932+SHOW QUERY_RESPONSE_TIME;
1407+ 1933+
1408+ 0.000001 25 0.0000001934+ 0.000001 24 0.000000
1409+ 0.000010 0 0.0000001935+ 0.000010 0 0.000000
1410+ 0.000100 0 0.0000001936+ 0.000100 0 0.000000
1411+ 0.001000 0 0.0000001937+ 0.001000 0 0.000000
1412+ 0.010000 0 0.0000001938+ 0.010000 0 0.000000
1413+ 0.100000 0 0.0000001939+ 0.100000 0 0.000000
1414+ 1.000000 13 4.2500001940+ 1.000000 11 4.050000
1415+ 10.000000 11 25.6999991941+ 10.000000 11 25.699999
1416+ 100.000000 0 0.0000001942+ 100.000000 0 0.000000
1417+ 1000.000000 0 0.0000001943+ 1000.000000 0 0.000000
@@ -1421,13 +1947,13 @@
1421+TOO LONG 0 TOO LONG1947+TOO LONG 0 TOO LONG
1422+SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME;1948+SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME;
1423+time count total1949+time count total
1424+ 0.000001 25 0.0000001950+ 0.000001 24 0.000000
1425+ 0.000010 0 0.0000001951+ 0.000010 0 0.000000
1426+ 0.000100 0 0.0000001952+ 0.000100 0 0.000000
1427+ 0.001000 0 0.0000001953+ 0.001000 0 0.000000
1428+ 0.010000 0 0.0000001954+ 0.010000 0 0.000000
1429+ 0.100000 0 0.0000001955+ 0.100000 0 0.000000
1430+ 1.000000 14 4.3500001956+ 1.000000 11 4.050000
1431+ 10.000000 11 25.6999991957+ 10.000000 11 25.699999
1432+ 100.000000 0 0.0000001958+ 100.000000 0 0.000000
1433+ 1000.000000 0 0.0000001959+ 1000.000000 0 0.000000
@@ -1440,6 +1966,44 @@
1440+SET GLOBAL QUERY_RESPONSE_TIME_STATS=0;1966+SET GLOBAL QUERY_RESPONSE_TIME_STATS=0;
1441+SET GLOBAL QUERY_RESPONSE_TIME_RANGE_BASE=7;1967+SET GLOBAL QUERY_RESPONSE_TIME_RANGE_BASE=7;
1442+FLUSH QUERY_RESPONSE_TIME;1968+FLUSH QUERY_RESPONSE_TIME;
1969+SHOW QUERY_RESPONSE_TIME;
1970+
1971+ 0.000001 0 0.000000
1972+ 0.000008 0 0.000000
1973+ 0.000059 0 0.000000
1974+ 0.000416 0 0.000000
1975+ 0.002915 0 0.000000
1976+ 0.020408 0 0.000000
1977+ 0.142857 0 0.000000
1978+ 1.000000 0 0.000000
1979+ 7.000000 0 0.000000
1980+ 49.000000 0 0.000000
1981+ 343.000000 0 0.000000
1982+ 2401.000000 0 0.000000
1983+ 16807.000000 0 0.000000
1984+ 117649.000000 0 0.000000
1985+ 823543.000000 0 0.000000
1986+ 5764801.00000 0 0.000000
1987+TOO LONG 0 TOO LONG
1988+SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME;
1989+time count total
1990+ 0.000001 0 0.000000
1991+ 0.000008 0 0.000000
1992+ 0.000059 0 0.000000
1993+ 0.000416 0 0.000000
1994+ 0.002915 0 0.000000
1995+ 0.020408 0 0.000000
1996+ 0.142857 0 0.000000
1997+ 1.000000 0 0.000000
1998+ 7.000000 0 0.000000
1999+ 49.000000 0 0.000000
2000+ 343.000000 0 0.000000
2001+ 2401.000000 0 0.000000
2002+ 16807.000000 0 0.000000
2003+ 117649.000000 0 0.000000
2004+ 823543.000000 0 0.000000
2005+ 5764801.00000 0 0.000000
2006+TOO LONG 0 TOO LONG
1443+SET GLOBAL QUERY_RESPONSE_TIME_STATS=1;2007+SET GLOBAL QUERY_RESPONSE_TIME_STATS=1;
1444+SET SESSION query_exec_time=0.31;2008+SET SESSION query_exec_time=0.31;
1445+SELECT 1;2009+SELECT 1;
@@ -1536,13 +2100,13 @@
1536+query_response_time_range_base 72100+query_response_time_range_base 7
1537+SHOW QUERY_RESPONSE_TIME;2101+SHOW QUERY_RESPONSE_TIME;
1538+ 2102+
1539+ 0.000001 25 0.0000002103+ 0.000001 24 0.000000
1540+ 0.000008 0 0.0000002104+ 0.000008 0 0.000000
1541+ 0.000059 0 0.0000002105+ 0.000059 0 0.000000
1542+ 0.000416 0 0.0000002106+ 0.000416 0 0.000000
1543+ 0.002915 0 0.0000002107+ 0.002915 0 0.000000
1544+ 0.020408 0 0.0000002108+ 0.020408 0 0.000000
1545+ 0.142857 2 0.2000002109+ 0.142857 0 0.000000
1546+ 1.000000 11 4.0500002110+ 1.000000 11 4.050000
1547+ 7.000000 11 25.6999992111+ 7.000000 11 25.699999
1548+ 49.000000 0 0.0000002112+ 49.000000 0 0.000000
@@ -1555,13 +2119,13 @@
1555+TOO LONG 0 TOO LONG2119+TOO LONG 0 TOO LONG
1556+SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME;2120+SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME;
1557+time count total2121+time count total
1558+ 0.000001 25 0.0000002122+ 0.000001 24 0.000000
1559+ 0.000008 0 0.0000002123+ 0.000008 0 0.000000
1560+ 0.000059 0 0.0000002124+ 0.000059 0 0.000000
1561+ 0.000416 0 0.0000002125+ 0.000416 0 0.000000
1562+ 0.002915 0 0.0000002126+ 0.002915 0 0.000000
1563+ 0.020408 0 0.0000002127+ 0.020408 0 0.000000
1564+ 0.142857 3 0.3000002128+ 0.142857 0 0.000000
1565+ 1.000000 11 4.0500002129+ 1.000000 11 4.050000
1566+ 7.000000 11 25.6999992130+ 7.000000 11 25.699999
1567+ 49.000000 0 0.0000002131+ 49.000000 0 0.000000
@@ -1577,6 +2141,24 @@
1577+SET GLOBAL QUERY_RESPONSE_TIME_STATS=0;2141+SET GLOBAL QUERY_RESPONSE_TIME_STATS=0;
1578+SET GLOBAL QUERY_RESPONSE_TIME_RANGE_BASE=156;2142+SET GLOBAL QUERY_RESPONSE_TIME_RANGE_BASE=156;
1579+FLUSH QUERY_RESPONSE_TIME;2143+FLUSH QUERY_RESPONSE_TIME;
2144+SHOW QUERY_RESPONSE_TIME;
2145+
2146+ 0.000041 0 0.000000
2147+ 0.006410 0 0.000000
2148+ 1.000000 0 0.000000
2149+ 156.000000 0 0.000000
2150+ 24336.000000 0 0.000000
2151+ 3796416.00000 0 0.000000
2152+TOO LONG 0 TOO LONG
2153+SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME;
2154+time count total
2155+ 0.000041 0 0.000000
2156+ 0.006410 0 0.000000
2157+ 1.000000 0 0.000000
2158+ 156.000000 0 0.000000
2159+ 24336.000000 0 0.000000
2160+ 3796416.00000 0 0.000000
2161+TOO LONG 0 TOO LONG
1580+SET GLOBAL QUERY_RESPONSE_TIME_STATS=1;2162+SET GLOBAL QUERY_RESPONSE_TIME_STATS=1;
1581+SET SESSION query_exec_time=0.31;2163+SET SESSION query_exec_time=0.31;
1582+SELECT 1;2164+SELECT 1;
@@ -1673,18 +2255,18 @@
1673+query_response_time_range_base 1562255+query_response_time_range_base 156
1674+SHOW QUERY_RESPONSE_TIME;2256+SHOW QUERY_RESPONSE_TIME;
1675+ 2257+
1676+ 0.000041 25 0.0000002258+ 0.000041 24 0.000000
1677+ 0.006410 0 0.0000002259+ 0.006410 0 0.000000
1678+ 1.000000 13 4.2500002260+ 1.000000 11 4.050000
1679+ 156.000000 11 25.6999992261+ 156.000000 11 25.699999
1680+ 24336.000000 0 0.0000002262+ 24336.000000 0 0.000000
1681+ 3796416.00000 0 0.0000002263+ 3796416.00000 0 0.000000
1682+TOO LONG 0 TOO LONG2264+TOO LONG 0 TOO LONG
1683+SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME;2265+SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME;
1684+time count total2266+time count total
1685+ 0.000041 25 0.0000002267+ 0.000041 24 0.000000
1686+ 0.006410 0 0.0000002268+ 0.006410 0 0.000000
1687+ 1.000000 14 4.3500002269+ 1.000000 11 4.050000
1688+ 156.000000 11 25.6999992270+ 156.000000 11 25.699999
1689+ 24336.000000 0 0.0000002271+ 24336.000000 0 0.000000
1690+ 3796416.00000 0 0.0000002272+ 3796416.00000 0 0.000000
@@ -1694,6 +2276,22 @@
1694+SET GLOBAL QUERY_RESPONSE_TIME_STATS=0;2276+SET GLOBAL QUERY_RESPONSE_TIME_STATS=0;
1695+SET GLOBAL QUERY_RESPONSE_TIME_RANGE_BASE=1000;2277+SET GLOBAL QUERY_RESPONSE_TIME_RANGE_BASE=1000;
1696+FLUSH QUERY_RESPONSE_TIME;2278+FLUSH QUERY_RESPONSE_TIME;
2279+SHOW QUERY_RESPONSE_TIME;
2280+
2281+ 0.000001 0 0.000000
2282+ 0.001000 0 0.000000
2283+ 1.000000 0 0.000000
2284+ 1000.000000 0 0.000000
2285+ 1000000.00000 0 0.000000
2286+TOO LONG 0 TOO LONG
2287+SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME;
2288+time count total
2289+ 0.000001 0 0.000000
2290+ 0.001000 0 0.000000
2291+ 1.000000 0 0.000000
2292+ 1000.000000 0 0.000000
2293+ 1000000.00000 0 0.000000
2294+TOO LONG 0 TOO LONG
1697+SET GLOBAL QUERY_RESPONSE_TIME_STATS=1;2295+SET GLOBAL QUERY_RESPONSE_TIME_STATS=1;
1698+SET SESSION query_exec_time=0.31;2296+SET SESSION query_exec_time=0.31;
1699+SELECT 1;2297+SELECT 1;
@@ -1790,17 +2388,17 @@
1790+query_response_time_range_base 10002388+query_response_time_range_base 1000
1791+SHOW QUERY_RESPONSE_TIME;2389+SHOW QUERY_RESPONSE_TIME;
1792+ 2390+
1793+ 0.000001 25 0.0000002391+ 0.000001 24 0.000000
1794+ 0.001000 0 0.0000002392+ 0.001000 0 0.000000
1795+ 1.000000 13 4.2500002393+ 1.000000 11 4.050000
1796+ 1000.000000 11 25.6999992394+ 1000.000000 11 25.699999
1797+ 1000000.00000 0 0.0000002395+ 1000000.00000 0 0.000000
1798+TOO LONG 0 TOO LONG2396+TOO LONG 0 TOO LONG
1799+SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME;2397+SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME;
1800+time count total2398+time count total
1801+ 0.000001 25 0.0000002399+ 0.000001 24 0.000000
1802+ 0.001000 0 0.0000002400+ 0.001000 0 0.000000
1803+ 1.000000 14 4.3500002401+ 1.000000 11 4.050000
1804+ 1000.000000 11 25.6999992402+ 1000.000000 11 25.699999
1805+ 1000000.00000 0 0.0000002403+ 1000000.00000 0 0.000000
1806+TOO LONG 0 TOO LONG2404+TOO LONG 0 TOO LONG
@@ -1811,6 +2409,22 @@
1811+Warnings:2409+Warnings:
1812+Warning 1292 Truncated incorrect query_response_time_range_base value: '1001'2410+Warning 1292 Truncated incorrect query_response_time_range_base value: '1001'
1813+FLUSH QUERY_RESPONSE_TIME;2411+FLUSH QUERY_RESPONSE_TIME;
2412+SHOW QUERY_RESPONSE_TIME;
2413+
2414+ 0.000001 0 0.000000
2415+ 0.001000 0 0.000000
2416+ 1.000000 0 0.000000
2417+ 1000.000000 0 0.000000
2418+ 1000000.00000 0 0.000000
2419+TOO LONG 0 TOO LONG
2420+SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME;
2421+time count total
2422+ 0.000001 0 0.000000
2423+ 0.001000 0 0.000000
2424+ 1.000000 0 0.000000
2425+ 1000.000000 0 0.000000
2426+ 1000000.00000 0 0.000000
2427+TOO LONG 0 TOO LONG
1814+SET GLOBAL QUERY_RESPONSE_TIME_STATS=1;2428+SET GLOBAL QUERY_RESPONSE_TIME_STATS=1;
1815+SET SESSION query_exec_time=0.31;2429+SET SESSION query_exec_time=0.31;
1816+SELECT 1;2430+SELECT 1;
@@ -1907,17 +2521,17 @@
1907+query_response_time_range_base 10002521+query_response_time_range_base 1000
1908+SHOW QUERY_RESPONSE_TIME;2522+SHOW QUERY_RESPONSE_TIME;
1909+ 2523+
1910+ 0.000001 25 0.0000002524+ 0.000001 24 0.000000
1911+ 0.001000 0 0.0000002525+ 0.001000 0 0.000000
1912+ 1.000000 13 4.2500002526+ 1.000000 11 4.050000
1913+ 1000.000000 11 25.6999992527+ 1000.000000 11 25.699999
1914+ 1000000.00000 0 0.0000002528+ 1000000.00000 0 0.000000
1915+TOO LONG 0 TOO LONG2529+TOO LONG 0 TOO LONG
1916+SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME;2530+SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME;
1917+time count total2531+time count total
1918+ 0.000001 25 0.0000002532+ 0.000001 24 0.000000
1919+ 0.001000 0 0.0000002533+ 0.001000 0 0.000000
1920+ 1.000000 14 4.3500002534+ 1.000000 11 4.050000
1921+ 1000.000000 11 25.6999992535+ 1000.000000 11 25.699999
1922+ 1000000.00000 0 0.0000002536+ 1000000.00000 0 0.000000
1923+TOO LONG 0 TOO LONG2537+TOO LONG 0 TOO LONG
@@ -1926,7 +2540,7 @@
1926+SET GLOBAL QUERY_RESPONSE_TIME_STATS=default;2540+SET GLOBAL QUERY_RESPONSE_TIME_STATS=default;
1927--- /dev/null2541--- /dev/null
1928+++ b/mysql-test/r/percona_query_response_time-stored.result2542+++ b/mysql-test/r/percona_query_response_time-stored.result
1929@@ -0,0 +1,544 @@2543@@ -0,0 +1,848 @@
1930+CREATE TABLE t(a INT);2544+CREATE TABLE t(a INT);
1931+CREATE PROCEDURE test_f(t DECIMAL(3,2))2545+CREATE PROCEDURE test_f(t DECIMAL(3,2))
1932+BEGIN2546+BEGIN
@@ -1941,6 +2555,98 @@
1941+Warnings:2555+Warnings:
1942+Warning 1292 Truncated incorrect query_response_time_range_base value: '1'2556+Warning 1292 Truncated incorrect query_response_time_range_base value: '1'
1943+FLUSH QUERY_RESPONSE_TIME;2557+FLUSH QUERY_RESPONSE_TIME;
2558+SHOW QUERY_RESPONSE_TIME;
2559+
2560+ 0.000001 0 0.000000
2561+ 0.000003 0 0.000000
2562+ 0.000007 0 0.000000
2563+ 0.000015 0 0.000000
2564+ 0.000030 0 0.000000
2565+ 0.000061 0 0.000000
2566+ 0.000122 0 0.000000
2567+ 0.000244 0 0.000000
2568+ 0.000488 0 0.000000
2569+ 0.000976 0 0.000000
2570+ 0.001953 0 0.000000
2571+ 0.003906 0 0.000000
2572+ 0.007812 0 0.000000
2573+ 0.015625 0 0.000000
2574+ 0.031250 0 0.000000
2575+ 0.062500 0 0.000000
2576+ 0.125000 0 0.000000
2577+ 0.250000 0 0.000000
2578+ 0.500000 0 0.000000
2579+ 1.000000 0 0.000000
2580+ 2.000000 0 0.000000
2581+ 4.000000 0 0.000000
2582+ 8.000000 0 0.000000
2583+ 16.000000 0 0.000000
2584+ 32.000000 0 0.000000
2585+ 64.000000 0 0.000000
2586+ 128.000000 0 0.000000
2587+ 256.000000 0 0.000000
2588+ 512.000000 0 0.000000
2589+ 1024.000000 0 0.000000
2590+ 2048.000000 0 0.000000
2591+ 4096.000000 0 0.000000
2592+ 8192.000000 0 0.000000
2593+ 16384.000000 0 0.000000
2594+ 32768.000000 0 0.000000
2595+ 65536.000000 0 0.000000
2596+ 131072.000000 0 0.000000
2597+ 262144.000000 0 0.000000
2598+ 524288.000000 0 0.000000
2599+ 1048576.00000 0 0.000000
2600+ 2097152.00000 0 0.000000
2601+ 4194304.00000 0 0.000000
2602+ 8388608.00000 0 0.000000
2603+TOO LONG 0 TOO LONG
2604+SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME;
2605+time count total
2606+ 0.000001 0 0.000000
2607+ 0.000003 0 0.000000
2608+ 0.000007 0 0.000000
2609+ 0.000015 0 0.000000
2610+ 0.000030 0 0.000000
2611+ 0.000061 0 0.000000
2612+ 0.000122 0 0.000000
2613+ 0.000244 0 0.000000
2614+ 0.000488 0 0.000000
2615+ 0.000976 0 0.000000
2616+ 0.001953 0 0.000000
2617+ 0.003906 0 0.000000
2618+ 0.007812 0 0.000000
2619+ 0.015625 0 0.000000
2620+ 0.031250 0 0.000000
2621+ 0.062500 0 0.000000
2622+ 0.125000 0 0.000000
2623+ 0.250000 0 0.000000
2624+ 0.500000 0 0.000000
2625+ 1.000000 0 0.000000
2626+ 2.000000 0 0.000000
2627+ 4.000000 0 0.000000
2628+ 8.000000 0 0.000000
2629+ 16.000000 0 0.000000
2630+ 32.000000 0 0.000000
2631+ 64.000000 0 0.000000
2632+ 128.000000 0 0.000000
2633+ 256.000000 0 0.000000
2634+ 512.000000 0 0.000000
2635+ 1024.000000 0 0.000000
2636+ 2048.000000 0 0.000000
2637+ 4096.000000 0 0.000000
2638+ 8192.000000 0 0.000000
2639+ 16384.000000 0 0.000000
2640+ 32768.000000 0 0.000000
2641+ 65536.000000 0 0.000000
2642+ 131072.000000 0 0.000000
2643+ 262144.000000 0 0.000000
2644+ 524288.000000 0 0.000000
2645+ 1048576.00000 0 0.000000
2646+ 2097152.00000 0 0.000000
2647+ 4194304.00000 0 0.000000
2648+ 8388608.00000 0 0.000000
2649+TOO LONG 0 TOO LONG
1944+SET GLOBAL QUERY_RESPONSE_TIME_STATS=1;2650+SET GLOBAL QUERY_RESPONSE_TIME_STATS=1;
1945+CALL test_f(0.31);2651+CALL test_f(0.31);
1946+CALL test_f(0.32);2652+CALL test_f(0.32);
@@ -1970,7 +2676,7 @@
1970+query_response_time_range_base 22676+query_response_time_range_base 2
1971+SHOW QUERY_RESPONSE_TIME;2677+SHOW QUERY_RESPONSE_TIME;
1972+ 2678+
1973+ 0.000001 46 0.0000002679+ 0.000001 45 0.000000
1974+ 0.000003 0 0.0000002680+ 0.000003 0 0.000000
1975+ 0.000007 0 0.0000002681+ 0.000007 0 0.000000
1976+ 0.000015 0 0.0000002682+ 0.000015 0 0.000000
@@ -1986,7 +2692,7 @@
1986+ 0.015625 0 0.0000002692+ 0.015625 0 0.000000
1987+ 0.031250 0 0.0000002693+ 0.031250 0 0.000000
1988+ 0.062500 0 0.0000002694+ 0.062500 0 0.000000
1989+ 0.125000 46 4.6000002695+ 0.125000 44 4.400000
1990+ 0.250000 0 0.0000002696+ 0.250000 0 0.000000
1991+ 0.500000 10 3.5500002697+ 0.500000 10 3.550000
1992+ 1.000000 1 0.5000002698+ 1.000000 1 0.500000
@@ -2016,7 +2722,7 @@
2016+TOO LONG 0 TOO LONG2722+TOO LONG 0 TOO LONG
2017+SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME;2723+SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME;
2018+time count total2724+time count total
2019+ 0.000001 46 0.0000002725+ 0.000001 45 0.000000
2020+ 0.000003 0 0.0000002726+ 0.000003 0 0.000000
2021+ 0.000007 0 0.0000002727+ 0.000007 0 0.000000
2022+ 0.000015 0 0.0000002728+ 0.000015 0 0.000000
@@ -2032,7 +2738,7 @@
2032+ 0.015625 0 0.0000002738+ 0.015625 0 0.000000
2033+ 0.031250 0 0.0000002739+ 0.031250 0 0.000000
2034+ 0.062500 0 0.0000002740+ 0.062500 0 0.000000
2035+ 0.125000 47 4.7000002741+ 0.125000 44 4.400000
2036+ 0.250000 0 0.0000002742+ 0.250000 0 0.000000
2037+ 0.500000 10 3.5500002743+ 0.500000 10 3.550000
2038+ 1.000000 1 0.5000002744+ 1.000000 1 0.500000
@@ -2065,6 +2771,98 @@
2065+SET GLOBAL QUERY_RESPONSE_TIME_STATS=0;2771+SET GLOBAL QUERY_RESPONSE_TIME_STATS=0;
2066+SET GLOBAL QUERY_RESPONSE_TIME_RANGE_BASE=2;2772+SET GLOBAL QUERY_RESPONSE_TIME_RANGE_BASE=2;
2067+FLUSH QUERY_RESPONSE_TIME;2773+FLUSH QUERY_RESPONSE_TIME;
2774+SHOW QUERY_RESPONSE_TIME;
2775+
2776+ 0.000001 0 0.000000
2777+ 0.000003 0 0.000000
2778+ 0.000007 0 0.000000
2779+ 0.000015 0 0.000000
2780+ 0.000030 0 0.000000
2781+ 0.000061 0 0.000000
2782+ 0.000122 0 0.000000
2783+ 0.000244 0 0.000000
2784+ 0.000488 0 0.000000
2785+ 0.000976 0 0.000000
2786+ 0.001953 0 0.000000
2787+ 0.003906 0 0.000000
2788+ 0.007812 0 0.000000
2789+ 0.015625 0 0.000000
2790+ 0.031250 0 0.000000
2791+ 0.062500 0 0.000000
2792+ 0.125000 0 0.000000
2793+ 0.250000 0 0.000000
2794+ 0.500000 0 0.000000
2795+ 1.000000 0 0.000000
2796+ 2.000000 0 0.000000
2797+ 4.000000 0 0.000000
2798+ 8.000000 0 0.000000
2799+ 16.000000 0 0.000000
2800+ 32.000000 0 0.000000
2801+ 64.000000 0 0.000000
2802+ 128.000000 0 0.000000
2803+ 256.000000 0 0.000000
2804+ 512.000000 0 0.000000
2805+ 1024.000000 0 0.000000
2806+ 2048.000000 0 0.000000
2807+ 4096.000000 0 0.000000
2808+ 8192.000000 0 0.000000
2809+ 16384.000000 0 0.000000
2810+ 32768.000000 0 0.000000
2811+ 65536.000000 0 0.000000
2812+ 131072.000000 0 0.000000
2813+ 262144.000000 0 0.000000
2814+ 524288.000000 0 0.000000
2815+ 1048576.00000 0 0.000000
2816+ 2097152.00000 0 0.000000
2817+ 4194304.00000 0 0.000000
2818+ 8388608.00000 0 0.000000
2819+TOO LONG 0 TOO LONG
2820+SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME;
2821+time count total
2822+ 0.000001 0 0.000000
2823+ 0.000003 0 0.000000
2824+ 0.000007 0 0.000000
2825+ 0.000015 0 0.000000
2826+ 0.000030 0 0.000000
2827+ 0.000061 0 0.000000
2828+ 0.000122 0 0.000000
2829+ 0.000244 0 0.000000
2830+ 0.000488 0 0.000000
2831+ 0.000976 0 0.000000
2832+ 0.001953 0 0.000000
2833+ 0.003906 0 0.000000
2834+ 0.007812 0 0.000000
2835+ 0.015625 0 0.000000
2836+ 0.031250 0 0.000000
2837+ 0.062500 0 0.000000
2838+ 0.125000 0 0.000000
2839+ 0.250000 0 0.000000
2840+ 0.500000 0 0.000000
2841+ 1.000000 0 0.000000
2842+ 2.000000 0 0.000000
2843+ 4.000000 0 0.000000
2844+ 8.000000 0 0.000000
2845+ 16.000000 0 0.000000
2846+ 32.000000 0 0.000000
2847+ 64.000000 0 0.000000
2848+ 128.000000 0 0.000000
2849+ 256.000000 0 0.000000
2850+ 512.000000 0 0.000000
2851+ 1024.000000 0 0.000000
2852+ 2048.000000 0 0.000000
2853+ 4096.000000 0 0.000000
2854+ 8192.000000 0 0.000000
2855+ 16384.000000 0 0.000000
2856+ 32768.000000 0 0.000000
2857+ 65536.000000 0 0.000000
2858+ 131072.000000 0 0.000000
2859+ 262144.000000 0 0.000000
2860+ 524288.000000 0 0.000000
2861+ 1048576.00000 0 0.000000
2862+ 2097152.00000 0 0.000000
2863+ 4194304.00000 0 0.000000
2864+ 8388608.00000 0 0.000000
2865+TOO LONG 0 TOO LONG
2068+SET GLOBAL QUERY_RESPONSE_TIME_STATS=1;2866+SET GLOBAL QUERY_RESPONSE_TIME_STATS=1;
2069+CALL test_f(0.31);2867+CALL test_f(0.31);
2070+CALL test_f(0.32);2868+CALL test_f(0.32);
@@ -2094,7 +2892,7 @@
2094+query_response_time_range_base 22892+query_response_time_range_base 2
2095+SHOW QUERY_RESPONSE_TIME;2893+SHOW QUERY_RESPONSE_TIME;
2096+ 2894+
2097+ 0.000001 46 0.0000002895+ 0.000001 45 0.000000
2098+ 0.000003 0 0.0000002896+ 0.000003 0 0.000000
2099+ 0.000007 0 0.0000002897+ 0.000007 0 0.000000
2100+ 0.000015 0 0.0000002898+ 0.000015 0 0.000000
@@ -2110,7 +2908,7 @@
2110+ 0.015625 0 0.0000002908+ 0.015625 0 0.000000
2111+ 0.031250 0 0.0000002909+ 0.031250 0 0.000000
2112+ 0.062500 0 0.0000002910+ 0.062500 0 0.000000
2113+ 0.125000 46 4.6000002911+ 0.125000 44 4.400000
2114+ 0.250000 0 0.0000002912+ 0.250000 0 0.000000
2115+ 0.500000 10 3.5500002913+ 0.500000 10 3.550000
2116+ 1.000000 1 0.5000002914+ 1.000000 1 0.500000
@@ -2140,7 +2938,7 @@
2140+TOO LONG 0 TOO LONG2938+TOO LONG 0 TOO LONG
2141+SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME;2939+SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME;
2142+time count total2940+time count total
2143+ 0.000001 46 0.0000002941+ 0.000001 45 0.000000
2144+ 0.000003 0 0.0000002942+ 0.000003 0 0.000000
2145+ 0.000007 0 0.0000002943+ 0.000007 0 0.000000
2146+ 0.000015 0 0.0000002944+ 0.000015 0 0.000000
@@ -2156,7 +2954,7 @@
2156+ 0.015625 0 0.0000002954+ 0.015625 0 0.000000
2157+ 0.031250 0 0.0000002955+ 0.031250 0 0.000000
2158+ 0.062500 0 0.0000002956+ 0.062500 0 0.000000
2159+ 0.125000 47 4.7000002957+ 0.125000 44 4.400000
2160+ 0.250000 0 0.0000002958+ 0.250000 0 0.000000
2161+ 0.500000 10 3.5500002959+ 0.500000 10 3.550000
2162+ 1.000000 1 0.5000002960+ 1.000000 1 0.500000
@@ -2189,6 +2987,38 @@
2189+SET GLOBAL QUERY_RESPONSE_TIME_STATS=0;2987+SET GLOBAL QUERY_RESPONSE_TIME_STATS=0;
2190+SET GLOBAL QUERY_RESPONSE_TIME_RANGE_BASE=10;2988+SET GLOBAL QUERY_RESPONSE_TIME_RANGE_BASE=10;
2191+FLUSH QUERY_RESPONSE_TIME;2989+FLUSH QUERY_RESPONSE_TIME;
2990+SHOW QUERY_RESPONSE_TIME;
2991+
2992+ 0.000001 0 0.000000
2993+ 0.000010 0 0.000000
2994+ 0.000100 0 0.000000
2995+ 0.001000 0 0.000000
2996+ 0.010000 0 0.000000
2997+ 0.100000 0 0.000000
2998+ 1.000000 0 0.000000
2999+ 10.000000 0 0.000000
3000+ 100.000000 0 0.000000
3001+ 1000.000000 0 0.000000
3002+ 10000.000000 0 0.000000
3003+ 100000.000000 0 0.000000
3004+ 1000000.00000 0 0.000000
3005+TOO LONG 0 TOO LONG
3006+SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME;
3007+time count total
3008+ 0.000001 0 0.000000
3009+ 0.000010 0 0.000000
3010+ 0.000100 0 0.000000
3011+ 0.001000 0 0.000000
3012+ 0.010000 0 0.000000
3013+ 0.100000 0 0.000000
3014+ 1.000000 0 0.000000
3015+ 10.000000 0 0.000000
3016+ 100.000000 0 0.000000
3017+ 1000.000000 0 0.000000
3018+ 10000.000000 0 0.000000
3019+ 100000.000000 0 0.000000
3020+ 1000000.00000 0 0.000000
3021+TOO LONG 0 TOO LONG
2192+SET GLOBAL QUERY_RESPONSE_TIME_STATS=1;3022+SET GLOBAL QUERY_RESPONSE_TIME_STATS=1;
2193+CALL test_f(0.31);3023+CALL test_f(0.31);
2194+CALL test_f(0.32);3024+CALL test_f(0.32);
@@ -2218,13 +3048,13 @@
2218+query_response_time_range_base 103048+query_response_time_range_base 10
2219+SHOW QUERY_RESPONSE_TIME;3049+SHOW QUERY_RESPONSE_TIME;
2220+ 3050+
2221+ 0.000001 46 0.0000003051+ 0.000001 45 0.000000
2222+ 0.000010 0 0.0000003052+ 0.000010 0 0.000000
2223+ 0.000100 0 0.0000003053+ 0.000100 0 0.000000
2224+ 0.001000 0 0.0000003054+ 0.001000 0 0.000000
2225+ 0.010000 0 0.0000003055+ 0.010000 0 0.000000
2226+ 0.100000 0 0.0000003056+ 0.100000 0 0.000000
2227+ 1.000000 57 8.6500003057+ 1.000000 55 8.450000
2228+ 10.000000 11 25.6999993058+ 10.000000 11 25.699999
2229+ 100.000000 0 0.0000003059+ 100.000000 0 0.000000
2230+ 1000.000000 0 0.0000003060+ 1000.000000 0 0.000000
@@ -2234,13 +3064,13 @@
2234+TOO LONG 0 TOO LONG3064+TOO LONG 0 TOO LONG
2235+SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME;3065+SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME;
2236+time count total3066+time count total
2237+ 0.000001 46 0.0000003067+ 0.000001 45 0.000000
2238+ 0.000010 0 0.0000003068+ 0.000010 0 0.000000
2239+ 0.000100 0 0.0000003069+ 0.000100 0 0.000000
2240+ 0.001000 0 0.0000003070+ 0.001000 0 0.000000
2241+ 0.010000 0 0.0000003071+ 0.010000 0 0.000000
2242+ 0.100000 0 0.0000003072+ 0.100000 0 0.000000
2243+ 1.000000 58 8.7500003073+ 1.000000 55 8.450000
2244+ 10.000000 11 25.6999993074+ 10.000000 11 25.699999
2245+ 100.000000 0 0.0000003075+ 100.000000 0 0.000000
2246+ 1000.000000 0 0.0000003076+ 1000.000000 0 0.000000
@@ -2253,6 +3083,44 @@
2253+SET GLOBAL QUERY_RESPONSE_TIME_STATS=0;3083+SET GLOBAL QUERY_RESPONSE_TIME_STATS=0;
2254+SET GLOBAL QUERY_RESPONSE_TIME_RANGE_BASE=7;3084+SET GLOBAL QUERY_RESPONSE_TIME_RANGE_BASE=7;
2255+FLUSH QUERY_RESPONSE_TIME;3085+FLUSH QUERY_RESPONSE_TIME;
3086+SHOW QUERY_RESPONSE_TIME;
3087+
3088+ 0.000001 0 0.000000
3089+ 0.000008 0 0.000000
3090+ 0.000059 0 0.000000
3091+ 0.000416 0 0.000000
3092+ 0.002915 0 0.000000
3093+ 0.020408 0 0.000000
3094+ 0.142857 0 0.000000
3095+ 1.000000 0 0.000000
3096+ 7.000000 0 0.000000
3097+ 49.000000 0 0.000000
3098+ 343.000000 0 0.000000
3099+ 2401.000000 0 0.000000
3100+ 16807.000000 0 0.000000
3101+ 117649.000000 0 0.000000
3102+ 823543.000000 0 0.000000
3103+ 5764801.00000 0 0.000000
3104+TOO LONG 0 TOO LONG
3105+SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME;
3106+time count total
3107+ 0.000001 0 0.000000
3108+ 0.000008 0 0.000000
3109+ 0.000059 0 0.000000
3110+ 0.000416 0 0.000000
3111+ 0.002915 0 0.000000
3112+ 0.020408 0 0.000000
3113+ 0.142857 0 0.000000
3114+ 1.000000 0 0.000000
3115+ 7.000000 0 0.000000
3116+ 49.000000 0 0.000000
3117+ 343.000000 0 0.000000
3118+ 2401.000000 0 0.000000
3119+ 16807.000000 0 0.000000
3120+ 117649.000000 0 0.000000
3121+ 823543.000000 0 0.000000
3122+ 5764801.00000 0 0.000000
3123+TOO LONG 0 TOO LONG
2256+SET GLOBAL QUERY_RESPONSE_TIME_STATS=1;3124+SET GLOBAL QUERY_RESPONSE_TIME_STATS=1;
2257+CALL test_f(0.31);3125+CALL test_f(0.31);
2258+CALL test_f(0.32);3126+CALL test_f(0.32);
@@ -2282,13 +3150,13 @@
2282+query_response_time_range_base 73150+query_response_time_range_base 7
2283+SHOW QUERY_RESPONSE_TIME;3151+SHOW QUERY_RESPONSE_TIME;
2284+ 3152+
2285+ 0.000001 46 0.0000003153+ 0.000001 45 0.000000
2286+ 0.000008 0 0.0000003154+ 0.000008 0 0.000000
2287+ 0.000059 0 0.0000003155+ 0.000059 0 0.000000
2288+ 0.000416 0 0.0000003156+ 0.000416 0 0.000000
2289+ 0.002915 0 0.0000003157+ 0.002915 0 0.000000
2290+ 0.020408 0 0.0000003158+ 0.020408 0 0.000000
2291+ 0.142857 46 4.6000003159+ 0.142857 44 4.400000
2292+ 1.000000 11 4.0500003160+ 1.000000 11 4.050000
2293+ 7.000000 11 25.6999993161+ 7.000000 11 25.699999
2294+ 49.000000 0 0.0000003162+ 49.000000 0 0.000000
@@ -2301,13 +3169,13 @@
2301+TOO LONG 0 TOO LONG3169+TOO LONG 0 TOO LONG
2302+SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME;3170+SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME;
2303+time count total3171+time count total
2304+ 0.000001 46 0.0000003172+ 0.000001 45 0.000000
2305+ 0.000008 0 0.0000003173+ 0.000008 0 0.000000
2306+ 0.000059 0 0.0000003174+ 0.000059 0 0.000000
2307+ 0.000416 0 0.0000003175+ 0.000416 0 0.000000
2308+ 0.002915 0 0.0000003176+ 0.002915 0 0.000000
2309+ 0.020408 0 0.0000003177+ 0.020408 0 0.000000
2310+ 0.142857 47 4.7000003178+ 0.142857 44 4.400000
2311+ 1.000000 11 4.0500003179+ 1.000000 11 4.050000
2312+ 7.000000 11 25.6999993180+ 7.000000 11 25.699999
2313+ 49.000000 0 0.0000003181+ 49.000000 0 0.000000
@@ -2323,6 +3191,24 @@
2323+SET GLOBAL QUERY_RESPONSE_TIME_STATS=0;3191+SET GLOBAL QUERY_RESPONSE_TIME_STATS=0;
2324+SET GLOBAL QUERY_RESPONSE_TIME_RANGE_BASE=156;3192+SET GLOBAL QUERY_RESPONSE_TIME_RANGE_BASE=156;
2325+FLUSH QUERY_RESPONSE_TIME;3193+FLUSH QUERY_RESPONSE_TIME;
3194+SHOW QUERY_RESPONSE_TIME;
3195+
3196+ 0.000041 0 0.000000
3197+ 0.006410 0 0.000000
3198+ 1.000000 0 0.000000
3199+ 156.000000 0 0.000000
3200+ 24336.000000 0 0.000000
3201+ 3796416.00000 0 0.000000
3202+TOO LONG 0 TOO LONG
3203+SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME;
3204+time count total
3205+ 0.000041 0 0.000000
3206+ 0.006410 0 0.000000
3207+ 1.000000 0 0.000000
3208+ 156.000000 0 0.000000
3209+ 24336.000000 0 0.000000
3210+ 3796416.00000 0 0.000000
3211+TOO LONG 0 TOO LONG
2326+SET GLOBAL QUERY_RESPONSE_TIME_STATS=1;3212+SET GLOBAL QUERY_RESPONSE_TIME_STATS=1;
2327+CALL test_f(0.31);3213+CALL test_f(0.31);
2328+CALL test_f(0.32);3214+CALL test_f(0.32);
@@ -2352,18 +3238,18 @@
2352+query_response_time_range_base 1563238+query_response_time_range_base 156
2353+SHOW QUERY_RESPONSE_TIME;3239+SHOW QUERY_RESPONSE_TIME;
2354+ 3240+
2355+ 0.000041 46 0.0000003241+ 0.000041 45 0.000000
2356+ 0.006410 0 0.0000003242+ 0.006410 0 0.000000
2357+ 1.000000 57 8.6500003243+ 1.000000 55 8.450000
2358+ 156.000000 11 25.6999993244+ 156.000000 11 25.699999
2359+ 24336.000000 0 0.0000003245+ 24336.000000 0 0.000000
2360+ 3796416.00000 0 0.0000003246+ 3796416.00000 0 0.000000
2361+TOO LONG 0 TOO LONG3247+TOO LONG 0 TOO LONG
2362+SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME;3248+SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME;
2363+time count total3249+time count total
2364+ 0.000041 46 0.0000003250+ 0.000041 45 0.000000
2365+ 0.006410 0 0.0000003251+ 0.006410 0 0.000000
2366+ 1.000000 58 8.7500003252+ 1.000000 55 8.450000
2367+ 156.000000 11 25.6999993253+ 156.000000 11 25.699999
2368+ 24336.000000 0 0.0000003254+ 24336.000000 0 0.000000
2369+ 3796416.00000 0 0.0000003255+ 3796416.00000 0 0.000000
@@ -2373,6 +3259,22 @@
2373+SET GLOBAL QUERY_RESPONSE_TIME_STATS=0;3259+SET GLOBAL QUERY_RESPONSE_TIME_STATS=0;
2374+SET GLOBAL QUERY_RESPONSE_TIME_RANGE_BASE=1000;3260+SET GLOBAL QUERY_RESPONSE_TIME_RANGE_BASE=1000;
2375+FLUSH QUERY_RESPONSE_TIME;3261+FLUSH QUERY_RESPONSE_TIME;
3262+SHOW QUERY_RESPONSE_TIME;
3263+
3264+ 0.000001 0 0.000000
3265+ 0.001000 0 0.000000
3266+ 1.000000 0 0.000000
3267+ 1000.000000 0 0.000000
3268+ 1000000.00000 0 0.000000
3269+TOO LONG 0 TOO LONG
3270+SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME;
3271+time count total
3272+ 0.000001 0 0.000000
3273+ 0.001000 0 0.000000
3274+ 1.000000 0 0.000000
3275+ 1000.000000 0 0.000000
3276+ 1000000.00000 0 0.000000
3277+TOO LONG 0 TOO LONG
2376+SET GLOBAL QUERY_RESPONSE_TIME_STATS=1;3278+SET GLOBAL QUERY_RESPONSE_TIME_STATS=1;
2377+CALL test_f(0.31);3279+CALL test_f(0.31);
2378+CALL test_f(0.32);3280+CALL test_f(0.32);
@@ -2402,17 +3304,17 @@
2402+query_response_time_range_base 10003304+query_response_time_range_base 1000
2403+SHOW QUERY_RESPONSE_TIME;3305+SHOW QUERY_RESPONSE_TIME;
2404+ 3306+
2405+ 0.000001 46 0.0000003307+ 0.000001 45 0.000000
2406+ 0.001000 0 0.0000003308+ 0.001000 0 0.000000
2407+ 1.000000 57 8.6500003309+ 1.000000 55 8.450000
2408+ 1000.000000 11 25.6999993310+ 1000.000000 11 25.699999
2409+ 1000000.00000 0 0.0000003311+ 1000000.00000 0 0.000000
2410+TOO LONG 0 TOO LONG3312+TOO LONG 0 TOO LONG
2411+SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME;3313+SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME;
2412+time count total3314+time count total
2413+ 0.000001 46 0.0000003315+ 0.000001 45 0.000000
2414+ 0.001000 0 0.0000003316+ 0.001000 0 0.000000
2415+ 1.000000 58 8.7500003317+ 1.000000 55 8.450000
2416+ 1000.000000 11 25.6999993318+ 1000.000000 11 25.699999
2417+ 1000000.00000 0 0.0000003319+ 1000000.00000 0 0.000000
2418+TOO LONG 0 TOO LONG3320+TOO LONG 0 TOO LONG
@@ -2423,6 +3325,22 @@
2423+Warnings:3325+Warnings:
2424+Warning 1292 Truncated incorrect query_response_time_range_base value: '1001'3326+Warning 1292 Truncated incorrect query_response_time_range_base value: '1001'
2425+FLUSH QUERY_RESPONSE_TIME;3327+FLUSH QUERY_RESPONSE_TIME;
3328+SHOW QUERY_RESPONSE_TIME;
3329+
3330+ 0.000001 0 0.000000
3331+ 0.001000 0 0.000000
3332+ 1.000000 0 0.000000
3333+ 1000.000000 0 0.000000
3334+ 1000000.00000 0 0.000000
3335+TOO LONG 0 TOO LONG
3336+SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME;
3337+time count total
3338+ 0.000001 0 0.000000
3339+ 0.001000 0 0.000000
3340+ 1.000000 0 0.000000
3341+ 1000.000000 0 0.000000
3342+ 1000000.00000 0 0.000000
3343+TOO LONG 0 TOO LONG
2426+SET GLOBAL QUERY_RESPONSE_TIME_STATS=1;3344+SET GLOBAL QUERY_RESPONSE_TIME_STATS=1;
2427+CALL test_f(0.31);3345+CALL test_f(0.31);
2428+CALL test_f(0.32);3346+CALL test_f(0.32);
@@ -2452,17 +3370,17 @@
2452+query_response_time_range_base 10003370+query_response_time_range_base 1000
2453+SHOW QUERY_RESPONSE_TIME;3371+SHOW QUERY_RESPONSE_TIME;
2454+ 3372+
2455+ 0.000001 46 0.0000003373+ 0.000001 45 0.000000
2456+ 0.001000 0 0.0000003374+ 0.001000 0 0.000000
2457+ 1.000000 57 8.6500003375+ 1.000000 55 8.450000
2458+ 1000.000000 11 25.6999993376+ 1000.000000 11 25.699999
2459+ 1000000.00000 0 0.0000003377+ 1000000.00000 0 0.000000
2460+TOO LONG 0 TOO LONG3378+TOO LONG 0 TOO LONG
2461+SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME;3379+SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME;
2462+time count total3380+time count total
2463+ 0.000001 46 0.0000003381+ 0.000001 45 0.000000
2464+ 0.001000 0 0.0000003382+ 0.001000 0 0.000000
2465+ 1.000000 58 8.7500003383+ 1.000000 55 8.450000
2466+ 1000.000000 11 25.6999993384+ 1000.000000 11 25.699999
2467+ 1000000.00000 0 0.0000003385+ 1000000.00000 0 0.000000
2468+TOO LONG 0 TOO LONG3386+TOO LONG 0 TOO LONG
@@ -3099,17 +4017,24 @@
3099 #include "transaction.h"4017 #include "transaction.h"
3100 #include "sql_audit.h"4018 #include "sql_audit.h"
3101 #include "sql_prepare.h"4019 #include "sql_prepare.h"
3102@@ -1507,6 +1508,9 @@4020@@ -1507,6 +1508,12 @@
3103 4021
3104 ulonglong end_utime_of_query= thd->current_utime();4022 ulonglong end_utime_of_query= thd->current_utime();
3105 ulonglong query_exec_time= get_query_exec_time(thd, end_utime_of_query);4023 ulonglong query_exec_time= get_query_exec_time(thd, end_utime_of_query);
3106+#ifdef HAVE_RESPONSE_TIME_DISTRIBUTION4024+#ifdef HAVE_RESPONSE_TIME_DISTRIBUTION
3107+ query_response_time_collect(query_exec_time);4025+ if (opt_query_response_time_stats)
4026+ {
4027+ query_response_time_collect(query_exec_time);
4028+ }
3108+#endif4029+#endif
3109 4030
3110 /*4031 /*
3111 Low long_query_time value most likely means user is debugging stuff and even4032 Low long_query_time value most likely means user is debugging stuff and even
4033<<<<<<< TREE
3112@@ -1671,6 +1675,7 @@4034@@ -1671,6 +1675,7 @@
4035=======
4036@@ -1671,6 +1678,7 @@
4037>>>>>>> MERGE-SOURCE
3113 case SCH_CHARSETS:4038 case SCH_CHARSETS:
3114 case SCH_ENGINES:4039 case SCH_ENGINES:
3115 case SCH_COLLATIONS:4040 case SCH_COLLATIONS:

Subscribers

People subscribed via source and target branches