]>
Commit | Line | Data |
---|---|---|
b4e1fa2c AM |
1 | # name : response-time-distribution.patch |
2 | # introduced : 12 | |
3 | # maintainer : Oleg | |
4 | # | |
5 | #!!! notice !!! | |
6 | # Any small change to this file in the main branch | |
7 | # should be done or reviewed by the maintainer! | |
db82db79 AM |
8 | --- a/CMakeLists.txt |
9 | +++ b/CMakeLists.txt | |
d8778560 | 10 | @@ -165,7 +165,12 @@ |
b4e1fa2c AM |
11 | OPTION (WITH_UNIT_TESTS "Compile MySQL with unit tests" ON) |
12 | MARK_AS_ADVANCED(CYBOZU BACKUP_TEST WITHOUT_SERVER DISABLE_SHARED) | |
13 | ||
14 | - | |
15 | +OPTION(WITHOUT_RESPONSE_TIME_DISTRIBUTION "If we want to have response_time_distribution" OFF) | |
16 | +IF(WITHOUT_RESPONSE_TIME_DISTRIBUTION) | |
17 | +ELSE() | |
18 | +ADD_DEFINITIONS(-DHAVE_RESPONSE_TIME_DISTRIBUTION) | |
19 | +ENDIF() | |
20 | + | |
21 | OPTION(ENABLE_DEBUG_SYNC "Enable debug sync (debug builds only)" ON) | |
22 | IF(ENABLE_DEBUG_SYNC) | |
23 | SET(CMAKE_CXX_FLAGS_DEBUG "${CMAKE_CXX_FLAGS_DEBUG} -DENABLED_DEBUG_SYNC") | |
db82db79 AM |
24 | --- a/include/mysql_com.h |
25 | +++ b/include/mysql_com.h | |
adf0fb13 | 26 | @@ -141,10 +141,11 @@ |
b4e1fa2c AM |
27 | #define REFRESH_FAST 32768 /* Intern flag */ |
28 | ||
29 | /* RESET (remove all queries) from query cache */ | |
30 | -#define REFRESH_QUERY_CACHE 65536 | |
31 | -#define REFRESH_QUERY_CACHE_FREE 0x20000L /* pack query cache */ | |
32 | -#define REFRESH_DES_KEY_FILE 0x40000L | |
33 | -#define REFRESH_USER_RESOURCES 0x80000L | |
34 | +#define REFRESH_QUERY_CACHE 65536 | |
35 | +#define REFRESH_QUERY_CACHE_FREE 0x20000L /* pack query cache */ | |
36 | +#define REFRESH_DES_KEY_FILE 0x40000L | |
37 | +#define REFRESH_USER_RESOURCES 0x80000L | |
38 | +#define REFRESH_QUERY_RESPONSE_TIME 0x100000L /* response time distibution */ | |
39 | ||
40 | #define CLIENT_LONG_PASSWORD 1 /* new more secure passwords */ | |
41 | #define CLIENT_FOUND_ROWS 2 /* Found instead of affected rows */ | |
db82db79 | 42 | --- /dev/null |
48b678b4 AM |
43 | +++ b/mysql-test/include/have_response_time_distribution.inc |
44 | @@ -0,0 +1,4 @@ | |
45 | +-- require r/have_response_time_distribution.require | |
46 | +disable_query_log; | |
47 | +show variables like 'have_response_time_distribution'; | |
48 | +enable_query_log; | |
49 | --- /dev/null | |
50 | +++ b/mysql-test/include/query_response_time.inc | |
734d6226 | 51 | @@ -0,0 +1,43 @@ |
48b678b4 AM |
52 | +SET SESSION query_exec_time=0.1; |
53 | + | |
54 | +SET GLOBAL QUERY_RESPONSE_TIME_STATS=0; | |
55 | +EVAL SET GLOBAL QUERY_RESPONSE_TIME_RANGE_BASE=$base; | |
56 | +FLUSH QUERY_RESPONSE_TIME; | |
734d6226 AM |
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; | |
48b678b4 AM |
61 | +SET GLOBAL QUERY_RESPONSE_TIME_STATS=1; |
62 | + | |
63 | +SET SESSION query_exec_time=0.31; SELECT 1; | |
64 | +SET SESSION query_exec_time=0.32; SELECT 1; | |
65 | +SET SESSION query_exec_time=0.33; SELECT 1; | |
66 | +SET SESSION query_exec_time=0.34; SELECT 1; | |
67 | +SET SESSION query_exec_time=0.35; SELECT 1; | |
68 | +SET SESSION query_exec_time=0.36; SELECT 1; | |
69 | +SET SESSION query_exec_time=0.37; SELECT 1; | |
70 | +SET SESSION query_exec_time=0.38; SELECT 1; | |
71 | +SET SESSION query_exec_time=0.39; SELECT 1; | |
72 | +SET SESSION query_exec_time=0.4; SELECT 1; | |
73 | +SET SESSION query_exec_time=1.1; SELECT 1; | |
74 | +SET SESSION query_exec_time=1.2; SELECT 1; | |
75 | +SET SESSION query_exec_time=1.3; SELECT 1; | |
76 | +SET SESSION query_exec_time=1.5; SELECT 1; | |
77 | +SET SESSION query_exec_time=1.4; SELECT 1; | |
78 | +SET SESSION query_exec_time=0.5; SELECT 1; | |
79 | +SET SESSION query_exec_time=2.1; SELECT 1; | |
80 | +SET SESSION query_exec_time=2.3; SELECT 1; | |
81 | +SET SESSION query_exec_time=2.5; SELECT 1; | |
82 | +SET SESSION query_exec_time=3.1; SELECT 1; | |
83 | +SET SESSION query_exec_time=4.1; SELECT 1; | |
84 | +SET SESSION query_exec_time=5.1; SELECT 1; | |
85 | + | |
86 | +SET SESSION query_exec_time=0.1; | |
87 | + | |
88 | +SET GLOBAL QUERY_RESPONSE_TIME_STATS=0; | |
89 | + | |
90 | +SHOW GLOBAL VARIABLES where Variable_name like 'QUERY_RESPONSE_TIME_RANGE_BASE'; | |
91 | +SHOW QUERY_RESPONSE_TIME; | |
92 | +SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME; | |
93 | + | |
94 | +SET SESSION query_exec_time=default; | |
95 | --- /dev/null | |
96 | +++ b/mysql-test/include/query_response_time-replication.inc | |
97 | @@ -0,0 +1,57 @@ | |
98 | +connection master; | |
99 | + | |
100 | +CREATE TABLE t(id INT); | |
101 | + | |
102 | +connection slave; | |
103 | +SET GLOBAL query_exec_time = 0.1; | |
104 | +--source include/restart_slave_sql.inc | |
105 | + | |
106 | +connection slave; | |
107 | + | |
108 | +SET SESSION query_exec_time=0.1; | |
109 | + | |
110 | +SET GLOBAL QUERY_RESPONSE_TIME_STATS=0; | |
111 | +--eval SET GLOBAL QUERY_RESPONSE_TIME_RANGE_BASE=$base | |
112 | +FLUSH QUERY_RESPONSE_TIME; | |
113 | +SET GLOBAL QUERY_RESPONSE_TIME_STATS=1; | |
114 | + | |
115 | +connection master; | |
116 | + | |
117 | +SET SESSION query_exec_time = 0.31; INSERT INTO t VALUES(1); | |
118 | +SET SESSION query_exec_time = 0.32; INSERT INTO t VALUES(1); | |
119 | +SET SESSION query_exec_time = 0.33; INSERT INTO t VALUES(1); | |
120 | +SET SESSION query_exec_time = 0.34; INSERT INTO t VALUES(1); | |
121 | +SET SESSION query_exec_time = 0.35; INSERT INTO t VALUES(1); | |
122 | +SET SESSION query_exec_time = 0.36; INSERT INTO t VALUES(1); | |
123 | +SET SESSION query_exec_time = 0.37; INSERT INTO t VALUES(1); | |
124 | +SET SESSION query_exec_time = 0.38; INSERT INTO t VALUES(1); | |
125 | +SET SESSION query_exec_time = 0.39; INSERT INTO t VALUES(1); | |
126 | +SET SESSION query_exec_time = 0.4; INSERT INTO t VALUES(1); | |
127 | +SET SESSION query_exec_time = 1.1; INSERT INTO t VALUES(1); | |
128 | +SET SESSION query_exec_time = 1.2; INSERT INTO t VALUES(1); | |
129 | +SET SESSION query_exec_time = 1.3; INSERT INTO t VALUES(1); | |
130 | +SET SESSION query_exec_time = 1.5; INSERT INTO t VALUES(1); | |
131 | +SET SESSION query_exec_time = 1.4; INSERT INTO t VALUES(1); | |
132 | +SET SESSION query_exec_time = 0.5; INSERT INTO t VALUES(1); | |
133 | +SET SESSION query_exec_time = 2.1; INSERT INTO t VALUES(1); | |
134 | +SET SESSION query_exec_time = 2.3; INSERT INTO t VALUES(1); | |
135 | +SET SESSION query_exec_time = 2.5; INSERT INTO t VALUES(1); | |
136 | +SET SESSION query_exec_time = 3.1; INSERT INTO t VALUES(1); | |
137 | +SET SESSION query_exec_time = 4.1; INSERT INTO t VALUES(1); | |
138 | +SET SESSION query_exec_time = 5.1; INSERT INTO t VALUES(1); | |
139 | + | |
140 | +sync_slave_with_master; | |
141 | + | |
142 | +connection slave; | |
143 | +SET GLOBAL QUERY_RESPONSE_TIME_STATS=0; | |
144 | +SHOW GLOBAL VARIABLES where Variable_name like 'QUERY_RESPONSE_TIME_RANGE_BASE'; | |
145 | +SHOW QUERY_RESPONSE_TIME; | |
146 | +SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME; | |
147 | + | |
148 | +SET GLOBAL QUERY_RESPONSE_TIME_RANGE_BASE=default; | |
149 | +SET GLOBAL QUERY_RESPONSE_TIME_STATS=default; | |
150 | + | |
151 | +connection master; | |
152 | +DROP TABLE t; | |
153 | + | |
154 | +sync_slave_with_master; | |
155 | --- /dev/null | |
156 | +++ b/mysql-test/include/query_response_time-stored.inc | |
157 | @@ -0,0 +1,37 @@ | |
158 | +SET SESSION query_exec_time=0.1; | |
159 | + | |
160 | +SET GLOBAL QUERY_RESPONSE_TIME_STATS=0; | |
161 | +EVAL SET GLOBAL QUERY_RESPONSE_TIME_RANGE_BASE=$base; | |
162 | +FLUSH QUERY_RESPONSE_TIME; | |
163 | +SET GLOBAL QUERY_RESPONSE_TIME_STATS=1; | |
164 | + | |
165 | +CALL test_f(0.31); | |
166 | +CALL test_f(0.32); | |
167 | +CALL test_f(0.33); | |
168 | +CALL test_f(0.34); | |
169 | +CALL test_f(0.35); | |
170 | +CALL test_f(0.36); | |
171 | +CALL test_f(0.37); | |
172 | +CALL test_f(0.38); | |
173 | +CALL test_f(0.39); | |
174 | +CALL test_f(0.4); | |
175 | +CALL test_f(1.1); | |
176 | +CALL test_f(1.2); | |
177 | +CALL test_f(1.3); | |
178 | +CALL test_f(1.5); | |
179 | +CALL test_f(1.4); | |
180 | +CALL test_f(0.5); | |
181 | +CALL test_f(2.1); | |
182 | +CALL test_f(2.3); | |
183 | +CALL test_f(2.5); | |
184 | +CALL test_f(3.1); | |
185 | +CALL test_f(4.1); | |
186 | +CALL test_f(5.1); | |
187 | + | |
188 | +SET GLOBAL QUERY_RESPONSE_TIME_STATS=0; | |
189 | + | |
190 | +SHOW GLOBAL VARIABLES where Variable_name like 'QUERY_RESPONSE_TIME_RANGE_BASE'; | |
191 | +SHOW QUERY_RESPONSE_TIME; | |
192 | +SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME; | |
193 | + | |
194 | +SET SESSION query_exec_time=default; | |
195 | --- /dev/null | |
196 | +++ b/mysql-test/r/percona_query_response_time-replication.result | |
197 | @@ -0,0 +1,727 @@ | |
198 | +SET GLOBAL query_exec_time=0.1; | |
199 | +include/master-slave.inc | |
200 | +[connection master] | |
201 | +CREATE TABLE t(id INT); | |
202 | +SET GLOBAL query_exec_time = 0.1; | |
203 | +include/restart_slave.inc | |
204 | +SET SESSION query_exec_time=0.1; | |
205 | +SET GLOBAL QUERY_RESPONSE_TIME_STATS=0; | |
206 | +SET GLOBAL QUERY_RESPONSE_TIME_RANGE_BASE=1; | |
207 | +Warnings: | |
208 | +Warning 1292 Truncated incorrect query_response_time_range_base value: '1' | |
209 | +FLUSH QUERY_RESPONSE_TIME; | |
210 | +SET GLOBAL QUERY_RESPONSE_TIME_STATS=1; | |
211 | +SET SESSION query_exec_time = 0.31; | |
212 | +INSERT INTO t VALUES(1); | |
213 | +SET SESSION query_exec_time = 0.32; | |
214 | +INSERT INTO t VALUES(1); | |
215 | +SET SESSION query_exec_time = 0.33; | |
216 | +INSERT INTO t VALUES(1); | |
217 | +SET SESSION query_exec_time = 0.34; | |
218 | +INSERT INTO t VALUES(1); | |
219 | +SET SESSION query_exec_time = 0.35; | |
220 | +INSERT INTO t VALUES(1); | |
221 | +SET SESSION query_exec_time = 0.36; | |
222 | +INSERT INTO t VALUES(1); | |
223 | +SET SESSION query_exec_time = 0.37; | |
224 | +INSERT INTO t VALUES(1); | |
225 | +SET SESSION query_exec_time = 0.38; | |
226 | +INSERT INTO t VALUES(1); | |
227 | +SET SESSION query_exec_time = 0.39; | |
228 | +INSERT INTO t VALUES(1); | |
229 | +SET SESSION query_exec_time = 0.4; | |
230 | +INSERT INTO t VALUES(1); | |
231 | +SET SESSION query_exec_time = 1.1; | |
232 | +INSERT INTO t VALUES(1); | |
233 | +SET SESSION query_exec_time = 1.2; | |
234 | +INSERT INTO t VALUES(1); | |
235 | +SET SESSION query_exec_time = 1.3; | |
236 | +INSERT INTO t VALUES(1); | |
237 | +SET SESSION query_exec_time = 1.5; | |
238 | +INSERT INTO t VALUES(1); | |
239 | +SET SESSION query_exec_time = 1.4; | |
240 | +INSERT INTO t VALUES(1); | |
241 | +SET SESSION query_exec_time = 0.5; | |
242 | +INSERT INTO t VALUES(1); | |
243 | +SET SESSION query_exec_time = 2.1; | |
244 | +INSERT INTO t VALUES(1); | |
245 | +SET SESSION query_exec_time = 2.3; | |
246 | +INSERT INTO t VALUES(1); | |
247 | +SET SESSION query_exec_time = 2.5; | |
248 | +INSERT INTO t VALUES(1); | |
249 | +SET SESSION query_exec_time = 3.1; | |
250 | +INSERT INTO t VALUES(1); | |
251 | +SET SESSION query_exec_time = 4.1; | |
252 | +INSERT INTO t VALUES(1); | |
253 | +SET SESSION query_exec_time = 5.1; | |
254 | +INSERT INTO t VALUES(1); | |
255 | +SET GLOBAL QUERY_RESPONSE_TIME_STATS=0; | |
256 | +SHOW GLOBAL VARIABLES where Variable_name like 'QUERY_RESPONSE_TIME_RANGE_BASE'; | |
257 | +Variable_name Value | |
258 | +query_response_time_range_base 2 | |
259 | +SHOW QUERY_RESPONSE_TIME; | |
260 | + | |
734d6226 | 261 | + 0.000001 1 0.000000 |
48b678b4 AM |
262 | + 0.000003 0 0.000000 |
263 | + 0.000007 0 0.000000 | |
264 | + 0.000015 0 0.000000 | |
265 | + 0.000030 0 0.000000 | |
266 | + 0.000061 0 0.000000 | |
267 | + 0.000122 0 0.000000 | |
268 | + 0.000244 0 0.000000 | |
269 | + 0.000488 0 0.000000 | |
270 | + 0.000976 0 0.000000 | |
271 | + 0.001953 0 0.000000 | |
272 | + 0.003906 0 0.000000 | |
273 | + 0.007812 0 0.000000 | |
274 | + 0.015625 0 0.000000 | |
275 | + 0.031250 0 0.000000 | |
276 | + 0.062500 0 0.000000 | |
734d6226 | 277 | + 0.125000 1 0.100000 |
48b678b4 AM |
278 | + 0.250000 0 0.000000 |
279 | + 0.500000 30 10.650000 | |
280 | + 1.000000 3 1.500000 | |
281 | + 2.000000 15 19.500000 | |
282 | + 4.000000 12 30.000000 | |
283 | + 8.000000 6 27.599997 | |
284 | + 16.000000 0 0.000000 | |
285 | + 32.000000 0 0.000000 | |
286 | + 64.000000 0 0.000000 | |
287 | + 128.000000 0 0.000000 | |
288 | + 256.000000 0 0.000000 | |
289 | + 512.000000 0 0.000000 | |
290 | + 1024.000000 0 0.000000 | |
291 | + 2048.000000 0 0.000000 | |
292 | + 4096.000000 0 0.000000 | |
293 | + 8192.000000 0 0.000000 | |
294 | + 16384.000000 0 0.000000 | |
295 | + 32768.000000 0 0.000000 | |
296 | + 65536.000000 0 0.000000 | |
297 | + 131072.000000 0 0.000000 | |
298 | + 262144.000000 0 0.000000 | |
299 | + 524288.000000 0 0.000000 | |
9dd04cbc AM |
300 | +1048576.000000 0 0.000000 |
301 | +2097152.000000 0 0.000000 | |
302 | +4194304.000000 0 0.000000 | |
303 | +8388608.000000 0 0.000000 | |
48b678b4 AM |
304 | +TOO LONG 0 TOO LONG |
305 | +SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME; | |
306 | +time count total | |
734d6226 | 307 | + 0.000001 1 0.000000 |
48b678b4 AM |
308 | + 0.000003 0 0.000000 |
309 | + 0.000007 0 0.000000 | |
310 | + 0.000015 0 0.000000 | |
311 | + 0.000030 0 0.000000 | |
312 | + 0.000061 0 0.000000 | |
313 | + 0.000122 0 0.000000 | |
314 | + 0.000244 0 0.000000 | |
315 | + 0.000488 0 0.000000 | |
316 | + 0.000976 0 0.000000 | |
317 | + 0.001953 0 0.000000 | |
318 | + 0.003906 0 0.000000 | |
319 | + 0.007812 0 0.000000 | |
320 | + 0.015625 0 0.000000 | |
321 | + 0.031250 0 0.000000 | |
322 | + 0.062500 0 0.000000 | |
734d6226 | 323 | + 0.125000 1 0.100000 |
48b678b4 AM |
324 | + 0.250000 0 0.000000 |
325 | + 0.500000 30 10.650000 | |
326 | + 1.000000 3 1.500000 | |
327 | + 2.000000 15 19.500000 | |
328 | + 4.000000 12 30.000000 | |
329 | + 8.000000 6 27.599997 | |
330 | + 16.000000 0 0.000000 | |
331 | + 32.000000 0 0.000000 | |
332 | + 64.000000 0 0.000000 | |
333 | + 128.000000 0 0.000000 | |
334 | + 256.000000 0 0.000000 | |
335 | + 512.000000 0 0.000000 | |
336 | + 1024.000000 0 0.000000 | |
337 | + 2048.000000 0 0.000000 | |
338 | + 4096.000000 0 0.000000 | |
339 | + 8192.000000 0 0.000000 | |
340 | + 16384.000000 0 0.000000 | |
341 | + 32768.000000 0 0.000000 | |
342 | + 65536.000000 0 0.000000 | |
343 | + 131072.000000 0 0.000000 | |
344 | + 262144.000000 0 0.000000 | |
345 | + 524288.000000 0 0.000000 | |
9dd04cbc AM |
346 | +1048576.000000 0 0.000000 |
347 | +2097152.000000 0 0.000000 | |
348 | +4194304.000000 0 0.000000 | |
349 | +8388608.000000 0 0.000000 | |
48b678b4 AM |
350 | +TOO LONG 0 TOO LONG |
351 | +SET GLOBAL QUERY_RESPONSE_TIME_RANGE_BASE=default; | |
352 | +SET GLOBAL QUERY_RESPONSE_TIME_STATS=default; | |
353 | +DROP TABLE t; | |
354 | +CREATE TABLE t(id INT); | |
355 | +SET GLOBAL query_exec_time = 0.1; | |
356 | +include/restart_slave.inc | |
357 | +SET SESSION query_exec_time=0.1; | |
358 | +SET GLOBAL QUERY_RESPONSE_TIME_STATS=0; | |
359 | +SET GLOBAL QUERY_RESPONSE_TIME_RANGE_BASE=2; | |
360 | +FLUSH QUERY_RESPONSE_TIME; | |
361 | +SET GLOBAL QUERY_RESPONSE_TIME_STATS=1; | |
362 | +SET SESSION query_exec_time = 0.31; | |
363 | +INSERT INTO t VALUES(1); | |
364 | +SET SESSION query_exec_time = 0.32; | |
365 | +INSERT INTO t VALUES(1); | |
366 | +SET SESSION query_exec_time = 0.33; | |
367 | +INSERT INTO t VALUES(1); | |
368 | +SET SESSION query_exec_time = 0.34; | |
369 | +INSERT INTO t VALUES(1); | |
370 | +SET SESSION query_exec_time = 0.35; | |
371 | +INSERT INTO t VALUES(1); | |
372 | +SET SESSION query_exec_time = 0.36; | |
373 | +INSERT INTO t VALUES(1); | |
374 | +SET SESSION query_exec_time = 0.37; | |
375 | +INSERT INTO t VALUES(1); | |
376 | +SET SESSION query_exec_time = 0.38; | |
377 | +INSERT INTO t VALUES(1); | |
378 | +SET SESSION query_exec_time = 0.39; | |
379 | +INSERT INTO t VALUES(1); | |
380 | +SET SESSION query_exec_time = 0.4; | |
381 | +INSERT INTO t VALUES(1); | |
382 | +SET SESSION query_exec_time = 1.1; | |
383 | +INSERT INTO t VALUES(1); | |
384 | +SET SESSION query_exec_time = 1.2; | |
385 | +INSERT INTO t VALUES(1); | |
386 | +SET SESSION query_exec_time = 1.3; | |
387 | +INSERT INTO t VALUES(1); | |
388 | +SET SESSION query_exec_time = 1.5; | |
389 | +INSERT INTO t VALUES(1); | |
390 | +SET SESSION query_exec_time = 1.4; | |
391 | +INSERT INTO t VALUES(1); | |
392 | +SET SESSION query_exec_time = 0.5; | |
393 | +INSERT INTO t VALUES(1); | |
394 | +SET SESSION query_exec_time = 2.1; | |
395 | +INSERT INTO t VALUES(1); | |
396 | +SET SESSION query_exec_time = 2.3; | |
397 | +INSERT INTO t VALUES(1); | |
398 | +SET SESSION query_exec_time = 2.5; | |
399 | +INSERT INTO t VALUES(1); | |
400 | +SET SESSION query_exec_time = 3.1; | |
401 | +INSERT INTO t VALUES(1); | |
402 | +SET SESSION query_exec_time = 4.1; | |
403 | +INSERT INTO t VALUES(1); | |
404 | +SET SESSION query_exec_time = 5.1; | |
405 | +INSERT INTO t VALUES(1); | |
406 | +SET GLOBAL QUERY_RESPONSE_TIME_STATS=0; | |
407 | +SHOW GLOBAL VARIABLES where Variable_name like 'QUERY_RESPONSE_TIME_RANGE_BASE'; | |
408 | +Variable_name Value | |
409 | +query_response_time_range_base 2 | |
410 | +SHOW QUERY_RESPONSE_TIME; | |
411 | + | |
734d6226 | 412 | + 0.000001 1 0.000000 |
48b678b4 AM |
413 | + 0.000003 0 0.000000 |
414 | + 0.000007 0 0.000000 | |
415 | + 0.000015 0 0.000000 | |
416 | + 0.000030 0 0.000000 | |
417 | + 0.000061 0 0.000000 | |
418 | + 0.000122 0 0.000000 | |
419 | + 0.000244 0 0.000000 | |
420 | + 0.000488 0 0.000000 | |
421 | + 0.000976 0 0.000000 | |
422 | + 0.001953 0 0.000000 | |
423 | + 0.003906 0 0.000000 | |
424 | + 0.007812 0 0.000000 | |
425 | + 0.015625 0 0.000000 | |
426 | + 0.031250 0 0.000000 | |
427 | + 0.062500 0 0.000000 | |
734d6226 | 428 | + 0.125000 1 0.100000 |
48b678b4 AM |
429 | + 0.250000 0 0.000000 |
430 | + 0.500000 30 10.650000 | |
431 | + 1.000000 3 1.500000 | |
432 | + 2.000000 15 19.500000 | |
433 | + 4.000000 12 30.000000 | |
434 | + 8.000000 6 27.599997 | |
435 | + 16.000000 0 0.000000 | |
436 | + 32.000000 0 0.000000 | |
437 | + 64.000000 0 0.000000 | |
438 | + 128.000000 0 0.000000 | |
439 | + 256.000000 0 0.000000 | |
440 | + 512.000000 0 0.000000 | |
441 | + 1024.000000 0 0.000000 | |
442 | + 2048.000000 0 0.000000 | |
443 | + 4096.000000 0 0.000000 | |
444 | + 8192.000000 0 0.000000 | |
445 | + 16384.000000 0 0.000000 | |
446 | + 32768.000000 0 0.000000 | |
447 | + 65536.000000 0 0.000000 | |
448 | + 131072.000000 0 0.000000 | |
449 | + 262144.000000 0 0.000000 | |
450 | + 524288.000000 0 0.000000 | |
9dd04cbc AM |
451 | +1048576.000000 0 0.000000 |
452 | +2097152.000000 0 0.000000 | |
453 | +4194304.000000 0 0.000000 | |
454 | +8388608.000000 0 0.000000 | |
48b678b4 AM |
455 | +TOO LONG 0 TOO LONG |
456 | +SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME; | |
457 | +time count total | |
734d6226 | 458 | + 0.000001 1 0.000000 |
48b678b4 AM |
459 | + 0.000003 0 0.000000 |
460 | + 0.000007 0 0.000000 | |
461 | + 0.000015 0 0.000000 | |
462 | + 0.000030 0 0.000000 | |
463 | + 0.000061 0 0.000000 | |
464 | + 0.000122 0 0.000000 | |
465 | + 0.000244 0 0.000000 | |
466 | + 0.000488 0 0.000000 | |
467 | + 0.000976 0 0.000000 | |
468 | + 0.001953 0 0.000000 | |
469 | + 0.003906 0 0.000000 | |
470 | + 0.007812 0 0.000000 | |
471 | + 0.015625 0 0.000000 | |
472 | + 0.031250 0 0.000000 | |
473 | + 0.062500 0 0.000000 | |
734d6226 | 474 | + 0.125000 1 0.100000 |
48b678b4 AM |
475 | + 0.250000 0 0.000000 |
476 | + 0.500000 30 10.650000 | |
477 | + 1.000000 3 1.500000 | |
478 | + 2.000000 15 19.500000 | |
479 | + 4.000000 12 30.000000 | |
480 | + 8.000000 6 27.599997 | |
481 | + 16.000000 0 0.000000 | |
482 | + 32.000000 0 0.000000 | |
483 | + 64.000000 0 0.000000 | |
484 | + 128.000000 0 0.000000 | |
485 | + 256.000000 0 0.000000 | |
486 | + 512.000000 0 0.000000 | |
487 | + 1024.000000 0 0.000000 | |
488 | + 2048.000000 0 0.000000 | |
489 | + 4096.000000 0 0.000000 | |
490 | + 8192.000000 0 0.000000 | |
491 | + 16384.000000 0 0.000000 | |
492 | + 32768.000000 0 0.000000 | |
493 | + 65536.000000 0 0.000000 | |
494 | + 131072.000000 0 0.000000 | |
495 | + 262144.000000 0 0.000000 | |
496 | + 524288.000000 0 0.000000 | |
9dd04cbc AM |
497 | +1048576.000000 0 0.000000 |
498 | +2097152.000000 0 0.000000 | |
499 | +4194304.000000 0 0.000000 | |
500 | +8388608.000000 0 0.000000 | |
48b678b4 AM |
501 | +TOO LONG 0 TOO LONG |
502 | +SET GLOBAL QUERY_RESPONSE_TIME_RANGE_BASE=default; | |
503 | +SET GLOBAL QUERY_RESPONSE_TIME_STATS=default; | |
504 | +DROP TABLE t; | |
505 | +CREATE TABLE t(id INT); | |
506 | +SET GLOBAL query_exec_time = 0.1; | |
507 | +include/restart_slave.inc | |
508 | +SET SESSION query_exec_time=0.1; | |
509 | +SET GLOBAL QUERY_RESPONSE_TIME_STATS=0; | |
510 | +SET GLOBAL QUERY_RESPONSE_TIME_RANGE_BASE=10; | |
511 | +FLUSH QUERY_RESPONSE_TIME; | |
512 | +SET GLOBAL QUERY_RESPONSE_TIME_STATS=1; | |
513 | +SET SESSION query_exec_time = 0.31; | |
514 | +INSERT INTO t VALUES(1); | |
515 | +SET SESSION query_exec_time = 0.32; | |
516 | +INSERT INTO t VALUES(1); | |
517 | +SET SESSION query_exec_time = 0.33; | |
518 | +INSERT INTO t VALUES(1); | |
519 | +SET SESSION query_exec_time = 0.34; | |
520 | +INSERT INTO t VALUES(1); | |
521 | +SET SESSION query_exec_time = 0.35; | |
522 | +INSERT INTO t VALUES(1); | |
523 | +SET SESSION query_exec_time = 0.36; | |
524 | +INSERT INTO t VALUES(1); | |
525 | +SET SESSION query_exec_time = 0.37; | |
526 | +INSERT INTO t VALUES(1); | |
527 | +SET SESSION query_exec_time = 0.38; | |
528 | +INSERT INTO t VALUES(1); | |
529 | +SET SESSION query_exec_time = 0.39; | |
530 | +INSERT INTO t VALUES(1); | |
531 | +SET SESSION query_exec_time = 0.4; | |
532 | +INSERT INTO t VALUES(1); | |
533 | +SET SESSION query_exec_time = 1.1; | |
534 | +INSERT INTO t VALUES(1); | |
535 | +SET SESSION query_exec_time = 1.2; | |
536 | +INSERT INTO t VALUES(1); | |
537 | +SET SESSION query_exec_time = 1.3; | |
538 | +INSERT INTO t VALUES(1); | |
539 | +SET SESSION query_exec_time = 1.5; | |
540 | +INSERT INTO t VALUES(1); | |
541 | +SET SESSION query_exec_time = 1.4; | |
542 | +INSERT INTO t VALUES(1); | |
543 | +SET SESSION query_exec_time = 0.5; | |
544 | +INSERT INTO t VALUES(1); | |
545 | +SET SESSION query_exec_time = 2.1; | |
546 | +INSERT INTO t VALUES(1); | |
547 | +SET SESSION query_exec_time = 2.3; | |
548 | +INSERT INTO t VALUES(1); | |
549 | +SET SESSION query_exec_time = 2.5; | |
550 | +INSERT INTO t VALUES(1); | |
551 | +SET SESSION query_exec_time = 3.1; | |
552 | +INSERT INTO t VALUES(1); | |
553 | +SET SESSION query_exec_time = 4.1; | |
554 | +INSERT INTO t VALUES(1); | |
555 | +SET SESSION query_exec_time = 5.1; | |
556 | +INSERT INTO t VALUES(1); | |
557 | +SET GLOBAL QUERY_RESPONSE_TIME_STATS=0; | |
558 | +SHOW GLOBAL VARIABLES where Variable_name like 'QUERY_RESPONSE_TIME_RANGE_BASE'; | |
559 | +Variable_name Value | |
560 | +query_response_time_range_base 10 | |
561 | +SHOW QUERY_RESPONSE_TIME; | |
562 | + | |
734d6226 | 563 | + 0.000001 1 0.000000 |
48b678b4 AM |
564 | + 0.000010 0 0.000000 |
565 | + 0.000100 0 0.000000 | |
566 | + 0.001000 0 0.000000 | |
567 | + 0.010000 0 0.000000 | |
568 | + 0.100000 0 0.000000 | |
734d6226 | 569 | + 1.000000 34 12.250000 |
48b678b4 AM |
570 | + 10.000000 33 77.099997 |
571 | + 100.000000 0 0.000000 | |
572 | + 1000.000000 0 0.000000 | |
573 | + 10000.000000 0 0.000000 | |
574 | + 100000.000000 0 0.000000 | |
9dd04cbc | 575 | +1000000.000000 0 0.000000 |
48b678b4 AM |
576 | +TOO LONG 0 TOO LONG |
577 | +SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME; | |
578 | +time count total | |
734d6226 | 579 | + 0.000001 1 0.000000 |
48b678b4 AM |
580 | + 0.000010 0 0.000000 |
581 | + 0.000100 0 0.000000 | |
582 | + 0.001000 0 0.000000 | |
583 | + 0.010000 0 0.000000 | |
584 | + 0.100000 0 0.000000 | |
734d6226 | 585 | + 1.000000 34 12.250000 |
48b678b4 AM |
586 | + 10.000000 33 77.099997 |
587 | + 100.000000 0 0.000000 | |
588 | + 1000.000000 0 0.000000 | |
589 | + 10000.000000 0 0.000000 | |
590 | + 100000.000000 0 0.000000 | |
9dd04cbc | 591 | +1000000.000000 0 0.000000 |
48b678b4 AM |
592 | +TOO LONG 0 TOO LONG |
593 | +SET GLOBAL QUERY_RESPONSE_TIME_RANGE_BASE=default; | |
594 | +SET GLOBAL QUERY_RESPONSE_TIME_STATS=default; | |
595 | +DROP TABLE t; | |
596 | +CREATE TABLE t(id INT); | |
597 | +SET GLOBAL query_exec_time = 0.1; | |
598 | +include/restart_slave.inc | |
599 | +SET SESSION query_exec_time=0.1; | |
600 | +SET GLOBAL QUERY_RESPONSE_TIME_STATS=0; | |
601 | +SET GLOBAL QUERY_RESPONSE_TIME_RANGE_BASE=7; | |
602 | +FLUSH QUERY_RESPONSE_TIME; | |
603 | +SET GLOBAL QUERY_RESPONSE_TIME_STATS=1; | |
604 | +SET SESSION query_exec_time = 0.31; | |
605 | +INSERT INTO t VALUES(1); | |
606 | +SET SESSION query_exec_time = 0.32; | |
607 | +INSERT INTO t VALUES(1); | |
608 | +SET SESSION query_exec_time = 0.33; | |
609 | +INSERT INTO t VALUES(1); | |
610 | +SET SESSION query_exec_time = 0.34; | |
611 | +INSERT INTO t VALUES(1); | |
612 | +SET SESSION query_exec_time = 0.35; | |
613 | +INSERT INTO t VALUES(1); | |
614 | +SET SESSION query_exec_time = 0.36; | |
615 | +INSERT INTO t VALUES(1); | |
616 | +SET SESSION query_exec_time = 0.37; | |
617 | +INSERT INTO t VALUES(1); | |
618 | +SET SESSION query_exec_time = 0.38; | |
619 | +INSERT INTO t VALUES(1); | |
620 | +SET SESSION query_exec_time = 0.39; | |
621 | +INSERT INTO t VALUES(1); | |
622 | +SET SESSION query_exec_time = 0.4; | |
623 | +INSERT INTO t VALUES(1); | |
624 | +SET SESSION query_exec_time = 1.1; | |
625 | +INSERT INTO t VALUES(1); | |
626 | +SET SESSION query_exec_time = 1.2; | |
627 | +INSERT INTO t VALUES(1); | |
628 | +SET SESSION query_exec_time = 1.3; | |
629 | +INSERT INTO t VALUES(1); | |
630 | +SET SESSION query_exec_time = 1.5; | |
631 | +INSERT INTO t VALUES(1); | |
632 | +SET SESSION query_exec_time = 1.4; | |
633 | +INSERT INTO t VALUES(1); | |
634 | +SET SESSION query_exec_time = 0.5; | |
635 | +INSERT INTO t VALUES(1); | |
636 | +SET SESSION query_exec_time = 2.1; | |
637 | +INSERT INTO t VALUES(1); | |
638 | +SET SESSION query_exec_time = 2.3; | |
639 | +INSERT INTO t VALUES(1); | |
640 | +SET SESSION query_exec_time = 2.5; | |
641 | +INSERT INTO t VALUES(1); | |
642 | +SET SESSION query_exec_time = 3.1; | |
643 | +INSERT INTO t VALUES(1); | |
644 | +SET SESSION query_exec_time = 4.1; | |
645 | +INSERT INTO t VALUES(1); | |
646 | +SET SESSION query_exec_time = 5.1; | |
647 | +INSERT INTO t VALUES(1); | |
648 | +SET GLOBAL QUERY_RESPONSE_TIME_STATS=0; | |
649 | +SHOW GLOBAL VARIABLES where Variable_name like 'QUERY_RESPONSE_TIME_RANGE_BASE'; | |
650 | +Variable_name Value | |
651 | +query_response_time_range_base 7 | |
652 | +SHOW QUERY_RESPONSE_TIME; | |
653 | + | |
734d6226 | 654 | + 0.000001 1 0.000000 |
48b678b4 AM |
655 | + 0.000008 0 0.000000 |
656 | + 0.000059 0 0.000000 | |
657 | + 0.000416 0 0.000000 | |
658 | + 0.002915 0 0.000000 | |
659 | + 0.020408 0 0.000000 | |
734d6226 | 660 | + 0.142857 1 0.100000 |
48b678b4 AM |
661 | + 1.000000 33 12.150000 |
662 | + 7.000000 33 77.099997 | |
663 | + 49.000000 0 0.000000 | |
664 | + 343.000000 0 0.000000 | |
665 | + 2401.000000 0 0.000000 | |
666 | + 16807.000000 0 0.000000 | |
667 | + 117649.000000 0 0.000000 | |
668 | + 823543.000000 0 0.000000 | |
9dd04cbc | 669 | +5764801.000000 0 0.000000 |
48b678b4 AM |
670 | +TOO LONG 0 TOO LONG |
671 | +SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME; | |
672 | +time count total | |
734d6226 | 673 | + 0.000001 1 0.000000 |
48b678b4 AM |
674 | + 0.000008 0 0.000000 |
675 | + 0.000059 0 0.000000 | |
676 | + 0.000416 0 0.000000 | |
677 | + 0.002915 0 0.000000 | |
678 | + 0.020408 0 0.000000 | |
734d6226 | 679 | + 0.142857 1 0.100000 |
48b678b4 AM |
680 | + 1.000000 33 12.150000 |
681 | + 7.000000 33 77.099997 | |
682 | + 49.000000 0 0.000000 | |
683 | + 343.000000 0 0.000000 | |
684 | + 2401.000000 0 0.000000 | |
685 | + 16807.000000 0 0.000000 | |
686 | + 117649.000000 0 0.000000 | |
687 | + 823543.000000 0 0.000000 | |
9dd04cbc | 688 | +5764801.000000 0 0.000000 |
48b678b4 AM |
689 | +TOO LONG 0 TOO LONG |
690 | +SET GLOBAL QUERY_RESPONSE_TIME_RANGE_BASE=default; | |
691 | +SET GLOBAL QUERY_RESPONSE_TIME_STATS=default; | |
692 | +DROP TABLE t; | |
693 | +CREATE TABLE t(id INT); | |
694 | +SET GLOBAL query_exec_time = 0.1; | |
695 | +include/restart_slave.inc | |
696 | +SET SESSION query_exec_time=0.1; | |
697 | +SET GLOBAL QUERY_RESPONSE_TIME_STATS=0; | |
698 | +SET GLOBAL QUERY_RESPONSE_TIME_RANGE_BASE=156; | |
699 | +FLUSH QUERY_RESPONSE_TIME; | |
700 | +SET GLOBAL QUERY_RESPONSE_TIME_STATS=1; | |
701 | +SET SESSION query_exec_time = 0.31; | |
702 | +INSERT INTO t VALUES(1); | |
703 | +SET SESSION query_exec_time = 0.32; | |
704 | +INSERT INTO t VALUES(1); | |
705 | +SET SESSION query_exec_time = 0.33; | |
706 | +INSERT INTO t VALUES(1); | |
707 | +SET SESSION query_exec_time = 0.34; | |
708 | +INSERT INTO t VALUES(1); | |
709 | +SET SESSION query_exec_time = 0.35; | |
710 | +INSERT INTO t VALUES(1); | |
711 | +SET SESSION query_exec_time = 0.36; | |
712 | +INSERT INTO t VALUES(1); | |
713 | +SET SESSION query_exec_time = 0.37; | |
714 | +INSERT INTO t VALUES(1); | |
715 | +SET SESSION query_exec_time = 0.38; | |
716 | +INSERT INTO t VALUES(1); | |
717 | +SET SESSION query_exec_time = 0.39; | |
718 | +INSERT INTO t VALUES(1); | |
719 | +SET SESSION query_exec_time = 0.4; | |
720 | +INSERT INTO t VALUES(1); | |
721 | +SET SESSION query_exec_time = 1.1; | |
722 | +INSERT INTO t VALUES(1); | |
723 | +SET SESSION query_exec_time = 1.2; | |
724 | +INSERT INTO t VALUES(1); | |
725 | +SET SESSION query_exec_time = 1.3; | |
726 | +INSERT INTO t VALUES(1); | |
727 | +SET SESSION query_exec_time = 1.5; | |
728 | +INSERT INTO t VALUES(1); | |
729 | +SET SESSION query_exec_time = 1.4; | |
730 | +INSERT INTO t VALUES(1); | |
731 | +SET SESSION query_exec_time = 0.5; | |
732 | +INSERT INTO t VALUES(1); | |
733 | +SET SESSION query_exec_time = 2.1; | |
734 | +INSERT INTO t VALUES(1); | |
735 | +SET SESSION query_exec_time = 2.3; | |
736 | +INSERT INTO t VALUES(1); | |
737 | +SET SESSION query_exec_time = 2.5; | |
738 | +INSERT INTO t VALUES(1); | |
739 | +SET SESSION query_exec_time = 3.1; | |
740 | +INSERT INTO t VALUES(1); | |
741 | +SET SESSION query_exec_time = 4.1; | |
742 | +INSERT INTO t VALUES(1); | |
743 | +SET SESSION query_exec_time = 5.1; | |
744 | +INSERT INTO t VALUES(1); | |
745 | +SET GLOBAL QUERY_RESPONSE_TIME_STATS=0; | |
746 | +SHOW GLOBAL VARIABLES where Variable_name like 'QUERY_RESPONSE_TIME_RANGE_BASE'; | |
747 | +Variable_name Value | |
748 | +query_response_time_range_base 156 | |
749 | +SHOW QUERY_RESPONSE_TIME; | |
750 | + | |
734d6226 | 751 | + 0.000041 1 0.000000 |
48b678b4 | 752 | + 0.006410 0 0.000000 |
734d6226 | 753 | + 1.000000 34 12.250000 |
48b678b4 AM |
754 | + 156.000000 33 77.099997 |
755 | + 24336.000000 0 0.000000 | |
9dd04cbc | 756 | +3796416.000000 0 0.000000 |
48b678b4 AM |
757 | +TOO LONG 0 TOO LONG |
758 | +SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME; | |
759 | +time count total | |
734d6226 | 760 | + 0.000041 1 0.000000 |
48b678b4 | 761 | + 0.006410 0 0.000000 |
734d6226 | 762 | + 1.000000 34 12.250000 |
48b678b4 AM |
763 | + 156.000000 33 77.099997 |
764 | + 24336.000000 0 0.000000 | |
9dd04cbc | 765 | +3796416.000000 0 0.000000 |
48b678b4 AM |
766 | +TOO LONG 0 TOO LONG |
767 | +SET GLOBAL QUERY_RESPONSE_TIME_RANGE_BASE=default; | |
768 | +SET GLOBAL QUERY_RESPONSE_TIME_STATS=default; | |
769 | +DROP TABLE t; | |
770 | +CREATE TABLE t(id INT); | |
771 | +SET GLOBAL query_exec_time = 0.1; | |
772 | +include/restart_slave.inc | |
773 | +SET SESSION query_exec_time=0.1; | |
774 | +SET GLOBAL QUERY_RESPONSE_TIME_STATS=0; | |
775 | +SET GLOBAL QUERY_RESPONSE_TIME_RANGE_BASE=1000; | |
776 | +FLUSH QUERY_RESPONSE_TIME; | |
777 | +SET GLOBAL QUERY_RESPONSE_TIME_STATS=1; | |
778 | +SET SESSION query_exec_time = 0.31; | |
779 | +INSERT INTO t VALUES(1); | |
780 | +SET SESSION query_exec_time = 0.32; | |
781 | +INSERT INTO t VALUES(1); | |
782 | +SET SESSION query_exec_time = 0.33; | |
783 | +INSERT INTO t VALUES(1); | |
784 | +SET SESSION query_exec_time = 0.34; | |
785 | +INSERT INTO t VALUES(1); | |
786 | +SET SESSION query_exec_time = 0.35; | |
787 | +INSERT INTO t VALUES(1); | |
788 | +SET SESSION query_exec_time = 0.36; | |
789 | +INSERT INTO t VALUES(1); | |
790 | +SET SESSION query_exec_time = 0.37; | |
791 | +INSERT INTO t VALUES(1); | |
792 | +SET SESSION query_exec_time = 0.38; | |
793 | +INSERT INTO t VALUES(1); | |
794 | +SET SESSION query_exec_time = 0.39; | |
795 | +INSERT INTO t VALUES(1); | |
796 | +SET SESSION query_exec_time = 0.4; | |
797 | +INSERT INTO t VALUES(1); | |
798 | +SET SESSION query_exec_time = 1.1; | |
799 | +INSERT INTO t VALUES(1); | |
800 | +SET SESSION query_exec_time = 1.2; | |
801 | +INSERT INTO t VALUES(1); | |
802 | +SET SESSION query_exec_time = 1.3; | |
803 | +INSERT INTO t VALUES(1); | |
804 | +SET SESSION query_exec_time = 1.5; | |
805 | +INSERT INTO t VALUES(1); | |
806 | +SET SESSION query_exec_time = 1.4; | |
807 | +INSERT INTO t VALUES(1); | |
808 | +SET SESSION query_exec_time = 0.5; | |
809 | +INSERT INTO t VALUES(1); | |
810 | +SET SESSION query_exec_time = 2.1; | |
811 | +INSERT INTO t VALUES(1); | |
812 | +SET SESSION query_exec_time = 2.3; | |
813 | +INSERT INTO t VALUES(1); | |
814 | +SET SESSION query_exec_time = 2.5; | |
815 | +INSERT INTO t VALUES(1); | |
816 | +SET SESSION query_exec_time = 3.1; | |
817 | +INSERT INTO t VALUES(1); | |
818 | +SET SESSION query_exec_time = 4.1; | |
819 | +INSERT INTO t VALUES(1); | |
820 | +SET SESSION query_exec_time = 5.1; | |
821 | +INSERT INTO t VALUES(1); | |
822 | +SET GLOBAL QUERY_RESPONSE_TIME_STATS=0; | |
823 | +SHOW GLOBAL VARIABLES where Variable_name like 'QUERY_RESPONSE_TIME_RANGE_BASE'; | |
824 | +Variable_name Value | |
825 | +query_response_time_range_base 1000 | |
826 | +SHOW QUERY_RESPONSE_TIME; | |
827 | + | |
734d6226 | 828 | + 0.000001 1 0.000000 |
48b678b4 | 829 | + 0.001000 0 0.000000 |
734d6226 | 830 | + 1.000000 34 12.250000 |
48b678b4 | 831 | + 1000.000000 33 77.099997 |
9dd04cbc | 832 | +1000000.000000 0 0.000000 |
48b678b4 AM |
833 | +TOO LONG 0 TOO LONG |
834 | +SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME; | |
835 | +time count total | |
734d6226 | 836 | + 0.000001 1 0.000000 |
48b678b4 | 837 | + 0.001000 0 0.000000 |
734d6226 | 838 | + 1.000000 34 12.250000 |
48b678b4 | 839 | + 1000.000000 33 77.099997 |
9dd04cbc | 840 | +1000000.000000 0 0.000000 |
48b678b4 AM |
841 | +TOO LONG 0 TOO LONG |
842 | +SET GLOBAL QUERY_RESPONSE_TIME_RANGE_BASE=default; | |
843 | +SET GLOBAL QUERY_RESPONSE_TIME_STATS=default; | |
844 | +DROP TABLE t; | |
845 | +CREATE TABLE t(id INT); | |
846 | +SET GLOBAL query_exec_time = 0.1; | |
847 | +include/restart_slave.inc | |
848 | +SET SESSION query_exec_time=0.1; | |
849 | +SET GLOBAL QUERY_RESPONSE_TIME_STATS=0; | |
850 | +SET GLOBAL QUERY_RESPONSE_TIME_RANGE_BASE=1001; | |
851 | +Warnings: | |
852 | +Warning 1292 Truncated incorrect query_response_time_range_base value: '1001' | |
853 | +FLUSH QUERY_RESPONSE_TIME; | |
854 | +SET GLOBAL QUERY_RESPONSE_TIME_STATS=1; | |
855 | +SET SESSION query_exec_time = 0.31; | |
856 | +INSERT INTO t VALUES(1); | |
857 | +SET SESSION query_exec_time = 0.32; | |
858 | +INSERT INTO t VALUES(1); | |
859 | +SET SESSION query_exec_time = 0.33; | |
860 | +INSERT INTO t VALUES(1); | |
861 | +SET SESSION query_exec_time = 0.34; | |
862 | +INSERT INTO t VALUES(1); | |
863 | +SET SESSION query_exec_time = 0.35; | |
864 | +INSERT INTO t VALUES(1); | |
865 | +SET SESSION query_exec_time = 0.36; | |
866 | +INSERT INTO t VALUES(1); | |
867 | +SET SESSION query_exec_time = 0.37; | |
868 | +INSERT INTO t VALUES(1); | |
869 | +SET SESSION query_exec_time = 0.38; | |
870 | +INSERT INTO t VALUES(1); | |
871 | +SET SESSION query_exec_time = 0.39; | |
872 | +INSERT INTO t VALUES(1); | |
873 | +SET SESSION query_exec_time = 0.4; | |
874 | +INSERT INTO t VALUES(1); | |
875 | +SET SESSION query_exec_time = 1.1; | |
876 | +INSERT INTO t VALUES(1); | |
877 | +SET SESSION query_exec_time = 1.2; | |
878 | +INSERT INTO t VALUES(1); | |
879 | +SET SESSION query_exec_time = 1.3; | |
880 | +INSERT INTO t VALUES(1); | |
881 | +SET SESSION query_exec_time = 1.5; | |
882 | +INSERT INTO t VALUES(1); | |
883 | +SET SESSION query_exec_time = 1.4; | |
884 | +INSERT INTO t VALUES(1); | |
885 | +SET SESSION query_exec_time = 0.5; | |
886 | +INSERT INTO t VALUES(1); | |
887 | +SET SESSION query_exec_time = 2.1; | |
888 | +INSERT INTO t VALUES(1); | |
889 | +SET SESSION query_exec_time = 2.3; | |
890 | +INSERT INTO t VALUES(1); | |
891 | +SET SESSION query_exec_time = 2.5; | |
892 | +INSERT INTO t VALUES(1); | |
893 | +SET SESSION query_exec_time = 3.1; | |
894 | +INSERT INTO t VALUES(1); | |
895 | +SET SESSION query_exec_time = 4.1; | |
896 | +INSERT INTO t VALUES(1); | |
897 | +SET SESSION query_exec_time = 5.1; | |
898 | +INSERT INTO t VALUES(1); | |
899 | +SET GLOBAL QUERY_RESPONSE_TIME_STATS=0; | |
900 | +SHOW GLOBAL VARIABLES where Variable_name like 'QUERY_RESPONSE_TIME_RANGE_BASE'; | |
901 | +Variable_name Value | |
902 | +query_response_time_range_base 1000 | |
903 | +SHOW QUERY_RESPONSE_TIME; | |
904 | + | |
734d6226 | 905 | + 0.000001 1 0.000000 |
48b678b4 | 906 | + 0.001000 0 0.000000 |
734d6226 | 907 | + 1.000000 34 12.250000 |
48b678b4 | 908 | + 1000.000000 33 77.099997 |
9dd04cbc | 909 | +1000000.000000 0 0.000000 |
48b678b4 AM |
910 | +TOO LONG 0 TOO LONG |
911 | +SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME; | |
912 | +time count total | |
734d6226 | 913 | + 0.000001 1 0.000000 |
48b678b4 | 914 | + 0.001000 0 0.000000 |
734d6226 | 915 | + 1.000000 34 12.250000 |
48b678b4 | 916 | + 1000.000000 33 77.099997 |
9dd04cbc | 917 | +1000000.000000 0 0.000000 |
48b678b4 AM |
918 | +TOO LONG 0 TOO LONG |
919 | +SET GLOBAL QUERY_RESPONSE_TIME_RANGE_BASE=default; | |
920 | +SET GLOBAL QUERY_RESPONSE_TIME_STATS=default; | |
921 | +DROP TABLE t; | |
922 | +include/rpl_end.inc | |
923 | +SET GLOBAL query_exec_time=default; | |
924 | +SET GLOBAL query_exec_time=default; | |
925 | --- /dev/null | |
926 | +++ b/mysql-test/r/percona_query_response_time.result | |
734d6226 | 927 | @@ -0,0 +1,1307 @@ |
48b678b4 AM |
928 | +SET SESSION query_exec_time=0.1; |
929 | +SET GLOBAL QUERY_RESPONSE_TIME_STATS=0; | |
930 | +SET GLOBAL QUERY_RESPONSE_TIME_RANGE_BASE=1; | |
931 | +Warnings: | |
932 | +Warning 1292 Truncated incorrect query_response_time_range_base value: '1' | |
933 | +FLUSH QUERY_RESPONSE_TIME; | |
734d6226 AM |
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 | |
9dd04cbc AM |
975 | +1048576.000000 0 0.000000 |
976 | +2097152.000000 0 0.000000 | |
977 | +4194304.000000 0 0.000000 | |
978 | +8388608.000000 0 0.000000 | |
734d6226 AM |
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 | |
9dd04cbc AM |
1021 | +1048576.000000 0 0.000000 |
1022 | +2097152.000000 0 0.000000 | |
1023 | +4194304.000000 0 0.000000 | |
1024 | +8388608.000000 0 0.000000 | |
734d6226 | 1025 | +TOO LONG 0 TOO LONG |
48b678b4 AM |
1026 | +SET GLOBAL QUERY_RESPONSE_TIME_STATS=1; |
1027 | +SET SESSION query_exec_time=0.31; | |
1028 | +SELECT 1; | |
1029 | +1 | |
1030 | +1 | |
1031 | +SET SESSION query_exec_time=0.32; | |
1032 | +SELECT 1; | |
1033 | +1 | |
1034 | +1 | |
1035 | +SET SESSION query_exec_time=0.33; | |
1036 | +SELECT 1; | |
1037 | +1 | |
1038 | +1 | |
1039 | +SET SESSION query_exec_time=0.34; | |
1040 | +SELECT 1; | |
1041 | +1 | |
1042 | +1 | |
1043 | +SET SESSION query_exec_time=0.35; | |
1044 | +SELECT 1; | |
1045 | +1 | |
1046 | +1 | |
1047 | +SET SESSION query_exec_time=0.36; | |
1048 | +SELECT 1; | |
1049 | +1 | |
1050 | +1 | |
1051 | +SET SESSION query_exec_time=0.37; | |
1052 | +SELECT 1; | |
1053 | +1 | |
1054 | +1 | |
1055 | +SET SESSION query_exec_time=0.38; | |
1056 | +SELECT 1; | |
1057 | +1 | |
1058 | +1 | |
1059 | +SET SESSION query_exec_time=0.39; | |
1060 | +SELECT 1; | |
1061 | +1 | |
1062 | +1 | |
1063 | +SET SESSION query_exec_time=0.4; | |
1064 | +SELECT 1; | |
1065 | +1 | |
1066 | +1 | |
1067 | +SET SESSION query_exec_time=1.1; | |
1068 | +SELECT 1; | |
1069 | +1 | |
1070 | +1 | |
1071 | +SET SESSION query_exec_time=1.2; | |
1072 | +SELECT 1; | |
1073 | +1 | |
1074 | +1 | |
1075 | +SET SESSION query_exec_time=1.3; | |
1076 | +SELECT 1; | |
1077 | +1 | |
1078 | +1 | |
1079 | +SET SESSION query_exec_time=1.5; | |
1080 | +SELECT 1; | |
1081 | +1 | |
1082 | +1 | |
1083 | +SET SESSION query_exec_time=1.4; | |
1084 | +SELECT 1; | |
1085 | +1 | |
1086 | +1 | |
1087 | +SET SESSION query_exec_time=0.5; | |
1088 | +SELECT 1; | |
1089 | +1 | |
1090 | +1 | |
1091 | +SET SESSION query_exec_time=2.1; | |
1092 | +SELECT 1; | |
1093 | +1 | |
1094 | +1 | |
1095 | +SET SESSION query_exec_time=2.3; | |
1096 | +SELECT 1; | |
1097 | +1 | |
1098 | +1 | |
1099 | +SET SESSION query_exec_time=2.5; | |
1100 | +SELECT 1; | |
1101 | +1 | |
1102 | +1 | |
1103 | +SET SESSION query_exec_time=3.1; | |
1104 | +SELECT 1; | |
1105 | +1 | |
1106 | +1 | |
1107 | +SET SESSION query_exec_time=4.1; | |
1108 | +SELECT 1; | |
1109 | +1 | |
1110 | +1 | |
1111 | +SET SESSION query_exec_time=5.1; | |
1112 | +SELECT 1; | |
1113 | +1 | |
1114 | +1 | |
1115 | +SET SESSION query_exec_time=0.1; | |
1116 | +SET GLOBAL QUERY_RESPONSE_TIME_STATS=0; | |
1117 | +SHOW GLOBAL VARIABLES where Variable_name like 'QUERY_RESPONSE_TIME_RANGE_BASE'; | |
1118 | +Variable_name Value | |
1119 | +query_response_time_range_base 2 | |
1120 | +SHOW QUERY_RESPONSE_TIME; | |
1121 | + | |
734d6226 | 1122 | + 0.000001 24 0.000000 |
48b678b4 AM |
1123 | + 0.000003 0 0.000000 |
1124 | + 0.000007 0 0.000000 | |
1125 | + 0.000015 0 0.000000 | |
1126 | + 0.000030 0 0.000000 | |
1127 | + 0.000061 0 0.000000 | |
1128 | + 0.000122 0 0.000000 | |
1129 | + 0.000244 0 0.000000 | |
1130 | + 0.000488 0 0.000000 | |
1131 | + 0.000976 0 0.000000 | |
1132 | + 0.001953 0 0.000000 | |
1133 | + 0.003906 0 0.000000 | |
1134 | + 0.007812 0 0.000000 | |
1135 | + 0.015625 0 0.000000 | |
1136 | + 0.031250 0 0.000000 | |
1137 | + 0.062500 0 0.000000 | |
734d6226 | 1138 | + 0.125000 0 0.000000 |
48b678b4 AM |
1139 | + 0.250000 0 0.000000 |
1140 | + 0.500000 10 3.550000 | |
1141 | + 1.000000 1 0.500000 | |
1142 | + 2.000000 5 6.500000 | |
1143 | + 4.000000 4 10.000000 | |
1144 | + 8.000000 2 9.199999 | |
1145 | + 16.000000 0 0.000000 | |
1146 | + 32.000000 0 0.000000 | |
1147 | + 64.000000 0 0.000000 | |
1148 | + 128.000000 0 0.000000 | |
1149 | + 256.000000 0 0.000000 | |
1150 | + 512.000000 0 0.000000 | |
1151 | + 1024.000000 0 0.000000 | |
1152 | + 2048.000000 0 0.000000 | |
1153 | + 4096.000000 0 0.000000 | |
1154 | + 8192.000000 0 0.000000 | |
1155 | + 16384.000000 0 0.000000 | |
1156 | + 32768.000000 0 0.000000 | |
1157 | + 65536.000000 0 0.000000 | |
1158 | + 131072.000000 0 0.000000 | |
1159 | + 262144.000000 0 0.000000 | |
1160 | + 524288.000000 0 0.000000 | |
9dd04cbc AM |
1161 | +1048576.000000 0 0.000000 |
1162 | +2097152.000000 0 0.000000 | |
1163 | +4194304.000000 0 0.000000 | |
1164 | +8388608.000000 0 0.000000 | |
48b678b4 AM |
1165 | +TOO LONG 0 TOO LONG |
1166 | +SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME; | |
1167 | +time count total | |
734d6226 | 1168 | + 0.000001 24 0.000000 |
48b678b4 AM |
1169 | + 0.000003 0 0.000000 |
1170 | + 0.000007 0 0.000000 | |
1171 | + 0.000015 0 0.000000 | |
1172 | + 0.000030 0 0.000000 | |
1173 | + 0.000061 0 0.000000 | |
1174 | + 0.000122 0 0.000000 | |
1175 | + 0.000244 0 0.000000 | |
1176 | + 0.000488 0 0.000000 | |
1177 | + 0.000976 0 0.000000 | |
1178 | + 0.001953 0 0.000000 | |
1179 | + 0.003906 0 0.000000 | |
1180 | + 0.007812 0 0.000000 | |
1181 | + 0.015625 0 0.000000 | |
1182 | + 0.031250 0 0.000000 | |
1183 | + 0.062500 0 0.000000 | |
734d6226 | 1184 | + 0.125000 0 0.000000 |
48b678b4 AM |
1185 | + 0.250000 0 0.000000 |
1186 | + 0.500000 10 3.550000 | |
1187 | + 1.000000 1 0.500000 | |
1188 | + 2.000000 5 6.500000 | |
1189 | + 4.000000 4 10.000000 | |
1190 | + 8.000000 2 9.199999 | |
1191 | + 16.000000 0 0.000000 | |
1192 | + 32.000000 0 0.000000 | |
1193 | + 64.000000 0 0.000000 | |
1194 | + 128.000000 0 0.000000 | |
1195 | + 256.000000 0 0.000000 | |
1196 | + 512.000000 0 0.000000 | |
1197 | + 1024.000000 0 0.000000 | |
1198 | + 2048.000000 0 0.000000 | |
1199 | + 4096.000000 0 0.000000 | |
1200 | + 8192.000000 0 0.000000 | |
1201 | + 16384.000000 0 0.000000 | |
1202 | + 32768.000000 0 0.000000 | |
1203 | + 65536.000000 0 0.000000 | |
1204 | + 131072.000000 0 0.000000 | |
1205 | + 262144.000000 0 0.000000 | |
1206 | + 524288.000000 0 0.000000 | |
9dd04cbc AM |
1207 | +1048576.000000 0 0.000000 |
1208 | +2097152.000000 0 0.000000 | |
1209 | +4194304.000000 0 0.000000 | |
1210 | +8388608.000000 0 0.000000 | |
48b678b4 AM |
1211 | +TOO LONG 0 TOO LONG |
1212 | +SET SESSION query_exec_time=default; | |
1213 | +SET SESSION query_exec_time=0.1; | |
1214 | +SET GLOBAL QUERY_RESPONSE_TIME_STATS=0; | |
1215 | +SET GLOBAL QUERY_RESPONSE_TIME_RANGE_BASE=2; | |
1216 | +FLUSH QUERY_RESPONSE_TIME; | |
734d6226 AM |
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 | |
9dd04cbc AM |
1258 | +1048576.000000 0 0.000000 |
1259 | +2097152.000000 0 0.000000 | |
1260 | +4194304.000000 0 0.000000 | |
1261 | +8388608.000000 0 0.000000 | |
734d6226 AM |
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 | |
9dd04cbc AM |
1304 | +1048576.000000 0 0.000000 |
1305 | +2097152.000000 0 0.000000 | |
1306 | +4194304.000000 0 0.000000 | |
1307 | +8388608.000000 0 0.000000 | |
734d6226 | 1308 | +TOO LONG 0 TOO LONG |
48b678b4 AM |
1309 | +SET GLOBAL QUERY_RESPONSE_TIME_STATS=1; |
1310 | +SET SESSION query_exec_time=0.31; | |
1311 | +SELECT 1; | |
1312 | +1 | |
1313 | +1 | |
1314 | +SET SESSION query_exec_time=0.32; | |
1315 | +SELECT 1; | |
1316 | +1 | |
1317 | +1 | |
1318 | +SET SESSION query_exec_time=0.33; | |
1319 | +SELECT 1; | |
1320 | +1 | |
1321 | +1 | |
1322 | +SET SESSION query_exec_time=0.34; | |
1323 | +SELECT 1; | |
1324 | +1 | |
1325 | +1 | |
1326 | +SET SESSION query_exec_time=0.35; | |
1327 | +SELECT 1; | |
1328 | +1 | |
1329 | +1 | |
1330 | +SET SESSION query_exec_time=0.36; | |
1331 | +SELECT 1; | |
1332 | +1 | |
1333 | +1 | |
1334 | +SET SESSION query_exec_time=0.37; | |
1335 | +SELECT 1; | |
1336 | +1 | |
1337 | +1 | |
1338 | +SET SESSION query_exec_time=0.38; | |
1339 | +SELECT 1; | |
1340 | +1 | |
1341 | +1 | |
1342 | +SET SESSION query_exec_time=0.39; | |
1343 | +SELECT 1; | |
1344 | +1 | |
1345 | +1 | |
1346 | +SET SESSION query_exec_time=0.4; | |
1347 | +SELECT 1; | |
1348 | +1 | |
1349 | +1 | |
1350 | +SET SESSION query_exec_time=1.1; | |
1351 | +SELECT 1; | |
1352 | +1 | |
1353 | +1 | |
1354 | +SET SESSION query_exec_time=1.2; | |
1355 | +SELECT 1; | |
1356 | +1 | |
1357 | +1 | |
1358 | +SET SESSION query_exec_time=1.3; | |
1359 | +SELECT 1; | |
1360 | +1 | |
1361 | +1 | |
1362 | +SET SESSION query_exec_time=1.5; | |
1363 | +SELECT 1; | |
1364 | +1 | |
1365 | +1 | |
1366 | +SET SESSION query_exec_time=1.4; | |
1367 | +SELECT 1; | |
1368 | +1 | |
1369 | +1 | |
1370 | +SET SESSION query_exec_time=0.5; | |
1371 | +SELECT 1; | |
1372 | +1 | |
1373 | +1 | |
1374 | +SET SESSION query_exec_time=2.1; | |
1375 | +SELECT 1; | |
1376 | +1 | |
1377 | +1 | |
1378 | +SET SESSION query_exec_time=2.3; | |
1379 | +SELECT 1; | |
1380 | +1 | |
1381 | +1 | |
1382 | +SET SESSION query_exec_time=2.5; | |
1383 | +SELECT 1; | |
1384 | +1 | |
1385 | +1 | |
1386 | +SET SESSION query_exec_time=3.1; | |
1387 | +SELECT 1; | |
1388 | +1 | |
1389 | +1 | |
1390 | +SET SESSION query_exec_time=4.1; | |
1391 | +SELECT 1; | |
1392 | +1 | |
1393 | +1 | |
1394 | +SET SESSION query_exec_time=5.1; | |
1395 | +SELECT 1; | |
1396 | +1 | |
1397 | +1 | |
1398 | +SET SESSION query_exec_time=0.1; | |
1399 | +SET GLOBAL QUERY_RESPONSE_TIME_STATS=0; | |
1400 | +SHOW GLOBAL VARIABLES where Variable_name like 'QUERY_RESPONSE_TIME_RANGE_BASE'; | |
1401 | +Variable_name Value | |
1402 | +query_response_time_range_base 2 | |
1403 | +SHOW QUERY_RESPONSE_TIME; | |
1404 | + | |
734d6226 | 1405 | + 0.000001 24 0.000000 |
48b678b4 AM |
1406 | + 0.000003 0 0.000000 |
1407 | + 0.000007 0 0.000000 | |
1408 | + 0.000015 0 0.000000 | |
1409 | + 0.000030 0 0.000000 | |
1410 | + 0.000061 0 0.000000 | |
1411 | + 0.000122 0 0.000000 | |
1412 | + 0.000244 0 0.000000 | |
1413 | + 0.000488 0 0.000000 | |
1414 | + 0.000976 0 0.000000 | |
1415 | + 0.001953 0 0.000000 | |
1416 | + 0.003906 0 0.000000 | |
1417 | + 0.007812 0 0.000000 | |
1418 | + 0.015625 0 0.000000 | |
1419 | + 0.031250 0 0.000000 | |
1420 | + 0.062500 0 0.000000 | |
734d6226 | 1421 | + 0.125000 0 0.000000 |
48b678b4 AM |
1422 | + 0.250000 0 0.000000 |
1423 | + 0.500000 10 3.550000 | |
1424 | + 1.000000 1 0.500000 | |
1425 | + 2.000000 5 6.500000 | |
1426 | + 4.000000 4 10.000000 | |
1427 | + 8.000000 2 9.199999 | |
1428 | + 16.000000 0 0.000000 | |
1429 | + 32.000000 0 0.000000 | |
1430 | + 64.000000 0 0.000000 | |
1431 | + 128.000000 0 0.000000 | |
1432 | + 256.000000 0 0.000000 | |
1433 | + 512.000000 0 0.000000 | |
1434 | + 1024.000000 0 0.000000 | |
1435 | + 2048.000000 0 0.000000 | |
1436 | + 4096.000000 0 0.000000 | |
1437 | + 8192.000000 0 0.000000 | |
1438 | + 16384.000000 0 0.000000 | |
1439 | + 32768.000000 0 0.000000 | |
1440 | + 65536.000000 0 0.000000 | |
1441 | + 131072.000000 0 0.000000 | |
1442 | + 262144.000000 0 0.000000 | |
1443 | + 524288.000000 0 0.000000 | |
9dd04cbc AM |
1444 | +1048576.000000 0 0.000000 |
1445 | +2097152.000000 0 0.000000 | |
1446 | +4194304.000000 0 0.000000 | |
1447 | +8388608.000000 0 0.000000 | |
48b678b4 AM |
1448 | +TOO LONG 0 TOO LONG |
1449 | +SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME; | |
1450 | +time count total | |
734d6226 | 1451 | + 0.000001 24 0.000000 |
48b678b4 AM |
1452 | + 0.000003 0 0.000000 |
1453 | + 0.000007 0 0.000000 | |
1454 | + 0.000015 0 0.000000 | |
1455 | + 0.000030 0 0.000000 | |
1456 | + 0.000061 0 0.000000 | |
1457 | + 0.000122 0 0.000000 | |
1458 | + 0.000244 0 0.000000 | |
1459 | + 0.000488 0 0.000000 | |
1460 | + 0.000976 0 0.000000 | |
1461 | + 0.001953 0 0.000000 | |
1462 | + 0.003906 0 0.000000 | |
1463 | + 0.007812 0 0.000000 | |
1464 | + 0.015625 0 0.000000 | |
1465 | + 0.031250 0 0.000000 | |
1466 | + 0.062500 0 0.000000 | |
734d6226 | 1467 | + 0.125000 0 0.000000 |
48b678b4 AM |
1468 | + 0.250000 0 0.000000 |
1469 | + 0.500000 10 3.550000 | |
1470 | + 1.000000 1 0.500000 | |
1471 | + 2.000000 5 6.500000 | |
1472 | + 4.000000 4 10.000000 | |
1473 | + 8.000000 2 9.199999 | |
1474 | + 16.000000 0 0.000000 | |
1475 | + 32.000000 0 0.000000 | |
1476 | + 64.000000 0 0.000000 | |
1477 | + 128.000000 0 0.000000 | |
1478 | + 256.000000 0 0.000000 | |
1479 | + 512.000000 0 0.000000 | |
1480 | + 1024.000000 0 0.000000 | |
1481 | + 2048.000000 0 0.000000 | |
1482 | + 4096.000000 0 0.000000 | |
1483 | + 8192.000000 0 0.000000 | |
1484 | + 16384.000000 0 0.000000 | |
1485 | + 32768.000000 0 0.000000 | |
1486 | + 65536.000000 0 0.000000 | |
1487 | + 131072.000000 0 0.000000 | |
1488 | + 262144.000000 0 0.000000 | |
1489 | + 524288.000000 0 0.000000 | |
9dd04cbc AM |
1490 | +1048576.000000 0 0.000000 |
1491 | +2097152.000000 0 0.000000 | |
1492 | +4194304.000000 0 0.000000 | |
1493 | +8388608.000000 0 0.000000 | |
48b678b4 AM |
1494 | +TOO LONG 0 TOO LONG |
1495 | +SET SESSION query_exec_time=default; | |
1496 | +SET SESSION query_exec_time=0.1; | |
1497 | +SET GLOBAL QUERY_RESPONSE_TIME_STATS=0; | |
1498 | +SET GLOBAL QUERY_RESPONSE_TIME_RANGE_BASE=10; | |
1499 | +FLUSH QUERY_RESPONSE_TIME; | |
734d6226 AM |
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 | |
9dd04cbc | 1514 | +1000000.000000 0 0.000000 |
734d6226 AM |
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 | |
9dd04cbc | 1530 | +1000000.000000 0 0.000000 |
734d6226 | 1531 | +TOO LONG 0 TOO LONG |
48b678b4 AM |
1532 | +SET GLOBAL QUERY_RESPONSE_TIME_STATS=1; |
1533 | +SET SESSION query_exec_time=0.31; | |
1534 | +SELECT 1; | |
1535 | +1 | |
1536 | +1 | |
1537 | +SET SESSION query_exec_time=0.32; | |
1538 | +SELECT 1; | |
1539 | +1 | |
1540 | +1 | |
1541 | +SET SESSION query_exec_time=0.33; | |
1542 | +SELECT 1; | |
1543 | +1 | |
1544 | +1 | |
1545 | +SET SESSION query_exec_time=0.34; | |
1546 | +SELECT 1; | |
1547 | +1 | |
1548 | +1 | |
1549 | +SET SESSION query_exec_time=0.35; | |
1550 | +SELECT 1; | |
1551 | +1 | |
1552 | +1 | |
1553 | +SET SESSION query_exec_time=0.36; | |
1554 | +SELECT 1; | |
1555 | +1 | |
1556 | +1 | |
1557 | +SET SESSION query_exec_time=0.37; | |
1558 | +SELECT 1; | |
1559 | +1 | |
1560 | +1 | |
1561 | +SET SESSION query_exec_time=0.38; | |
1562 | +SELECT 1; | |
1563 | +1 | |
1564 | +1 | |
1565 | +SET SESSION query_exec_time=0.39; | |
1566 | +SELECT 1; | |
1567 | +1 | |
1568 | +1 | |
1569 | +SET SESSION query_exec_time=0.4; | |
1570 | +SELECT 1; | |
1571 | +1 | |
1572 | +1 | |
1573 | +SET SESSION query_exec_time=1.1; | |
1574 | +SELECT 1; | |
1575 | +1 | |
1576 | +1 | |
1577 | +SET SESSION query_exec_time=1.2; | |
1578 | +SELECT 1; | |
1579 | +1 | |
1580 | +1 | |
1581 | +SET SESSION query_exec_time=1.3; | |
1582 | +SELECT 1; | |
1583 | +1 | |
1584 | +1 | |
1585 | +SET SESSION query_exec_time=1.5; | |
1586 | +SELECT 1; | |
1587 | +1 | |
1588 | +1 | |
1589 | +SET SESSION query_exec_time=1.4; | |
1590 | +SELECT 1; | |
1591 | +1 | |
1592 | +1 | |
1593 | +SET SESSION query_exec_time=0.5; | |
1594 | +SELECT 1; | |
1595 | +1 | |
1596 | +1 | |
1597 | +SET SESSION query_exec_time=2.1; | |
1598 | +SELECT 1; | |
1599 | +1 | |
1600 | +1 | |
1601 | +SET SESSION query_exec_time=2.3; | |
1602 | +SELECT 1; | |
1603 | +1 | |
1604 | +1 | |
1605 | +SET SESSION query_exec_time=2.5; | |
1606 | +SELECT 1; | |
1607 | +1 | |
1608 | +1 | |
1609 | +SET SESSION query_exec_time=3.1; | |
1610 | +SELECT 1; | |
1611 | +1 | |
1612 | +1 | |
1613 | +SET SESSION query_exec_time=4.1; | |
1614 | +SELECT 1; | |
1615 | +1 | |
1616 | +1 | |
1617 | +SET SESSION query_exec_time=5.1; | |
1618 | +SELECT 1; | |
1619 | +1 | |
1620 | +1 | |
1621 | +SET SESSION query_exec_time=0.1; | |
1622 | +SET GLOBAL QUERY_RESPONSE_TIME_STATS=0; | |
1623 | +SHOW GLOBAL VARIABLES where Variable_name like 'QUERY_RESPONSE_TIME_RANGE_BASE'; | |
1624 | +Variable_name Value | |
1625 | +query_response_time_range_base 10 | |
1626 | +SHOW QUERY_RESPONSE_TIME; | |
1627 | + | |
734d6226 | 1628 | + 0.000001 24 0.000000 |
48b678b4 AM |
1629 | + 0.000010 0 0.000000 |
1630 | + 0.000100 0 0.000000 | |
1631 | + 0.001000 0 0.000000 | |
1632 | + 0.010000 0 0.000000 | |
1633 | + 0.100000 0 0.000000 | |
734d6226 | 1634 | + 1.000000 11 4.050000 |
48b678b4 AM |
1635 | + 10.000000 11 25.699999 |
1636 | + 100.000000 0 0.000000 | |
1637 | + 1000.000000 0 0.000000 | |
1638 | + 10000.000000 0 0.000000 | |
1639 | + 100000.000000 0 0.000000 | |
9dd04cbc | 1640 | +1000000.000000 0 0.000000 |
48b678b4 AM |
1641 | +TOO LONG 0 TOO LONG |
1642 | +SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME; | |
1643 | +time count total | |
734d6226 | 1644 | + 0.000001 24 0.000000 |
48b678b4 AM |
1645 | + 0.000010 0 0.000000 |
1646 | + 0.000100 0 0.000000 | |
1647 | + 0.001000 0 0.000000 | |
1648 | + 0.010000 0 0.000000 | |
1649 | + 0.100000 0 0.000000 | |
734d6226 | 1650 | + 1.000000 11 4.050000 |
48b678b4 AM |
1651 | + 10.000000 11 25.699999 |
1652 | + 100.000000 0 0.000000 | |
1653 | + 1000.000000 0 0.000000 | |
1654 | + 10000.000000 0 0.000000 | |
1655 | + 100000.000000 0 0.000000 | |
9dd04cbc | 1656 | +1000000.000000 0 0.000000 |
48b678b4 AM |
1657 | +TOO LONG 0 TOO LONG |
1658 | +SET SESSION query_exec_time=default; | |
1659 | +SET SESSION query_exec_time=0.1; | |
1660 | +SET GLOBAL QUERY_RESPONSE_TIME_STATS=0; | |
1661 | +SET GLOBAL QUERY_RESPONSE_TIME_RANGE_BASE=7; | |
1662 | +FLUSH QUERY_RESPONSE_TIME; | |
734d6226 AM |
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 | |
9dd04cbc | 1680 | +5764801.000000 0 0.000000 |
734d6226 AM |
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 | |
9dd04cbc | 1699 | +5764801.000000 0 0.000000 |
734d6226 | 1700 | +TOO LONG 0 TOO LONG |
48b678b4 AM |
1701 | +SET GLOBAL QUERY_RESPONSE_TIME_STATS=1; |
1702 | +SET SESSION query_exec_time=0.31; | |
1703 | +SELECT 1; | |
1704 | +1 | |
1705 | +1 | |
1706 | +SET SESSION query_exec_time=0.32; | |
1707 | +SELECT 1; | |
1708 | +1 | |
1709 | +1 | |
1710 | +SET SESSION query_exec_time=0.33; | |
1711 | +SELECT 1; | |
1712 | +1 | |
1713 | +1 | |
1714 | +SET SESSION query_exec_time=0.34; | |
1715 | +SELECT 1; | |
1716 | +1 | |
1717 | +1 | |
1718 | +SET SESSION query_exec_time=0.35; | |
1719 | +SELECT 1; | |
1720 | +1 | |
1721 | +1 | |
1722 | +SET SESSION query_exec_time=0.36; | |
1723 | +SELECT 1; | |
1724 | +1 | |
1725 | +1 | |
1726 | +SET SESSION query_exec_time=0.37; | |
1727 | +SELECT 1; | |
1728 | +1 | |
1729 | +1 | |
1730 | +SET SESSION query_exec_time=0.38; | |
1731 | +SELECT 1; | |
1732 | +1 | |
1733 | +1 | |
1734 | +SET SESSION query_exec_time=0.39; | |
1735 | +SELECT 1; | |
1736 | +1 | |
1737 | +1 | |
1738 | +SET SESSION query_exec_time=0.4; | |
1739 | +SELECT 1; | |
1740 | +1 | |
1741 | +1 | |
1742 | +SET SESSION query_exec_time=1.1; | |
1743 | +SELECT 1; | |
1744 | +1 | |
1745 | +1 | |
1746 | +SET SESSION query_exec_time=1.2; | |
1747 | +SELECT 1; | |
1748 | +1 | |
1749 | +1 | |
1750 | +SET SESSION query_exec_time=1.3; | |
1751 | +SELECT 1; | |
1752 | +1 | |
1753 | +1 | |
1754 | +SET SESSION query_exec_time=1.5; | |
1755 | +SELECT 1; | |
1756 | +1 | |
1757 | +1 | |
1758 | +SET SESSION query_exec_time=1.4; | |
1759 | +SELECT 1; | |
1760 | +1 | |
1761 | +1 | |
1762 | +SET SESSION query_exec_time=0.5; | |
1763 | +SELECT 1; | |
1764 | +1 | |
1765 | +1 | |
1766 | +SET SESSION query_exec_time=2.1; | |
1767 | +SELECT 1; | |
1768 | +1 | |
1769 | +1 | |
1770 | +SET SESSION query_exec_time=2.3; | |
1771 | +SELECT 1; | |
1772 | +1 | |
1773 | +1 | |
1774 | +SET SESSION query_exec_time=2.5; | |
1775 | +SELECT 1; | |
1776 | +1 | |
1777 | +1 | |
1778 | +SET SESSION query_exec_time=3.1; | |
1779 | +SELECT 1; | |
1780 | +1 | |
1781 | +1 | |
1782 | +SET SESSION query_exec_time=4.1; | |
1783 | +SELECT 1; | |
1784 | +1 | |
1785 | +1 | |
1786 | +SET SESSION query_exec_time=5.1; | |
1787 | +SELECT 1; | |
1788 | +1 | |
1789 | +1 | |
1790 | +SET SESSION query_exec_time=0.1; | |
1791 | +SET GLOBAL QUERY_RESPONSE_TIME_STATS=0; | |
1792 | +SHOW GLOBAL VARIABLES where Variable_name like 'QUERY_RESPONSE_TIME_RANGE_BASE'; | |
1793 | +Variable_name Value | |
1794 | +query_response_time_range_base 7 | |
1795 | +SHOW QUERY_RESPONSE_TIME; | |
1796 | + | |
734d6226 | 1797 | + 0.000001 24 0.000000 |
48b678b4 AM |
1798 | + 0.000008 0 0.000000 |
1799 | + 0.000059 0 0.000000 | |
1800 | + 0.000416 0 0.000000 | |
1801 | + 0.002915 0 0.000000 | |
1802 | + 0.020408 0 0.000000 | |
734d6226 | 1803 | + 0.142857 0 0.000000 |
48b678b4 AM |
1804 | + 1.000000 11 4.050000 |
1805 | + 7.000000 11 25.699999 | |
1806 | + 49.000000 0 0.000000 | |
1807 | + 343.000000 0 0.000000 | |
1808 | + 2401.000000 0 0.000000 | |
1809 | + 16807.000000 0 0.000000 | |
1810 | + 117649.000000 0 0.000000 | |
1811 | + 823543.000000 0 0.000000 | |
9dd04cbc | 1812 | +5764801.000000 0 0.000000 |
48b678b4 AM |
1813 | +TOO LONG 0 TOO LONG |
1814 | +SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME; | |
1815 | +time count total | |
734d6226 | 1816 | + 0.000001 24 0.000000 |
48b678b4 AM |
1817 | + 0.000008 0 0.000000 |
1818 | + 0.000059 0 0.000000 | |
1819 | + 0.000416 0 0.000000 | |
1820 | + 0.002915 0 0.000000 | |
1821 | + 0.020408 0 0.000000 | |
734d6226 | 1822 | + 0.142857 0 0.000000 |
48b678b4 AM |
1823 | + 1.000000 11 4.050000 |
1824 | + 7.000000 11 25.699999 | |
1825 | + 49.000000 0 0.000000 | |
1826 | + 343.000000 0 0.000000 | |
1827 | + 2401.000000 0 0.000000 | |
1828 | + 16807.000000 0 0.000000 | |
1829 | + 117649.000000 0 0.000000 | |
1830 | + 823543.000000 0 0.000000 | |
9dd04cbc | 1831 | +5764801.000000 0 0.000000 |
48b678b4 AM |
1832 | +TOO LONG 0 TOO LONG |
1833 | +SET SESSION query_exec_time=default; | |
1834 | +SET SESSION query_exec_time=0.1; | |
1835 | +SET GLOBAL QUERY_RESPONSE_TIME_STATS=0; | |
1836 | +SET GLOBAL QUERY_RESPONSE_TIME_RANGE_BASE=156; | |
1837 | +FLUSH QUERY_RESPONSE_TIME; | |
734d6226 AM |
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 | |
9dd04cbc | 1845 | +3796416.000000 0 0.000000 |
734d6226 AM |
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 | |
9dd04cbc | 1854 | +3796416.000000 0 0.000000 |
734d6226 | 1855 | +TOO LONG 0 TOO LONG |
48b678b4 AM |
1856 | +SET GLOBAL QUERY_RESPONSE_TIME_STATS=1; |
1857 | +SET SESSION query_exec_time=0.31; | |
1858 | +SELECT 1; | |
1859 | +1 | |
1860 | +1 | |
1861 | +SET SESSION query_exec_time=0.32; | |
1862 | +SELECT 1; | |
1863 | +1 | |
1864 | +1 | |
1865 | +SET SESSION query_exec_time=0.33; | |
1866 | +SELECT 1; | |
1867 | +1 | |
1868 | +1 | |
1869 | +SET SESSION query_exec_time=0.34; | |
1870 | +SELECT 1; | |
1871 | +1 | |
1872 | +1 | |
1873 | +SET SESSION query_exec_time=0.35; | |
1874 | +SELECT 1; | |
1875 | +1 | |
1876 | +1 | |
1877 | +SET SESSION query_exec_time=0.36; | |
1878 | +SELECT 1; | |
1879 | +1 | |
1880 | +1 | |
1881 | +SET SESSION query_exec_time=0.37; | |
1882 | +SELECT 1; | |
1883 | +1 | |
1884 | +1 | |
1885 | +SET SESSION query_exec_time=0.38; | |
1886 | +SELECT 1; | |
1887 | +1 | |
1888 | +1 | |
1889 | +SET SESSION query_exec_time=0.39; | |
1890 | +SELECT 1; | |
1891 | +1 | |
1892 | +1 | |
1893 | +SET SESSION query_exec_time=0.4; | |
1894 | +SELECT 1; | |
1895 | +1 | |
1896 | +1 | |
1897 | +SET SESSION query_exec_time=1.1; | |
1898 | +SELECT 1; | |
1899 | +1 | |
1900 | +1 | |
1901 | +SET SESSION query_exec_time=1.2; | |
1902 | +SELECT 1; | |
1903 | +1 | |
1904 | +1 | |
1905 | +SET SESSION query_exec_time=1.3; | |
1906 | +SELECT 1; | |
1907 | +1 | |
1908 | +1 | |
1909 | +SET SESSION query_exec_time=1.5; | |
1910 | +SELECT 1; | |
1911 | +1 | |
1912 | +1 | |
1913 | +SET SESSION query_exec_time=1.4; | |
1914 | +SELECT 1; | |
1915 | +1 | |
1916 | +1 | |
1917 | +SET SESSION query_exec_time=0.5; | |
1918 | +SELECT 1; | |
1919 | +1 | |
1920 | +1 | |
1921 | +SET SESSION query_exec_time=2.1; | |
1922 | +SELECT 1; | |
1923 | +1 | |
1924 | +1 | |
1925 | +SET SESSION query_exec_time=2.3; | |
1926 | +SELECT 1; | |
1927 | +1 | |
1928 | +1 | |
1929 | +SET SESSION query_exec_time=2.5; | |
1930 | +SELECT 1; | |
1931 | +1 | |
1932 | +1 | |
1933 | +SET SESSION query_exec_time=3.1; | |
1934 | +SELECT 1; | |
1935 | +1 | |
1936 | +1 | |
1937 | +SET SESSION query_exec_time=4.1; | |
1938 | +SELECT 1; | |
1939 | +1 | |
1940 | +1 | |
1941 | +SET SESSION query_exec_time=5.1; | |
1942 | +SELECT 1; | |
1943 | +1 | |
1944 | +1 | |
1945 | +SET SESSION query_exec_time=0.1; | |
1946 | +SET GLOBAL QUERY_RESPONSE_TIME_STATS=0; | |
1947 | +SHOW GLOBAL VARIABLES where Variable_name like 'QUERY_RESPONSE_TIME_RANGE_BASE'; | |
1948 | +Variable_name Value | |
1949 | +query_response_time_range_base 156 | |
1950 | +SHOW QUERY_RESPONSE_TIME; | |
1951 | + | |
734d6226 | 1952 | + 0.000041 24 0.000000 |
48b678b4 | 1953 | + 0.006410 0 0.000000 |
734d6226 | 1954 | + 1.000000 11 4.050000 |
48b678b4 AM |
1955 | + 156.000000 11 25.699999 |
1956 | + 24336.000000 0 0.000000 | |
9dd04cbc | 1957 | +3796416.000000 0 0.000000 |
48b678b4 AM |
1958 | +TOO LONG 0 TOO LONG |
1959 | +SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME; | |
1960 | +time count total | |
734d6226 | 1961 | + 0.000041 24 0.000000 |
48b678b4 | 1962 | + 0.006410 0 0.000000 |
734d6226 | 1963 | + 1.000000 11 4.050000 |
48b678b4 AM |
1964 | + 156.000000 11 25.699999 |
1965 | + 24336.000000 0 0.000000 | |
9dd04cbc | 1966 | +3796416.000000 0 0.000000 |
48b678b4 AM |
1967 | +TOO LONG 0 TOO LONG |
1968 | +SET SESSION query_exec_time=default; | |
1969 | +SET SESSION query_exec_time=0.1; | |
1970 | +SET GLOBAL QUERY_RESPONSE_TIME_STATS=0; | |
1971 | +SET GLOBAL QUERY_RESPONSE_TIME_RANGE_BASE=1000; | |
1972 | +FLUSH QUERY_RESPONSE_TIME; | |
734d6226 AM |
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 | |
9dd04cbc | 1979 | +1000000.000000 0 0.000000 |
734d6226 AM |
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 | |
9dd04cbc | 1987 | +1000000.000000 0 0.000000 |
734d6226 | 1988 | +TOO LONG 0 TOO LONG |
48b678b4 AM |
1989 | +SET GLOBAL QUERY_RESPONSE_TIME_STATS=1; |
1990 | +SET SESSION query_exec_time=0.31; | |
1991 | +SELECT 1; | |
1992 | +1 | |
1993 | +1 | |
1994 | +SET SESSION query_exec_time=0.32; | |
1995 | +SELECT 1; | |
1996 | +1 | |
1997 | +1 | |
1998 | +SET SESSION query_exec_time=0.33; | |
1999 | +SELECT 1; | |
2000 | +1 | |
2001 | +1 | |
2002 | +SET SESSION query_exec_time=0.34; | |
2003 | +SELECT 1; | |
2004 | +1 | |
2005 | +1 | |
2006 | +SET SESSION query_exec_time=0.35; | |
2007 | +SELECT 1; | |
2008 | +1 | |
2009 | +1 | |
2010 | +SET SESSION query_exec_time=0.36; | |
2011 | +SELECT 1; | |
2012 | +1 | |
2013 | +1 | |
2014 | +SET SESSION query_exec_time=0.37; | |
2015 | +SELECT 1; | |
2016 | +1 | |
2017 | +1 | |
2018 | +SET SESSION query_exec_time=0.38; | |
2019 | +SELECT 1; | |
2020 | +1 | |
2021 | +1 | |
2022 | +SET SESSION query_exec_time=0.39; | |
2023 | +SELECT 1; | |
2024 | +1 | |
2025 | +1 | |
2026 | +SET SESSION query_exec_time=0.4; | |
2027 | +SELECT 1; | |
2028 | +1 | |
2029 | +1 | |
2030 | +SET SESSION query_exec_time=1.1; | |
2031 | +SELECT 1; | |
2032 | +1 | |
2033 | +1 | |
2034 | +SET SESSION query_exec_time=1.2; | |
2035 | +SELECT 1; | |
2036 | +1 | |
2037 | +1 | |
2038 | +SET SESSION query_exec_time=1.3; | |
2039 | +SELECT 1; | |
2040 | +1 | |
2041 | +1 | |
2042 | +SET SESSION query_exec_time=1.5; | |
2043 | +SELECT 1; | |
2044 | +1 | |
2045 | +1 | |
2046 | +SET SESSION query_exec_time=1.4; | |
2047 | +SELECT 1; | |
2048 | +1 | |
2049 | +1 | |
2050 | +SET SESSION query_exec_time=0.5; | |
2051 | +SELECT 1; | |
2052 | +1 | |
2053 | +1 | |
2054 | +SET SESSION query_exec_time=2.1; | |
2055 | +SELECT 1; | |
2056 | +1 | |
2057 | +1 | |
2058 | +SET SESSION query_exec_time=2.3; | |
2059 | +SELECT 1; | |
2060 | +1 | |
2061 | +1 | |
2062 | +SET SESSION query_exec_time=2.5; | |
2063 | +SELECT 1; | |
2064 | +1 | |
2065 | +1 | |
2066 | +SET SESSION query_exec_time=3.1; | |
2067 | +SELECT 1; | |
2068 | +1 | |
2069 | +1 | |
2070 | +SET SESSION query_exec_time=4.1; | |
2071 | +SELECT 1; | |
2072 | +1 | |
2073 | +1 | |
2074 | +SET SESSION query_exec_time=5.1; | |
2075 | +SELECT 1; | |
2076 | +1 | |
2077 | +1 | |
2078 | +SET SESSION query_exec_time=0.1; | |
2079 | +SET GLOBAL QUERY_RESPONSE_TIME_STATS=0; | |
2080 | +SHOW GLOBAL VARIABLES where Variable_name like 'QUERY_RESPONSE_TIME_RANGE_BASE'; | |
2081 | +Variable_name Value | |
2082 | +query_response_time_range_base 1000 | |
2083 | +SHOW QUERY_RESPONSE_TIME; | |
2084 | + | |
734d6226 | 2085 | + 0.000001 24 0.000000 |
48b678b4 | 2086 | + 0.001000 0 0.000000 |
734d6226 | 2087 | + 1.000000 11 4.050000 |
48b678b4 | 2088 | + 1000.000000 11 25.699999 |
9dd04cbc | 2089 | +1000000.000000 0 0.000000 |
48b678b4 AM |
2090 | +TOO LONG 0 TOO LONG |
2091 | +SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME; | |
2092 | +time count total | |
734d6226 | 2093 | + 0.000001 24 0.000000 |
48b678b4 | 2094 | + 0.001000 0 0.000000 |
734d6226 | 2095 | + 1.000000 11 4.050000 |
48b678b4 | 2096 | + 1000.000000 11 25.699999 |
9dd04cbc | 2097 | +1000000.000000 0 0.000000 |
48b678b4 AM |
2098 | +TOO LONG 0 TOO LONG |
2099 | +SET SESSION query_exec_time=default; | |
2100 | +SET SESSION query_exec_time=0.1; | |
2101 | +SET GLOBAL QUERY_RESPONSE_TIME_STATS=0; | |
2102 | +SET GLOBAL QUERY_RESPONSE_TIME_RANGE_BASE=1001; | |
2103 | +Warnings: | |
2104 | +Warning 1292 Truncated incorrect query_response_time_range_base value: '1001' | |
2105 | +FLUSH QUERY_RESPONSE_TIME; | |
734d6226 AM |
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 | |
9dd04cbc | 2112 | +1000000.000000 0 0.000000 |
734d6226 AM |
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 | |
9dd04cbc | 2120 | +1000000.000000 0 0.000000 |
734d6226 | 2121 | +TOO LONG 0 TOO LONG |
48b678b4 AM |
2122 | +SET GLOBAL QUERY_RESPONSE_TIME_STATS=1; |
2123 | +SET SESSION query_exec_time=0.31; | |
2124 | +SELECT 1; | |
2125 | +1 | |
2126 | +1 | |
2127 | +SET SESSION query_exec_time=0.32; | |
2128 | +SELECT 1; | |
2129 | +1 | |
2130 | +1 | |
2131 | +SET SESSION query_exec_time=0.33; | |
2132 | +SELECT 1; | |
2133 | +1 | |
2134 | +1 | |
2135 | +SET SESSION query_exec_time=0.34; | |
2136 | +SELECT 1; | |
2137 | +1 | |
2138 | +1 | |
2139 | +SET SESSION query_exec_time=0.35; | |
2140 | +SELECT 1; | |
2141 | +1 | |
2142 | +1 | |
2143 | +SET SESSION query_exec_time=0.36; | |
2144 | +SELECT 1; | |
2145 | +1 | |
2146 | +1 | |
2147 | +SET SESSION query_exec_time=0.37; | |
2148 | +SELECT 1; | |
2149 | +1 | |
2150 | +1 | |
2151 | +SET SESSION query_exec_time=0.38; | |
2152 | +SELECT 1; | |
2153 | +1 | |
2154 | +1 | |
2155 | +SET SESSION query_exec_time=0.39; | |
2156 | +SELECT 1; | |
2157 | +1 | |
2158 | +1 | |
2159 | +SET SESSION query_exec_time=0.4; | |
2160 | +SELECT 1; | |
2161 | +1 | |
2162 | +1 | |
2163 | +SET SESSION query_exec_time=1.1; | |
2164 | +SELECT 1; | |
2165 | +1 | |
2166 | +1 | |
2167 | +SET SESSION query_exec_time=1.2; | |
2168 | +SELECT 1; | |
2169 | +1 | |
2170 | +1 | |
2171 | +SET SESSION query_exec_time=1.3; | |
2172 | +SELECT 1; | |
2173 | +1 | |
2174 | +1 | |
2175 | +SET SESSION query_exec_time=1.5; | |
2176 | +SELECT 1; | |
2177 | +1 | |
2178 | +1 | |
2179 | +SET SESSION query_exec_time=1.4; | |
2180 | +SELECT 1; | |
2181 | +1 | |
2182 | +1 | |
2183 | +SET SESSION query_exec_time=0.5; | |
2184 | +SELECT 1; | |
2185 | +1 | |
2186 | +1 | |
2187 | +SET SESSION query_exec_time=2.1; | |
2188 | +SELECT 1; | |
2189 | +1 | |
2190 | +1 | |
2191 | +SET SESSION query_exec_time=2.3; | |
2192 | +SELECT 1; | |
2193 | +1 | |
2194 | +1 | |
2195 | +SET SESSION query_exec_time=2.5; | |
2196 | +SELECT 1; | |
2197 | +1 | |
2198 | +1 | |
2199 | +SET SESSION query_exec_time=3.1; | |
2200 | +SELECT 1; | |
2201 | +1 | |
2202 | +1 | |
2203 | +SET SESSION query_exec_time=4.1; | |
2204 | +SELECT 1; | |
2205 | +1 | |
2206 | +1 | |
2207 | +SET SESSION query_exec_time=5.1; | |
2208 | +SELECT 1; | |
2209 | +1 | |
2210 | +1 | |
2211 | +SET SESSION query_exec_time=0.1; | |
2212 | +SET GLOBAL QUERY_RESPONSE_TIME_STATS=0; | |
2213 | +SHOW GLOBAL VARIABLES where Variable_name like 'QUERY_RESPONSE_TIME_RANGE_BASE'; | |
2214 | +Variable_name Value | |
2215 | +query_response_time_range_base 1000 | |
2216 | +SHOW QUERY_RESPONSE_TIME; | |
2217 | + | |
734d6226 | 2218 | + 0.000001 24 0.000000 |
48b678b4 | 2219 | + 0.001000 0 0.000000 |
734d6226 | 2220 | + 1.000000 11 4.050000 |
48b678b4 | 2221 | + 1000.000000 11 25.699999 |
9dd04cbc | 2222 | +1000000.000000 0 0.000000 |
48b678b4 AM |
2223 | +TOO LONG 0 TOO LONG |
2224 | +SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME; | |
2225 | +time count total | |
734d6226 | 2226 | + 0.000001 24 0.000000 |
48b678b4 | 2227 | + 0.001000 0 0.000000 |
734d6226 | 2228 | + 1.000000 11 4.050000 |
48b678b4 | 2229 | + 1000.000000 11 25.699999 |
9dd04cbc | 2230 | +1000000.000000 0 0.000000 |
48b678b4 AM |
2231 | +TOO LONG 0 TOO LONG |
2232 | +SET SESSION query_exec_time=default; | |
2233 | +SET GLOBAL QUERY_RESPONSE_TIME_RANGE_BASE=default; | |
2234 | +SET GLOBAL QUERY_RESPONSE_TIME_STATS=default; | |
2235 | --- /dev/null | |
2236 | +++ b/mysql-test/r/percona_query_response_time-stored.result | |
2237 | @@ -0,0 +1,544 @@ | |
2238 | +CREATE TABLE t(a INT); | |
2239 | +CREATE PROCEDURE test_f(t DECIMAL(3,2)) | |
2240 | +BEGIN | |
2241 | +SET SESSION query_exec_time=t; | |
2242 | +INSERT INTO t VALUES(1); | |
2243 | +SET SESSION query_exec_time=0.1; | |
2244 | +DELETE FROM t; | |
2245 | +END^ | |
2246 | +SET SESSION query_exec_time=0.1; | |
2247 | +SET GLOBAL QUERY_RESPONSE_TIME_STATS=0; | |
2248 | +SET GLOBAL QUERY_RESPONSE_TIME_RANGE_BASE=1; | |
2249 | +Warnings: | |
2250 | +Warning 1292 Truncated incorrect query_response_time_range_base value: '1' | |
2251 | +FLUSH QUERY_RESPONSE_TIME; | |
2252 | +SET GLOBAL QUERY_RESPONSE_TIME_STATS=1; | |
2253 | +CALL test_f(0.31); | |
2254 | +CALL test_f(0.32); | |
2255 | +CALL test_f(0.33); | |
2256 | +CALL test_f(0.34); | |
2257 | +CALL test_f(0.35); | |
2258 | +CALL test_f(0.36); | |
2259 | +CALL test_f(0.37); | |
2260 | +CALL test_f(0.38); | |
2261 | +CALL test_f(0.39); | |
2262 | +CALL test_f(0.4); | |
2263 | +CALL test_f(1.1); | |
2264 | +CALL test_f(1.2); | |
2265 | +CALL test_f(1.3); | |
2266 | +CALL test_f(1.5); | |
2267 | +CALL test_f(1.4); | |
2268 | +CALL test_f(0.5); | |
2269 | +CALL test_f(2.1); | |
2270 | +CALL test_f(2.3); | |
2271 | +CALL test_f(2.5); | |
2272 | +CALL test_f(3.1); | |
2273 | +CALL test_f(4.1); | |
2274 | +CALL test_f(5.1); | |
2275 | +SET GLOBAL QUERY_RESPONSE_TIME_STATS=0; | |
2276 | +SHOW GLOBAL VARIABLES where Variable_name like 'QUERY_RESPONSE_TIME_RANGE_BASE'; | |
2277 | +Variable_name Value | |
2278 | +query_response_time_range_base 2 | |
2279 | +SHOW QUERY_RESPONSE_TIME; | |
2280 | + | |
734d6226 | 2281 | + 0.000001 45 0.000000 |
48b678b4 AM |
2282 | + 0.000003 0 0.000000 |
2283 | + 0.000007 0 0.000000 | |
2284 | + 0.000015 0 0.000000 | |
2285 | + 0.000030 0 0.000000 | |
2286 | + 0.000061 0 0.000000 | |
2287 | + 0.000122 0 0.000000 | |
2288 | + 0.000244 0 0.000000 | |
2289 | + 0.000488 0 0.000000 | |
2290 | + 0.000976 0 0.000000 | |
2291 | + 0.001953 0 0.000000 | |
2292 | + 0.003906 0 0.000000 | |
2293 | + 0.007812 0 0.000000 | |
2294 | + 0.015625 0 0.000000 | |
2295 | + 0.031250 0 0.000000 | |
2296 | + 0.062500 0 0.000000 | |
734d6226 | 2297 | + 0.125000 44 4.400000 |
48b678b4 AM |
2298 | + 0.250000 0 0.000000 |
2299 | + 0.500000 10 3.550000 | |
2300 | + 1.000000 1 0.500000 | |
2301 | + 2.000000 5 6.500000 | |
2302 | + 4.000000 4 10.000000 | |
2303 | + 8.000000 2 9.199999 | |
2304 | + 16.000000 0 0.000000 | |
2305 | + 32.000000 0 0.000000 | |
2306 | + 64.000000 0 0.000000 | |
2307 | + 128.000000 0 0.000000 | |
2308 | + 256.000000 0 0.000000 | |
2309 | + 512.000000 0 0.000000 | |
2310 | + 1024.000000 0 0.000000 | |
2311 | + 2048.000000 0 0.000000 | |
2312 | + 4096.000000 0 0.000000 | |
2313 | + 8192.000000 0 0.000000 | |
2314 | + 16384.000000 0 0.000000 | |
2315 | + 32768.000000 0 0.000000 | |
2316 | + 65536.000000 0 0.000000 | |
2317 | + 131072.000000 0 0.000000 | |
2318 | + 262144.000000 0 0.000000 | |
2319 | + 524288.000000 0 0.000000 | |
9dd04cbc AM |
2320 | +1048576.000000 0 0.000000 |
2321 | +2097152.000000 0 0.000000 | |
2322 | +4194304.000000 0 0.000000 | |
2323 | +8388608.000000 0 0.000000 | |
48b678b4 AM |
2324 | +TOO LONG 0 TOO LONG |
2325 | +SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME; | |
2326 | +time count total | |
734d6226 | 2327 | + 0.000001 45 0.000000 |
48b678b4 AM |
2328 | + 0.000003 0 0.000000 |
2329 | + 0.000007 0 0.000000 | |
2330 | + 0.000015 0 0.000000 | |
2331 | + 0.000030 0 0.000000 | |
2332 | + 0.000061 0 0.000000 | |
2333 | + 0.000122 0 0.000000 | |
2334 | + 0.000244 0 0.000000 | |
2335 | + 0.000488 0 0.000000 | |
2336 | + 0.000976 0 0.000000 | |
2337 | + 0.001953 0 0.000000 | |
2338 | + 0.003906 0 0.000000 | |
2339 | + 0.007812 0 0.000000 | |
2340 | + 0.015625 0 0.000000 | |
2341 | + 0.031250 0 0.000000 | |
2342 | + 0.062500 0 0.000000 | |
734d6226 | 2343 | + 0.125000 44 4.400000 |
48b678b4 AM |
2344 | + 0.250000 0 0.000000 |
2345 | + 0.500000 10 3.550000 | |
2346 | + 1.000000 1 0.500000 | |
2347 | + 2.000000 5 6.500000 | |
2348 | + 4.000000 4 10.000000 | |
2349 | + 8.000000 2 9.199999 | |
2350 | + 16.000000 0 0.000000 | |
2351 | + 32.000000 0 0.000000 | |
2352 | + 64.000000 0 0.000000 | |
2353 | + 128.000000 0 0.000000 | |
2354 | + 256.000000 0 0.000000 | |
2355 | + 512.000000 0 0.000000 | |
2356 | + 1024.000000 0 0.000000 | |
2357 | + 2048.000000 0 0.000000 | |
2358 | + 4096.000000 0 0.000000 | |
2359 | + 8192.000000 0 0.000000 | |
2360 | + 16384.000000 0 0.000000 | |
2361 | + 32768.000000 0 0.000000 | |
2362 | + 65536.000000 0 0.000000 | |
2363 | + 131072.000000 0 0.000000 | |
2364 | + 262144.000000 0 0.000000 | |
2365 | + 524288.000000 0 0.000000 | |
9dd04cbc AM |
2366 | +1048576.000000 0 0.000000 |
2367 | +2097152.000000 0 0.000000 | |
2368 | +4194304.000000 0 0.000000 | |
2369 | +8388608.000000 0 0.000000 | |
48b678b4 AM |
2370 | +TOO LONG 0 TOO LONG |
2371 | +SET SESSION query_exec_time=default; | |
2372 | +SET SESSION query_exec_time=0.1; | |
2373 | +SET GLOBAL QUERY_RESPONSE_TIME_STATS=0; | |
2374 | +SET GLOBAL QUERY_RESPONSE_TIME_RANGE_BASE=2; | |
2375 | +FLUSH QUERY_RESPONSE_TIME; | |
2376 | +SET GLOBAL QUERY_RESPONSE_TIME_STATS=1; | |
2377 | +CALL test_f(0.31); | |
2378 | +CALL test_f(0.32); | |
2379 | +CALL test_f(0.33); | |
2380 | +CALL test_f(0.34); | |
2381 | +CALL test_f(0.35); | |
2382 | +CALL test_f(0.36); | |
2383 | +CALL test_f(0.37); | |
2384 | +CALL test_f(0.38); | |
2385 | +CALL test_f(0.39); | |
2386 | +CALL test_f(0.4); | |
2387 | +CALL test_f(1.1); | |
2388 | +CALL test_f(1.2); | |
2389 | +CALL test_f(1.3); | |
2390 | +CALL test_f(1.5); | |
2391 | +CALL test_f(1.4); | |
2392 | +CALL test_f(0.5); | |
2393 | +CALL test_f(2.1); | |
2394 | +CALL test_f(2.3); | |
2395 | +CALL test_f(2.5); | |
2396 | +CALL test_f(3.1); | |
2397 | +CALL test_f(4.1); | |
2398 | +CALL test_f(5.1); | |
2399 | +SET GLOBAL QUERY_RESPONSE_TIME_STATS=0; | |
2400 | +SHOW GLOBAL VARIABLES where Variable_name like 'QUERY_RESPONSE_TIME_RANGE_BASE'; | |
2401 | +Variable_name Value | |
2402 | +query_response_time_range_base 2 | |
2403 | +SHOW QUERY_RESPONSE_TIME; | |
2404 | + | |
734d6226 | 2405 | + 0.000001 45 0.000000 |
48b678b4 AM |
2406 | + 0.000003 0 0.000000 |
2407 | + 0.000007 0 0.000000 | |
2408 | + 0.000015 0 0.000000 | |
2409 | + 0.000030 0 0.000000 | |
2410 | + 0.000061 0 0.000000 | |
2411 | + 0.000122 0 0.000000 | |
2412 | + 0.000244 0 0.000000 | |
2413 | + 0.000488 0 0.000000 | |
2414 | + 0.000976 0 0.000000 | |
2415 | + 0.001953 0 0.000000 | |
2416 | + 0.003906 0 0.000000 | |
2417 | + 0.007812 0 0.000000 | |
2418 | + 0.015625 0 0.000000 | |
2419 | + 0.031250 0 0.000000 | |
2420 | + 0.062500 0 0.000000 | |
734d6226 | 2421 | + 0.125000 44 4.400000 |
48b678b4 AM |
2422 | + 0.250000 0 0.000000 |
2423 | + 0.500000 10 3.550000 | |
2424 | + 1.000000 1 0.500000 | |
2425 | + 2.000000 5 6.500000 | |
2426 | + 4.000000 4 10.000000 | |
2427 | + 8.000000 2 9.199999 | |
2428 | + 16.000000 0 0.000000 | |
2429 | + 32.000000 0 0.000000 | |
2430 | + 64.000000 0 0.000000 | |
2431 | + 128.000000 0 0.000000 | |
2432 | + 256.000000 0 0.000000 | |
2433 | + 512.000000 0 0.000000 | |
2434 | + 1024.000000 0 0.000000 | |
2435 | + 2048.000000 0 0.000000 | |
2436 | + 4096.000000 0 0.000000 | |
2437 | + 8192.000000 0 0.000000 | |
2438 | + 16384.000000 0 0.000000 | |
2439 | + 32768.000000 0 0.000000 | |
2440 | + 65536.000000 0 0.000000 | |
2441 | + 131072.000000 0 0.000000 | |
2442 | + 262144.000000 0 0.000000 | |
2443 | + 524288.000000 0 0.000000 | |
9dd04cbc AM |
2444 | +1048576.000000 0 0.000000 |
2445 | +2097152.000000 0 0.000000 | |
2446 | +4194304.000000 0 0.000000 | |
2447 | +8388608.000000 0 0.000000 | |
48b678b4 AM |
2448 | +TOO LONG 0 TOO LONG |
2449 | +SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME; | |
2450 | +time count total | |
734d6226 | 2451 | + 0.000001 45 0.000000 |
48b678b4 AM |
2452 | + 0.000003 0 0.000000 |
2453 | + 0.000007 0 0.000000 | |
2454 | + 0.000015 0 0.000000 | |
2455 | + 0.000030 0 0.000000 | |
2456 | + 0.000061 0 0.000000 | |
2457 | + 0.000122 0 0.000000 | |
2458 | + 0.000244 0 0.000000 | |
2459 | + 0.000488 0 0.000000 | |
2460 | + 0.000976 0 0.000000 | |
2461 | + 0.001953 0 0.000000 | |
2462 | + 0.003906 0 0.000000 | |
2463 | + 0.007812 0 0.000000 | |
2464 | + 0.015625 0 0.000000 | |
2465 | + 0.031250 0 0.000000 | |
2466 | + 0.062500 0 0.000000 | |
734d6226 | 2467 | + 0.125000 44 4.400000 |
48b678b4 AM |
2468 | + 0.250000 0 0.000000 |
2469 | + 0.500000 10 3.550000 | |
2470 | + 1.000000 1 0.500000 | |
2471 | + 2.000000 5 6.500000 | |
2472 | + 4.000000 4 10.000000 | |
2473 | + 8.000000 2 9.199999 | |
2474 | + 16.000000 0 0.000000 | |
2475 | + 32.000000 0 0.000000 | |
2476 | + 64.000000 0 0.000000 | |
2477 | + 128.000000 0 0.000000 | |
2478 | + 256.000000 0 0.000000 | |
2479 | + 512.000000 0 0.000000 | |
2480 | + 1024.000000 0 0.000000 | |
2481 | + 2048.000000 0 0.000000 | |
2482 | + 4096.000000 0 0.000000 | |
2483 | + 8192.000000 0 0.000000 | |
2484 | + 16384.000000 0 0.000000 | |
2485 | + 32768.000000 0 0.000000 | |
2486 | + 65536.000000 0 0.000000 | |
2487 | + 131072.000000 0 0.000000 | |
2488 | + 262144.000000 0 0.000000 | |
2489 | + 524288.000000 0 0.000000 | |
9dd04cbc AM |
2490 | +1048576.000000 0 0.000000 |
2491 | +2097152.000000 0 0.000000 | |
2492 | +4194304.000000 0 0.000000 | |
2493 | +8388608.000000 0 0.000000 | |
48b678b4 AM |
2494 | +TOO LONG 0 TOO LONG |
2495 | +SET SESSION query_exec_time=default; | |
2496 | +SET SESSION query_exec_time=0.1; | |
2497 | +SET GLOBAL QUERY_RESPONSE_TIME_STATS=0; | |
2498 | +SET GLOBAL QUERY_RESPONSE_TIME_RANGE_BASE=10; | |
2499 | +FLUSH QUERY_RESPONSE_TIME; | |
2500 | +SET GLOBAL QUERY_RESPONSE_TIME_STATS=1; | |
2501 | +CALL test_f(0.31); | |
2502 | +CALL test_f(0.32); | |
2503 | +CALL test_f(0.33); | |
2504 | +CALL test_f(0.34); | |
2505 | +CALL test_f(0.35); | |
2506 | +CALL test_f(0.36); | |
2507 | +CALL test_f(0.37); | |
2508 | +CALL test_f(0.38); | |
2509 | +CALL test_f(0.39); | |
2510 | +CALL test_f(0.4); | |
2511 | +CALL test_f(1.1); | |
2512 | +CALL test_f(1.2); | |
2513 | +CALL test_f(1.3); | |
2514 | +CALL test_f(1.5); | |
2515 | +CALL test_f(1.4); | |
2516 | +CALL test_f(0.5); | |
2517 | +CALL test_f(2.1); | |
2518 | +CALL test_f(2.3); | |
2519 | +CALL test_f(2.5); | |
2520 | +CALL test_f(3.1); | |
2521 | +CALL test_f(4.1); | |
2522 | +CALL test_f(5.1); | |
2523 | +SET GLOBAL QUERY_RESPONSE_TIME_STATS=0; | |
2524 | +SHOW GLOBAL VARIABLES where Variable_name like 'QUERY_RESPONSE_TIME_RANGE_BASE'; | |
2525 | +Variable_name Value | |
2526 | +query_response_time_range_base 10 | |
2527 | +SHOW QUERY_RESPONSE_TIME; | |
2528 | + | |
734d6226 | 2529 | + 0.000001 45 0.000000 |
48b678b4 AM |
2530 | + 0.000010 0 0.000000 |
2531 | + 0.000100 0 0.000000 | |
2532 | + 0.001000 0 0.000000 | |
2533 | + 0.010000 0 0.000000 | |
2534 | + 0.100000 0 0.000000 | |
734d6226 | 2535 | + 1.000000 55 8.450000 |
48b678b4 AM |
2536 | + 10.000000 11 25.699999 |
2537 | + 100.000000 0 0.000000 | |
2538 | + 1000.000000 0 0.000000 | |
2539 | + 10000.000000 0 0.000000 | |
2540 | + 100000.000000 0 0.000000 | |
9dd04cbc | 2541 | +1000000.000000 0 0.000000 |
48b678b4 AM |
2542 | +TOO LONG 0 TOO LONG |
2543 | +SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME; | |
2544 | +time count total | |
734d6226 | 2545 | + 0.000001 45 0.000000 |
48b678b4 AM |
2546 | + 0.000010 0 0.000000 |
2547 | + 0.000100 0 0.000000 | |
2548 | + 0.001000 0 0.000000 | |
2549 | + 0.010000 0 0.000000 | |
2550 | + 0.100000 0 0.000000 | |
734d6226 | 2551 | + 1.000000 55 8.450000 |
48b678b4 AM |
2552 | + 10.000000 11 25.699999 |
2553 | + 100.000000 0 0.000000 | |
2554 | + 1000.000000 0 0.000000 | |
2555 | + 10000.000000 0 0.000000 | |
2556 | + 100000.000000 0 0.000000 | |
9dd04cbc | 2557 | +1000000.000000 0 0.000000 |
48b678b4 AM |
2558 | +TOO LONG 0 TOO LONG |
2559 | +SET SESSION query_exec_time=default; | |
2560 | +SET SESSION query_exec_time=0.1; | |
2561 | +SET GLOBAL QUERY_RESPONSE_TIME_STATS=0; | |
2562 | +SET GLOBAL QUERY_RESPONSE_TIME_RANGE_BASE=7; | |
2563 | +FLUSH QUERY_RESPONSE_TIME; | |
2564 | +SET GLOBAL QUERY_RESPONSE_TIME_STATS=1; | |
2565 | +CALL test_f(0.31); | |
2566 | +CALL test_f(0.32); | |
2567 | +CALL test_f(0.33); | |
2568 | +CALL test_f(0.34); | |
2569 | +CALL test_f(0.35); | |
2570 | +CALL test_f(0.36); | |
2571 | +CALL test_f(0.37); | |
2572 | +CALL test_f(0.38); | |
2573 | +CALL test_f(0.39); | |
2574 | +CALL test_f(0.4); | |
2575 | +CALL test_f(1.1); | |
2576 | +CALL test_f(1.2); | |
2577 | +CALL test_f(1.3); | |
2578 | +CALL test_f(1.5); | |
2579 | +CALL test_f(1.4); | |
2580 | +CALL test_f(0.5); | |
2581 | +CALL test_f(2.1); | |
2582 | +CALL test_f(2.3); | |
2583 | +CALL test_f(2.5); | |
2584 | +CALL test_f(3.1); | |
2585 | +CALL test_f(4.1); | |
2586 | +CALL test_f(5.1); | |
2587 | +SET GLOBAL QUERY_RESPONSE_TIME_STATS=0; | |
2588 | +SHOW GLOBAL VARIABLES where Variable_name like 'QUERY_RESPONSE_TIME_RANGE_BASE'; | |
2589 | +Variable_name Value | |
2590 | +query_response_time_range_base 7 | |
2591 | +SHOW QUERY_RESPONSE_TIME; | |
2592 | + | |
734d6226 | 2593 | + 0.000001 45 0.000000 |
48b678b4 AM |
2594 | + 0.000008 0 0.000000 |
2595 | + 0.000059 0 0.000000 | |
2596 | + 0.000416 0 0.000000 | |
2597 | + 0.002915 0 0.000000 | |
2598 | + 0.020408 0 0.000000 | |
734d6226 | 2599 | + 0.142857 44 4.400000 |
48b678b4 AM |
2600 | + 1.000000 11 4.050000 |
2601 | + 7.000000 11 25.699999 | |
2602 | + 49.000000 0 0.000000 | |
2603 | + 343.000000 0 0.000000 | |
2604 | + 2401.000000 0 0.000000 | |
2605 | + 16807.000000 0 0.000000 | |
2606 | + 117649.000000 0 0.000000 | |
2607 | + 823543.000000 0 0.000000 | |
9dd04cbc | 2608 | +5764801.000000 0 0.000000 |
48b678b4 AM |
2609 | +TOO LONG 0 TOO LONG |
2610 | +SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME; | |
2611 | +time count total | |
734d6226 | 2612 | + 0.000001 45 0.000000 |
48b678b4 AM |
2613 | + 0.000008 0 0.000000 |
2614 | + 0.000059 0 0.000000 | |
2615 | + 0.000416 0 0.000000 | |
2616 | + 0.002915 0 0.000000 | |
2617 | + 0.020408 0 0.000000 | |
734d6226 | 2618 | + 0.142857 44 4.400000 |
48b678b4 AM |
2619 | + 1.000000 11 4.050000 |
2620 | + 7.000000 11 25.699999 | |
2621 | + 49.000000 0 0.000000 | |
2622 | + 343.000000 0 0.000000 | |
2623 | + 2401.000000 0 0.000000 | |
2624 | + 16807.000000 0 0.000000 | |
2625 | + 117649.000000 0 0.000000 | |
2626 | + 823543.000000 0 0.000000 | |
9dd04cbc | 2627 | +5764801.000000 0 0.000000 |
48b678b4 AM |
2628 | +TOO LONG 0 TOO LONG |
2629 | +SET SESSION query_exec_time=default; | |
2630 | +SET SESSION query_exec_time=0.1; | |
2631 | +SET GLOBAL QUERY_RESPONSE_TIME_STATS=0; | |
2632 | +SET GLOBAL QUERY_RESPONSE_TIME_RANGE_BASE=156; | |
2633 | +FLUSH QUERY_RESPONSE_TIME; | |
2634 | +SET GLOBAL QUERY_RESPONSE_TIME_STATS=1; | |
2635 | +CALL test_f(0.31); | |
2636 | +CALL test_f(0.32); | |
2637 | +CALL test_f(0.33); | |
2638 | +CALL test_f(0.34); | |
2639 | +CALL test_f(0.35); | |
2640 | +CALL test_f(0.36); | |
2641 | +CALL test_f(0.37); | |
2642 | +CALL test_f(0.38); | |
2643 | +CALL test_f(0.39); | |
2644 | +CALL test_f(0.4); | |
2645 | +CALL test_f(1.1); | |
2646 | +CALL test_f(1.2); | |
2647 | +CALL test_f(1.3); | |
2648 | +CALL test_f(1.5); | |
2649 | +CALL test_f(1.4); | |
2650 | +CALL test_f(0.5); | |
2651 | +CALL test_f(2.1); | |
2652 | +CALL test_f(2.3); | |
2653 | +CALL test_f(2.5); | |
2654 | +CALL test_f(3.1); | |
2655 | +CALL test_f(4.1); | |
2656 | +CALL test_f(5.1); | |
2657 | +SET GLOBAL QUERY_RESPONSE_TIME_STATS=0; | |
2658 | +SHOW GLOBAL VARIABLES where Variable_name like 'QUERY_RESPONSE_TIME_RANGE_BASE'; | |
2659 | +Variable_name Value | |
2660 | +query_response_time_range_base 156 | |
2661 | +SHOW QUERY_RESPONSE_TIME; | |
2662 | + | |
734d6226 | 2663 | + 0.000041 45 0.000000 |
48b678b4 | 2664 | + 0.006410 0 0.000000 |
734d6226 | 2665 | + 1.000000 55 8.450000 |
48b678b4 AM |
2666 | + 156.000000 11 25.699999 |
2667 | + 24336.000000 0 0.000000 | |
9dd04cbc | 2668 | +3796416.000000 0 0.000000 |
48b678b4 AM |
2669 | +TOO LONG 0 TOO LONG |
2670 | +SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME; | |
2671 | +time count total | |
734d6226 | 2672 | + 0.000041 45 0.000000 |
48b678b4 | 2673 | + 0.006410 0 0.000000 |
734d6226 | 2674 | + 1.000000 55 8.450000 |
48b678b4 AM |
2675 | + 156.000000 11 25.699999 |
2676 | + 24336.000000 0 0.000000 | |
9dd04cbc | 2677 | +3796416.000000 0 0.000000 |
48b678b4 AM |
2678 | +TOO LONG 0 TOO LONG |
2679 | +SET SESSION query_exec_time=default; | |
2680 | +SET SESSION query_exec_time=0.1; | |
2681 | +SET GLOBAL QUERY_RESPONSE_TIME_STATS=0; | |
2682 | +SET GLOBAL QUERY_RESPONSE_TIME_RANGE_BASE=1000; | |
2683 | +FLUSH QUERY_RESPONSE_TIME; | |
2684 | +SET GLOBAL QUERY_RESPONSE_TIME_STATS=1; | |
2685 | +CALL test_f(0.31); | |
2686 | +CALL test_f(0.32); | |
2687 | +CALL test_f(0.33); | |
2688 | +CALL test_f(0.34); | |
2689 | +CALL test_f(0.35); | |
2690 | +CALL test_f(0.36); | |
2691 | +CALL test_f(0.37); | |
2692 | +CALL test_f(0.38); | |
2693 | +CALL test_f(0.39); | |
2694 | +CALL test_f(0.4); | |
2695 | +CALL test_f(1.1); | |
2696 | +CALL test_f(1.2); | |
2697 | +CALL test_f(1.3); | |
2698 | +CALL test_f(1.5); | |
2699 | +CALL test_f(1.4); | |
2700 | +CALL test_f(0.5); | |
2701 | +CALL test_f(2.1); | |
2702 | +CALL test_f(2.3); | |
2703 | +CALL test_f(2.5); | |
2704 | +CALL test_f(3.1); | |
2705 | +CALL test_f(4.1); | |
2706 | +CALL test_f(5.1); | |
2707 | +SET GLOBAL QUERY_RESPONSE_TIME_STATS=0; | |
2708 | +SHOW GLOBAL VARIABLES where Variable_name like 'QUERY_RESPONSE_TIME_RANGE_BASE'; | |
2709 | +Variable_name Value | |
2710 | +query_response_time_range_base 1000 | |
2711 | +SHOW QUERY_RESPONSE_TIME; | |
2712 | + | |
734d6226 | 2713 | + 0.000001 45 0.000000 |
48b678b4 | 2714 | + 0.001000 0 0.000000 |
734d6226 | 2715 | + 1.000000 55 8.450000 |
48b678b4 | 2716 | + 1000.000000 11 25.699999 |
9dd04cbc | 2717 | +1000000.000000 0 0.000000 |
48b678b4 AM |
2718 | +TOO LONG 0 TOO LONG |
2719 | +SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME; | |
2720 | +time count total | |
734d6226 | 2721 | + 0.000001 45 0.000000 |
48b678b4 | 2722 | + 0.001000 0 0.000000 |
734d6226 | 2723 | + 1.000000 55 8.450000 |
48b678b4 | 2724 | + 1000.000000 11 25.699999 |
9dd04cbc | 2725 | +1000000.000000 0 0.000000 |
48b678b4 AM |
2726 | +TOO LONG 0 TOO LONG |
2727 | +SET SESSION query_exec_time=default; | |
2728 | +SET SESSION query_exec_time=0.1; | |
2729 | +SET GLOBAL QUERY_RESPONSE_TIME_STATS=0; | |
2730 | +SET GLOBAL QUERY_RESPONSE_TIME_RANGE_BASE=1001; | |
2731 | +Warnings: | |
2732 | +Warning 1292 Truncated incorrect query_response_time_range_base value: '1001' | |
2733 | +FLUSH QUERY_RESPONSE_TIME; | |
2734 | +SET GLOBAL QUERY_RESPONSE_TIME_STATS=1; | |
2735 | +CALL test_f(0.31); | |
2736 | +CALL test_f(0.32); | |
2737 | +CALL test_f(0.33); | |
2738 | +CALL test_f(0.34); | |
2739 | +CALL test_f(0.35); | |
2740 | +CALL test_f(0.36); | |
2741 | +CALL test_f(0.37); | |
2742 | +CALL test_f(0.38); | |
2743 | +CALL test_f(0.39); | |
2744 | +CALL test_f(0.4); | |
2745 | +CALL test_f(1.1); | |
2746 | +CALL test_f(1.2); | |
2747 | +CALL test_f(1.3); | |
2748 | +CALL test_f(1.5); | |
2749 | +CALL test_f(1.4); | |
2750 | +CALL test_f(0.5); | |
2751 | +CALL test_f(2.1); | |
2752 | +CALL test_f(2.3); | |
2753 | +CALL test_f(2.5); | |
2754 | +CALL test_f(3.1); | |
2755 | +CALL test_f(4.1); | |
2756 | +CALL test_f(5.1); | |
2757 | +SET GLOBAL QUERY_RESPONSE_TIME_STATS=0; | |
2758 | +SHOW GLOBAL VARIABLES where Variable_name like 'QUERY_RESPONSE_TIME_RANGE_BASE'; | |
2759 | +Variable_name Value | |
2760 | +query_response_time_range_base 1000 | |
2761 | +SHOW QUERY_RESPONSE_TIME; | |
2762 | + | |
734d6226 | 2763 | + 0.000001 45 0.000000 |
48b678b4 | 2764 | + 0.001000 0 0.000000 |
734d6226 | 2765 | + 1.000000 55 8.450000 |
48b678b4 | 2766 | + 1000.000000 11 25.699999 |
9dd04cbc | 2767 | +1000000.000000 0 0.000000 |
48b678b4 AM |
2768 | +TOO LONG 0 TOO LONG |
2769 | +SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME; | |
2770 | +time count total | |
734d6226 | 2771 | + 0.000001 45 0.000000 |
48b678b4 | 2772 | + 0.001000 0 0.000000 |
734d6226 | 2773 | + 1.000000 55 8.450000 |
48b678b4 | 2774 | + 1000.000000 11 25.699999 |
9dd04cbc | 2775 | +1000000.000000 0 0.000000 |
48b678b4 AM |
2776 | +TOO LONG 0 TOO LONG |
2777 | +SET SESSION query_exec_time=default; | |
2778 | +SET GLOBAL QUERY_RESPONSE_TIME_RANGE_BASE=default; | |
2779 | +SET GLOBAL QUERY_RESPONSE_TIME_STATS=default; | |
2780 | +DROP PROCEDURE test_f; | |
2781 | +DROP TABLE t; | |
2782 | --- /dev/null | |
2783 | +++ b/mysql-test/t/percona_query_response_time-replication.test | |
2784 | @@ -0,0 +1,28 @@ | |
2785 | +SET GLOBAL query_exec_time=0.1; | |
2786 | + | |
2787 | +--source include/have_response_time_distribution.inc | |
2788 | +--source include/have_debug.inc | |
2789 | +--source include/have_binlog_format_statement.inc | |
2790 | +--source include/master-slave.inc | |
2791 | + | |
2792 | +--let base=1 | |
2793 | +--source include/query_response_time-replication.inc | |
2794 | +--let base=2 | |
2795 | +--source include/query_response_time-replication.inc | |
2796 | +--let base=10 | |
2797 | +--source include/query_response_time-replication.inc | |
2798 | +--let base=7 | |
2799 | +--source include/query_response_time-replication.inc | |
2800 | +--let base=156 | |
2801 | +--source include/query_response_time-replication.inc | |
2802 | +--let base=1000 | |
2803 | +--source include/query_response_time-replication.inc | |
2804 | +--let base=1001 | |
2805 | +--source include/query_response_time-replication.inc | |
2806 | + | |
2807 | +--source include/rpl_end.inc | |
2808 | + | |
2809 | +SET GLOBAL query_exec_time=default; | |
2810 | + | |
2811 | +connection slave; | |
2812 | +SET GLOBAL query_exec_time=default; | |
2813 | --- /dev/null | |
2814 | +++ b/mysql-test/t/percona_query_response_time-stored.test | |
2815 | @@ -0,0 +1,36 @@ | |
2816 | +--source include/have_response_time_distribution.inc | |
2817 | +--source include/have_debug.inc | |
2818 | + | |
2819 | +CREATE TABLE t(a INT); | |
2820 | + | |
2821 | +delimiter ^; | |
2822 | +CREATE PROCEDURE test_f(t DECIMAL(3,2)) | |
2823 | +BEGIN | |
2824 | + SET SESSION query_exec_time=t; | |
2825 | + INSERT INTO t VALUES(1); | |
2826 | + SET SESSION query_exec_time=0.1; | |
2827 | + DELETE FROM t; | |
2828 | +END^ | |
2829 | +delimiter ;^ | |
2830 | + | |
2831 | +--let base=1 | |
2832 | +--source include/query_response_time-stored.inc | |
2833 | +--let base=2 | |
2834 | +--source include/query_response_time-stored.inc | |
2835 | +--let base=10 | |
2836 | +--source include/query_response_time-stored.inc | |
2837 | +--let base=7 | |
2838 | +--source include/query_response_time-stored.inc | |
2839 | +--let base=156 | |
2840 | +--source include/query_response_time-stored.inc | |
2841 | +--let base=1000 | |
2842 | +--source include/query_response_time-stored.inc | |
2843 | +--let base=1001 | |
2844 | +--source include/query_response_time-stored.inc | |
2845 | + | |
2846 | +SET GLOBAL QUERY_RESPONSE_TIME_RANGE_BASE=default; | |
2847 | +SET GLOBAL QUERY_RESPONSE_TIME_STATS=default; | |
2848 | + | |
2849 | +DROP PROCEDURE test_f; | |
2850 | + | |
2851 | +DROP TABLE t; | |
2852 | --- /dev/null | |
2853 | +++ b/mysql-test/t/percona_query_response_time.test | |
2854 | @@ -0,0 +1,20 @@ | |
2855 | +--source include/have_response_time_distribution.inc | |
2856 | +--source include/have_debug.inc | |
2857 | + | |
2858 | +--let base=1 | |
2859 | +--source include/query_response_time.inc | |
2860 | +--let base=2 | |
2861 | +--source include/query_response_time.inc | |
2862 | +--let base=10 | |
2863 | +--source include/query_response_time.inc | |
2864 | +--let base=7 | |
2865 | +--source include/query_response_time.inc | |
2866 | +--let base=156 | |
2867 | +--source include/query_response_time.inc | |
2868 | +--let base=1000 | |
2869 | +--source include/query_response_time.inc | |
2870 | +--let base=1001 | |
2871 | +--source include/query_response_time.inc | |
2872 | + | |
2873 | +SET GLOBAL QUERY_RESPONSE_TIME_RANGE_BASE=default; | |
2874 | +SET GLOBAL QUERY_RESPONSE_TIME_STATS=default; | |
2875 | --- /dev/null | |
db82db79 | 2876 | +++ b/patch_info/response-time-distribution.info |
b4e1fa2c AM |
2877 | @@ -0,0 +1,9 @@ |
2878 | +File=response-time-distribution.patch | |
2879 | +Name=Response time distribution | |
2880 | +Version=1.0 | |
2881 | +Author=Percona <info@percona.com> | |
2882 | +License=GPL | |
2883 | +Comment= | |
2884 | +Changelog | |
2885 | +2010-07-02 first version avaliable | |
2886 | +2010-09-15 add column 'total' | |
db82db79 AM |
2887 | --- a/sql/CMakeLists.txt |
2888 | +++ b/sql/CMakeLists.txt | |
b4e1fa2c AM |
2889 | @@ -51,7 +51,7 @@ |
2890 | message.h mf_iocache.cc my_decimal.cc ../sql-common/my_time.c | |
2891 | mysqld.cc net_serv.cc keycaches.cc | |
2892 | ../sql-common/client_plugin.c | |
2893 | - opt_range.cc opt_range.h opt_sum.cc | |
2894 | + opt_range.cc opt_range.h query_response_time.h opt_sum.cc | |
2895 | ../sql-common/pack.c parse_file.cc password.c procedure.cc | |
2896 | protocol.cc records.cc repl_failsafe.cc rpl_filter.cc set_var.cc | |
2897 | slave.cc sp.cc sp_cache.cc sp_head.cc sp_pcontext.cc | |
2898 | @@ -59,7 +59,7 @@ | |
2899 | sql_cache.cc sql_class.cc sql_client.cc sql_crypt.cc sql_crypt.h | |
2900 | sql_cursor.cc sql_db.cc sql_delete.cc sql_derived.cc sql_do.cc | |
2901 | sql_error.cc sql_handler.cc sql_help.cc sql_insert.cc sql_lex.cc | |
2902 | - sql_list.cc sql_load.cc sql_manager.cc sql_parse.cc | |
2903 | + sql_list.cc sql_load.cc sql_manager.cc sql_parse.cc query_response_time.cc | |
2904 | sql_partition.cc sql_plugin.cc sql_prepare.cc sql_rename.cc | |
2905 | debug_sync.cc debug_sync.h | |
2906 | sql_repl.cc sql_select.cc sql_show.cc sql_state.c sql_string.cc | |
db82db79 AM |
2907 | --- a/sql/handler.h |
2908 | +++ b/sql/handler.h | |
2909 | @@ -581,6 +581,7 @@ | |
b4e1fa2c AM |
2910 | SCH_PROFILES, |
2911 | SCH_REFERENTIAL_CONSTRAINTS, | |
2912 | SCH_PROCEDURES, | |
2913 | + SCH_QUERY_RESPONSE_TIME, | |
2914 | SCH_SCHEMATA, | |
2915 | SCH_SCHEMA_PRIVILEGES, | |
2916 | SCH_SESSION_STATUS, | |
db82db79 AM |
2917 | --- a/sql/lex.h |
2918 | +++ b/sql/lex.h | |
b4e1fa2c AM |
2919 | @@ -426,6 +426,7 @@ |
2920 | { "PURGE", SYM(PURGE)}, | |
2921 | { "QUARTER", SYM(QUARTER_SYM)}, | |
2922 | { "QUERY", SYM(QUERY_SYM)}, | |
2923 | + { "QUERY_RESPONSE_TIME", SYM(QUERY_RESPONSE_TIME_SYM)}, | |
2924 | { "QUICK", SYM(QUICK)}, | |
2925 | { "RANGE", SYM(RANGE_SYM)}, | |
2926 | { "READ", SYM(READ_SYM)}, | |
db82db79 AM |
2927 | --- a/sql/mysqld.cc |
2928 | +++ b/sql/mysqld.cc | |
b4e1fa2c AM |
2929 | @@ -69,6 +69,8 @@ |
2930 | #include "debug_sync.h" | |
2931 | #include "sql_callback.h" | |
2932 | ||
2933 | +#include "query_response_time.h" | |
2934 | + | |
2935 | #ifdef WITH_PERFSCHEMA_STORAGE_ENGINE | |
2936 | #include "../storage/perfschema/pfs_server.h" | |
2937 | #endif /* WITH_PERFSCHEMA_STORAGE_ENGINE */ | |
db82db79 | 2938 | @@ -611,7 +613,7 @@ |
b4e1fa2c AM |
2939 | MY_LOCALE *my_default_lc_messages; |
2940 | MY_LOCALE *my_default_lc_time_names; | |
2941 | ||
2942 | -SHOW_COMP_OPTION have_ssl, have_symlink, have_dlopen, have_query_cache; | |
2943 | +SHOW_COMP_OPTION have_ssl, have_symlink, have_dlopen, have_query_cache, have_response_time_distribution; | |
2944 | SHOW_COMP_OPTION have_geometry, have_rtree_keys; | |
2945 | SHOW_COMP_OPTION have_crypt, have_compress; | |
2946 | SHOW_COMP_OPTION have_profiling; | |
db82db79 | 2947 | @@ -912,6 +914,10 @@ |
b4e1fa2c AM |
2948 | my_bool opt_enable_shared_memory; |
2949 | HANDLE smem_event_connect_request= 0; | |
2950 | #endif | |
2951 | +#ifdef HAVE_RESPONSE_TIME_DISTRIBUTION | |
2952 | +ulong opt_query_response_time_range_base = QRT_DEFAULT_BASE; | |
d8778560 | 2953 | +my_bool opt_query_response_time_stats= 0; |
b4e1fa2c AM |
2954 | +#endif // HAVE_RESPONSE_TIME_DISTRIBUTION |
2955 | ||
2956 | my_bool opt_use_ssl = 0; | |
2957 | char *opt_ssl_ca= NULL, *opt_ssl_capath= NULL, *opt_ssl_cert= NULL, | |
db82db79 | 2958 | @@ -1483,6 +1489,9 @@ |
b4e1fa2c AM |
2959 | my_free(opt_bin_logname); |
2960 | bitmap_free(&temp_pool); | |
2961 | free_max_user_conn(); | |
2962 | +#ifdef HAVE_RESPONSE_TIME_DISTRIBUTION | |
2963 | + query_response_time_free(); | |
2964 | +#endif // HAVE_RESPONSE_TIME_DISTRIBUTION | |
2965 | #ifdef HAVE_REPLICATION | |
2966 | end_slave_list(); | |
2967 | #endif | |
db82db79 | 2968 | @@ -4010,6 +4019,9 @@ |
b4e1fa2c AM |
2969 | if (!DEFAULT_ERRMSGS[0][0]) |
2970 | unireg_abort(1); | |
2971 | ||
2972 | +#ifdef HAVE_RESPONSE_TIME_DISTRIBUTION | |
2973 | + query_response_time_init(); | |
2974 | +#endif // HAVE_RESPONSE_TIME_DISTRIBUTION | |
2975 | /* We have to initialize the storage engines before CSV logging */ | |
2976 | if (ha_init()) | |
2977 | { | |
734d6226 | 2978 | @@ -6905,6 +6917,11 @@ |
b4e1fa2c AM |
2979 | #else |
2980 | have_query_cache=SHOW_OPTION_NO; | |
2981 | #endif | |
2982 | +#ifdef HAVE_RESPONSE_TIME_DISTRIBUTION | |
2983 | + have_response_time_distribution= SHOW_OPTION_YES; | |
2984 | +#else // HAVE_RESPONSE_TIME_DISTRIBUTION | |
2985 | + have_response_time_distribution= SHOW_OPTION_NO; | |
2986 | +#endif // HAVE_RESPONSE_TIME_DISTRIBUTION | |
2987 | #ifdef HAVE_SPATIAL | |
2988 | have_geometry=SHOW_OPTION_YES; | |
2989 | #else | |
db82db79 AM |
2990 | --- a/sql/mysqld.h |
2991 | +++ b/sql/mysqld.h | |
b4e1fa2c AM |
2992 | @@ -98,6 +98,10 @@ |
2993 | extern bool opt_disable_networking, opt_skip_show_db; | |
2994 | extern bool opt_skip_name_resolve; | |
2995 | extern bool opt_ignore_builtin_innodb; | |
2996 | +#ifdef HAVE_RESPONSE_TIME_DISTRIBUTION | |
2997 | +extern ulong opt_query_response_time_range_base; | |
d8778560 | 2998 | +extern my_bool opt_query_response_time_stats; |
b4e1fa2c AM |
2999 | +#endif // HAVE_RESPONSE_TIME_DISTRIBUTION |
3000 | extern my_bool opt_character_set_client_handshake; | |
3001 | extern bool volatile abort_loop; | |
3002 | extern bool in_bootstrap; | |
db82db79 AM |
3003 | --- /dev/null |
3004 | +++ b/sql/query_response_time.cc | |
9dd04cbc | 3005 | @@ -0,0 +1,302 @@ |
b4e1fa2c | 3006 | +#include "mysql_version.h" |
b4e1fa2c AM |
3007 | +#include "my_global.h" |
3008 | +#ifdef HAVE_RESPONSE_TIME_DISTRIBUTION | |
3009 | +#include "mysql_com.h" | |
3010 | +#include "rpl_tblmap.h" | |
3011 | +#include "table.h" | |
3012 | +#include "field.h" | |
3013 | +#include "sql_show.h" | |
3014 | +#include "query_response_time.h" | |
3015 | + | |
3016 | +#define TIME_STRING_POSITIVE_POWER_LENGTH QRT_TIME_STRING_POSITIVE_POWER_LENGTH | |
3017 | +#define TIME_STRING_NEGATIVE_POWER_LENGTH 6 | |
3018 | +#define TOTAL_STRING_POSITIVE_POWER_LENGTH QRT_TOTAL_STRING_POSITIVE_POWER_LENGTH | |
3019 | +#define TOTAL_STRING_NEGATIVE_POWER_LENGTH 6 | |
3020 | +#define MINIMUM_BASE 2 | |
3021 | +#define MAXIMUM_BASE QRT_MAXIMUM_BASE | |
3022 | +#define POSITIVE_POWER_FILLER QRT_POSITIVE_POWER_FILLER | |
3023 | +#define NEGATIVE_POWER_FILLER QRT_NEGATIVE_POWER_FILLER | |
b4e1fa2c AM |
3024 | +#define TIME_OVERFLOW QRT_TIME_OVERFLOW |
3025 | +#define DEFAULT_BASE QRT_DEFAULT_BASE | |
3026 | + | |
3027 | +#define do_xstr(s) do_str(s) | |
3028 | +#define do_str(s) #s | |
3029 | +#define do_format(filler,width) "%" filler width "lld" | |
3030 | +/* | |
3031 | + Format strings for snprintf. Generate from: | |
3032 | + POSITIVE_POWER_FILLER and TIME_STRING_POSITIVE_POWER_LENGTH | |
3033 | + NEFATIVE_POWER_FILLER and TIME_STRING_NEGATIVE_POWER_LENGTH | |
3034 | +*/ | |
3035 | +#define TIME_STRING_POSITIVE_POWER_FORMAT do_format(POSITIVE_POWER_FILLER,do_xstr(TIME_STRING_POSITIVE_POWER_LENGTH)) | |
3036 | +#define TIME_STRING_NEGATIVE_POWER_FORMAT do_format(NEGATIVE_POWER_FILLER,do_xstr(TIME_STRING_NEGATIVE_POWER_LENGTH)) | |
3037 | +#define TIME_STRING_FORMAT TIME_STRING_POSITIVE_POWER_FORMAT "." TIME_STRING_NEGATIVE_POWER_FORMAT | |
3038 | + | |
3039 | +#define TOTAL_STRING_POSITIVE_POWER_FORMAT do_format(POSITIVE_POWER_FILLER,do_xstr(TOTAL_STRING_POSITIVE_POWER_LENGTH)) | |
3040 | +#define TOTAL_STRING_NEGATIVE_POWER_FORMAT do_format(NEGATIVE_POWER_FILLER,do_xstr(TOTAL_STRING_NEGATIVE_POWER_LENGTH)) | |
3041 | +#define TOTAL_STRING_FORMAT TOTAL_STRING_POSITIVE_POWER_FORMAT "." TOTAL_STRING_NEGATIVE_POWER_FORMAT | |
3042 | + | |
3043 | +#define TIME_STRING_LENGTH QRT_TIME_STRING_LENGTH | |
3044 | +#define TIME_STRING_BUFFER_LENGTH (TIME_STRING_LENGTH + 1 /* '\0' */) | |
3045 | + | |
3046 | +#define TOTAL_STRING_LENGTH QRT_TOTAL_STRING_LENGTH | |
3047 | +#define TOTAL_STRING_BUFFER_LENGTH (TOTAL_STRING_LENGTH + 1 /* '\0' */) | |
3048 | + | |
3049 | +/* | |
3050 | + Calculate length of "log linear" | |
3051 | + 1) | |
3052 | + (MINIMUM_BASE ^ result) <= (10 ^ STRING_POWER_LENGTH) < (MINIMUM_BASE ^ (result + 1)) | |
3053 | + | |
3054 | + 2) | |
3055 | + (MINIMUM_BASE ^ result) <= (10 ^ STRING_POWER_LENGTH) | |
3056 | + and | |
3057 | + (MINIMUM_BASE ^ (result + 1)) > (10 ^ STRING_POWER_LENGTH) | |
3058 | + | |
3059 | + 3) | |
3060 | + result <= LOG(MINIMUM_BASE, 10 ^ STRING_POWER_LENGTH)= STRING_POWER_LENGTH * LOG(MINIMUM_BASE,10) | |
3061 | + result + 1 > LOG(MINIMUM_BASE, 10 ^ STRING_POWER_LENGTH)= STRING_POWER_LENGTH * LOG(MINIMUM_BASE,10) | |
3062 | + | |
3063 | + 4) STRING_POWER_LENGTH * LOG(MINIMUM_BASE,10) - 1 < result <= STRING_POWER_LENGTH * LOG(MINIMUM_BASE,10) | |
3064 | + | |
3065 | + MINIMUM_BASE= 2 always, LOG(MINIMUM_BASE,10)= 3.3219280948873626, result= (int)3.3219280948873626 * STRING_POWER_LENGTH | |
3066 | + | |
3067 | + Last counter always use for time overflow | |
3068 | +*/ | |
3069 | +#define POSITIVE_POWER_COUNT ((int)(3.32192809 * TIME_STRING_POSITIVE_POWER_LENGTH)) | |
3070 | +#define NEGATIVE_POWER_COUNT ((int)(3.32192809 * TIME_STRING_NEGATIVE_POWER_LENGTH)) | |
3071 | +#define OVERALL_POWER_COUNT (NEGATIVE_POWER_COUNT + 1 + POSITIVE_POWER_COUNT) | |
3072 | + | |
3073 | +#define MILLION ((unsigned long)1000 * 1000) | |
3074 | + | |
3075 | +namespace query_response_time | |
3076 | +{ | |
3077 | + | |
3078 | +class utility | |
3079 | +{ | |
3080 | +public: | |
3081 | + utility() : m_base(0) | |
3082 | + { | |
3083 | + m_max_dec_value= MILLION; | |
3084 | + for(int i= 0; TIME_STRING_POSITIVE_POWER_LENGTH > i; ++i) | |
3085 | + m_max_dec_value *= 10; | |
3086 | + setup(DEFAULT_BASE); | |
3087 | + } | |
3088 | +public: | |
3089 | + uint base() const { return m_base; } | |
3090 | + uint negative_count() const { return m_negative_count; } | |
3091 | + uint positive_count() const { return m_positive_count; } | |
3092 | + uint bound_count() const { return m_bound_count; } | |
3093 | + ulonglong max_dec_value() const { return m_max_dec_value; } | |
3094 | + ulonglong bound(uint index) const { return m_bound[ index ]; } | |
3095 | +public: | |
3096 | + void setup(uint base) | |
3097 | + { | |
3098 | + if(base != m_base) | |
3099 | + { | |
3100 | + m_base= base; | |
3101 | + | |
3102 | + const ulonglong million= 1000 * 1000; | |
3103 | + ulonglong value= million; | |
3104 | + m_negative_count= 0; | |
3105 | + while(value > 0) | |
3106 | + { | |
3107 | + m_negative_count += 1; | |
3108 | + value /= m_base; | |
3109 | + } | |
3110 | + m_negative_count -= 1; | |
3111 | + | |
3112 | + value= million; | |
3113 | + m_positive_count= 0; | |
3114 | + while(value < m_max_dec_value) | |
3115 | + { | |
3116 | + m_positive_count += 1; | |
3117 | + value *= m_base; | |
3118 | + } | |
3119 | + m_bound_count= m_negative_count + m_positive_count; | |
3120 | + | |
3121 | + value= million; | |
3122 | + for(uint i= 0; i < m_negative_count; ++i) | |
3123 | + { | |
3124 | + value /= m_base; | |
3125 | + m_bound[m_negative_count - i - 1]= value; | |
3126 | + } | |
3127 | + value= million; | |
3128 | + for(uint i= 0; i < m_positive_count; ++i) | |
3129 | + { | |
3130 | + m_bound[m_negative_count + i]= value; | |
3131 | + value *= m_base; | |
3132 | + } | |
3133 | + } | |
3134 | + } | |
3135 | +private: | |
3136 | + uint m_base; | |
3137 | + uint m_negative_count; | |
3138 | + uint m_positive_count; | |
3139 | + uint m_bound_count; | |
3140 | + ulonglong m_max_dec_value; /* for TIME_STRING_POSITIVE_POWER_LENGTH=7 is 10000000 */ | |
3141 | + ulonglong m_bound[OVERALL_POWER_COUNT]; | |
3142 | +}; | |
3143 | + | |
9dd04cbc AM |
3144 | +static |
3145 | +void print_time(char* buffer, std::size_t buffer_size, const char* format, | |
3146 | + uint64 value) | |
b4e1fa2c | 3147 | +{ |
b4e1fa2c AM |
3148 | + ulonglong second= (value / MILLION); |
3149 | + ulonglong microsecond= (value % MILLION); | |
9dd04cbc | 3150 | + my_snprintf(buffer, buffer_size, format, second, microsecond); |
b4e1fa2c | 3151 | +} |
adf0fb13 AM |
3152 | + |
3153 | +class time_collector | |
b4e1fa2c AM |
3154 | +{ |
3155 | +public: | |
adf0fb13 | 3156 | + time_collector(utility& u) : m_utility(&u) |
b4e1fa2c | 3157 | + { |
adf0fb13 | 3158 | + my_atomic_rwlock_init(&time_collector_lock); |
b4e1fa2c | 3159 | + } |
adf0fb13 | 3160 | + ~time_collector() |
b4e1fa2c | 3161 | + { |
adf0fb13 | 3162 | + my_atomic_rwlock_destroy(&time_collector_lock); |
b4e1fa2c | 3163 | + } |
adf0fb13 | 3164 | + uint32 count(uint index) const |
b4e1fa2c | 3165 | + { |
adf0fb13 | 3166 | + my_atomic_rwlock_rdlock(&time_collector_lock); |
9dd04cbc | 3167 | + uint32 result= my_atomic_load32((int32*)&m_count[index]); |
adf0fb13 AM |
3168 | + my_atomic_rwlock_rdunlock(&time_collector_lock); |
3169 | + return result; | |
b4e1fa2c | 3170 | + } |
adf0fb13 | 3171 | + uint64 total(uint index) const |
b4e1fa2c | 3172 | + { |
adf0fb13 | 3173 | + my_atomic_rwlock_rdlock(&time_collector_lock); |
9dd04cbc | 3174 | + uint64 result= my_atomic_load64((int64*)&m_total[index]); |
adf0fb13 AM |
3175 | + my_atomic_rwlock_rdunlock(&time_collector_lock); |
3176 | + return result; | |
b4e1fa2c | 3177 | + } |
b4e1fa2c AM |
3178 | +public: |
3179 | + void flush() | |
3180 | + { | |
adf0fb13 AM |
3181 | + my_atomic_rwlock_wrlock(&time_collector_lock); |
3182 | + memset((void*)&m_count,0,sizeof(m_count)); | |
b4e1fa2c | 3183 | + memset((void*)&m_total,0,sizeof(m_total)); |
adf0fb13 | 3184 | + my_atomic_rwlock_wrunlock(&time_collector_lock); |
b4e1fa2c AM |
3185 | + } |
3186 | + void collect(uint64 time) | |
3187 | + { | |
b4e1fa2c AM |
3188 | + int i= 0; |
3189 | + for(int count= m_utility->bound_count(); count > i; ++i) | |
3190 | + { | |
3191 | + if(m_utility->bound(i) > time) | |
3192 | + { | |
adf0fb13 | 3193 | + my_atomic_rwlock_wrlock(&time_collector_lock); |
9dd04cbc AM |
3194 | + my_atomic_add32((int32*)(&m_count[i]), 1); |
3195 | + my_atomic_add64((int64*)(&m_total[i]), time); | |
adf0fb13 | 3196 | + my_atomic_rwlock_wrunlock(&time_collector_lock); |
b4e1fa2c AM |
3197 | + break; |
3198 | + } | |
3199 | + } | |
3200 | + } | |
3201 | +private: | |
3202 | + utility* m_utility; | |
adf0fb13 AM |
3203 | + /* The lock for atomic operations on m_count and m_total. Only actually |
3204 | + used on architectures that do not have atomic implementation of atomic | |
3205 | + operations. */ | |
3206 | + my_atomic_rwlock_t time_collector_lock; | |
9dd04cbc AM |
3207 | + uint32 m_count[OVERALL_POWER_COUNT + 1]; |
3208 | + uint64 m_total[OVERALL_POWER_COUNT + 1]; | |
b4e1fa2c AM |
3209 | +}; |
3210 | + | |
3211 | +class collector | |
3212 | +{ | |
3213 | +public: | |
3214 | + collector() : m_time(m_utility) | |
3215 | + { | |
3216 | + m_utility.setup(DEFAULT_BASE); | |
3217 | + m_time.flush(); | |
3218 | + } | |
3219 | +public: | |
3220 | + void flush() | |
3221 | + { | |
3222 | + m_utility.setup(opt_query_response_time_range_base); | |
3223 | + m_time.flush(); | |
3224 | + } | |
3225 | + int fill(THD* thd, TABLE_LIST *tables, COND *cond) | |
3226 | + { | |
3227 | + DBUG_ENTER("fill_schema_query_response_time"); | |
3228 | + TABLE *table= static_cast<TABLE*>(tables->table); | |
3229 | + Field **fields= table->field; | |
3230 | + for(uint i= 0, count= bound_count() + 1 /* with overflow */; count > i; ++i) | |
3231 | + { | |
3232 | + char time[TIME_STRING_BUFFER_LENGTH]; | |
3233 | + char total[TOTAL_STRING_BUFFER_LENGTH]; | |
3234 | + if(i == bound_count()) | |
3235 | + { | |
3236 | + assert(sizeof(TIME_OVERFLOW) <= TIME_STRING_BUFFER_LENGTH); | |
3237 | + assert(sizeof(TIME_OVERFLOW) <= TOTAL_STRING_BUFFER_LENGTH); | |
3238 | + memcpy(time,TIME_OVERFLOW,sizeof(TIME_OVERFLOW)); | |
3239 | + memcpy(total,TIME_OVERFLOW,sizeof(TIME_OVERFLOW)); | |
3240 | + } | |
3241 | + else | |
3242 | + { | |
9dd04cbc AM |
3243 | + print_time(time, sizeof(time), TIME_STRING_FORMAT, this->bound(i)); |
3244 | + print_time(total, sizeof(total), TOTAL_STRING_FORMAT, this->total(i)); | |
b4e1fa2c AM |
3245 | + } |
3246 | + fields[0]->store(time,strlen(time),system_charset_info); | |
3247 | + fields[1]->store(this->count(i)); | |
3248 | + fields[2]->store(total,strlen(total),system_charset_info); | |
3249 | + if (schema_table_store_record(thd, table)) | |
3250 | + { | |
3251 | + DBUG_RETURN(1); | |
3252 | + } | |
3253 | + } | |
3254 | + DBUG_RETURN(0); | |
3255 | + } | |
3256 | + void collect(ulonglong time) | |
3257 | + { | |
3258 | + m_time.collect(time); | |
3259 | + } | |
3260 | + uint bound_count() const | |
3261 | + { | |
3262 | + return m_utility.bound_count(); | |
3263 | + } | |
3264 | + ulonglong bound(uint index) | |
3265 | + { | |
3266 | + return m_utility.bound(index); | |
3267 | + } | |
3268 | + ulonglong count(uint index) | |
3269 | + { | |
3270 | + return m_time.count(index); | |
3271 | + } | |
3272 | + ulonglong total(uint index) | |
3273 | + { | |
3274 | + return m_time.total(index); | |
3275 | + } | |
3276 | +private: | |
3277 | + utility m_utility; | |
3278 | + time_collector m_time; | |
3279 | +}; | |
3280 | + | |
3281 | +static collector g_collector; | |
3282 | + | |
3283 | +} // namespace query_response_time | |
3284 | + | |
3285 | +void query_response_time_init() | |
3286 | +{ | |
3287 | +} | |
3288 | + | |
3289 | +void query_response_time_free() | |
3290 | +{ | |
3291 | + query_response_time::g_collector.flush(); | |
3292 | +} | |
3293 | + | |
3294 | +void query_response_time_flush() | |
3295 | +{ | |
3296 | + query_response_time::g_collector.flush(); | |
3297 | +} | |
3298 | +void query_response_time_collect(ulonglong query_time) | |
3299 | +{ | |
3300 | + query_response_time::g_collector.collect(query_time); | |
3301 | +} | |
3302 | + | |
3303 | +int query_response_time_fill(THD* thd, TABLE_LIST *tables, COND *cond) | |
3304 | +{ | |
3305 | + return query_response_time::g_collector.fill(thd,tables,cond); | |
3306 | +} | |
3307 | +#endif // HAVE_RESPONSE_TIME_DISTRIBUTION | |
db82db79 AM |
3308 | --- /dev/null |
3309 | +++ b/sql/query_response_time.h | |
9dd04cbc | 3310 | @@ -0,0 +1,64 @@ |
b4e1fa2c AM |
3311 | +#ifndef QUERY_RESPONSE_TIME_H |
3312 | +#define QUERY_RESPONSE_TIME_H | |
3313 | + | |
3314 | +/* | |
3315 | + Settings for query response time | |
3316 | +*/ | |
3317 | + | |
3318 | +/* | |
3319 | + Maximum string length for (10 ^ (-1 * QRT_STRING_NEGATIVE_POWER_LENGTH)) in text representation. | |
3320 | + Example: for 6 is 0.000001 | |
3321 | + Always 2 | |
3322 | + | |
3323 | + Maximum string length for (10 ^ (QRT_STRING_POSITIVE_POWER_LENGTH + 1) - 1) in text representation. | |
3324 | + Example: for 7 is 9999999.0 | |
3325 | +*/ | |
3326 | +#define QRT_TIME_STRING_POSITIVE_POWER_LENGTH 7 | |
3327 | +#define QRT_TOTAL_STRING_POSITIVE_POWER_LENGTH 7 | |
3328 | + | |
3329 | +/* | |
3330 | + Minimum base for log - ALWAYS 2 | |
3331 | + Maximum base for log: | |
3332 | +*/ | |
3333 | +#define QRT_MAXIMUM_BASE 1000 | |
3334 | + | |
3335 | +/* | |
3336 | + Filler for whole number (positive power) | |
3337 | + Example: for | |
3338 | + QRT_POSITIVE_POWER_FILLER ' ' | |
3339 | + QRT_POSITIVE_POWER_LENGTH 7 | |
3340 | + and number 7234 result is: | |
3341 | + ' 7234' | |
3342 | +*/ | |
9dd04cbc | 3343 | +#define QRT_POSITIVE_POWER_FILLER "" |
b4e1fa2c AM |
3344 | +/* |
3345 | + Filler for fractional number. Similiary to whole number | |
3346 | +*/ | |
3347 | +#define QRT_NEGATIVE_POWER_FILLER "0" | |
3348 | + | |
3349 | +/* | |
b4e1fa2c AM |
3350 | + Message if time too big for statistic collecting (very long query) |
3351 | +*/ | |
3352 | +#define QRT_TIME_OVERFLOW "TOO LONG" | |
3353 | + | |
3354 | +#define QRT_DEFAULT_BASE 10 | |
3355 | + | |
3356 | +#define QRT_TIME_STRING_LENGTH \ | |
3357 | + max( (QRT_TIME_STRING_POSITIVE_POWER_LENGTH + 1 /* '.' */ + 6 /*QRT_TIME_STRING_NEGATIVE_POWER_LENGTH*/), \ | |
9dd04cbc | 3358 | + (sizeof(QRT_TIME_OVERFLOW) - 1) ) |
b4e1fa2c AM |
3359 | + |
3360 | +#define QRT_TOTAL_STRING_LENGTH \ | |
3361 | + max( (QRT_TOTAL_STRING_POSITIVE_POWER_LENGTH + 1 /* '.' */ + 6 /*QRT_TOTAL_STRING_NEGATIVE_POWER_LENGTH*/), \ | |
9dd04cbc | 3362 | + (sizeof(QRT_TIME_OVERFLOW) - 1) ) |
b4e1fa2c AM |
3363 | + |
3364 | +extern ST_SCHEMA_TABLE query_response_time_table; | |
3365 | + | |
3366 | +#ifdef HAVE_RESPONSE_TIME_DISTRIBUTION | |
3367 | +extern void query_response_time_init (); | |
3368 | +extern void query_response_time_free (); | |
3369 | +extern void query_response_time_flush (); | |
3370 | +extern void query_response_time_collect(ulonglong query_time); | |
3371 | +extern int query_response_time_fill (THD* thd, TABLE_LIST *tables, COND *cond); | |
3372 | +#endif // HAVE_RESPONSE_TIME_DISTRIBUTION | |
3373 | + | |
3374 | +#endif // QUERY_RESPONSE_TIME_H | |
db82db79 AM |
3375 | --- a/sql/set_var.h |
3376 | +++ b/sql/set_var.h | |
b4e1fa2c AM |
3377 | @@ -293,6 +293,7 @@ |
3378 | ||
3379 | extern SHOW_COMP_OPTION have_ssl, have_symlink, have_dlopen; | |
3380 | extern SHOW_COMP_OPTION have_query_cache; | |
3381 | +extern SHOW_COMP_OPTION have_response_time_distribution; | |
3382 | extern SHOW_COMP_OPTION have_geometry, have_rtree_keys; | |
3383 | extern SHOW_COMP_OPTION have_crypt; | |
3384 | extern SHOW_COMP_OPTION have_compress; | |
db82db79 AM |
3385 | --- a/sql/sql_parse.cc |
3386 | +++ b/sql/sql_parse.cc | |
b4e1fa2c AM |
3387 | @@ -88,6 +88,7 @@ |
3388 | #include "sp_cache.h" | |
3389 | #include "events.h" | |
3390 | #include "sql_trigger.h" | |
3391 | +#include "query_response_time.h" | |
3392 | #include "transaction.h" | |
3393 | #include "sql_audit.h" | |
3394 | #include "sql_prepare.h" | |
13ceb006 | 3395 | @@ -1518,6 +1519,12 @@ |
11822e22 | 3396 | |
48b678b4 AM |
3397 | ulonglong end_utime_of_query= thd->current_utime(); |
3398 | ulonglong query_exec_time= get_query_exec_time(thd, end_utime_of_query); | |
734d6226 AM |
3399 | +#ifdef HAVE_RESPONSE_TIME_DISTRIBUTION |
3400 | + if (opt_query_response_time_stats) | |
3401 | + { | |
3402 | + query_response_time_collect(query_exec_time); | |
3403 | + } | |
3404 | +#endif | |
48b678b4 AM |
3405 | |
3406 | /* | |
3407 | Low long_query_time value most likely means user is debugging stuff and even | |
13ceb006 | 3408 | @@ -1682,6 +1689,7 @@ |
b4e1fa2c AM |
3409 | case SCH_CHARSETS: |
3410 | case SCH_ENGINES: | |
3411 | case SCH_COLLATIONS: | |
3412 | + case SCH_QUERY_RESPONSE_TIME: | |
3413 | case SCH_COLLATION_CHARACTER_SET_APPLICABILITY: | |
3414 | case SCH_USER_PRIVILEGES: | |
3415 | case SCH_SCHEMA_PRIVILEGES: | |
db82db79 AM |
3416 | --- a/sql/sql_reload.cc |
3417 | +++ b/sql/sql_reload.cc | |
b4e1fa2c AM |
3418 | @@ -25,7 +25,7 @@ |
3419 | #include "hostname.h" // hostname_cache_refresh | |
3420 | #include "sql_repl.h" // reset_master, reset_slave | |
3421 | #include "debug_sync.h" | |
3422 | - | |
3423 | +#include "query_response_time.h" | |
3424 | ||
3425 | /** | |
3426 | Reload/resets privileges and the different caches. | |
13ceb006 | 3427 | @@ -322,6 +322,12 @@ |
b4e1fa2c AM |
3428 | #endif |
3429 | if (options & REFRESH_USER_RESOURCES) | |
3430 | reset_mqh((LEX_USER *) NULL, 0); /* purecov: inspected */ | |
3431 | +#ifdef HAVE_RESPONSE_TIME_DISTRIBUTION | |
3432 | + if (options & REFRESH_QUERY_RESPONSE_TIME) | |
3433 | + { | |
3434 | + query_response_time_flush(); | |
3435 | + } | |
3436 | +#endif // HAVE_RESPONSE_TIME_DISTRIBUTION | |
d8778560 AM |
3437 | if (*write_to_binlog != -1) |
3438 | *write_to_binlog= tmp_write_to_binlog; | |
b4e1fa2c | 3439 | /* |
db82db79 AM |
3440 | --- a/sql/sql_show.cc |
3441 | +++ b/sql/sql_show.cc | |
b4e1fa2c AM |
3442 | @@ -50,6 +50,7 @@ |
3443 | #include "event_data_objects.h" | |
3444 | #endif | |
3445 | #include <my_dir.h> | |
3446 | +#include "query_response_time.h" | |
3447 | #include "lock.h" // MYSQL_OPEN_IGNORE_FLUSH | |
3448 | #include "debug_sync.h" | |
3449 | #include "datadict.h" // dd_frm_type() | |
734d6226 | 3450 | @@ -7888,6 +7889,14 @@ |
b4e1fa2c AM |
3451 | |
3452 | */ | |
3453 | ||
3454 | +ST_FIELD_INFO query_response_time_fields_info[] = | |
3455 | + { | |
3456 | + {"time", QRT_TIME_STRING_LENGTH, MYSQL_TYPE_STRING, 0, 0, "", SKIP_OPEN_TABLE }, | |
3457 | + {"count", MY_INT32_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONG, 0, MY_I_S_UNSIGNED, "", SKIP_OPEN_TABLE }, | |
3458 | + {"total", QRT_TIME_STRING_LENGTH, MYSQL_TYPE_STRING, 0, 0, "", SKIP_OPEN_TABLE }, | |
3459 | + {0, 0, MYSQL_TYPE_STRING, 0, 0, 0, SKIP_OPEN_TABLE } | |
3460 | + }; | |
3461 | + | |
3462 | ST_SCHEMA_TABLE schema_tables[]= | |
3463 | { | |
3464 | {"CHARACTER_SETS", charsets_fields_info, create_schema_table, | |
734d6226 | 3465 | @@ -7941,6 +7950,13 @@ |
b4e1fa2c AM |
3466 | 1, 9, 0, OPTIMIZE_I_S_TABLE|OPEN_TABLE_ONLY}, |
3467 | {"ROUTINES", proc_fields_info, create_schema_table, | |
3468 | fill_schema_proc, make_proc_old_format, 0, -1, -1, 0, 0}, | |
3469 | +#ifdef HAVE_RESPONSE_TIME_DISTRIBUTION | |
3470 | + {"QUERY_RESPONSE_TIME", query_response_time_fields_info, create_schema_table, | |
3471 | + query_response_time_fill, make_old_format, 0, -1, -1, 0, 0}, | |
3472 | +#else | |
3473 | + {"QUERY_RESPONSE_TIME", query_response_time_fields_info, create_schema_table, | |
3474 | + 0, make_old_format, 0, -1, -1, 0, 0}, | |
3475 | +#endif // HAVE_RESPONSE_TIME_DISTRIBUTION | |
3476 | {"SCHEMATA", schema_fields_info, create_schema_table, | |
3477 | fill_schema_schemata, make_schemata_old_format, 0, 1, -1, 0, 0}, | |
3478 | {"SCHEMA_PRIVILEGES", schema_privileges_fields_info, create_schema_table, | |
db82db79 AM |
3479 | --- a/sql/sql_yacc.yy |
3480 | +++ b/sql/sql_yacc.yy | |
3481 | @@ -1194,6 +1194,7 @@ | |
b4e1fa2c AM |
3482 | %token PURGE |
3483 | %token QUARTER_SYM | |
3484 | %token QUERY_SYM | |
3485 | +%token QUERY_RESPONSE_TIME_SYM | |
3486 | %token QUICK | |
3487 | %token RANGE_SYM /* SQL-2003-R */ | |
3488 | %token READS_SYM /* SQL-2003-R */ | |
13ceb006 | 3489 | @@ -11100,6 +11101,15 @@ |
b4e1fa2c AM |
3490 | { |
3491 | Lex->sql_command = SQLCOM_SHOW_SLAVE_STAT; | |
3492 | } | |
3493 | + | QUERY_RESPONSE_TIME_SYM wild_and_where | |
3494 | + { | |
3495 | +#ifdef HAVE_RESPONSE_TIME_DISTRIBUTION | |
3496 | + LEX *lex= Lex; | |
3497 | + lex->sql_command= SQLCOM_SELECT; | |
3498 | + if (prepare_schema_table(YYTHD, lex, 0, SCH_QUERY_RESPONSE_TIME)) | |
3499 | + MYSQL_YYABORT; | |
3500 | +#endif // HAVE_RESPONSE_TIME_DISTRIBUTION | |
3501 | + } | |
3502 | | CREATE PROCEDURE_SYM sp_name | |
3503 | { | |
3504 | LEX *lex= Lex; | |
13ceb006 | 3505 | @@ -11339,6 +11349,12 @@ |
734d6226 AM |
3506 | Lex->type|= REFRESH_SLAVE; |
3507 | Lex->reset_slave_info.all= false; | |
3508 | } | |
b4e1fa2c AM |
3509 | + | QUERY_RESPONSE_TIME_SYM |
3510 | + { | |
3511 | +#ifdef HAVE_RESPONSE_TIME_DISTRIBUTION | |
3512 | + Lex->type|= REFRESH_QUERY_RESPONSE_TIME; | |
3513 | +#endif // HAVE_RESPONSE_TIME_DISTRIBUTION | |
3514 | + } | |
3515 | | MASTER_SYM | |
3516 | { Lex->type|= REFRESH_MASTER; } | |
3517 | | DES_KEY_FILE | |
13ceb006 | 3518 | @@ -12646,6 +12662,7 @@ |
b4e1fa2c AM |
3519 | | PROXY_SYM {} |
3520 | | QUARTER_SYM {} | |
3521 | | QUERY_SYM {} | |
3522 | + | QUERY_RESPONSE_TIME_SYM {} | |
3523 | | QUICK {} | |
3524 | | READ_ONLY_SYM {} | |
3525 | | REBUILD_SYM {} | |
db82db79 AM |
3526 | --- a/sql/sys_vars.cc |
3527 | +++ b/sql/sys_vars.cc | |
b4e1fa2c AM |
3528 | @@ -49,6 +49,7 @@ |
3529 | #include "../storage/perfschema/pfs_server.h" | |
3530 | #endif /* WITH_PERFSCHEMA_STORAGE_ENGINE */ | |
3531 | ||
3532 | +#include "query_response_time.h" | |
3533 | /* | |
3534 | This forward declaration is needed because including sql_base.h | |
3535 | causes further includes. [TODO] Eliminate this forward declaration | |
1bfc1981 | 3536 | @@ -1866,6 +1867,26 @@ |
b4e1fa2c AM |
3537 | DEFAULT(FALSE)); |
3538 | #endif /* HAVE_QUERY_CACHE */ | |
3539 | ||
3540 | + | |
3541 | +static Sys_var_have Sys_have_response_time_distribution( | |
3542 | + "have_response_time_distribution", "have_response_time_distribution", | |
3543 | + READ_ONLY GLOBAL_VAR(have_response_time_distribution), NO_CMD_LINE); | |
3544 | + | |
3545 | +#ifdef HAVE_RESPONSE_TIME_DISTRIBUTION | |
d8778560 AM |
3546 | +static Sys_var_mybool Sys_query_response_time_stats( |
3547 | + "query_response_time_stats", "Enable or disable query response time statisics collecting", | |
3548 | + GLOBAL_VAR(opt_query_response_time_stats), CMD_LINE(OPT_ARG), | |
b4e1fa2c AM |
3549 | + DEFAULT(FALSE)); |
3550 | + | |
3551 | +static Sys_var_ulong Sys_query_response_time_range_base( | |
3552 | + "query_response_time_range_base", | |
3553 | + "Select base of log for query_response_time ranges. WARNING: variable change affect only after flush", | |
3554 | + GLOBAL_VAR(opt_query_response_time_range_base), | |
3555 | + CMD_LINE(REQUIRED_ARG), VALID_RANGE(2, QRT_MAXIMUM_BASE), | |
3556 | + DEFAULT(QRT_DEFAULT_BASE), | |
3557 | + BLOCK_SIZE(1)); | |
3558 | +#endif // HAVE_RESPONSE_TIME_DISTRIBUTION | |
3559 | + | |
3560 | static Sys_var_mybool Sys_secure_auth( | |
3561 | "secure_auth", | |
3562 | "Disallow authentication for accounts that have old (pre-4.1) " | |
48b678b4 AM |
3563 | --- /dev/null |
3564 | +++ b/mysql-test/r/have_response_time_distribution.require | |
3565 | @@ -0,0 +1,2 @@ | |
3566 | +Variable_name Value | |
3567 | +have_response_time_distribution YES | |
734d6226 AM |
3568 | --- a/include/atomic/x86-gcc.h |
3569 | +++ b/include/atomic/x86-gcc.h | |
9dd04cbc | 3570 | @@ -108,27 +108,23 @@ |
db82db79 AM |
3571 | v=tmp; |
3572 | ||
3573 | /* | |
3574 | - On some platforms (e.g. Mac OS X and Solaris) the ebx register | |
3575 | - is held as a pointer to the global offset table. Thus we're not | |
3576 | - allowed to use the b-register on those platforms when compiling | |
3577 | - PIC code, to avoid this we push ebx and pop ebx. The new value | |
3578 | - is copied directly from memory to avoid problems with a implicit | |
3579 | - manipulation of the stack pointer by the push. | |
3580 | - | |
3581 | cmpxchg8b works on both 32-bit platforms and 64-bit platforms but | |
3582 | the code here is only used on 32-bit platforms, on 64-bit | |
3583 | platforms the much simpler make_atomic_cas_body32 will work | |
3584 | fine. | |
3585 | */ | |
3586 | -#define make_atomic_cas_body64 \ | |
3587 | - asm volatile ("push %%ebx;" \ | |
3588 | - "movl (%%ecx), %%ebx;" \ | |
3589 | - "movl 4(%%ecx), %%ecx;" \ | |
3590 | - LOCK_prefix "; cmpxchg8b %0;" \ | |
3591 | - "setz %2; pop %%ebx" \ | |
3592 | - : "=m" (*a), "+A" (*cmp), "=c" (ret) \ | |
3593 | - : "c" (&set), "m" (*a) \ | |
3594 | - : "memory", "esp") | |
3595 | +#define make_atomic_cas_body64 \ | |
9dd04cbc AM |
3596 | + asm volatile ("movl %%edi, -4(%%esp);" \ |
3597 | + "leal %0, %%edi;" \ | |
3598 | + "xchgl %%ebx, %%esi;" \ | |
3599 | + LOCK_prefix "; cmpxchg8b (%%edi);" \ | |
3600 | + "movl %%esi, %%ebx;" \ | |
3601 | + "movl -4(%%esp), %%edi;" \ | |
3602 | + "setz %1;" \ | |
3603 | + : "+m" (*a), "=q" (ret), "+A" (*cmp) \ | |
3604 | + : "S" ((int32)(set & 0xFFFFFFFF)), \ | |
3605 | + "c" ((int32)(set >> 32)) \ | |
3606 | + : "memory", "flags") | |
db82db79 AM |
3607 | #endif |
3608 | ||
3609 | /* | |
734d6226 AM |
3610 | --- a/mysql-test/r/mysqld--help-notwin.result |
3611 | +++ b/mysql-test/r/mysqld--help-notwin.result | |
1bfc1981 | 3612 | @@ -505,6 +505,12 @@ |
734d6226 AM |
3613 | Invalidate queries in query cache on LOCK for write |
3614 | --query-prealloc-size=# | |
3615 | Persistent buffer for query parsing and execution | |
3616 | + --query-response-time-range-base=# | |
3617 | + Select base of log for query_response_time ranges. | |
3618 | + WARNING: variable change affect only after flush | |
3619 | + --query-response-time-stats | |
3620 | + Enable or disable query response time statisics | |
3621 | + collecting | |
3622 | --range-alloc-block-size=# | |
3623 | Allocation block size for storing ranges during | |
3624 | optimization | |
1bfc1981 | 3625 | @@ -939,6 +945,8 @@ |
734d6226 AM |
3626 | query-cache-type ON |
3627 | query-cache-wlock-invalidate FALSE | |
3628 | query-prealloc-size 8192 | |
3629 | +query-response-time-range-base 10 | |
3630 | +query-response-time-stats FALSE | |
3631 | range-alloc-block-size 4096 | |
3632 | read-buffer-size 131072 | |
3633 | read-only FALSE |