Debian Codegraph @

mysql-test/suite/x/r/performance_schema_sockets.result

raw
1 Verify [No socket from X Plugin should be reported]
2 Verify [Check the IP and PORT of TCP socket]
3 Check if clinet_socket are reported in proper way in PFS
4 Verify [Checking if X Plugin reports 1 connections]
5 connecting...
6 active session is now 'NAME_2'
7 Verify [Checking if X Plugin reports 2 connections]
8 connecting...
9 active session is now 'NAME_3'
10 Verify [Checking if X Plugin reports 3 connections]
11 connecting...
12 active session is now 'NAME_4'
13 Verify [Checking if X Plugin reports 4 connections]
14 connecting...
15 active session is now 'NAME_5'
16 Verify [Checking if X Plugin reports 5 connections]
17 connecting...
18 active session is now 'NAME_6'
19 Verify [Checking if X Plugin reports 6 connections]
20 connecting...
21 active session is now 'NAME_7'
22 Verify [Checking if X Plugin reports 7 connections]
23 connecting...
24 active session is now 'NAME_8'
25 Verify [Checking if X Plugin reports 8 connections]
26 connecting...
27 active session is now 'NAME_9'
28 Verify [Checking if X Plugin reports 9 connections]
29 connecting...
30 active session is now 'NAME_10'
31 Verify [Checking if X Plugin reports 10 connections]
32 connecting...
33 active session is now 'NAME_11'
34 Verify [Checking if X Plugin reports 11 connections]
35 Verify [Peer addresses of all sockets should be set to ::ffff:127.0.0.1]
36 Verify [Peer ports should be unique]
37 Check if we have connection ACTIVE and IDLE state
38 STATE
39 IDLE
40 ACTIVE
41 0 rows affected
42 switched to session NAME_11
43 closing session NAME_11
44 Mysqlx.Ok {
45 msg: "bye!"
46 }
47 switched to session default
48 switched to session NAME_10
49 closing session NAME_10
50 Mysqlx.Ok {
51 msg: "bye!"
52 }
53 switched to session default
54 switched to session NAME_9
55 closing session NAME_9
56 Mysqlx.Ok {
57 msg: "bye!"
58 }
59 switched to session default
60 switched to session NAME_8
61 closing session NAME_8
62 Mysqlx.Ok {
63 msg: "bye!"
64 }
65 switched to session default
66 switched to session NAME_7
67 closing session NAME_7
68 Mysqlx.Ok {
69 msg: "bye!"
70 }
71 switched to session default
72 switched to session NAME_6
73 closing session NAME_6
74 Mysqlx.Ok {
75 msg: "bye!"
76 }
77 switched to session default
78 switched to session NAME_5
79 closing session NAME_5
80 Mysqlx.Ok {
81 msg: "bye!"
82 }
83 switched to session default
84 switched to session NAME_4
85 closing session NAME_4
86 Mysqlx.Ok {
87 msg: "bye!"
88 }
89 switched to session default
90 switched to session NAME_3
91 closing session NAME_3
92 Mysqlx.Ok {
93 msg: "bye!"
94 }
95 switched to session default
96 switched to session NAME_2
97 closing session NAME_2
98 Mysqlx.Ok {
99 msg: "bye!"
100 }
101 switched to session default
102 switched to session default
103 Verify [Checking if X Plugin reports 1 connections]
104 Mysqlx.Ok {
105 msg: "bye!"
106 }
107 ok
108 No socket should be reported by X Plugin
109 Verify [Checking if data in column `COUNT_READ` had increased]
110 Verify [Checking if data in column `COUNT_READ` had increased]
111 Verify [Checking if data in column `COUNT_READ` had increased]
112 Verify [Checking if data in column `COUNT_READ` had increased]
113 Verify [Checking if data in column `COUNT_WRITE` had increased]
114 Verify [Checking if data in column `COUNT_WRITE` had increased]
115 Verify [Checking if data in column `COUNT_WRITE` had increased]
116 Verify [Checking if data in column `COUNT_WRITE` had increased]
117 Verify [Checking if data in column `SUM_NUMBER_OF_BYTES_READ` had increased]
118 Verify [Checking if data in column `SUM_NUMBER_OF_BYTES_READ` had increased]
119 Verify [Checking if data in column `SUM_NUMBER_OF_BYTES_READ` had increased]
120 Verify [Checking if data in column `SUM_NUMBER_OF_BYTES_READ` had increased]
121 Verify [Checking if data in column `SUM_NUMBER_OF_BYTES_WRITE` had increased]
122 Verify [Checking if data in column `SUM_NUMBER_OF_BYTES_WRITE` had increased]
123 Verify [Checking if data in column `SUM_NUMBER_OF_BYTES_WRITE` had increased]
124 Verify [Checking if data in column `SUM_NUMBER_OF_BYTES_WRITE` had increased]
125 Verify [Checking if data in column `SUM_TIMER_READ` had increased]
126 Verify [Checking if data in column `SUM_TIMER_READ` had increased]
127 Verify [Checking if data in column `SUM_TIMER_READ` had increased]
128 Verify [Checking if data in column `SUM_TIMER_READ` had increased]
129 Verify [Checking if data in column `SUM_TIMER_WRITE` had increased]
130 Verify [Checking if data in column `SUM_TIMER_WRITE` had increased]
131 Verify [Checking if data in column `SUM_TIMER_WRITE` had increased]
132 Verify [Checking if data in column `SUM_TIMER_WRITE` had increased]
133 connecting...
134 active session is now 'second_session'
135 Verify [Checking if data in column `SUM_NUMBER_OF_BYTES_READ` had increased]
136 Verify [Checking if data in column `SUM_NUMBER_OF_BYTES_READ` had increased]
137 Verify [Checking if data in column `SUM_NUMBER_OF_BYTES_READ` had increased]
138 Verify [Checking if data in column `SUM_NUMBER_OF_BYTES_READ` had increased]
139 Verify [Checking if data in column `SUM_NUMBER_OF_BYTES_READ` had increased]
140 Verify [Checking if data in column `SUM_NUMBER_OF_BYTES_READ` had increased]
141 Verify [Checking if data in column `SUM_NUMBER_OF_BYTES_READ` had increased]
142 Verify [Checking if data in column `SUM_NUMBER_OF_BYTES_READ` had increased]
143 Verify [Checking if data in column `SUM_NUMBER_OF_BYTES_READ` had increased]
144 Verify [Checking if data in column `SUM_NUMBER_OF_BYTES_READ` had increased]
145 Verify [Checking if data in column `SUM_NUMBER_OF_BYTES_READ` had increased]
146 Verify [Checking if data in column `SUM_NUMBER_OF_BYTES_READ` had increased]
147 Verify [Checking if data in column `SUM_NUMBER_OF_BYTES_READ` had increased]
148 Verify [Checking if data in column `SUM_NUMBER_OF_BYTES_READ` had increased]
149 Verify [Checking if data in column `SUM_NUMBER_OF_BYTES_READ` had increased]
150 Verify [Checking if data in column `SUM_NUMBER_OF_BYTES_READ` had increased]
151 Verify [Checking if data in column `SUM_NUMBER_OF_BYTES_READ` had increased]
152 Verify [Checking if data in column `SUM_NUMBER_OF_BYTES_READ` had increased]
153 Verify [Checking if data in column `SUM_NUMBER_OF_BYTES_READ` had increased]
154 Verify [Checking if data in column `SUM_NUMBER_OF_BYTES_READ` had increased]
155 Verify [Checking if data in column `SUM_NUMBER_OF_BYTES_READ` had increased]
156 Verify [Checking if data in column `SUM_NUMBER_OF_BYTES_READ` had increased]
157 Verify [Checking if data in column `SUM_NUMBER_OF_BYTES_READ` had increased]
158 Verify [Checking if data in column `SUM_NUMBER_OF_BYTES_READ` had increased]
159 Verify [Checking if data in column `SUM_NUMBER_OF_BYTES_READ` had increased]
160 Verify [Checking if data in column `SUM_NUMBER_OF_BYTES_READ` had increased]
161 Verify [Checking if data in column `SUM_NUMBER_OF_BYTES_READ` had increased]
162 Verify [Checking if data in column `SUM_NUMBER_OF_BYTES_READ` had increased]
163 Verify [Checking if data in column `SUM_NUMBER_OF_BYTES_READ` had increased]
164 Verify [Checking if data in column `SUM_NUMBER_OF_BYTES_READ` had increased]
165 Verify [Checking if data in column `SUM_NUMBER_OF_BYTES_READ` had increased]
166 Verify [Checking if data in column `SUM_NUMBER_OF_BYTES_READ` had increased]
167 Verify [Checking if data in column `SUM_NUMBER_OF_BYTES_READ` had increased]
168 Verify [Checking if data in column `SUM_NUMBER_OF_BYTES_READ` had increased]
169 Verify [Checking if data in column `SUM_NUMBER_OF_BYTES_READ` had increased]
170 Verify [Checking if data in column `SUM_NUMBER_OF_BYTES_READ` had increased]
171 Verify [Checking if data in column `SUM_NUMBER_OF_BYTES_READ` had increased]
172 Verify [Checking if data in column `SUM_NUMBER_OF_BYTES_READ` had increased]
173 Verify [Checking if data in column `SUM_NUMBER_OF_BYTES_READ` had increased]
174 Verify [Checking if data in column `SUM_NUMBER_OF_BYTES_READ` had increased]
175 connecting...
176 active session is now 'temporary_connection'
177 Verify [Checking if data in column `COUNT_MISC` had increased]
178 closing session temporary_connection
179 Mysqlx.Ok {
180 msg: "bye!"
181 }
182 switched to session default
183 connecting...
184 active session is now 'temporary_connection'
185 Verify [Checking if data in column `COUNT_MISC` had increased]
186 closing session temporary_connection
187 Mysqlx.Ok {
188 msg: "bye!"
189 }
190 switched to session default
191 connecting...
192 active session is now 'temporary_connection'
193 Verify [Checking if data in column `COUNT_MISC` had increased]
194 closing session temporary_connection
195 Mysqlx.Ok {
196 msg: "bye!"
197 }
198 switched to session default
199 connecting...
200 active session is now 'temporary_connection'
201 Verify [Checking if data in column `COUNT_MISC` had increased]
202 closing session temporary_connection
203 Mysqlx.Ok {
204 msg: "bye!"
205 }
206 switched to session default
207 connecting...
208 active session is now 'temporary_connection'
209 Verify [Checking if data in column `COUNT_MISC` had increased]
210 closing session temporary_connection
211 Mysqlx.Ok {
212 msg: "bye!"
213 }
214 switched to session default
215 connecting...
216 active session is now 'temporary_connection'
217 Verify [Checking if data in column `COUNT_MISC` had increased]
218 closing session temporary_connection
219 Mysqlx.Ok {
220 msg: "bye!"
221 }
222 switched to session default
223 connecting...
224 active session is now 'temporary_connection'
225 Verify [Checking if data in column `COUNT_MISC` had increased]
226 closing session temporary_connection
227 Mysqlx.Ok {
228 msg: "bye!"
229 }
230 switched to session default
231 connecting...
232 active session is now 'temporary_connection'
233 Verify [Checking if data in column `COUNT_MISC` had increased]
234 closing session temporary_connection
235 Mysqlx.Ok {
236 msg: "bye!"
237 }
238 switched to session default
239 connecting...
240 active session is now 'temporary_connection'
241 Verify [Checking if data in column `COUNT_MISC` had increased]
242 closing session temporary_connection
243 Mysqlx.Ok {
244 msg: "bye!"
245 }
246 switched to session default
247 connecting...
248 active session is now 'temporary_connection'
249 Verify [Checking if data in column `COUNT_MISC` had increased]
250 closing session temporary_connection
251 Mysqlx.Ok {
252 msg: "bye!"
253 }
254 switched to session default
255 connecting...
256 active session is now 'temporary_connection'
257 Verify [Checking if data in column `COUNT_MISC` had increased]
258 closing session temporary_connection
259 Mysqlx.Ok {
260 msg: "bye!"
261 }
262 switched to session default
263 connecting...
264 active session is now 'temporary_connection'
265 Verify [Checking if data in column `COUNT_MISC` had increased]
266 closing session temporary_connection
267 Mysqlx.Ok {
268 msg: "bye!"
269 }
270 switched to session default
271 connecting...
272 active session is now 'temporary_connection'
273 Verify [Checking if data in column `COUNT_MISC` had increased]
274 closing session temporary_connection
275 Mysqlx.Ok {
276 msg: "bye!"
277 }
278 switched to session default
279 connecting...
280 active session is now 'temporary_connection'
281 Verify [Checking if data in column `COUNT_MISC` had increased]
282 closing session temporary_connection
283 Mysqlx.Ok {
284 msg: "bye!"
285 }
286 switched to session default
287 connecting...
288 active session is now 'temporary_connection'
289 Verify [Checking if data in column `COUNT_MISC` had increased]
290 closing session temporary_connection
291 Mysqlx.Ok {
292 msg: "bye!"
293 }
294 switched to session default
295 connecting...
296 active session is now 'temporary_connection'
297 Verify [Checking if data in column `COUNT_MISC` had increased]
298 closing session temporary_connection
299 Mysqlx.Ok {
300 msg: "bye!"
301 }
302 switched to session default
303 connecting...
304 active session is now 'temporary_connection'
305 Verify [Checking if data in column `COUNT_MISC` had increased]
306 closing session temporary_connection
307 Mysqlx.Ok {
308 msg: "bye!"
309 }
310 switched to session default
311 connecting...
312 active session is now 'temporary_connection'
313 Verify [Checking if data in column `COUNT_MISC` had increased]
314 closing session temporary_connection
315 Mysqlx.Ok {
316 msg: "bye!"
317 }
318 switched to session default
319 connecting...
320 active session is now 'temporary_connection'
321 Verify [Checking if data in column `COUNT_MISC` had increased]
322 closing session temporary_connection
323 Mysqlx.Ok {
324 msg: "bye!"
325 }
326 switched to session default
327 connecting...
328 active session is now 'temporary_connection'
329 Verify [Checking if data in column `COUNT_MISC` had increased]
330 closing session temporary_connection
331 Mysqlx.Ok {
332 msg: "bye!"
333 }
334 switched to session default
335 connecting...
336 active session is now 'temporary_connection'
337 Verify [Checking if data in column `COUNT_MISC` had increased]
338 closing session temporary_connection
339 Mysqlx.Ok {
340 msg: "bye!"
341 }
342 switched to session default
343 connecting...
344 active session is now 'temporary_connection'
345 Verify [Checking if data in column `COUNT_MISC` had increased]
346 closing session temporary_connection
347 Mysqlx.Ok {
348 msg: "bye!"
349 }
350 switched to session default
351 connecting...
352 active session is now 'temporary_connection'
353 Verify [Checking if data in column `COUNT_MISC` had increased]
354 closing session temporary_connection
355 Mysqlx.Ok {
356 msg: "bye!"
357 }
358 switched to session default
359 connecting...
360 active session is now 'temporary_connection'
361 Verify [Checking if data in column `COUNT_MISC` had increased]
362 closing session temporary_connection
363 Mysqlx.Ok {
364 msg: "bye!"
365 }
366 switched to session default
367 connecting...
368 active session is now 'temporary_connection'
369 Verify [Checking if data in column `COUNT_MISC` had increased]
370 closing session temporary_connection
371 Mysqlx.Ok {
372 msg: "bye!"
373 }
374 switched to session default
375 connecting...
376 active session is now 'temporary_connection'
377 Verify [Checking if data in column `COUNT_MISC` had increased]
378 closing session temporary_connection
379 Mysqlx.Ok {
380 msg: "bye!"
381 }
382 switched to session default
383 connecting...
384 active session is now 'temporary_connection'
385 Verify [Checking if data in column `COUNT_MISC` had increased]
386 closing session temporary_connection
387 Mysqlx.Ok {
388 msg: "bye!"
389 }
390 switched to session default
391 connecting...
392 active session is now 'temporary_connection'
393 Verify [Checking if data in column `COUNT_MISC` had increased]
394 closing session temporary_connection
395 Mysqlx.Ok {
396 msg: "bye!"
397 }
398 switched to session default
399 connecting...
400 active session is now 'temporary_connection'
401 Verify [Checking if data in column `COUNT_MISC` had increased]
402 closing session temporary_connection
403 Mysqlx.Ok {
404 msg: "bye!"
405 }
406 switched to session default
407 connecting...
408 active session is now 'temporary_connection'
409 Verify [Checking if data in column `COUNT_MISC` had increased]
410 closing session temporary_connection
411 Mysqlx.Ok {
412 msg: "bye!"
413 }
414 switched to session default
415 connecting...
416 active session is now 'temporary_connection'
417 Verify [Checking if data in column `COUNT_MISC` had increased]
418 closing session temporary_connection
419 Mysqlx.Ok {
420 msg: "bye!"
421 }
422 switched to session default
423 connecting...
424 active session is now 'temporary_connection'
425 Verify [Checking if data in column `COUNT_MISC` had increased]
426 closing session temporary_connection
427 Mysqlx.Ok {
428 msg: "bye!"
429 }
430 switched to session default
431 connecting...
432 active session is now 'temporary_connection'
433 Verify [Checking if data in column `COUNT_MISC` had increased]
434 closing session temporary_connection
435 Mysqlx.Ok {
436 msg: "bye!"
437 }
438 switched to session default
439 connecting...
440 active session is now 'temporary_connection'
441 Verify [Checking if data in column `COUNT_MISC` had increased]
442 closing session temporary_connection
443 Mysqlx.Ok {
444 msg: "bye!"
445 }
446 switched to session default
447 connecting...
448 active session is now 'temporary_connection'
449 Verify [Checking if data in column `COUNT_MISC` had increased]
450 closing session temporary_connection
451 Mysqlx.Ok {
452 msg: "bye!"
453 }
454 switched to session default
455 connecting...
456 active session is now 'temporary_connection'
457 Verify [Checking if data in column `COUNT_MISC` had increased]
458 closing session temporary_connection
459 Mysqlx.Ok {
460 msg: "bye!"
461 }
462 switched to session default
463 connecting...
464 active session is now 'temporary_connection'
465 Verify [Checking if data in column `COUNT_MISC` had increased]
466 closing session temporary_connection
467 Mysqlx.Ok {
468 msg: "bye!"
469 }
470 switched to session default
471 connecting...
472 active session is now 'temporary_connection'
473 Verify [Checking if data in column `COUNT_MISC` had increased]
474 closing session temporary_connection
475 Mysqlx.Ok {
476 msg: "bye!"
477 }
478 switched to session default
479 connecting...
480 active session is now 'temporary_connection'
481 Verify [Checking if data in column `COUNT_MISC` had increased]
482 closing session temporary_connection
483 Mysqlx.Ok {
484 msg: "bye!"
485 }
486 switched to session default
487 connecting...
488 active session is now 'temporary_connection'
489 Verify [Checking if data in column `COUNT_MISC` had increased]
490 closing session temporary_connection
491 Mysqlx.Ok {
492 msg: "bye!"
493 }
494 switched to session default
495 Verify summary table
496 Verify [Checking if data in column `SUM_NUMBER_OF_BYTES_READ` had increased]
497 Mysqlx.Ok {
498 msg: "bye!"
499 }
500 ok