SET GLOBAL query_exec_time=0.1;
include/master-slave.inc
[connection master]
CREATE TABLE t(id INT);
SET GLOBAL query_exec_time = 0.1;
include/restart_slave.inc
SET SESSION query_exec_time=0.1;
SET GLOBAL QUERY_RESPONSE_TIME_STATS=0;
SET GLOBAL QUERY_RESPONSE_TIME_RANGE_BASE=1;
Warnings:
Warning	1292	Truncated incorrect query_response_time_range_base value: '1'
FLUSH QUERY_RESPONSE_TIME;
SET GLOBAL QUERY_RESPONSE_TIME_STATS=1;
SET SESSION query_exec_time = 0.31;
INSERT INTO t VALUES(1);
SET SESSION query_exec_time = 0.32;
INSERT INTO t VALUES(1);
SET SESSION query_exec_time = 0.33;
INSERT INTO t VALUES(1);
SET SESSION query_exec_time = 0.34;
INSERT INTO t VALUES(1);
SET SESSION query_exec_time = 0.35;
INSERT INTO t VALUES(1);
SET SESSION query_exec_time = 0.36;
INSERT INTO t VALUES(1);
SET SESSION query_exec_time = 0.37;
INSERT INTO t VALUES(1);
SET SESSION query_exec_time = 0.38;
INSERT INTO t VALUES(1);
SET SESSION query_exec_time = 0.39;
INSERT INTO t VALUES(1);
SET SESSION query_exec_time = 0.4;
INSERT INTO t VALUES(1);
SET SESSION query_exec_time = 1.1;
INSERT INTO t VALUES(1);
SET SESSION query_exec_time = 1.2;
INSERT INTO t VALUES(1);
SET SESSION query_exec_time = 1.3;
INSERT INTO t VALUES(1);
SET SESSION query_exec_time = 1.5;
INSERT INTO t VALUES(1);
SET SESSION query_exec_time = 1.4;
INSERT INTO t VALUES(1);
SET SESSION query_exec_time = 0.5;
INSERT INTO t VALUES(1);
SET SESSION query_exec_time = 2.1;
INSERT INTO t VALUES(1);
SET SESSION query_exec_time = 2.3;
INSERT INTO t VALUES(1);
SET SESSION query_exec_time = 2.5;
INSERT INTO t VALUES(1);
SET SESSION query_exec_time = 3.1;
INSERT INTO t VALUES(1);
SET SESSION query_exec_time = 4.1;
INSERT INTO t VALUES(1);
SET SESSION query_exec_time = 5.1;
INSERT INTO t VALUES(1);
SET GLOBAL QUERY_RESPONSE_TIME_STATS=0;
SHOW GLOBAL VARIABLES where Variable_name like 'QUERY_RESPONSE_TIME_RANGE_BASE';
Variable_name	Value
query_response_time_range_base	2
SHOW QUERY_RESPONSE_TIME;
		
      0.000001	1	      0.000000
      0.000003	0	      0.000000
      0.000007	0	      0.000000
      0.000015	0	      0.000000
      0.000030	0	      0.000000
      0.000061	0	      0.000000
      0.000122	0	      0.000000
      0.000244	0	      0.000000
      0.000488	0	      0.000000
      0.000976	0	      0.000000
      0.001953	0	      0.000000
      0.003906	0	      0.000000
      0.007812	0	      0.000000
      0.015625	0	      0.000000
      0.031250	0	      0.000000
      0.062500	0	      0.000000
      0.125000	1	      0.100000
      0.250000	0	      0.000000
      0.500000	30	     10.650000
      1.000000	3	      1.500000
      2.000000	15	     19.500000
      4.000000	12	     30.000000
      8.000000	6	     27.599997
     16.000000	0	      0.000000
     32.000000	0	      0.000000
     64.000000	0	      0.000000
    128.000000	0	      0.000000
    256.000000	0	      0.000000
    512.000000	0	      0.000000
   1024.000000	0	      0.000000
   2048.000000	0	      0.000000
   4096.000000	0	      0.000000
   8192.000000	0	      0.000000
  16384.000000	0	      0.000000
  32768.000000	0	      0.000000
  65536.000000	0	      0.000000
 131072.000000	0	      0.000000
 262144.000000	0	      0.000000
 524288.000000	0	      0.000000
 1048576.00000	0	      0.000000
 2097152.00000	0	      0.000000
 4194304.00000	0	      0.000000
 8388608.00000	0	      0.000000
