Debian Codegraph @

mysql-test/suite/perfschema/r/histograms.result

raw
1 update performance_schema.threads
2 set INSTRUMENTED='NO'
3 where PROCESSLIST_ID = connection_id();
4 TRUNCATE TABLE performance_schema.events_statements_summary_by_digest;
5 TRUNCATE TABLE performance_schema.events_statements_histogram_by_digest;
6 TRUNCATE TABLE performance_schema.events_statements_histogram_global;
7 select count(*) from performance_schema.events_statements_summary_by_digest;
8 count(*)
9 0
10 select count(*) from performance_schema.events_statements_histogram_by_digest;
11 count(*)
12 0
13 select count(*) from performance_schema.events_statements_histogram_global;
14 count(*)
15 450
16 select * from performance_schema.events_statements_histogram_global
17 where COUNT_BUCKET > 0;
18 BUCKET_NUMBER BUCKET_TIMER_LOW BUCKET_TIMER_HIGH COUNT_BUCKET COUNT_BUCKET_AND_LOWER BUCKET_QUANTILE
19 select BUCKET_NUMBER, BUCKET_TIMER_LOW, BUCKET_TIMER_HIGH
20 from performance_schema.events_statements_histogram_global
21 where BUCKET_NUMBER <= 10
22 order by BUCKET_NUMBER;
23 BUCKET_NUMBER BUCKET_TIMER_LOW BUCKET_TIMER_HIGH
24 0 0 10000000
25 1 10000000 10471285
26 2 10471285 10964781
27 3 10964781 11481536
28 4 11481536 12022644
29 5 12022644 12589254
30 6 12589254 13182567
31 7 13182567 13803842
32 8 13803842 14454397
33 9 14454397 15135612
34 10 15135612 15848931
35 select BUCKET_NUMBER, BUCKET_TIMER_LOW, BUCKET_TIMER_HIGH
36 from performance_schema.events_statements_histogram_global
37 where BUCKET_NUMBER >= 440
38 order by BUCKET_NUMBER;
39 BUCKET_NUMBER BUCKET_TIMER_LOW BUCKET_TIMER_HIGH
40 440 6025595860743779 6309573444802144
41 441 6309573444802144 6606934480076182
42 442 6606934480076182 6918309709189598
43 443 6918309709189598 7244359600750145
44 444 7244359600750145 7585775750292094
45 445 7585775750292094 7943282347243084
46 446 7943282347243084 8317637711026992
47 447 8317637711026992 8709635899561102
48 448 8709635899561102 9120108393559408
49 449 9120108393559408 18446744073709551615
50 select min(BUCKET_TIMER_HIGH/BUCKET_TIMER_LOW),
51 max(BUCKET_TIMER_HIGH/BUCKET_TIMER_LOW)
52 from performance_schema.events_statements_histogram_global
53 where (BUCKET_NUMBER > 0) and (BUCKET_NUMBER < 449);
54 min(BUCKET_TIMER_HIGH/BUCKET_TIMER_LOW) max(BUCKET_TIMER_HIGH/BUCKET_TIMER_LOW)
55 1.0471 1.0471
56 select "A 1st statement" as marker_one;
57 marker_one
58 A 1st statement
59 select count(*)
60 from performance_schema.events_statements_histogram_by_digest;
61 count(*)
62 450
63 select count(*)
64 from performance_schema.events_statements_histogram_by_digest
65 where COUNT_BUCKET > 0;
66 count(*)
67 1
68 select DIGEST
69 from performance_schema.events_statements_summary_by_digest
70 where DIGEST_TEXT like "%marker_one%"
71 into @digest_one;
72 select count(*)
73 from performance_schema.events_statements_histogram_by_digest
74 where DIGEST = @digest_one;
75 count(*)
76 450
77 select BUCKET_NUMBER, BUCKET_TIMER_LOW, BUCKET_TIMER_HIGH
78 from performance_schema.events_statements_histogram_by_digest
79 where (BUCKET_NUMBER <= 10)
80 and (DIGEST = @digest_one)
81 order by BUCKET_NUMBER;
82 BUCKET_NUMBER BUCKET_TIMER_LOW BUCKET_TIMER_HIGH
83 0 0 10000000
84 1 10000000 10471285
85 2 10471285 10964781
86 3 10964781 11481536
87 4 11481536 12022644
88 5 12022644 12589254
89 6 12589254 13182567
90 7 13182567 13803842
91 8 13803842 14454397
92 9 14454397 15135612
93 10 15135612 15848931
94 select BUCKET_NUMBER, BUCKET_TIMER_LOW, BUCKET_TIMER_HIGH
95 from performance_schema.events_statements_histogram_by_digest
96 where (BUCKET_NUMBER >= 440)
97 and (DIGEST = @digest_one)
98 order by BUCKET_NUMBER;
99 BUCKET_NUMBER BUCKET_TIMER_LOW BUCKET_TIMER_HIGH
100 440 6025595860743779 6309573444802144
101 441 6309573444802144 6606934480076182
102 442 6606934480076182 6918309709189598
103 443 6918309709189598 7244359600750145
104 444 7244359600750145 7585775750292094
105 445 7585775750292094 7943282347243084
106 446 7943282347243084 8317637711026992
107 447 8317637711026992 8709635899561102
108 448 8709635899561102 9120108393559408
109 449 9120108393559408 18446744073709551615
110 select min(BUCKET_TIMER_HIGH/BUCKET_TIMER_LOW),
111 max(BUCKET_TIMER_HIGH/BUCKET_TIMER_LOW)
112 from performance_schema.events_statements_histogram_by_digest
113 where (BUCKET_NUMBER > 0) and (BUCKET_NUMBER < 449)
114 and (DIGEST = @digest_one);
115 min(BUCKET_TIMER_HIGH/BUCKET_TIMER_LOW) max(BUCKET_TIMER_HIGH/BUCKET_TIMER_LOW)
116 1.0471 1.0471
117 select sum(COUNT_BUCKET)
118 from performance_schema.events_statements_histogram_by_digest
119 where DIGEST = @digest_one;
120 sum(COUNT_BUCKET)
121 1
122 select sum(COUNT_BUCKET)
123 from performance_schema.events_statements_histogram_global;
124 sum(COUNT_BUCKET)
125 1
126 select "A 1st statement, again" as marker_one;
127 marker_one
128 A 1st statement, again
129 select sum(COUNT_BUCKET)
130 from performance_schema.events_statements_histogram_by_digest
131 where DIGEST = @digest_one;
132 sum(COUNT_BUCKET)
133 2
134 select sum(COUNT_BUCKET)
135 from performance_schema.events_statements_histogram_global;
136 sum(COUNT_BUCKET)
137 2
138 select "A 1st statement, again and again" as marker_one;
139 marker_one
140 A 1st statement, again and again
141 select sum(COUNT_BUCKET)
142 from performance_schema.events_statements_histogram_by_digest
143 where DIGEST = @digest_one;
144 sum(COUNT_BUCKET)
145 3
146 select sum(COUNT_BUCKET)
147 from performance_schema.events_statements_histogram_global;
148 sum(COUNT_BUCKET)
149 3
150 select "A 2nd statement" as marker_two;
151 marker_two
152 A 2nd statement
153 select DIGEST
154 from performance_schema.events_statements_summary_by_digest
155 where DIGEST_TEXT like "%marker_two%"
156 into @digest_two;
157 select sum(COUNT_BUCKET)
158 from performance_schema.events_statements_histogram_by_digest
159 where DIGEST = @digest_one;
160 sum(COUNT_BUCKET)
161 3
162 select sum(COUNT_BUCKET)
163 from performance_schema.events_statements_histogram_by_digest
164 where DIGEST = @digest_two;
165 sum(COUNT_BUCKET)
166 1
167 select sum(COUNT_BUCKET)
168 from performance_schema.events_statements_histogram_global;
169 sum(COUNT_BUCKET)
170 4
171 select "A 2nd statement, again" as marker_two;
172 marker_two
173 A 2nd statement, again
174 select sum(COUNT_BUCKET), max(COUNT_BUCKET_AND_LOWER)
175 from performance_schema.events_statements_histogram_by_digest
176 where DIGEST = @digest_one;
177 sum(COUNT_BUCKET) max(COUNT_BUCKET_AND_LOWER)
178 3 3
179 select sum(COUNT_BUCKET), max(COUNT_BUCKET_AND_LOWER)
180 from performance_schema.events_statements_histogram_by_digest
181 where DIGEST = @digest_two;
182 sum(COUNT_BUCKET) max(COUNT_BUCKET_AND_LOWER)
183 2 2
184 select sum(COUNT_BUCKET)
185 from performance_schema.events_statements_histogram_global;
186 sum(COUNT_BUCKET)
187 5
188 select sum(COUNT_BUCKET)
189 from performance_schema.events_statements_histogram_by_digest
190 where (DIGEST = @digest_one)
191 into @sum_digest_one;
192 select min(BUCKET_TIMER_LOW)
193 from performance_schema.events_statements_histogram_by_digest
194 where (DIGEST = @digest_one)
195 and (COUNT_BUCKET > 0)
196 into @min_digest_one;
197 select BUCKET_TIMER_HIGH
198 from performance_schema.events_statements_histogram_by_digest
199 where (DIGEST = @digest_one)
200 and (COUNT_BUCKET_AND_LOWER = @sum_digest_one)
201 order by BUCKET_NUMBER
202 limit 1
203 into @max_digest_one;
204 select DIGEST_TEXT,
205 "Check quantile relative values" as check_title,
206 (0 <= QUANTILE_95) as check_1,
207 (QUANTILE_95 <= QUANTILE_99) as check_2,
208 (QUANTILE_99 <= QUANTILE_999) as check_3
209 from performance_schema.events_statements_summary_by_digest;
210 DIGEST_TEXT check_title check_1 check_2 check_3
211 SELECT ? AS `marker_one` Check quantile relative values 1 1 1
212 SELECT ? AS `marker_two` Check quantile relative values 1 1 1
213 select
214 DIGEST_TEXT,
215 "Check quantile values within bounds" as check_title,
216 (0 <= @min_digest_one) as check_1,
217 (@min_digest_one <= QUANTILE_95) as check_2,
218 (QUANTILE_999 <= @max_digest_one) as check_3
219 from performance_schema.events_statements_summary_by_digest
220 where DIGEST = @digest_one;
221 DIGEST_TEXT check_title check_1 check_2 check_3
222 SELECT ? AS `marker_one` Check quantile values within bounds 1 1 1
223 truncate table performance_schema.events_statements_histogram_by_digest;
224 select count(*)
225 from performance_schema.events_statements_histogram_by_digest
226 where DIGEST = @digest_one;
227 count(*)
228 450
229 select sum(COUNT_BUCKET)
230 from performance_schema.events_statements_histogram_by_digest
231 where DIGEST = @digest_one;
232 sum(COUNT_BUCKET)
233 0
234 select count(*)
235 from performance_schema.events_statements_histogram_by_digest
236 where DIGEST = @digest_two;
237 count(*)
238 450
239 select sum(COUNT_BUCKET)
240 from performance_schema.events_statements_histogram_by_digest
241 where DIGEST = @digest_two;
242 sum(COUNT_BUCKET)
243 0
244 select sum(COUNT_BUCKET)
245 from performance_schema.events_statements_histogram_global;
246 sum(COUNT_BUCKET)
247 5
248 select DIGEST_TEXT, COUNT_STAR
249 from performance_schema.events_statements_summary_by_digest;
250 DIGEST_TEXT COUNT_STAR
251 SELECT ? AS `marker_one` 3
252 SELECT ? AS `marker_two` 2
253 select "A 2nd statement, again" as marker_two;
254 marker_two
255 A 2nd statement, again
256 select sum(COUNT_BUCKET)
257 from performance_schema.events_statements_histogram_by_digest
258 where DIGEST = @digest_one;
259 sum(COUNT_BUCKET)
260 0
261 select sum(COUNT_BUCKET)
262 from performance_schema.events_statements_histogram_by_digest
263 where DIGEST = @digest_two;
264 sum(COUNT_BUCKET)
265 1
266 select sum(COUNT_BUCKET)
267 from performance_schema.events_statements_histogram_global;
268 sum(COUNT_BUCKET)
269 6
270 truncate table performance_schema.events_statements_histogram_global;
271 select sum(COUNT_BUCKET)
272 from performance_schema.events_statements_histogram_by_digest
273 where DIGEST = @digest_one;
274 sum(COUNT_BUCKET)
275 0
276 select sum(COUNT_BUCKET)
277 from performance_schema.events_statements_histogram_by_digest
278 where DIGEST = @digest_two;
279 sum(COUNT_BUCKET)
280 1
281 select sum(COUNT_BUCKET)
282 from performance_schema.events_statements_histogram_global;
283 sum(COUNT_BUCKET)
284 0
285 select DIGEST_TEXT, COUNT_STAR
286 from performance_schema.events_statements_summary_by_digest;
287 DIGEST_TEXT COUNT_STAR
288 SELECT ? AS `marker_one` 3
289 SELECT ? AS `marker_two` 3
290 select "A 1st statement, again" as marker_one;
291 marker_one
292 A 1st statement, again
293 select sum(COUNT_BUCKET)
294 from performance_schema.events_statements_histogram_by_digest
295 where DIGEST = @digest_one;
296 sum(COUNT_BUCKET)
297 1
298 select sum(COUNT_BUCKET)
299 from performance_schema.events_statements_histogram_by_digest
300 where DIGEST = @digest_two;
301 sum(COUNT_BUCKET)
302 1
303 select sum(COUNT_BUCKET)
304 from performance_schema.events_statements_histogram_global;
305 sum(COUNT_BUCKET)
306 1
307 truncate table performance_schema.events_statements_summary_by_digest;
308 select count(*)
309 from performance_schema.events_statements_histogram_by_digest;
310 count(*)
311 0
312 select sum(COUNT_BUCKET)
313 from performance_schema.events_statements_histogram_global;
314 sum(COUNT_BUCKET)
315 1
316 select "A 1st statement, another time" as marker_one;
317 marker_one
318 A 1st statement, another time
319 select count(*)
320 from performance_schema.events_statements_histogram_by_digest;
321 count(*)
322 450
323 select sum(COUNT_BUCKET)
324 from performance_schema.events_statements_histogram_by_digest
325 where DIGEST = @digest_one;
326 sum(COUNT_BUCKET)
327 1
328 select count(*)
329 from performance_schema.events_statements_histogram_by_digest
330 where DIGEST = @digest_two;
331 count(*)
332 0
333 select sum(COUNT_BUCKET)
334 from performance_schema.events_statements_histogram_global;
335 sum(COUNT_BUCKET)
336 2
337 truncate table performance_schema.events_statements_summary_global_by_event_name;
338 select count(*)
339 from performance_schema.events_statements_histogram_by_digest;
340 count(*)
341 450
342 select sum(COUNT_BUCKET)
343 from performance_schema.events_statements_histogram_by_digest
344 where DIGEST = @digest_one;
345 sum(COUNT_BUCKET)
346 1
347 select count(*)
348 from performance_schema.events_statements_histogram_by_digest
349 where DIGEST = @digest_two;
350 count(*)
351 0
352 select sum(COUNT_BUCKET)
353 from performance_schema.events_statements_histogram_global;
354 sum(COUNT_BUCKET)
355 0