2
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
5
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
7
DROP TABLE IF EXISTS t;
8
CREATE TABLE t(id INT);
13
SET GLOBAL QUERY_RESPONSE_TIME_RANGE_BASE = 1;
15
Warning 1292 Truncated incorrect query_response_time_range_base value: '1'
16
SHOW GLOBAL VARIABLES where Variable_name like 'QUERY_RESPONSE_TIME_RANGE_BASE';
18
query_response_time_range_base 2
19
SET GLOBAL QUERY_RESPONSE_TIME_RANGE_BASE = 10;
20
SHOW GLOBAL VARIABLES where Variable_name like 'QUERY_RESPONSE_TIME_RANGE_BASE';
22
query_response_time_range_base 10
23
FLUSH QUERY_RESPONSE_TIME;
24
SET GLOBAL ENABLE_QUERY_RESPONSE_TIME_STATS=ON;
25
INSERT INTO t VALUES(0);
26
SELECT SUM(INFORMATION_SCHEMA.QUERY_RESPONSE_TIME.count) FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME;
27
SUM(INFORMATION_SCHEMA.QUERY_RESPONSE_TIME.count)
29
INSERT INTO t VALUES(1);
30
SELECT SUM(INFORMATION_SCHEMA.QUERY_RESPONSE_TIME.count) FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME;
31
SUM(INFORMATION_SCHEMA.QUERY_RESPONSE_TIME.count)
33
SELECT SUM(INFORMATION_SCHEMA.QUERY_RESPONSE_TIME.count) FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME;
34
SUM(INFORMATION_SCHEMA.QUERY_RESPONSE_TIME.count)
36
SELECT SUM(INFORMATION_SCHEMA.QUERY_RESPONSE_TIME.count) FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME;
37
SUM(INFORMATION_SCHEMA.QUERY_RESPONSE_TIME.count)
39
SET GLOBAL QUERY_RESPONSE_TIME_RANGE_BASE = 2;
40
SHOW GLOBAL VARIABLES where Variable_name like 'QUERY_RESPONSE_TIME_RANGE_BASE';
42
query_response_time_range_base 2
43
FLUSH QUERY_RESPONSE_TIME;
44
INSERT INTO t VALUES(0);
45
SELECT SUM(INFORMATION_SCHEMA.QUERY_RESPONSE_TIME.count) FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME;
46
SUM(INFORMATION_SCHEMA.QUERY_RESPONSE_TIME.count)
48
INSERT INTO t VALUES(1);
49
SELECT SUM(INFORMATION_SCHEMA.QUERY_RESPONSE_TIME.count) FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME;
50
SUM(INFORMATION_SCHEMA.QUERY_RESPONSE_TIME.count)
52
SELECT SUM(INFORMATION_SCHEMA.QUERY_RESPONSE_TIME.count) FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME;
53
SUM(INFORMATION_SCHEMA.QUERY_RESPONSE_TIME.count)
55
SELECT SUM(INFORMATION_SCHEMA.QUERY_RESPONSE_TIME.count) FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME;
56
SUM(INFORMATION_SCHEMA.QUERY_RESPONSE_TIME.count)
58
DROP TABLE IF EXISTS t;
59
SET GLOBAL QUERY_RESPONSE_TIME_RANGE_BASE = 10;
60
SET GLOBAL ENABLE_QUERY_RESPONSE_TIME_STATS=OFF;