TOO LONG	0	TOO LONG
SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME;
time	count	total
      0.000001	1	      0.000000
      0.000003	0	      0.000000
      0.000007	0	      0.000000
      0.000015	0	      0.000000
      0.000030	0	      0.000000
      0.000061	0	      0.000000
      0.000122	0	      0.000000
      0.000244	0	      0.000000
      0.000488	0	      0.000000
      0.000976	0	      0.000000
      0.001953	0	      0.000000
      0.003906	0	      0.000000
      0.007812	0	      0.000000
      0.015625	0	      0.000000
      0.031250	0	      0.000000
      0.062500	0	      0.000000
      0.125000	1	      0.100000
      0.250000	0	      0.000000
      0.500000	30	     10.650000
      1.000000	3	      1.500000
      2.000000	15	     19.500000
      4.000000	12	     30.000000
      8.000000	6	     27.599997
     16.000000	0	      0.000000
     32.000000	0	      0.000000
     64.000000	0	      0.000000
    128.000000	0	      0.000000
    256.000000	0	      0.000000
    512.000000	0	      0.000000
   1024.000000	0	      0.000000
   2048.000000	0	      0.000000
   4096.000000	0	      0.000000
   8192.000000	0	      0.000000
  16384.000000	0	      0.000000
  32768.000000	0	      0.000000
  65536.000000	0	      0.000000
 131072.000000	0	      0.000000
 262144.000000	0	      0.000000
 524288.000000	0	      0.000000
 1048576.00000	0	      0.000000
 2097152.00000	0	      0.000000
 4194304.00000	0	      0.000000
 8388608.00000	0	      0.000000
