4
4
SET GLOBAL QUERY_RESPONSE_TIME_RANGE_BASE = 2;
5
5
SHOW GLOBAL VARIABLES where Variable_name like 'QUERY_RESPONSE_TIME_RANGE_BASE';
7
FLUSH QUERY_RESPONSE_TIME;
10
(SELECT SUM(a.count) FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME as a WHERE a.count != 0) as query_count,
11
(SELECT COUNT(*) FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME as b WHERE b.count != 0) as not_zero_region_count,
12
(SELECT COUNT(*) FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME) as region_count
13
FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME as c WHERE c.count > 0;
14
SELECT COUNT(*) as region_count FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME;
15
SELECT time FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME;
7
source include/percona_query_response_time_flush.inc;
8
source include/percona_query_response_time_show.inc;
17
10
SET GLOBAL ENABLE_QUERY_RESPONSE_TIME_STATS=1;
11
source include/percona_query_response_time_sleep.inc;
37
12
SET GLOBAL ENABLE_QUERY_RESPONSE_TIME_STATS=0;
40
(SELECT SUM(a.count) FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME as a WHERE a.count != 0) as query_count,
41
(SELECT COUNT(*) FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME as b WHERE b.count != 0) as not_zero_region_count,
42
(SELECT COUNT(*) FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME) as region_count
43
FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME as c WHERE c.count > 0;
44
SELECT COUNT(*) as region_count FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME;
45
SELECT time FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME;
14
source include/percona_query_response_time_show.inc;
47
16
SHOW GLOBAL VARIABLES where Variable_name like 'QUERY_RESPONSE_TIME_RANGE_BASE';
48
17
SET GLOBAL QUERY_RESPONSE_TIME_RANGE_BASE = 10;
49
18
SHOW GLOBAL VARIABLES where Variable_name like 'QUERY_RESPONSE_TIME_RANGE_BASE';
51
FLUSH QUERY_RESPONSE_TIME;
20
source include/percona_query_response_time_flush.inc;
52
21
SET GLOBAL ENABLE_QUERY_RESPONSE_TIME_STATS=1;
22
source include/percona_query_response_time_sleep.inc;
72
23
SET GLOBAL ENABLE_QUERY_RESPONSE_TIME_STATS=0;
75
(SELECT SUM(a.count) FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME as a WHERE a.count != 0) as query_count,
76
(SELECT COUNT(*) FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME as b WHERE b.count != 0) as not_zero_region_count,
77
(SELECT COUNT(*) FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME) as region_count
78
FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME as c WHERE c.count > 0;
79
SELECT COUNT(*) as region_count FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME;
80
SELECT time FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME;
25
source include/percona_query_response_time_show.inc;
82
27
SHOW GLOBAL VARIABLES where Variable_name like 'QUERY_RESPONSE_TIME_RANGE_BASE';
83
28
SET GLOBAL QUERY_RESPONSE_TIME_RANGE_BASE = 7;
84
29
SHOW GLOBAL VARIABLES where Variable_name like 'QUERY_RESPONSE_TIME_RANGE_BASE';
86
FLUSH QUERY_RESPONSE_TIME;
31
source include/percona_query_response_time_flush.inc;
87
32
SET GLOBAL ENABLE_QUERY_RESPONSE_TIME_STATS=1;
33
source include/percona_query_response_time_sleep.inc;
107
34
SET GLOBAL ENABLE_QUERY_RESPONSE_TIME_STATS=0;
110
(SELECT SUM(a.count) FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME as a WHERE a.count != 0) as query_count,
111
(SELECT COUNT(*) FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME as b WHERE b.count != 0) as not_zero_region_count,
112
(SELECT COUNT(*) FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME) as region_count
113
FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME as c WHERE c.count > 0;
114
SELECT COUNT(*) as region_count FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME;
115
SELECT time FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME;
36
source include/percona_query_response_time_show.inc;
117
38
SHOW GLOBAL VARIABLES where Variable_name like 'QUERY_RESPONSE_TIME_RANGE_BASE';
118
39
SET GLOBAL QUERY_RESPONSE_TIME_RANGE_BASE = 156;
119
40
SHOW GLOBAL VARIABLES where Variable_name like 'QUERY_RESPONSE_TIME_RANGE_BASE';
121
FLUSH QUERY_RESPONSE_TIME;
42
source include/percona_query_response_time_flush.inc;
122
43
SET GLOBAL ENABLE_QUERY_RESPONSE_TIME_STATS=1;
44
source include/percona_query_response_time_sleep.inc;
142
45
SET GLOBAL ENABLE_QUERY_RESPONSE_TIME_STATS=0;
145
(SELECT SUM(a.count) FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME as a WHERE a.count != 0) as query_count,
146
(SELECT COUNT(*) FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME as b WHERE b.count != 0) as not_zero_region_count,
147
(SELECT COUNT(*) FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME) as region_count
148
FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME as c WHERE c.count > 0;
149
SELECT COUNT(*) as region_count FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME;
150
SELECT time FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME;
47
source include/percona_query_response_time_show.inc;
152
49
SHOW GLOBAL VARIABLES where Variable_name like 'QUERY_RESPONSE_TIME_RANGE_BASE';
153
50
SET GLOBAL QUERY_RESPONSE_TIME_RANGE_BASE = 1000;
154
51
SHOW GLOBAL VARIABLES where Variable_name like 'QUERY_RESPONSE_TIME_RANGE_BASE';
156
FLUSH QUERY_RESPONSE_TIME;
53
source include/percona_query_response_time_flush.inc;
157
54
SET GLOBAL ENABLE_QUERY_RESPONSE_TIME_STATS=1;
55
source include/percona_query_response_time_sleep.inc;
177
56
SET GLOBAL ENABLE_QUERY_RESPONSE_TIME_STATS=0;
180
(SELECT SUM(a.count) FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME as a WHERE a.count != 0) as query_count,
181
(SELECT COUNT(*) FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME as b WHERE b.count != 0) as not_zero_region_count,
182
(SELECT COUNT(*) FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME) as region_count
183
FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME as c WHERE c.count > 0;
184
SELECT COUNT(*) as region_count FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME;
185
SELECT time FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME;
58
source include/percona_query_response_time_show.inc;
187
60
SHOW GLOBAL VARIABLES where Variable_name like 'QUERY_RESPONSE_TIME_RANGE_BASE';
188
61
SET GLOBAL QUERY_RESPONSE_TIME_RANGE_BASE = 1001;