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: 1015 lines (+400/-89)
1 file modified
patches/response_time_distribution.patch (+400/-89)
To merge this branch: bzr merge lp:~tsarev/percona-server/5.5_fix_bug_855312
Reviewer Review Type Date Requested Status
Laurynas Biveinis (community) Needs Fixing
Review via email: mp+76554@code.launchpad.net

This proposal supersedes a proposal from 2011-09-21.

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

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 : Posted in a previous version of this proposal

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 : Posted in a previous version of this proposal

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

Revision history for this message
Laurynas Biveinis (laurynas-biveinis) wrote :

The code part LGTM.
In tests:
1) I think it is enough to test for not collecting data when the option is off only in the query_response_time.inc, no need to do it in query_response_time-replication.inc and uery_response_time-stored.inc.
2) In query_response_time.inc add a comment before ++SHOW QUERY_RESPONSE_TIME; (line 15):
# Test for LP bug #855312 - slow query data was collected when opt_query_response_time_stats was off
or similar.

LGTM with these two changes.

review: Needs Fixing

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-23 06:56:22 +0000
@@ -48,12 +48,16 @@
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,43 @@
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+# Following two queries check works of FLUSH and
58+# respecting of "QUERY_RESPONSE_TIME_STATS" variable (see launchpad bug #855312)
59+SHOW QUERY_RESPONSE_TIME;
60+SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME;
57+SET GLOBAL QUERY_RESPONSE_TIME_STATS=1;61+SET GLOBAL QUERY_RESPONSE_TIME_STATS=1;
58+62+
59+SET SESSION query_exec_time=0.31; SELECT 1;63+SET SESSION query_exec_time=0.31; SELECT 1;
@@ -254,7 +258,7 @@
254+query_response_time_range_base 2258+query_response_time_range_base 2
255+SHOW QUERY_RESPONSE_TIME;259+SHOW QUERY_RESPONSE_TIME;
256+ 260+
257+ 0.000001 2 0.000000261+ 0.000001 1 0.000000
258+ 0.000003 0 0.000000262+ 0.000003 0 0.000000
259+ 0.000007 0 0.000000263+ 0.000007 0 0.000000
260+ 0.000015 0 0.000000264+ 0.000015 0 0.000000
@@ -270,7 +274,7 @@
270+ 0.015625 0 0.000000274+ 0.015625 0 0.000000
271+ 0.031250 0 0.000000275+ 0.031250 0 0.000000
272+ 0.062500 0 0.000000276+ 0.062500 0 0.000000
273+ 0.125000 3 0.300000277+ 0.125000 1 0.100000
274+ 0.250000 0 0.000000278+ 0.250000 0 0.000000
275+ 0.500000 30 10.650000279+ 0.500000 30 10.650000
276+ 1.000000 3 1.500000280+ 1.000000 3 1.500000
@@ -300,7 +304,7 @@
300+TOO LONG 0 TOO LONG304+TOO LONG 0 TOO LONG
301+SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME;305+SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME;
302+time count total306+time count total
303+ 0.000001 2 0.000000307+ 0.000001 1 0.000000
304+ 0.000003 0 0.000000308+ 0.000003 0 0.000000
305+ 0.000007 0 0.000000309+ 0.000007 0 0.000000
306+ 0.000015 0 0.000000310+ 0.000015 0 0.000000
@@ -316,7 +320,7 @@
316+ 0.015625 0 0.000000320+ 0.015625 0 0.000000
317+ 0.031250 0 0.000000321+ 0.031250 0 0.000000
318+ 0.062500 0 0.000000322+ 0.062500 0 0.000000
319+ 0.125000 4 0.400000323+ 0.125000 1 0.100000
320+ 0.250000 0 0.000000324+ 0.250000 0 0.000000
321+ 0.500000 30 10.650000325+ 0.500000 30 10.650000
322+ 1.000000 3 1.500000326+ 1.000000 3 1.500000
@@ -405,7 +409,7 @@
405+query_response_time_range_base 2409+query_response_time_range_base 2
406+SHOW QUERY_RESPONSE_TIME;410+SHOW QUERY_RESPONSE_TIME;
407+ 411+
408+ 0.000001 2 0.000000412+ 0.000001 1 0.000000
409+ 0.000003 0 0.000000413+ 0.000003 0 0.000000
410+ 0.000007 0 0.000000414+ 0.000007 0 0.000000
411+ 0.000015 0 0.000000415+ 0.000015 0 0.000000
@@ -421,7 +425,7 @@
421+ 0.015625 0 0.000000425+ 0.015625 0 0.000000
422+ 0.031250 0 0.000000426+ 0.031250 0 0.000000
423+ 0.062500 0 0.000000427+ 0.062500 0 0.000000
424+ 0.125000 3 0.300000428+ 0.125000 1 0.100000
425+ 0.250000 0 0.000000429+ 0.250000 0 0.000000
426+ 0.500000 30 10.650000430+ 0.500000 30 10.650000
427+ 1.000000 3 1.500000431+ 1.000000 3 1.500000
@@ -451,7 +455,7 @@
451+TOO LONG 0 TOO LONG455+TOO LONG 0 TOO LONG
452+SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME;456+SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME;
453+time count total457+time count total
454+ 0.000001 2 0.000000458+ 0.000001 1 0.000000
455+ 0.000003 0 0.000000459+ 0.000003 0 0.000000
456+ 0.000007 0 0.000000460+ 0.000007 0 0.000000
457+ 0.000015 0 0.000000461+ 0.000015 0 0.000000
@@ -467,7 +471,7 @@
467+ 0.015625 0 0.000000471+ 0.015625 0 0.000000
468+ 0.031250 0 0.000000472+ 0.031250 0 0.000000
469+ 0.062500 0 0.000000473+ 0.062500 0 0.000000
470+ 0.125000 4 0.400000474+ 0.125000 1 0.100000
471+ 0.250000 0 0.000000475+ 0.250000 0 0.000000
472+ 0.500000 30 10.650000476+ 0.500000 30 10.650000
473+ 1.000000 3 1.500000477+ 1.000000 3 1.500000
@@ -556,13 +560,13 @@
556+query_response_time_range_base 10560+query_response_time_range_base 10
557+SHOW QUERY_RESPONSE_TIME;561+SHOW QUERY_RESPONSE_TIME;
558+ 562+
559+ 0.000001 2 0.000000563+ 0.000001 1 0.000000
560+ 0.000010 0 0.000000564+ 0.000010 0 0.000000
561+ 0.000100 0 0.000000565+ 0.000100 0 0.000000
562+ 0.001000 0 0.000000566+ 0.001000 0 0.000000
563+ 0.010000 0 0.000000567+ 0.010000 0 0.000000
564+ 0.100000 0 0.000000568+ 0.100000 0 0.000000
565+ 1.000000 36 12.450000569+ 1.000000 34 12.250000
566+ 10.000000 33 77.099997570+ 10.000000 33 77.099997
567+ 100.000000 0 0.000000571+ 100.000000 0 0.000000
568+ 1000.000000 0 0.000000572+ 1000.000000 0 0.000000
@@ -572,13 +576,13 @@
572+TOO LONG 0 TOO LONG576+TOO LONG 0 TOO LONG
573+SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME;577+SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME;
574+time count total578+time count total
575+ 0.000001 2 0.000000579+ 0.000001 1 0.000000
576+ 0.000010 0 0.000000580+ 0.000010 0 0.000000
577+ 0.000100 0 0.000000581+ 0.000100 0 0.000000
578+ 0.001000 0 0.000000582+ 0.001000 0 0.000000
579+ 0.010000 0 0.000000583+ 0.010000 0 0.000000
580+ 0.100000 0 0.000000584+ 0.100000 0 0.000000
581+ 1.000000 37 12.550000585+ 1.000000 34 12.250000
582+ 10.000000 33 77.099997586+ 10.000000 33 77.099997
583+ 100.000000 0 0.000000587+ 100.000000 0 0.000000
584+ 1000.000000 0 0.000000588+ 1000.000000 0 0.000000
@@ -647,13 +651,13 @@
647+query_response_time_range_base 7651+query_response_time_range_base 7
648+SHOW QUERY_RESPONSE_TIME;652+SHOW QUERY_RESPONSE_TIME;
649+ 653+
650+ 0.000001 2 0.000000654+ 0.000001 1 0.000000
651+ 0.000008 0 0.000000655+ 0.000008 0 0.000000
652+ 0.000059 0 0.000000656+ 0.000059 0 0.000000
653+ 0.000416 0 0.000000657+ 0.000416 0 0.000000
654+ 0.002915 0 0.000000658+ 0.002915 0 0.000000
655+ 0.020408 0 0.000000659+ 0.020408 0 0.000000
656+ 0.142857 3 0.300000660+ 0.142857 1 0.100000
657+ 1.000000 33 12.150000661+ 1.000000 33 12.150000
658+ 7.000000 33 77.099997662+ 7.000000 33 77.099997
659+ 49.000000 0 0.000000663+ 49.000000 0 0.000000
@@ -666,13 +670,13 @@
666+TOO LONG 0 TOO LONG670+TOO LONG 0 TOO LONG
667+SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME;671+SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME;
668+time count total672+time count total
669+ 0.000001 2 0.000000673+ 0.000001 1 0.000000
670+ 0.000008 0 0.000000674+ 0.000008 0 0.000000
671+ 0.000059 0 0.000000675+ 0.000059 0 0.000000
672+ 0.000416 0 0.000000676+ 0.000416 0 0.000000
673+ 0.002915 0 0.000000677+ 0.002915 0 0.000000
674+ 0.020408 0 0.000000678+ 0.020408 0 0.000000
675+ 0.142857 4 0.400000679+ 0.142857 1 0.100000
676+ 1.000000 33 12.150000680+ 1.000000 33 12.150000
677+ 7.000000 33 77.099997681+ 7.000000 33 77.099997
678+ 49.000000 0 0.000000682+ 49.000000 0 0.000000
@@ -744,18 +748,18 @@
744+query_response_time_range_base 156748+query_response_time_range_base 156
745+SHOW QUERY_RESPONSE_TIME;749+SHOW QUERY_RESPONSE_TIME;
746+ 750+
747+ 0.000041 2 0.000000751+ 0.000041 1 0.000000
748+ 0.006410 0 0.000000752+ 0.006410 0 0.000000
749+ 1.000000 36 12.450000753+ 1.000000 34 12.250000
750+ 156.000000 33 77.099997754+ 156.000000 33 77.099997
751+ 24336.000000 0 0.000000755+ 24336.000000 0 0.000000
752+ 3796416.00000 0 0.000000756+ 3796416.00000 0 0.000000
753+TOO LONG 0 TOO LONG757+TOO LONG 0 TOO LONG
754+SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME;758+SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME;
755+time count total759+time count total
756+ 0.000041 2 0.000000760+ 0.000041 1 0.000000
757+ 0.006410 0 0.000000761+ 0.006410 0 0.000000
758+ 1.000000 37 12.550000762+ 1.000000 34 12.250000
759+ 156.000000 33 77.099997763+ 156.000000 33 77.099997
760+ 24336.000000 0 0.000000764+ 24336.000000 0 0.000000
761+ 3796416.00000 0 0.000000765+ 3796416.00000 0 0.000000
@@ -821,17 +825,17 @@
821+query_response_time_range_base 1000825+query_response_time_range_base 1000
822+SHOW QUERY_RESPONSE_TIME;826+SHOW QUERY_RESPONSE_TIME;
823+ 827+
824+ 0.000001 2 0.000000828+ 0.000001 1 0.000000
825+ 0.001000 0 0.000000829+ 0.001000 0 0.000000
826+ 1.000000 36 12.450000830+ 1.000000 34 12.250000
827+ 1000.000000 33 77.099997831+ 1000.000000 33 77.099997
828+ 1000000.00000 0 0.000000832+ 1000000.00000 0 0.000000
829+TOO LONG 0 TOO LONG833+TOO LONG 0 TOO LONG
830+SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME;834+SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME;
831+time count total835+time count total
832+ 0.000001 2 0.000000836+ 0.000001 1 0.000000
833+ 0.001000 0 0.000000837+ 0.001000 0 0.000000
834+ 1.000000 37 12.550000838+ 1.000000 34 12.250000
835+ 1000.000000 33 77.099997839+ 1000.000000 33 77.099997
836+ 1000000.00000 0 0.000000840+ 1000000.00000 0 0.000000
837+TOO LONG 0 TOO LONG841+TOO LONG 0 TOO LONG
@@ -898,17 +902,17 @@
898+query_response_time_range_base 1000902+query_response_time_range_base 1000
899+SHOW QUERY_RESPONSE_TIME;903+SHOW QUERY_RESPONSE_TIME;
900+ 904+
901+ 0.000001 2 0.000000905+ 0.000001 1 0.000000
902+ 0.001000 0 0.000000906+ 0.001000 0 0.000000
903+ 1.000000 36 12.450000907+ 1.000000 34 12.250000
904+ 1000.000000 33 77.099997908+ 1000.000000 33 77.099997
905+ 1000000.00000 0 0.000000909+ 1000000.00000 0 0.000000
906+TOO LONG 0 TOO LONG910+TOO LONG 0 TOO LONG
907+SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME;911+SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME;
908+time count total912+time count total
909+ 0.000001 2 0.000000913+ 0.000001 1 0.000000
910+ 0.001000 0 0.000000914+ 0.001000 0 0.000000
911+ 1.000000 37 12.550000915+ 1.000000 34 12.250000
912+ 1000.000000 33 77.099997916+ 1000.000000 33 77.099997
913+ 1000000.00000 0 0.000000917+ 1000000.00000 0 0.000000
914+TOO LONG 0 TOO LONG918+TOO LONG 0 TOO LONG
@@ -920,13 +924,105 @@
920+SET GLOBAL query_exec_time=default;924+SET GLOBAL query_exec_time=default;
921--- /dev/null925--- /dev/null
922+++ b/mysql-test/r/percona_query_response_time.result926+++ b/mysql-test/r/percona_query_response_time.result
923@@ -0,0 +1,1003 @@927@@ -0,0 +1,1307 @@
924+SET SESSION query_exec_time=0.1;928+SET SESSION query_exec_time=0.1;
925+SET GLOBAL QUERY_RESPONSE_TIME_STATS=0;929+SET GLOBAL QUERY_RESPONSE_TIME_STATS=0;
926+SET GLOBAL QUERY_RESPONSE_TIME_RANGE_BASE=1;930+SET GLOBAL QUERY_RESPONSE_TIME_RANGE_BASE=1;
927+Warnings:931+Warnings:
928+Warning 1292 Truncated incorrect query_response_time_range_base value: '1'932+Warning 1292 Truncated incorrect query_response_time_range_base value: '1'
929+FLUSH QUERY_RESPONSE_TIME;933+FLUSH QUERY_RESPONSE_TIME;
934+SHOW QUERY_RESPONSE_TIME;
935+
936+ 0.000001 0 0.000000
937+ 0.000003 0 0.000000
938+ 0.000007 0 0.000000
939+ 0.000015 0 0.000000
940+ 0.000030 0 0.000000
941+ 0.000061 0 0.000000
942+ 0.000122 0 0.000000
943+ 0.000244 0 0.000000
944+ 0.000488 0 0.000000
945+ 0.000976 0 0.000000
946+ 0.001953 0 0.000000
947+ 0.003906 0 0.000000
948+ 0.007812 0 0.000000
949+ 0.015625 0 0.000000
950+ 0.031250 0 0.000000
951+ 0.062500 0 0.000000
952+ 0.125000 0 0.000000
953+ 0.250000 0 0.000000
954+ 0.500000 0 0.000000
955+ 1.000000 0 0.000000
956+ 2.000000 0 0.000000
957+ 4.000000 0 0.000000
958+ 8.000000 0 0.000000
959+ 16.000000 0 0.000000
960+ 32.000000 0 0.000000
961+ 64.000000 0 0.000000
962+ 128.000000 0 0.000000
963+ 256.000000 0 0.000000
964+ 512.000000 0 0.000000
965+ 1024.000000 0 0.000000
966+ 2048.000000 0 0.000000
967+ 4096.000000 0 0.000000
968+ 8192.000000 0 0.000000
969+ 16384.000000 0 0.000000
970+ 32768.000000 0 0.000000
971+ 65536.000000 0 0.000000
972+ 131072.000000 0 0.000000
973+ 262144.000000 0 0.000000
974+ 524288.000000 0 0.000000
975+ 1048576.00000 0 0.000000
976+ 2097152.00000 0 0.000000
977+ 4194304.00000 0 0.000000
978+ 8388608.00000 0 0.000000
979+TOO LONG 0 TOO LONG
980+SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME;
981+time count total
982+ 0.000001 0 0.000000
983+ 0.000003 0 0.000000
984+ 0.000007 0 0.000000
985+ 0.000015 0 0.000000
986+ 0.000030 0 0.000000
987+ 0.000061 0 0.000000
988+ 0.000122 0 0.000000
989+ 0.000244 0 0.000000
990+ 0.000488 0 0.000000
991+ 0.000976 0 0.000000
992+ 0.001953 0 0.000000
993+ 0.003906 0 0.000000
994+ 0.007812 0 0.000000
995+ 0.015625 0 0.000000
996+ 0.031250 0 0.000000
997+ 0.062500 0 0.000000
998+ 0.125000 0 0.000000
999+ 0.250000 0 0.000000
1000+ 0.500000 0 0.000000
1001+ 1.000000 0 0.000000
1002+ 2.000000 0 0.000000
1003+ 4.000000 0 0.000000
1004+ 8.000000 0 0.000000
1005+ 16.000000 0 0.000000
1006+ 32.000000 0 0.000000
1007+ 64.000000 0 0.000000
1008+ 128.000000 0 0.000000
1009+ 256.000000 0 0.000000
1010+ 512.000000 0 0.000000
1011+ 1024.000000 0 0.000000
1012+ 2048.000000 0 0.000000
1013+ 4096.000000 0 0.000000
1014+ 8192.000000 0 0.000000
1015+ 16384.000000 0 0.000000
1016+ 32768.000000 0 0.000000
1017+ 65536.000000 0 0.000000
1018+ 131072.000000 0 0.000000
1019+ 262144.000000 0 0.000000
1020+ 524288.000000 0 0.000000
1021+ 1048576.00000 0 0.000000
1022+ 2097152.00000 0 0.000000
1023+ 4194304.00000 0 0.000000
1024+ 8388608.00000 0 0.000000
1025+TOO LONG 0 TOO LONG
930+SET GLOBAL QUERY_RESPONSE_TIME_STATS=1;1026+SET GLOBAL QUERY_RESPONSE_TIME_STATS=1;
931+SET SESSION query_exec_time=0.31;1027+SET SESSION query_exec_time=0.31;
932+SELECT 1;1028+SELECT 1;
@@ -1023,7 +1119,7 @@
1023+query_response_time_range_base 21119+query_response_time_range_base 2
1024+SHOW QUERY_RESPONSE_TIME;1120+SHOW QUERY_RESPONSE_TIME;
1025+ 1121+
1026+ 0.000001 25 0.0000001122+ 0.000001 24 0.000000
1027+ 0.000003 0 0.0000001123+ 0.000003 0 0.000000
1028+ 0.000007 0 0.0000001124+ 0.000007 0 0.000000
1029+ 0.000015 0 0.0000001125+ 0.000015 0 0.000000
@@ -1039,7 +1135,7 @@
1039+ 0.015625 0 0.0000001135+ 0.015625 0 0.000000
1040+ 0.031250 0 0.0000001136+ 0.031250 0 0.000000
1041+ 0.062500 0 0.0000001137+ 0.062500 0 0.000000
1042+ 0.125000 2 0.2000001138+ 0.125000 0 0.000000
1043+ 0.250000 0 0.0000001139+ 0.250000 0 0.000000
1044+ 0.500000 10 3.5500001140+ 0.500000 10 3.550000
1045+ 1.000000 1 0.5000001141+ 1.000000 1 0.500000
@@ -1069,7 +1165,7 @@
1069+TOO LONG 0 TOO LONG1165+TOO LONG 0 TOO LONG
1070+SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME;1166+SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME;
1071+time count total1167+time count total
1072+ 0.000001 25 0.0000001168+ 0.000001 24 0.000000
1073+ 0.000003 0 0.0000001169+ 0.000003 0 0.000000
1074+ 0.000007 0 0.0000001170+ 0.000007 0 0.000000
1075+ 0.000015 0 0.0000001171+ 0.000015 0 0.000000
@@ -1085,7 +1181,7 @@
1085+ 0.015625 0 0.0000001181+ 0.015625 0 0.000000
1086+ 0.031250 0 0.0000001182+ 0.031250 0 0.000000
1087+ 0.062500 0 0.0000001183+ 0.062500 0 0.000000
1088+ 0.125000 3 0.3000001184+ 0.125000 0 0.000000
1089+ 0.250000 0 0.0000001185+ 0.250000 0 0.000000
1090+ 0.500000 10 3.5500001186+ 0.500000 10 3.550000
1091+ 1.000000 1 0.5000001187+ 1.000000 1 0.500000
@@ -1118,6 +1214,98 @@
1118+SET GLOBAL QUERY_RESPONSE_TIME_STATS=0;1214+SET GLOBAL QUERY_RESPONSE_TIME_STATS=0;
1119+SET GLOBAL QUERY_RESPONSE_TIME_RANGE_BASE=2;1215+SET GLOBAL QUERY_RESPONSE_TIME_RANGE_BASE=2;
1120+FLUSH QUERY_RESPONSE_TIME;1216+FLUSH QUERY_RESPONSE_TIME;
1217+SHOW QUERY_RESPONSE_TIME;
1218+
1219+ 0.000001 0 0.000000
1220+ 0.000003 0 0.000000
1221+ 0.000007 0 0.000000
1222+ 0.000015 0 0.000000
1223+ 0.000030 0 0.000000
1224+ 0.000061 0 0.000000
1225+ 0.000122 0 0.000000
1226+ 0.000244 0 0.000000
1227+ 0.000488 0 0.000000
1228+ 0.000976 0 0.000000
1229+ 0.001953 0 0.000000
1230+ 0.003906 0 0.000000
1231+ 0.007812 0 0.000000
1232+ 0.015625 0 0.000000
1233+ 0.031250 0 0.000000
1234+ 0.062500 0 0.000000
1235+ 0.125000 0 0.000000
1236+ 0.250000 0 0.000000
1237+ 0.500000 0 0.000000
1238+ 1.000000 0 0.000000
1239+ 2.000000 0 0.000000
1240+ 4.000000 0 0.000000
1241+ 8.000000 0 0.000000
1242+ 16.000000 0 0.000000
1243+ 32.000000 0 0.000000
1244+ 64.000000 0 0.000000
1245+ 128.000000 0 0.000000
1246+ 256.000000 0 0.000000
1247+ 512.000000 0 0.000000
1248+ 1024.000000 0 0.000000
1249+ 2048.000000 0 0.000000
1250+ 4096.000000 0 0.000000
1251+ 8192.000000 0 0.000000
1252+ 16384.000000 0 0.000000
1253+ 32768.000000 0 0.000000
1254+ 65536.000000 0 0.000000
1255+ 131072.000000 0 0.000000
1256+ 262144.000000 0 0.000000
1257+ 524288.000000 0 0.000000
1258+ 1048576.00000 0 0.000000
1259+ 2097152.00000 0 0.000000
1260+ 4194304.00000 0 0.000000
1261+ 8388608.00000 0 0.000000
1262+TOO LONG 0 TOO LONG
1263+SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME;
1264+time count total
1265+ 0.000001 0 0.000000
1266+ 0.000003 0 0.000000
1267+ 0.000007 0 0.000000
1268+ 0.000015 0 0.000000
1269+ 0.000030 0 0.000000
1270+ 0.000061 0 0.000000
1271+ 0.000122 0 0.000000
1272+ 0.000244 0 0.000000
1273+ 0.000488 0 0.000000
1274+ 0.000976 0 0.000000
1275+ 0.001953 0 0.000000
1276+ 0.003906 0 0.000000
1277+ 0.007812 0 0.000000
1278+ 0.015625 0 0.000000
1279+ 0.031250 0 0.000000
1280+ 0.062500 0 0.000000
1281+ 0.125000 0 0.000000
1282+ 0.250000 0 0.000000
1283+ 0.500000 0 0.000000
1284+ 1.000000 0 0.000000
1285+ 2.000000 0 0.000000
1286+ 4.000000 0 0.000000
1287+ 8.000000 0 0.000000
1288+ 16.000000 0 0.000000
1289+ 32.000000 0 0.000000
1290+ 64.000000 0 0.000000
1291+ 128.000000 0 0.000000
1292+ 256.000000 0 0.000000
1293+ 512.000000 0 0.000000
1294+ 1024.000000 0 0.000000
1295+ 2048.000000 0 0.000000
1296+ 4096.000000 0 0.000000
1297+ 8192.000000 0 0.000000
1298+ 16384.000000 0 0.000000
1299+ 32768.000000 0 0.000000
1300+ 65536.000000 0 0.000000
1301+ 131072.000000 0 0.000000
1302+ 262144.000000 0 0.000000
1303+ 524288.000000 0 0.000000
1304+ 1048576.00000 0 0.000000
1305+ 2097152.00000 0 0.000000
1306+ 4194304.00000 0 0.000000
1307+ 8388608.00000 0 0.000000
1308+TOO LONG 0 TOO LONG
1121+SET GLOBAL QUERY_RESPONSE_TIME_STATS=1;1309+SET GLOBAL QUERY_RESPONSE_TIME_STATS=1;
1122+SET SESSION query_exec_time=0.31;1310+SET SESSION query_exec_time=0.31;
1123+SELECT 1;1311+SELECT 1;
@@ -1214,7 +1402,7 @@
1214+query_response_time_range_base 21402+query_response_time_range_base 2
1215+SHOW QUERY_RESPONSE_TIME;1403+SHOW QUERY_RESPONSE_TIME;
1216+ 1404+
1217+ 0.000001 25 0.0000001405+ 0.000001 24 0.000000
1218+ 0.000003 0 0.0000001406+ 0.000003 0 0.000000
1219+ 0.000007 0 0.0000001407+ 0.000007 0 0.000000
1220+ 0.000015 0 0.0000001408+ 0.000015 0 0.000000
@@ -1230,7 +1418,7 @@
1230+ 0.015625 0 0.0000001418+ 0.015625 0 0.000000
1231+ 0.031250 0 0.0000001419+ 0.031250 0 0.000000
1232+ 0.062500 0 0.0000001420+ 0.062500 0 0.000000
1233+ 0.125000 2 0.2000001421+ 0.125000 0 0.000000
1234+ 0.250000 0 0.0000001422+ 0.250000 0 0.000000
1235+ 0.500000 10 3.5500001423+ 0.500000 10 3.550000
1236+ 1.000000 1 0.5000001424+ 1.000000 1 0.500000
@@ -1260,7 +1448,7 @@
1260+TOO LONG 0 TOO LONG1448+TOO LONG 0 TOO LONG
1261+SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME;1449+SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME;
1262+time count total1450+time count total
1263+ 0.000001 25 0.0000001451+ 0.000001 24 0.000000
1264+ 0.000003 0 0.0000001452+ 0.000003 0 0.000000
1265+ 0.000007 0 0.0000001453+ 0.000007 0 0.000000
1266+ 0.000015 0 0.0000001454+ 0.000015 0 0.000000
@@ -1276,7 +1464,7 @@
1276+ 0.015625 0 0.0000001464+ 0.015625 0 0.000000
1277+ 0.031250 0 0.0000001465+ 0.031250 0 0.000000
1278+ 0.062500 0 0.0000001466+ 0.062500 0 0.000000
1279+ 0.125000 3 0.3000001467+ 0.125000 0 0.000000
1280+ 0.250000 0 0.0000001468+ 0.250000 0 0.000000
1281+ 0.500000 10 3.5500001469+ 0.500000 10 3.550000
1282+ 1.000000 1 0.5000001470+ 1.000000 1 0.500000
@@ -1309,6 +1497,38 @@
1309+SET GLOBAL QUERY_RESPONSE_TIME_STATS=0;1497+SET GLOBAL QUERY_RESPONSE_TIME_STATS=0;
1310+SET GLOBAL QUERY_RESPONSE_TIME_RANGE_BASE=10;1498+SET GLOBAL QUERY_RESPONSE_TIME_RANGE_BASE=10;
1311+FLUSH QUERY_RESPONSE_TIME;1499+FLUSH QUERY_RESPONSE_TIME;
1500+SHOW QUERY_RESPONSE_TIME;
1501+
1502+ 0.000001 0 0.000000
1503+ 0.000010 0 0.000000
1504+ 0.000100 0 0.000000
1505+ 0.001000 0 0.000000
1506+ 0.010000 0 0.000000
1507+ 0.100000 0 0.000000
1508+ 1.000000 0 0.000000
1509+ 10.000000 0 0.000000
1510+ 100.000000 0 0.000000
1511+ 1000.000000 0 0.000000
1512+ 10000.000000 0 0.000000
1513+ 100000.000000 0 0.000000
1514+ 1000000.00000 0 0.000000
1515+TOO LONG 0 TOO LONG
1516+SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME;
1517+time count total
1518+ 0.000001 0 0.000000
1519+ 0.000010 0 0.000000
1520+ 0.000100 0 0.000000
1521+ 0.001000 0 0.000000
1522+ 0.010000 0 0.000000
1523+ 0.100000 0 0.000000
1524+ 1.000000 0 0.000000
1525+ 10.000000 0 0.000000
1526+ 100.000000 0 0.000000
1527+ 1000.000000 0 0.000000
1528+ 10000.000000 0 0.000000
1529+ 100000.000000 0 0.000000
1530+ 1000000.00000 0 0.000000
1531+TOO LONG 0 TOO LONG
1312+SET GLOBAL QUERY_RESPONSE_TIME_STATS=1;1532+SET GLOBAL QUERY_RESPONSE_TIME_STATS=1;
1313+SET SESSION query_exec_time=0.31;1533+SET SESSION query_exec_time=0.31;
1314+SELECT 1;1534+SELECT 1;
@@ -1405,13 +1625,13 @@
1405+query_response_time_range_base 101625+query_response_time_range_base 10
1406+SHOW QUERY_RESPONSE_TIME;1626+SHOW QUERY_RESPONSE_TIME;
1407+ 1627+
1408+ 0.000001 25 0.0000001628+ 0.000001 24 0.000000
1409+ 0.000010 0 0.0000001629+ 0.000010 0 0.000000
1410+ 0.000100 0 0.0000001630+ 0.000100 0 0.000000
1411+ 0.001000 0 0.0000001631+ 0.001000 0 0.000000
1412+ 0.010000 0 0.0000001632+ 0.010000 0 0.000000
1413+ 0.100000 0 0.0000001633+ 0.100000 0 0.000000
1414+ 1.000000 13 4.2500001634+ 1.000000 11 4.050000
1415+ 10.000000 11 25.6999991635+ 10.000000 11 25.699999
1416+ 100.000000 0 0.0000001636+ 100.000000 0 0.000000
1417+ 1000.000000 0 0.0000001637+ 1000.000000 0 0.000000
@@ -1421,13 +1641,13 @@
1421+TOO LONG 0 TOO LONG1641+TOO LONG 0 TOO LONG
1422+SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME;1642+SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME;
1423+time count total1643+time count total
1424+ 0.000001 25 0.0000001644+ 0.000001 24 0.000000
1425+ 0.000010 0 0.0000001645+ 0.000010 0 0.000000
1426+ 0.000100 0 0.0000001646+ 0.000100 0 0.000000
1427+ 0.001000 0 0.0000001647+ 0.001000 0 0.000000
1428+ 0.010000 0 0.0000001648+ 0.010000 0 0.000000
1429+ 0.100000 0 0.0000001649+ 0.100000 0 0.000000
1430+ 1.000000 14 4.3500001650+ 1.000000 11 4.050000
1431+ 10.000000 11 25.6999991651+ 10.000000 11 25.699999
1432+ 100.000000 0 0.0000001652+ 100.000000 0 0.000000
1433+ 1000.000000 0 0.0000001653+ 1000.000000 0 0.000000
@@ -1440,6 +1660,44 @@
1440+SET GLOBAL QUERY_RESPONSE_TIME_STATS=0;1660+SET GLOBAL QUERY_RESPONSE_TIME_STATS=0;
1441+SET GLOBAL QUERY_RESPONSE_TIME_RANGE_BASE=7;1661+SET GLOBAL QUERY_RESPONSE_TIME_RANGE_BASE=7;
1442+FLUSH QUERY_RESPONSE_TIME;1662+FLUSH QUERY_RESPONSE_TIME;
1663+SHOW QUERY_RESPONSE_TIME;
1664+
1665+ 0.000001 0 0.000000
1666+ 0.000008 0 0.000000
1667+ 0.000059 0 0.000000
1668+ 0.000416 0 0.000000
1669+ 0.002915 0 0.000000
1670+ 0.020408 0 0.000000
1671+ 0.142857 0 0.000000
1672+ 1.000000 0 0.000000
1673+ 7.000000 0 0.000000
1674+ 49.000000 0 0.000000
1675+ 343.000000 0 0.000000
1676+ 2401.000000 0 0.000000
1677+ 16807.000000 0 0.000000
1678+ 117649.000000 0 0.000000
1679+ 823543.000000 0 0.000000
1680+ 5764801.00000 0 0.000000
1681+TOO LONG 0 TOO LONG
1682+SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME;
1683+time count total
1684+ 0.000001 0 0.000000
1685+ 0.000008 0 0.000000
1686+ 0.000059 0 0.000000
1687+ 0.000416 0 0.000000
1688+ 0.002915 0 0.000000
1689+ 0.020408 0 0.000000
1690+ 0.142857 0 0.000000
1691+ 1.000000 0 0.000000
1692+ 7.000000 0 0.000000
1693+ 49.000000 0 0.000000
1694+ 343.000000 0 0.000000
1695+ 2401.000000 0 0.000000
1696+ 16807.000000 0 0.000000
1697+ 117649.000000 0 0.000000
1698+ 823543.000000 0 0.000000
1699+ 5764801.00000 0 0.000000
1700+TOO LONG 0 TOO LONG
1443+SET GLOBAL QUERY_RESPONSE_TIME_STATS=1;1701+SET GLOBAL QUERY_RESPONSE_TIME_STATS=1;
1444+SET SESSION query_exec_time=0.31;1702+SET SESSION query_exec_time=0.31;
1445+SELECT 1;1703+SELECT 1;
@@ -1536,13 +1794,13 @@
1536+query_response_time_range_base 71794+query_response_time_range_base 7
1537+SHOW QUERY_RESPONSE_TIME;1795+SHOW QUERY_RESPONSE_TIME;
1538+ 1796+
1539+ 0.000001 25 0.0000001797+ 0.000001 24 0.000000
1540+ 0.000008 0 0.0000001798+ 0.000008 0 0.000000
1541+ 0.000059 0 0.0000001799+ 0.000059 0 0.000000
1542+ 0.000416 0 0.0000001800+ 0.000416 0 0.000000
1543+ 0.002915 0 0.0000001801+ 0.002915 0 0.000000
1544+ 0.020408 0 0.0000001802+ 0.020408 0 0.000000
1545+ 0.142857 2 0.2000001803+ 0.142857 0 0.000000
1546+ 1.000000 11 4.0500001804+ 1.000000 11 4.050000
1547+ 7.000000 11 25.6999991805+ 7.000000 11 25.699999
1548+ 49.000000 0 0.0000001806+ 49.000000 0 0.000000
@@ -1555,13 +1813,13 @@
1555+TOO LONG 0 TOO LONG1813+TOO LONG 0 TOO LONG
1556+SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME;1814+SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME;
1557+time count total1815+time count total
1558+ 0.000001 25 0.0000001816+ 0.000001 24 0.000000
1559+ 0.000008 0 0.0000001817+ 0.000008 0 0.000000
1560+ 0.000059 0 0.0000001818+ 0.000059 0 0.000000
1561+ 0.000416 0 0.0000001819+ 0.000416 0 0.000000
1562+ 0.002915 0 0.0000001820+ 0.002915 0 0.000000
1563+ 0.020408 0 0.0000001821+ 0.020408 0 0.000000
1564+ 0.142857 3 0.3000001822+ 0.142857 0 0.000000
1565+ 1.000000 11 4.0500001823+ 1.000000 11 4.050000
1566+ 7.000000 11 25.6999991824+ 7.000000 11 25.699999
1567+ 49.000000 0 0.0000001825+ 49.000000 0 0.000000
@@ -1577,6 +1835,24 @@
1577+SET GLOBAL QUERY_RESPONSE_TIME_STATS=0;1835+SET GLOBAL QUERY_RESPONSE_TIME_STATS=0;
1578+SET GLOBAL QUERY_RESPONSE_TIME_RANGE_BASE=156;1836+SET GLOBAL QUERY_RESPONSE_TIME_RANGE_BASE=156;
1579+FLUSH QUERY_RESPONSE_TIME;1837+FLUSH QUERY_RESPONSE_TIME;
1838+SHOW QUERY_RESPONSE_TIME;
1839+
1840+ 0.000041 0 0.000000
1841+ 0.006410 0 0.000000
1842+ 1.000000 0 0.000000
1843+ 156.000000 0 0.000000
1844+ 24336.000000 0 0.000000
1845+ 3796416.00000 0 0.000000
1846+TOO LONG 0 TOO LONG
1847+SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME;
1848+time count total
1849+ 0.000041 0 0.000000
1850+ 0.006410 0 0.000000
1851+ 1.000000 0 0.000000
1852+ 156.000000 0 0.000000
1853+ 24336.000000 0 0.000000
1854+ 3796416.00000 0 0.000000
1855+TOO LONG 0 TOO LONG
1580+SET GLOBAL QUERY_RESPONSE_TIME_STATS=1;1856+SET GLOBAL QUERY_RESPONSE_TIME_STATS=1;
1581+SET SESSION query_exec_time=0.31;1857+SET SESSION query_exec_time=0.31;
1582+SELECT 1;1858+SELECT 1;
@@ -1673,18 +1949,18 @@
1673+query_response_time_range_base 1561949+query_response_time_range_base 156
1674+SHOW QUERY_RESPONSE_TIME;1950+SHOW QUERY_RESPONSE_TIME;
1675+ 1951+
1676+ 0.000041 25 0.0000001952+ 0.000041 24 0.000000
1677+ 0.006410 0 0.0000001953+ 0.006410 0 0.000000
1678+ 1.000000 13 4.2500001954+ 1.000000 11 4.050000
1679+ 156.000000 11 25.6999991955+ 156.000000 11 25.699999
1680+ 24336.000000 0 0.0000001956+ 24336.000000 0 0.000000
1681+ 3796416.00000 0 0.0000001957+ 3796416.00000 0 0.000000
1682+TOO LONG 0 TOO LONG1958+TOO LONG 0 TOO LONG
1683+SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME;1959+SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME;
1684+time count total1960+time count total
1685+ 0.000041 25 0.0000001961+ 0.000041 24 0.000000
1686+ 0.006410 0 0.0000001962+ 0.006410 0 0.000000
1687+ 1.000000 14 4.3500001963+ 1.000000 11 4.050000
1688+ 156.000000 11 25.6999991964+ 156.000000 11 25.699999
1689+ 24336.000000 0 0.0000001965+ 24336.000000 0 0.000000
1690+ 3796416.00000 0 0.0000001966+ 3796416.00000 0 0.000000
@@ -1694,6 +1970,22 @@
1694+SET GLOBAL QUERY_RESPONSE_TIME_STATS=0;1970+SET GLOBAL QUERY_RESPONSE_TIME_STATS=0;
1695+SET GLOBAL QUERY_RESPONSE_TIME_RANGE_BASE=1000;1971+SET GLOBAL QUERY_RESPONSE_TIME_RANGE_BASE=1000;
1696+FLUSH QUERY_RESPONSE_TIME;1972+FLUSH QUERY_RESPONSE_TIME;
1973+SHOW QUERY_RESPONSE_TIME;
1974+
1975+ 0.000001 0 0.000000
1976+ 0.001000 0 0.000000
1977+ 1.000000 0 0.000000
1978+ 1000.000000 0 0.000000
1979+ 1000000.00000 0 0.000000
1980+TOO LONG 0 TOO LONG
1981+SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME;
1982+time count total
1983+ 0.000001 0 0.000000
1984+ 0.001000 0 0.000000
1985+ 1.000000 0 0.000000
1986+ 1000.000000 0 0.000000
1987+ 1000000.00000 0 0.000000
1988+TOO LONG 0 TOO LONG
1697+SET GLOBAL QUERY_RESPONSE_TIME_STATS=1;1989+SET GLOBAL QUERY_RESPONSE_TIME_STATS=1;
1698+SET SESSION query_exec_time=0.31;1990+SET SESSION query_exec_time=0.31;
1699+SELECT 1;1991+SELECT 1;
@@ -1790,17 +2082,17 @@
1790+query_response_time_range_base 10002082+query_response_time_range_base 1000
1791+SHOW QUERY_RESPONSE_TIME;2083+SHOW QUERY_RESPONSE_TIME;
1792+ 2084+
1793+ 0.000001 25 0.0000002085+ 0.000001 24 0.000000
1794+ 0.001000 0 0.0000002086+ 0.001000 0 0.000000
1795+ 1.000000 13 4.2500002087+ 1.000000 11 4.050000
1796+ 1000.000000 11 25.6999992088+ 1000.000000 11 25.699999
1797+ 1000000.00000 0 0.0000002089+ 1000000.00000 0 0.000000
1798+TOO LONG 0 TOO LONG2090+TOO LONG 0 TOO LONG
1799+SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME;2091+SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME;
1800+time count total2092+time count total
1801+ 0.000001 25 0.0000002093+ 0.000001 24 0.000000
1802+ 0.001000 0 0.0000002094+ 0.001000 0 0.000000
1803+ 1.000000 14 4.3500002095+ 1.000000 11 4.050000
1804+ 1000.000000 11 25.6999992096+ 1000.000000 11 25.699999
1805+ 1000000.00000 0 0.0000002097+ 1000000.00000 0 0.000000
1806+TOO LONG 0 TOO LONG2098+TOO LONG 0 TOO LONG
@@ -1811,6 +2103,22 @@
1811+Warnings:2103+Warnings:
1812+Warning 1292 Truncated incorrect query_response_time_range_base value: '1001'2104+Warning 1292 Truncated incorrect query_response_time_range_base value: '1001'
1813+FLUSH QUERY_RESPONSE_TIME;2105+FLUSH QUERY_RESPONSE_TIME;
2106+SHOW QUERY_RESPONSE_TIME;
2107+
2108+ 0.000001 0 0.000000
2109+ 0.001000 0 0.000000
2110+ 1.000000 0 0.000000
2111+ 1000.000000 0 0.000000
2112+ 1000000.00000 0 0.000000
2113+TOO LONG 0 TOO LONG
2114+SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME;
2115+time count total
2116+ 0.000001 0 0.000000
2117+ 0.001000 0 0.000000
2118+ 1.000000 0 0.000000
2119+ 1000.000000 0 0.000000
2120+ 1000000.00000 0 0.000000
2121+TOO LONG 0 TOO LONG
1814+SET GLOBAL QUERY_RESPONSE_TIME_STATS=1;2122+SET GLOBAL QUERY_RESPONSE_TIME_STATS=1;
1815+SET SESSION query_exec_time=0.31;2123+SET SESSION query_exec_time=0.31;
1816+SELECT 1;2124+SELECT 1;
@@ -1907,17 +2215,17 @@
1907+query_response_time_range_base 10002215+query_response_time_range_base 1000
1908+SHOW QUERY_RESPONSE_TIME;2216+SHOW QUERY_RESPONSE_TIME;
1909+ 2217+
1910+ 0.000001 25 0.0000002218+ 0.000001 24 0.000000
1911+ 0.001000 0 0.0000002219+ 0.001000 0 0.000000
1912+ 1.000000 13 4.2500002220+ 1.000000 11 4.050000
1913+ 1000.000000 11 25.6999992221+ 1000.000000 11 25.699999
1914+ 1000000.00000 0 0.0000002222+ 1000000.00000 0 0.000000
1915+TOO LONG 0 TOO LONG2223+TOO LONG 0 TOO LONG
1916+SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME;2224+SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME;
1917+time count total2225+time count total
1918+ 0.000001 25 0.0000002226+ 0.000001 24 0.000000
1919+ 0.001000 0 0.0000002227+ 0.001000 0 0.000000
1920+ 1.000000 14 4.3500002228+ 1.000000 11 4.050000
1921+ 1000.000000 11 25.6999992229+ 1000.000000 11 25.699999
1922+ 1000000.00000 0 0.0000002230+ 1000000.00000 0 0.000000
1923+TOO LONG 0 TOO LONG2231+TOO LONG 0 TOO LONG
@@ -1970,7 +2278,7 @@
1970+query_response_time_range_base 22278+query_response_time_range_base 2
1971+SHOW QUERY_RESPONSE_TIME;2279+SHOW QUERY_RESPONSE_TIME;
1972+ 2280+
1973+ 0.000001 46 0.0000002281+ 0.000001 45 0.000000
1974+ 0.000003 0 0.0000002282+ 0.000003 0 0.000000
1975+ 0.000007 0 0.0000002283+ 0.000007 0 0.000000
1976+ 0.000015 0 0.0000002284+ 0.000015 0 0.000000
@@ -1986,7 +2294,7 @@
1986+ 0.015625 0 0.0000002294+ 0.015625 0 0.000000
1987+ 0.031250 0 0.0000002295+ 0.031250 0 0.000000
1988+ 0.062500 0 0.0000002296+ 0.062500 0 0.000000
1989+ 0.125000 46 4.6000002297+ 0.125000 44 4.400000
1990+ 0.250000 0 0.0000002298+ 0.250000 0 0.000000
1991+ 0.500000 10 3.5500002299+ 0.500000 10 3.550000
1992+ 1.000000 1 0.5000002300+ 1.000000 1 0.500000
@@ -2016,7 +2324,7 @@
2016+TOO LONG 0 TOO LONG2324+TOO LONG 0 TOO LONG
2017+SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME;2325+SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME;
2018+time count total2326+time count total
2019+ 0.000001 46 0.0000002327+ 0.000001 45 0.000000
2020+ 0.000003 0 0.0000002328+ 0.000003 0 0.000000
2021+ 0.000007 0 0.0000002329+ 0.000007 0 0.000000
2022+ 0.000015 0 0.0000002330+ 0.000015 0 0.000000
@@ -2032,7 +2340,7 @@
2032+ 0.015625 0 0.0000002340+ 0.015625 0 0.000000
2033+ 0.031250 0 0.0000002341+ 0.031250 0 0.000000
2034+ 0.062500 0 0.0000002342+ 0.062500 0 0.000000
2035+ 0.125000 47 4.7000002343+ 0.125000 44 4.400000
2036+ 0.250000 0 0.0000002344+ 0.250000 0 0.000000
2037+ 0.500000 10 3.5500002345+ 0.500000 10 3.550000
2038+ 1.000000 1 0.5000002346+ 1.000000 1 0.500000
@@ -2094,7 +2402,7 @@
2094+query_response_time_range_base 22402+query_response_time_range_base 2
2095+SHOW QUERY_RESPONSE_TIME;2403+SHOW QUERY_RESPONSE_TIME;
2096+ 2404+
2097+ 0.000001 46 0.0000002405+ 0.000001 45 0.000000
2098+ 0.000003 0 0.0000002406+ 0.000003 0 0.000000
2099+ 0.000007 0 0.0000002407+ 0.000007 0 0.000000
2100+ 0.000015 0 0.0000002408+ 0.000015 0 0.000000
@@ -2110,7 +2418,7 @@
2110+ 0.015625 0 0.0000002418+ 0.015625 0 0.000000
2111+ 0.031250 0 0.0000002419+ 0.031250 0 0.000000
2112+ 0.062500 0 0.0000002420+ 0.062500 0 0.000000
2113+ 0.125000 46 4.6000002421+ 0.125000 44 4.400000
2114+ 0.250000 0 0.0000002422+ 0.250000 0 0.000000
2115+ 0.500000 10 3.5500002423+ 0.500000 10 3.550000
2116+ 1.000000 1 0.5000002424+ 1.000000 1 0.500000
@@ -2140,7 +2448,7 @@
2140+TOO LONG 0 TOO LONG2448+TOO LONG 0 TOO LONG
2141+SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME;2449+SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME;
2142+time count total2450+time count total
2143+ 0.000001 46 0.0000002451+ 0.000001 45 0.000000
2144+ 0.000003 0 0.0000002452+ 0.000003 0 0.000000
2145+ 0.000007 0 0.0000002453+ 0.000007 0 0.000000
2146+ 0.000015 0 0.0000002454+ 0.000015 0 0.000000
@@ -2156,7 +2464,7 @@
2156+ 0.015625 0 0.0000002464+ 0.015625 0 0.000000
2157+ 0.031250 0 0.0000002465+ 0.031250 0 0.000000
2158+ 0.062500 0 0.0000002466+ 0.062500 0 0.000000
2159+ 0.125000 47 4.7000002467+ 0.125000 44 4.400000
2160+ 0.250000 0 0.0000002468+ 0.250000 0 0.000000
2161+ 0.500000 10 3.5500002469+ 0.500000 10 3.550000
2162+ 1.000000 1 0.5000002470+ 1.000000 1 0.500000
@@ -2218,13 +2526,13 @@
2218+query_response_time_range_base 102526+query_response_time_range_base 10
2219+SHOW QUERY_RESPONSE_TIME;2527+SHOW QUERY_RESPONSE_TIME;
2220+ 2528+
2221+ 0.000001 46 0.0000002529+ 0.000001 45 0.000000
2222+ 0.000010 0 0.0000002530+ 0.000010 0 0.000000
2223+ 0.000100 0 0.0000002531+ 0.000100 0 0.000000
2224+ 0.001000 0 0.0000002532+ 0.001000 0 0.000000
2225+ 0.010000 0 0.0000002533+ 0.010000 0 0.000000
2226+ 0.100000 0 0.0000002534+ 0.100000 0 0.000000
2227+ 1.000000 57 8.6500002535+ 1.000000 55 8.450000
2228+ 10.000000 11 25.6999992536+ 10.000000 11 25.699999
2229+ 100.000000 0 0.0000002537+ 100.000000 0 0.000000
2230+ 1000.000000 0 0.0000002538+ 1000.000000 0 0.000000
@@ -2234,13 +2542,13 @@
2234+TOO LONG 0 TOO LONG2542+TOO LONG 0 TOO LONG
2235+SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME;2543+SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME;
2236+time count total2544+time count total
2237+ 0.000001 46 0.0000002545+ 0.000001 45 0.000000
2238+ 0.000010 0 0.0000002546+ 0.000010 0 0.000000
2239+ 0.000100 0 0.0000002547+ 0.000100 0 0.000000
2240+ 0.001000 0 0.0000002548+ 0.001000 0 0.000000
2241+ 0.010000 0 0.0000002549+ 0.010000 0 0.000000
2242+ 0.100000 0 0.0000002550+ 0.100000 0 0.000000
2243+ 1.000000 58 8.7500002551+ 1.000000 55 8.450000
2244+ 10.000000 11 25.6999992552+ 10.000000 11 25.699999
2245+ 100.000000 0 0.0000002553+ 100.000000 0 0.000000
2246+ 1000.000000 0 0.0000002554+ 1000.000000 0 0.000000
@@ -2282,13 +2590,13 @@
2282+query_response_time_range_base 72590+query_response_time_range_base 7
2283+SHOW QUERY_RESPONSE_TIME;2591+SHOW QUERY_RESPONSE_TIME;
2284+ 2592+
2285+ 0.000001 46 0.0000002593+ 0.000001 45 0.000000
2286+ 0.000008 0 0.0000002594+ 0.000008 0 0.000000
2287+ 0.000059 0 0.0000002595+ 0.000059 0 0.000000
2288+ 0.000416 0 0.0000002596+ 0.000416 0 0.000000
2289+ 0.002915 0 0.0000002597+ 0.002915 0 0.000000
2290+ 0.020408 0 0.0000002598+ 0.020408 0 0.000000
2291+ 0.142857 46 4.6000002599+ 0.142857 44 4.400000
2292+ 1.000000 11 4.0500002600+ 1.000000 11 4.050000
2293+ 7.000000 11 25.6999992601+ 7.000000 11 25.699999
2294+ 49.000000 0 0.0000002602+ 49.000000 0 0.000000
@@ -2301,13 +2609,13 @@
2301+TOO LONG 0 TOO LONG2609+TOO LONG 0 TOO LONG
2302+SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME;2610+SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME;
2303+time count total2611+time count total
2304+ 0.000001 46 0.0000002612+ 0.000001 45 0.000000
2305+ 0.000008 0 0.0000002613+ 0.000008 0 0.000000
2306+ 0.000059 0 0.0000002614+ 0.000059 0 0.000000
2307+ 0.000416 0 0.0000002615+ 0.000416 0 0.000000
2308+ 0.002915 0 0.0000002616+ 0.002915 0 0.000000
2309+ 0.020408 0 0.0000002617+ 0.020408 0 0.000000
2310+ 0.142857 47 4.7000002618+ 0.142857 44 4.400000
2311+ 1.000000 11 4.0500002619+ 1.000000 11 4.050000
2312+ 7.000000 11 25.6999992620+ 7.000000 11 25.699999
2313+ 49.000000 0 0.0000002621+ 49.000000 0 0.000000
@@ -2352,18 +2660,18 @@
2352+query_response_time_range_base 1562660+query_response_time_range_base 156
2353+SHOW QUERY_RESPONSE_TIME;2661+SHOW QUERY_RESPONSE_TIME;
2354+ 2662+
2355+ 0.000041 46 0.0000002663+ 0.000041 45 0.000000
2356+ 0.006410 0 0.0000002664+ 0.006410 0 0.000000
2357+ 1.000000 57 8.6500002665+ 1.000000 55 8.450000
2358+ 156.000000 11 25.6999992666+ 156.000000 11 25.699999
2359+ 24336.000000 0 0.0000002667+ 24336.000000 0 0.000000
2360+ 3796416.00000 0 0.0000002668+ 3796416.00000 0 0.000000
2361+TOO LONG 0 TOO LONG2669+TOO LONG 0 TOO LONG
2362+SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME;2670+SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME;
2363+time count total2671+time count total
2364+ 0.000041 46 0.0000002672+ 0.000041 45 0.000000
2365+ 0.006410 0 0.0000002673+ 0.006410 0 0.000000
2366+ 1.000000 58 8.7500002674+ 1.000000 55 8.450000
2367+ 156.000000 11 25.6999992675+ 156.000000 11 25.699999
2368+ 24336.000000 0 0.0000002676+ 24336.000000 0 0.000000
2369+ 3796416.00000 0 0.0000002677+ 3796416.00000 0 0.000000
@@ -2402,17 +2710,17 @@
2402+query_response_time_range_base 10002710+query_response_time_range_base 1000
2403+SHOW QUERY_RESPONSE_TIME;2711+SHOW QUERY_RESPONSE_TIME;
2404+ 2712+
2405+ 0.000001 46 0.0000002713+ 0.000001 45 0.000000
2406+ 0.001000 0 0.0000002714+ 0.001000 0 0.000000
2407+ 1.000000 57 8.6500002715+ 1.000000 55 8.450000
2408+ 1000.000000 11 25.6999992716+ 1000.000000 11 25.699999
2409+ 1000000.00000 0 0.0000002717+ 1000000.00000 0 0.000000
2410+TOO LONG 0 TOO LONG2718+TOO LONG 0 TOO LONG
2411+SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME;2719+SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME;
2412+time count total2720+time count total
2413+ 0.000001 46 0.0000002721+ 0.000001 45 0.000000
2414+ 0.001000 0 0.0000002722+ 0.001000 0 0.000000
2415+ 1.000000 58 8.7500002723+ 1.000000 55 8.450000
2416+ 1000.000000 11 25.6999992724+ 1000.000000 11 25.699999
2417+ 1000000.00000 0 0.0000002725+ 1000000.00000 0 0.000000
2418+TOO LONG 0 TOO LONG2726+TOO LONG 0 TOO LONG
@@ -2452,17 +2760,17 @@
2452+query_response_time_range_base 10002760+query_response_time_range_base 1000
2453+SHOW QUERY_RESPONSE_TIME;2761+SHOW QUERY_RESPONSE_TIME;
2454+ 2762+
2455+ 0.000001 46 0.0000002763+ 0.000001 45 0.000000
2456+ 0.001000 0 0.0000002764+ 0.001000 0 0.000000
2457+ 1.000000 57 8.6500002765+ 1.000000 55 8.450000
2458+ 1000.000000 11 25.6999992766+ 1000.000000 11 25.699999
2459+ 1000000.00000 0 0.0000002767+ 1000000.00000 0 0.000000
2460+TOO LONG 0 TOO LONG2768+TOO LONG 0 TOO LONG
2461+SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME;2769+SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME;
2462+time count total2770+time count total
2463+ 0.000001 46 0.0000002771+ 0.000001 45 0.000000
2464+ 0.001000 0 0.0000002772+ 0.001000 0 0.000000
2465+ 1.000000 58 8.7500002773+ 1.000000 55 8.450000
2466+ 1000.000000 11 25.6999992774+ 1000.000000 11 25.699999
2467+ 1000000.00000 0 0.0000002775+ 1000000.00000 0 0.000000
2468+TOO LONG 0 TOO LONG2776+TOO LONG 0 TOO LONG
@@ -3099,17 +3407,20 @@
3099 #include "transaction.h"3407 #include "transaction.h"
3100 #include "sql_audit.h"3408 #include "sql_audit.h"
3101 #include "sql_prepare.h"3409 #include "sql_prepare.h"
3102@@ -1507,6 +1508,9 @@3410@@ -1507,6 +1508,12 @@
3103 3411
3104 ulonglong end_utime_of_query= thd->current_utime();3412 ulonglong end_utime_of_query= thd->current_utime();
3105 ulonglong query_exec_time= get_query_exec_time(thd, end_utime_of_query);3413 ulonglong query_exec_time= get_query_exec_time(thd, end_utime_of_query);
3106+#ifdef HAVE_RESPONSE_TIME_DISTRIBUTION3414+#ifdef HAVE_RESPONSE_TIME_DISTRIBUTION
3107+ query_response_time_collect(query_exec_time);3415+ if (opt_query_response_time_stats)
3416+ {
3417+ query_response_time_collect(query_exec_time);
3418+ }
3108+#endif3419+#endif
3109 3420
3110 /*3421 /*
3111 Low long_query_time value most likely means user is debugging stuff and even3422 Low long_query_time value most likely means user is debugging stuff and even
3112@@ -1671,6 +1675,7 @@3423@@ -1671,6 +1678,7 @@
3113 case SCH_CHARSETS:3424 case SCH_CHARSETS:
3114 case SCH_ENGINES:3425 case SCH_ENGINES:
3115 case SCH_COLLATIONS:3426 case SCH_COLLATIONS:

Subscribers

People subscribed via source and target branches