TOO LONG	0	TOO LONG
SET GLOBAL QUERY_RESPONSE_TIME_RANGE_BASE=default;
SET GLOBAL QUERY_RESPONSE_TIME_STATS=default;
DROP TABLE t;
CREATE TABLE t(id INT);
SET GLOBAL query_exec_time = 0.1;
include/restart_slave.inc
SET SESSION query_exec_time=0.1;
SET GLOBAL QUERY_RESPONSE_TIME_STATS=0;
SET GLOBAL QUERY_RESPONSE_TIME_RANGE_BASE=2;
FLUSH QUERY_RESPONSE_TIME;
SET GLOBAL QUERY_RESPONSE_TIME_STATS=1;
SET SESSION query_exec_time = 0.31;
INSERT INTO t VALUES(1);
SET SESSION query_exec_time = 0.32;
INSERT INTO t VALUES(1);
SET SESSION query_exec_time = 0.33;
INSERT INTO t VALUES(1);
SET SESSION query_exec_time = 0.34;
INSERT INTO t VALUES(1);
SET SESSION query_exec_time = 0.35;
INSERT INTO t VALUES(1);
SET SESSION query_exec_time = 0.36;
INSERT INTO t VALUES(1);
SET SESSION query_exec_time = 0.37;
INSERT INTO t VALUES(1);
SET SESSION query_exec_time = 0.38;
INSERT INTO t VALUES(1);
SET SESSION query_exec_time = 0.39;
INSERT INTO t VALUES(1);
SET SESSION query_exec_time = 0.4;
INSERT INTO t VALUES(1);
SET SESSION query_exec_time = 1.1;
INSERT INTO t VALUES(1);
SET SESSION query_exec_time = 1.2;
INSERT INTO t VALUES(1);
SET SESSION query_exec_time = 1.3;
INSERT INTO t VALUES(1);
SET SESSION query_exec_time = 1.5;
INSERT INTO t VALUES(1);
SET SESSION query_exec_time = 1.4;
INSERT INTO t VALUES(1);
SET SESSION query_exec_time = 0.5;
INSERT INTO t VALUES(1);
SET SESSION query_exec_time = 2.1;
INSERT INTO t VALUES(1);
SET SESSION query_exec_time = 2.3;
INSERT INTO t VALUES(1);
SET SESSION query_exec_time = 2.5;
INSERT INTO t VALUES(1);
SET SESSION query_exec_time = 3.1;
INSERT INTO t VALUES(1);
SET SESSION query_exec_time = 4.1;
INSERT INTO t VALUES(1);
SET SESSION query_exec_time = 5.1;
INSERT INTO t VALUES(1);
SET GLOBAL QUERY_RESPONSE_TIME_STATS=0;
SHOW GLOBAL VARIABLES where Variable_name like 'QUERY_RESPONSE_TIME_RANGE_BASE';
Variable_name	Value
query_response_time_range_base	2
SHOW QUERY_RESPONSE_TIME;
		
      0.000001	1	      0.000000
      0.000003	0	      0.000000
      0.000007	0	      0.000000
      0.000015	0	      0.000000
      0.000030	0	      0.000000
      0.000061	0	      0.000000
      0.000122	0	      0.000000
      0.000244	0	      0.000000
      0.000488	0	      0.000000
      0.000976	0	      0.000000
      0.001953	0	      0.000000
      0.003906	0	      0.000000
      0.007812	0	      0.000000
      0.015625	0	      0.000000
      0.031250	0	      0.000000
      0.062500	0	      0.000000
      0.125000	1	      0.100000
      0.250000	0	      0.000000
      0.500000	30	     10.650000
      1.000000	3	      1.500000
      2.000000	15	     19.500000
      4.000000	12	     30.000000
      8.000000	6	     27.599997
     16.000000	0	      0.000000
     32.000000	0	      0.000000
     64.000000	0	      0.000000
    128.000000	0	      0.000000
    256.000000	0	      0.000000
    512.000000	0	      0.000000
   1024.000000	0	      0.000000
   2048.000000	0	      0.000000
   4096.000000	0	      0.000000
   8192.000000	0	      0.000000
  16384.000000	0	      0.000000
  32768.000000	0	      0.000000
  65536.000000	0	      0.000000
 131072.000000	0	      0.000000
 262144.000000	0	      0.000000
 524288.000000	0	      0.000000
 1048576.00000	0	      0.000000
 2097152.00000	0	      0.000000
 4194304.00000	0	      0.000000
 8388608.00000	0	      0.000000
TOO LONG	0	TOO LONG
SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME;
time	count	total
      0.000001	1	      0.000000
      0.000003	0	      0.000000
      0.000007	0	      0.000000
      0.000015	0	      0.000000
      0.000030	0	      0.000000
      0.000061	0	      0.000000
      0.000122	0	      0.000000
      0.000244	0	      0.000000
      0.000488	0	      0.000000
      0.000976	0	      0.000000
      0.001953	0	      0.000000
      0.003906	0	      0.000000
      0.007812	0	      0.000000
      0.015625	0	      0.000000
      0.031250	0	      0.000000
      0.062500	0	      0.000000
      0.125000	1	      0.100000
      0.250000	0	      0.000000
      0.500000	30	     10.650000
      1.000000	3	      1.500000
      2.000000	15	     19.500000
      4.000000	12	     30.000000
      8.000000	6	     27.599997
     16.000000	0	      0.000000
     32.000000	0	      0.000000
     64.000000	0	      0.000000
    128.000000	0	      0.000000
    256.000000	0	      0.000000
    512.000000	0	      0.000000
   1024.000000	0	      0.000000
   2048.000000	0	      0.000000
   4096.000000	0	      0.000000
   8192.000000	0	      0.000000
  16384.000000	0	      0.000000
  32768.000000	0	      0.000000
  65536.000000	0	      0.000000
 131072.000000	0	      0.000000
 262144.000000	0	      0.000000
 524288.000000	0	      0.000000
 1048576.00000	0	      0.000000
 2097152.00000	0	      0.000000
 4194304.00000	0	      0.000000
 8388608.00000	0	      0.000000
