Debian Codegraph @

mysql-test/suite/perfschema/t/histograms.test

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