TOO LONG	0	TOO LONG
SET GLOBAL QUERY_RESPONSE_TIME_RANGE_BASE=default;
SET GLOBAL QUERY_RESPONSE_TIME_STATS=default;
DROP TABLE t;
CREATE TABLE t(id INT);
SET GLOBAL query_exec_time = 0.1;
include/restart_slave.inc
SET SESSION query_exec_time=0.1;
SET GLOBAL QUERY_RESPONSE_TIME_STATS=0;
SET GLOBAL QUERY_RESPONSE_TIME_RANGE_BASE=10;
FLUSH QUERY_RESPONSE_TIME;
SET GLOBAL QUERY_RESPONSE_TIME_STATS=1;
SET SESSION query_exec_time = 0.31;
INSERT INTO t VALUES(1);
SET SESSION query_exec_time = 0.32;
INSERT INTO t VALUES(1);
SET SESSION query_exec_time = 0.33;
INSERT INTO t VALUES(1);
SET SESSION query_exec_time = 0.34;
INSERT INTO t VALUES(1);
SET SESSION query_exec_time = 0.35;
INSERT INTO t VALUES(1);
SET SESSION query_exec_time = 0.36;
INSERT INTO t VALUES(1);
SET SESSION query_exec_time = 0.37;
INSERT INTO t VALUES(1);
SET SESSION query_exec_time = 0.38;
INSERT INTO t VALUES(1);
SET SESSION query_exec_time = 0.39;
INSERT INTO t VALUES(1);
SET SESSION query_exec_time = 0.4;
INSERT INTO t VALUES(1);
SET SESSION query_exec_time = 1.1;
INSERT INTO t VALUES(1);
SET SESSION query_exec_time = 1.2;
INSERT INTO t VALUES(1);
SET SESSION query_exec_time = 1.3;
INSERT INTO t VALUES(1);
SET SESSION query_exec_time = 1.5;
INSERT INTO t VALUES(1);
SET SESSION query_exec_time = 1.4;
INSERT INTO t VALUES(1);
SET SESSION query_exec_time = 0.5;
INSERT INTO t VALUES(1);
SET SESSION query_exec_time = 2.1;
INSERT INTO t VALUES(1);
SET SESSION query_exec_time = 2.3;
INSERT INTO t VALUES(1);
SET SESSION query_exec_time = 2.5;
INSERT INTO t VALUES(1);
SET SESSION query_exec_time = 3.1;
INSERT INTO t VALUES(1);
SET SESSION query_exec_time = 4.1;
INSERT INTO t VALUES(1);
SET SESSION query_exec_time = 5.1;
INSERT INTO t VALUES(1);
SET GLOBAL QUERY_RESPONSE_TIME_STATS=0;
SHOW GLOBAL VARIABLES where Variable_name like 'QUERY_RESPONSE_TIME_RANGE_BASE';
Variable_name	Value
query_response_time_range_base	10
SHOW QUERY_RESPONSE_TIME;
		
      0.000001	1	      0.000000
      0.000010	0	      0.000000
      0.000100	0	      0.000000
      0.001000	0	      0.000000
      0.010000	0	      0.000000
      0.100000	0	      0.000000
      1.000000	34	     12.250000
     10.000000	33	     77.099997
    100.000000	0	      0.000000
   1000.000000	0	      0.000000
  10000.000000	0	      0.000000
 100000.000000	0	      0.000000
 1000000.00000	0	      0.000000
TOO LONG	0	TOO LONG
SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME;
time	count	total
      0.000001	1	      0.000000
      0.000010	0	      0.000000
      0.000100	0	      0.000000
      0.001000	0	      0.000000
      0.010000	0	      0.000000
      0.100000	0	      0.000000
      1.000000	34	     12.250000
     10.000000	33	     77.099997
    100.000000	0	      0.000000
   1000.000000	0	      0.000000
  10000.000000	0	      0.000000
 100000.000000	0	      0.000000
 1000000.00000	0	      0.000000
TOO LONG	0	TOO LONG
SET GLOBAL QUERY_RESPONSE_TIME_RANGE_BASE=default;
SET GLOBAL QUERY_RESPONSE_TIME_STATS=default;
DROP TABLE t;
CREATE TABLE t(id INT);
SET GLOBAL query_exec_time = 0.1;
include/restart_slave.inc
SET SESSION query_exec_time=0.1;
SET GLOBAL QUERY_RESPONSE_TIME_STATS=0;
SET GLOBAL QUERY_RESPONSE_TIME_RANGE_BASE=7;
FLUSH QUERY_RESPONSE_TIME;
SET GLOBAL QUERY_RESPONSE_TIME_STATS=1;
SET SESSION query_exec_time = 0.31;
INSERT INTO t VALUES(1);
SET SESSION query_exec_time = 0.32;
INSERT INTO t VALUES(1);
SET SESSION query_exec_time = 0.33;
INSERT INTO t VALUES(1);
SET SESSION query_exec_time = 0.34;
INSERT INTO t VALUES(1);
SET SESSION query_exec_time = 0.35;
INSERT INTO t VALUES(1);
SET SESSION query_exec_time = 0.36;
INSERT INTO t VALUES(1);
SET SESSION query_exec_time = 0.37;
INSERT INTO t VALUES(1);
SET SESSION query_exec_time = 0.38;
INSERT INTO t VALUES(1);
SET SESSION query_exec_time = 0.39;
INSERT INTO t VALUES(1);
SET SESSION query_exec_time = 0.4;
INSERT INTO t VALUES(1);
SET SESSION query_exec_time = 1.1;
INSERT INTO t VALUES(1);
SET SESSION query_exec_time = 1.2;
INSERT INTO t VALUES(1);
SET SESSION query_exec_time = 1.3;
INSERT INTO t VALUES(1);
SET SESSION query_exec_time = 1.5;
INSERT INTO t VALUES(1);
SET SESSION query_exec_time = 1.4;
INSERT INTO t VALUES(1);
SET SESSION query_exec_time = 0.5;
INSERT INTO t VALUES(1);
SET SESSION query_exec_time = 2.1;
INSERT INTO t VALUES(1);
SET SESSION query_exec_time = 2.3;
INSERT INTO t VALUES(1);
SET SESSION query_exec_time = 2.5;
INSERT INTO t VALUES(1);
SET SESSION query_exec_time = 3.1;
INSERT INTO t VALUES(1);
SET SESSION query_exec_time = 4.1;
INSERT INTO t VALUES(1);
SET SESSION query_exec_time = 5.1;
INSERT INTO t VALUES(1);
SET GLOBAL QUERY_RESPONSE_TIME_STATS=0;
SHOW GLOBAL VARIABLES where Variable_name like 'QUERY_RESPONSE_TIME_RANGE_BASE';
Variable_name	Value
query_response_time_range_base	7
SHOW QUERY_RESPONSE_TIME;
		
      0.000001	1	      0.000000
      0.000008	0	      0.000000
      0.000059	0	      0.000000
      0.000416	0	      0.000000
      0.002915	0	      0.000000
      0.020408	0	      0.000000
      0.142857	1	      0.100000
      1.000000	33	     12.150000
      7.000000	33	     77.099997
     49.000000	0	      0.000000
    343.000000	0	      0.000000
   2401.000000	0	      0.000000
  16807.000000	0	      0.000000
 117649.000000	0	      0.000000
 823543.000000	0	      0.000000
 5764801.00000	0	      0.000000
TOO LONG	0	TOO LONG
SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME;
time	count	total
      0.000001	1	      0.000000
      0.000008	0	      0.000000
      0.000059	0	      0.000000
      0.000416	0	      0.000000
      0.002915	0	      0.000000
      0.020408	0	      0.000000
      0.142857	1	      0.100000
      1.000000	33	     12.150000
      7.000000	33	     77.099997
     49.000000	0	      0.000000
    343.000000	0	      0.000000
   2401.000000	0	      0.000000
  16807.000000	0	      0.000000
 117649.000000	0	      0.000000
 823543.000000	0	      0.000000
 5764801.00000	0	      0.000000
TOO LONG	0	TOO LONG
SET GLOBAL QUERY_RESPONSE_TIME_RANGE_BASE=default;
SET GLOBAL QUERY_RESPONSE_TIME_STATS=default;
DROP TABLE t;
CREATE TABLE t(id INT);
SET GLOBAL query_exec_time = 0.1;
include/restart_slave.inc
SET SESSION query_exec_time=0.1;
SET GLOBAL QUERY_RESPONSE_TIME_STATS=0;
SET GLOBAL QUERY_RESPONSE_TIME_RANGE_BASE=156;
FLUSH QUERY_RESPONSE_TIME;
SET GLOBAL QUERY_RESPONSE_TIME_STATS=1;
SET SESSION query_exec_time = 0.31;
INSERT INTO t VALUES(1);
SET SESSION query_exec_time = 0.32;
INSERT INTO t VALUES(1);
SET SESSION query_exec_time = 0.33;
INSERT INTO t VALUES(1);
SET SESSION query_exec_time = 0.34;
INSERT INTO t VALUES(1);
SET SESSION query_exec_time = 0.35;
INSERT INTO t VALUES(1);
SET SESSION query_exec_time = 0.36;
INSERT INTO t VALUES(1);
SET SESSION query_exec_time = 0.37;
INSERT INTO t VALUES(1);
SET SESSION query_exec_time = 0.38;
INSERT INTO t VALUES(1);
SET SESSION query_exec_time = 0.39;
INSERT INTO t VALUES(1);
SET SESSION query_exec_time = 0.4;
INSERT INTO t VALUES(1);
SET SESSION query_exec_time = 1.1;
INSERT INTO t VALUES(1);
SET SESSION query_exec_time = 1.2;
INSERT INTO t VALUES(1);
SET SESSION query_exec_time = 1.3;
INSERT INTO t VALUES(1);
SET SESSION query_exec_time = 1.5;
INSERT INTO t VALUES(1);
SET SESSION query_exec_time = 1.4;
INSERT INTO t VALUES(1);
SET SESSION query_exec_time = 0.5;
INSERT INTO t VALUES(1);
SET SESSION query_exec_time = 2.1;
INSERT INTO t VALUES(1);
SET SESSION query_exec_time = 2.3;
INSERT INTO t VALUES(1);
SET SESSION query_exec_time = 2.5;
INSERT INTO t VALUES(1);
SET SESSION query_exec_time = 3.1;
INSERT INTO t VALUES(1);
SET SESSION query_exec_time = 4.1;
INSERT INTO t VALUES(1);
SET SESSION query_exec_time = 5.1;
INSERT INTO t VALUES(1);
SET GLOBAL QUERY_RESPONSE_TIME_STATS=0;
SHOW GLOBAL VARIABLES where Variable_name like 'QUERY_RESPONSE_TIME_RANGE_BASE';
Variable_name	Value
query_response_time_range_base	156
SHOW QUERY_RESPONSE_TIME;
		
      0.000041	1	      0.000000
      0.006410	0	      0.000000
      1.000000	34	     12.250000
    156.000000	33	     77.099997
  24336.000000	0	      0.000000
 3796416.00000	0	      0.000000
TOO LONG	0	TOO LONG
SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME;
time	count	total
      0.000041	1	      0.000000
      0.006410	0	      0.000000
      1.000000	34	     12.250000
    156.000000	33	     77.099997
  24336.000000	0	      0.000000
 3796416.00000	0	      0.000000
TOO LONG	0	TOO LONG
SET GLOBAL QUERY_RESPONSE_TIME_RANGE_BASE=default;
SET GLOBAL QUERY_RESPONSE_TIME_STATS=default;
DROP TABLE t;
CREATE TABLE t(id INT);
SET GLOBAL query_exec_time = 0.1;
include/restart_slave.inc
SET SESSION query_exec_time=0.1;
SET GLOBAL QUERY_RESPONSE_TIME_STATS=0;
SET GLOBAL QUERY_RESPONSE_TIME_RANGE_BASE=1000;
FLUSH QUERY_RESPONSE_TIME;
SET GLOBAL QUERY_RESPONSE_TIME_STATS=1;
SET SESSION query_exec_time = 0.31;
INSERT INTO t VALUES(1);
SET SESSION query_exec_time = 0.32;
INSERT INTO t VALUES(1);
SET SESSION query_exec_time = 0.33;
INSERT INTO t VALUES(1);
SET SESSION query_exec_time = 0.34;
INSERT INTO t VALUES(1);
SET SESSION query_exec_time = 0.35;
INSERT INTO t VALUES(1);
SET SESSION query_exec_time = 0.36;
INSERT INTO t VALUES(1);
SET SESSION query_exec_time = 0.37;
INSERT INTO t VALUES(1);
SET SESSION query_exec_time = 0.38;
INSERT INTO t VALUES(1);
SET SESSION query_exec_time = 0.39;
INSERT INTO t VALUES(1);
SET SESSION query_exec_time = 0.4;
INSERT INTO t VALUES(1);
SET SESSION query_exec_time = 1.1;
INSERT INTO t VALUES(1);
SET SESSION query_exec_time = 1.2;
INSERT INTO t VALUES(1);
SET SESSION query_exec_time = 1.3;
INSERT INTO t VALUES(1);
SET SESSION query_exec_time = 1.5;
INSERT INTO t VALUES(1);
SET SESSION query_exec_time = 1.4;
INSERT INTO t VALUES(1);
SET SESSION query_exec_time = 0.5;
INSERT INTO t VALUES(1);
SET SESSION query_exec_time = 2.1;
INSERT INTO t VALUES(1);
SET SESSION query_exec_time = 2.3;
INSERT INTO t VALUES(1);
SET SESSION query_exec_time = 2.5;
INSERT INTO t VALUES(1);
SET SESSION query_exec_time = 3.1;
INSERT INTO t VALUES(1);
SET SESSION query_exec_time = 4.1;
INSERT INTO t VALUES(1);
SET SESSION query_exec_time = 5.1;
INSERT INTO t VALUES(1);
SET GLOBAL QUERY_RESPONSE_TIME_STATS=0;
SHOW GLOBAL VARIABLES where Variable_name like 'QUERY_RESPONSE_TIME_RANGE_BASE';
Variable_name	Value
query_response_time_range_base	1000
SHOW QUERY_RESPONSE_TIME;
		
      0.000001	1	      0.000000
      0.001000	0	      0.000000
      1.000000	34	     12.250000
   1000.000000	33	     77.099997
 1000000.00000	0	      0.000000
TOO LONG	0	TOO LONG
SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME;
time	count	total
      0.000001	1	      0.000000
      0.001000	0	      0.000000
      1.000000	34	     12.250000
   1000.000000	33	     77.099997
 1000000.00000	0	      0.000000
TOO LONG	0	TOO LONG
SET GLOBAL QUERY_RESPONSE_TIME_RANGE_BASE=default;
SET GLOBAL QUERY_RESPONSE_TIME_STATS=default;
DROP TABLE t;
CREATE TABLE t(id INT);
SET GLOBAL query_exec_time = 0.1;
include/restart_slave.inc
SET SESSION query_exec_time=0.1;
SET GLOBAL QUERY_RESPONSE_TIME_STATS=0;
SET GLOBAL QUERY_RESPONSE_TIME_RANGE_BASE=1001;
Warnings:
Warning	1292	Truncated incorrect query_response_time_range_base value: '1001'
FLUSH QUERY_RESPONSE_TIME;
SET GLOBAL QUERY_RESPONSE_TIME_STATS=1;
SET SESSION query_exec_time = 0.31;
INSERT INTO t VALUES(1);
SET SESSION query_exec_time = 0.32;
INSERT INTO t VALUES(1);
SET SESSION query_exec_time = 0.33;
INSERT INTO t VALUES(1);
SET SESSION query_exec_time = 0.34;
INSERT INTO t VALUES(1);
SET SESSION query_exec_time = 0.35;
INSERT INTO t VALUES(1);
SET SESSION query_exec_time = 0.36;
INSERT INTO t VALUES(1);
SET SESSION query_exec_time = 0.37;
INSERT INTO t VALUES(1);
SET SESSION query_exec_time = 0.38;
INSERT INTO t VALUES(1);
SET SESSION query_exec_time = 0.39;
INSERT INTO t VALUES(1);
SET SESSION query_exec_time = 0.4;
INSERT INTO t VALUES(1);
SET SESSION query_exec_time = 1.1;
INSERT INTO t VALUES(1);
SET SESSION query_exec_time = 1.2;
INSERT INTO t VALUES(1);
SET SESSION query_exec_time = 1.3;
INSERT INTO t VALUES(1);
SET SESSION query_exec_time = 1.5;
INSERT INTO t VALUES(1);
SET SESSION query_exec_time = 1.4;
INSERT INTO t VALUES(1);
SET SESSION query_exec_time = 0.5;
INSERT INTO t VALUES(1);
SET SESSION query_exec_time = 2.1;
INSERT INTO t VALUES(1);
SET SESSION query_exec_time = 2.3;
INSERT INTO t VALUES(1);
SET SESSION query_exec_time = 2.5;
INSERT INTO t VALUES(1);
SET SESSION query_exec_time = 3.1;
INSERT INTO t VALUES(1);
SET SESSION query_exec_time = 4.1;
INSERT INTO t VALUES(1);
SET SESSION query_exec_time = 5.1;
INSERT INTO t VALUES(1);
SET GLOBAL QUERY_RESPONSE_TIME_STATS=0;
SHOW GLOBAL VARIABLES where Variable_name like 'QUERY_RESPONSE_TIME_RANGE_BASE';
Variable_name	Value
query_response_time_range_base	1000
SHOW QUERY_RESPONSE_TIME;
		
      0.000001	1	      0.000000
      0.001000	0	      0.000000
      1.000000	34	     12.250000
   1000.000000	33	     77.099997
 1000000.00000	0	      0.000000
TOO LONG	0	TOO LONG
SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME;
time	count	total
      0.000001	1	      0.000000
      0.001000	0	      0.000000
      1.000000	34	     12.250000
   1000.000000	33	     77.099997
 1000000.00000	0	      0.000000
TOO LONG	0	TOO LONG
SET GLOBAL QUERY_RESPONSE_TIME_RANGE_BASE=default;
SET GLOBAL QUERY_RESPONSE_TIME_STATS=default;
DROP TABLE t;
include/rpl_end.inc
SET GLOBAL query_exec_time=default;
SET GLOBAL query_exec_time=default;