Debian Codegraph @

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

raw
1 CREATE DATABASE db;
2 USE db;
3 TRUNCATE TABLE performance_schema.prepared_statements_instances ;
4 TRUNCATE TABLE performance_schema.events_statements_history_long ;
5 CREATE TABLE t1 (a INT NOT NULL);
6 INSERT INTO t1 VALUES (4), (8), (11), (32), (80);
7 PREPARE st1 FROM 'SELECT SQRT(POW(?,2) + POW(?,2)) AS hypotenuse';
8 SET @table = 't1';
9 SET @s = CONCAT('SELECT * FROM ', @table);
10 PREPARE st2 FROM @s;
11 PREPARE st3 FROM 'INSERT INTO t1 SELECT * FROM t1 WHERE a<=?';
12 PREPARE st4 FROM
13 '(SELECT a FROM t1) UNION (SELECT a+10 FROM t1) ORDER BY RAND()*0+a';
14 SELECT STATEMENT_NAME, SQL_TEXT, COUNT_REPREPARE, COUNT_EXECUTE, SUM_ROWS_SENT, SUM_SELECT_SCAN, SUM_NO_INDEX_USED FROM performance_schema.prepared_statements_instances ;
15 STATEMENT_NAME st1
16 SQL_TEXT SELECT SQRT(POW(?,2) + POW(?,2)) AS hypotenuse
17 COUNT_REPREPARE 0
18 COUNT_EXECUTE 0
19 SUM_ROWS_SENT 0
20 SUM_SELECT_SCAN 0
21 SUM_NO_INDEX_USED 0
22 STATEMENT_NAME st2
23 SQL_TEXT SELECT * FROM t1
24 COUNT_REPREPARE 0
25 COUNT_EXECUTE 0
26 SUM_ROWS_SENT 0
27 SUM_SELECT_SCAN 0
28 SUM_NO_INDEX_USED 0
29 STATEMENT_NAME st3
30 SQL_TEXT INSERT INTO t1 SELECT * FROM t1 WHERE a<=?
31 COUNT_REPREPARE 0
32 COUNT_EXECUTE 0
33 SUM_ROWS_SENT 0
34 SUM_SELECT_SCAN 0
35 SUM_NO_INDEX_USED 0
36 STATEMENT_NAME st4
37 SQL_TEXT (SELECT a FROM t1) UNION (SELECT a+10 FROM t1) ORDER BY RAND()*0+a
38 COUNT_REPREPARE 0
39 COUNT_EXECUTE 0
40 SUM_ROWS_SENT 0
41 SUM_SELECT_SCAN 0
42 SUM_NO_INDEX_USED 0
43 SELECT EVENT_NAME, SQL_TEXT, OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME FROM performance_schema.events_statements_history_long WHERE CURRENT_SCHEMA='db' ;
44 EVENT_NAME statement/sql/truncate
45 SQL_TEXT TRUNCATE TABLE performance_schema.events_statements_history_long
46 OBJECT_TYPE NULL
47 OBJECT_SCHEMA NULL
48 OBJECT_NAME NULL
49 EVENT_NAME statement/sql/create_table
50 SQL_TEXT CREATE TABLE t1 (a INT NOT NULL)
51 OBJECT_TYPE NULL
52 OBJECT_SCHEMA NULL
53 OBJECT_NAME NULL
54 EVENT_NAME statement/sql/insert
55 SQL_TEXT INSERT INTO t1 VALUES (4), (8), (11), (32), (80)
56 OBJECT_TYPE NULL
57 OBJECT_SCHEMA NULL
58 OBJECT_NAME NULL
59 EVENT_NAME statement/sql/prepare_sql
60 SQL_TEXT PREPARE st1 FROM ...
61 OBJECT_TYPE NULL
62 OBJECT_SCHEMA NULL
63 OBJECT_NAME NULL
64 EVENT_NAME statement/sql/set_option
65 SQL_TEXT SET @table = 't1'
66 OBJECT_TYPE NULL
67 OBJECT_SCHEMA NULL
68 OBJECT_NAME NULL
69 EVENT_NAME statement/sql/set_option
70 SQL_TEXT SET @s = CONCAT('SELECT * FROM ', @table)
71 OBJECT_TYPE NULL
72 OBJECT_SCHEMA NULL
73 OBJECT_NAME NULL
74 EVENT_NAME statement/sql/prepare_sql
75 SQL_TEXT PREPARE st2 FROM @s
76 OBJECT_TYPE NULL
77 OBJECT_SCHEMA NULL
78 OBJECT_NAME NULL
79 EVENT_NAME statement/sql/prepare_sql
80 SQL_TEXT PREPARE st3 FROM ...
81 OBJECT_TYPE NULL
82 OBJECT_SCHEMA NULL
83 OBJECT_NAME NULL
84 EVENT_NAME statement/sql/prepare_sql
85 SQL_TEXT PREPARE st4 FROM ...
86 OBJECT_TYPE NULL
87 OBJECT_SCHEMA NULL
88 OBJECT_NAME NULL
89 EVENT_NAME statement/sql/select
90 SQL_TEXT SELECT STATEMENT_NAME, SQL_TEXT, COUNT_REPREPARE, COUNT_EXECUTE, SUM_ROWS_SENT, SUM_SELECT_SCAN, SUM_NO_INDEX_USED FROM performance_schema.prepared_statements_instances
91 OBJECT_TYPE NULL
92 OBJECT_SCHEMA NULL
93 OBJECT_NAME NULL
94 SET @a = 3;
95 SET @b = 4;
96 EXECUTE st1 USING @a, @b;
97 hypotenuse
98 5
99 EXECUTE st2;
100 a
101 4
102 8
103 11
104 32
105 80
106 SET @c=3;
107 EXECUTE st3 using @c;
108 EXECUTE st4;
109 a
110 4
111 8
112 11
113 14
114 18
115 21
116 32
117 42
118 80
119 90
120 SELECT STATEMENT_NAME, SQL_TEXT, COUNT_REPREPARE, COUNT_EXECUTE, SUM_ROWS_SENT, SUM_SELECT_SCAN, SUM_NO_INDEX_USED FROM performance_schema.prepared_statements_instances ;
121 STATEMENT_NAME st1
122 SQL_TEXT SELECT SQRT(POW(?,2) + POW(?,2)) AS hypotenuse
123 COUNT_REPREPARE 0
124 COUNT_EXECUTE 1
125 SUM_ROWS_SENT 1
126 SUM_SELECT_SCAN 0
127 SUM_NO_INDEX_USED 0
128 STATEMENT_NAME st2
129 SQL_TEXT SELECT * FROM t1
130 COUNT_REPREPARE 0
131 COUNT_EXECUTE 1
132 SUM_ROWS_SENT 5
133 SUM_SELECT_SCAN 1
134 SUM_NO_INDEX_USED 1
135 STATEMENT_NAME st3
136 SQL_TEXT INSERT INTO t1 SELECT * FROM t1 WHERE a<=?
137 COUNT_REPREPARE 0
138 COUNT_EXECUTE 1
139 SUM_ROWS_SENT 0
140 SUM_SELECT_SCAN 1
141 SUM_NO_INDEX_USED 1
142 STATEMENT_NAME st4
143 SQL_TEXT (SELECT a FROM t1) UNION (SELECT a+10 FROM t1) ORDER BY RAND()*0+a
144 COUNT_REPREPARE 0
145 COUNT_EXECUTE 1
146 SUM_ROWS_SENT 10
147 SUM_SELECT_SCAN 3
148 SUM_NO_INDEX_USED 1
149 SELECT EVENT_NAME, SQL_TEXT, OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME FROM performance_schema.events_statements_history_long WHERE CURRENT_SCHEMA='db' ;
150 EVENT_NAME statement/sql/truncate
151 SQL_TEXT TRUNCATE TABLE performance_schema.events_statements_history_long
152 OBJECT_TYPE NULL
153 OBJECT_SCHEMA NULL
154 OBJECT_NAME NULL
155 EVENT_NAME statement/sql/create_table
156 SQL_TEXT CREATE TABLE t1 (a INT NOT NULL)
157 OBJECT_TYPE NULL
158 OBJECT_SCHEMA NULL
159 OBJECT_NAME NULL
160 EVENT_NAME statement/sql/insert
161 SQL_TEXT INSERT INTO t1 VALUES (4), (8), (11), (32), (80)
162 OBJECT_TYPE NULL
163 OBJECT_SCHEMA NULL
164 OBJECT_NAME NULL
165 EVENT_NAME statement/sql/prepare_sql
166 SQL_TEXT PREPARE st1 FROM ...
167 OBJECT_TYPE NULL
168 OBJECT_SCHEMA NULL
169 OBJECT_NAME NULL
170 EVENT_NAME statement/sql/set_option
171 SQL_TEXT SET @table = 't1'
172 OBJECT_TYPE NULL
173 OBJECT_SCHEMA NULL
174 OBJECT_NAME NULL
175 EVENT_NAME statement/sql/set_option
176 SQL_TEXT SET @s = CONCAT('SELECT * FROM ', @table)
177 OBJECT_TYPE NULL
178 OBJECT_SCHEMA NULL
179 OBJECT_NAME NULL
180 EVENT_NAME statement/sql/prepare_sql
181 SQL_TEXT PREPARE st2 FROM @s
182 OBJECT_TYPE NULL
183 OBJECT_SCHEMA NULL
184 OBJECT_NAME NULL
185 EVENT_NAME statement/sql/prepare_sql
186 SQL_TEXT PREPARE st3 FROM ...
187 OBJECT_TYPE NULL
188 OBJECT_SCHEMA NULL
189 OBJECT_NAME NULL
190 EVENT_NAME statement/sql/prepare_sql
191 SQL_TEXT PREPARE st4 FROM ...
192 OBJECT_TYPE NULL
193 OBJECT_SCHEMA NULL
194 OBJECT_NAME NULL
195 EVENT_NAME statement/sql/select
196 SQL_TEXT SELECT STATEMENT_NAME, SQL_TEXT, COUNT_REPREPARE, COUNT_EXECUTE, SUM_ROWS_SENT, SUM_SELECT_SCAN, SUM_NO_INDEX_USED FROM performance_schema.prepared_statements_instances
197 OBJECT_TYPE NULL
198 OBJECT_SCHEMA NULL
199 OBJECT_NAME NULL
200 EVENT_NAME statement/sql/select
201 SQL_TEXT SELECT EVENT_NAME, SQL_TEXT, OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME FROM performance_schema.events_statements_history_long WHERE CURRENT_SCHEMA='db'
202 OBJECT_TYPE NULL
203 OBJECT_SCHEMA NULL
204 OBJECT_NAME NULL
205 EVENT_NAME statement/sql/set_option
206 SQL_TEXT SET @a = 3
207 OBJECT_TYPE NULL
208 OBJECT_SCHEMA NULL
209 OBJECT_NAME NULL
210 EVENT_NAME statement/sql/set_option
211 SQL_TEXT SET @b = 4
212 OBJECT_TYPE NULL
213 OBJECT_SCHEMA NULL
214 OBJECT_NAME NULL
215 EVENT_NAME statement/sql/execute_sql
216 SQL_TEXT EXECUTE st1 USING @a, @b
217 OBJECT_TYPE NULL
218 OBJECT_SCHEMA NULL
219 OBJECT_NAME NULL
220 EVENT_NAME statement/sql/execute_sql
221 SQL_TEXT EXECUTE st2
222 OBJECT_TYPE NULL
223 OBJECT_SCHEMA NULL
224 OBJECT_NAME NULL
225 EVENT_NAME statement/sql/set_option
226 SQL_TEXT SET @c=3
227 OBJECT_TYPE NULL
228 OBJECT_SCHEMA NULL
229 OBJECT_NAME NULL
230 EVENT_NAME statement/sql/execute_sql
231 SQL_TEXT EXECUTE st3 using @c
232 OBJECT_TYPE NULL
233 OBJECT_SCHEMA NULL
234 OBJECT_NAME NULL
235 EVENT_NAME statement/sql/execute_sql
236 SQL_TEXT EXECUTE st4
237 OBJECT_TYPE NULL
238 OBJECT_SCHEMA NULL
239 OBJECT_NAME NULL
240 EVENT_NAME statement/sql/select
241 SQL_TEXT SELECT STATEMENT_NAME, SQL_TEXT, COUNT_REPREPARE, COUNT_EXECUTE, SUM_ROWS_SENT, SUM_SELECT_SCAN, SUM_NO_INDEX_USED FROM performance_schema.prepared_statements_instances
242 OBJECT_TYPE NULL
243 OBJECT_SCHEMA NULL
244 OBJECT_NAME NULL
245 TRUNCATE TABLE performance_schema.prepared_statements_instances ;
246 SELECT STATEMENT_NAME, SQL_TEXT, COUNT_REPREPARE, COUNT_EXECUTE, SUM_ROWS_SENT, SUM_SELECT_SCAN, SUM_NO_INDEX_USED FROM performance_schema.prepared_statements_instances ;
247 STATEMENT_NAME st1
248 SQL_TEXT SELECT SQRT(POW(?,2) + POW(?,2)) AS hypotenuse
249 COUNT_REPREPARE 0
250 COUNT_EXECUTE 0
251 SUM_ROWS_SENT 0
252 SUM_SELECT_SCAN 0
253 SUM_NO_INDEX_USED 0
254 STATEMENT_NAME st2
255 SQL_TEXT SELECT * FROM t1
256 COUNT_REPREPARE 0
257 COUNT_EXECUTE 0
258 SUM_ROWS_SENT 0
259 SUM_SELECT_SCAN 0
260 SUM_NO_INDEX_USED 0
261 STATEMENT_NAME st3
262 SQL_TEXT INSERT INTO t1 SELECT * FROM t1 WHERE a<=?
263 COUNT_REPREPARE 0
264 COUNT_EXECUTE 0
265 SUM_ROWS_SENT 0
266 SUM_SELECT_SCAN 0
267 SUM_NO_INDEX_USED 0
268 STATEMENT_NAME st4
269 SQL_TEXT (SELECT a FROM t1) UNION (SELECT a+10 FROM t1) ORDER BY RAND()*0+a
270 COUNT_REPREPARE 0
271 COUNT_EXECUTE 0
272 SUM_ROWS_SENT 0
273 SUM_SELECT_SCAN 0
274 SUM_NO_INDEX_USED 0
275 DEALLOCATE PREPARE st1;
276 DEALLOCATE PREPARE st2;
277 DEALLOCATE PREPARE st3;
278 DEALLOCATE PREPARE st4;
279 DROP TABLE t1;
280 SELECT STATEMENT_NAME, SQL_TEXT, COUNT_REPREPARE, COUNT_EXECUTE, SUM_ROWS_SENT, SUM_SELECT_SCAN, SUM_NO_INDEX_USED FROM performance_schema.prepared_statements_instances ;
281 SELECT EVENT_NAME, SQL_TEXT, OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME FROM performance_schema.events_statements_history_long WHERE CURRENT_SCHEMA='db' ;
282 EVENT_NAME statement/sql/truncate
283 SQL_TEXT TRUNCATE TABLE performance_schema.events_statements_history_long
284 OBJECT_TYPE NULL
285 OBJECT_SCHEMA NULL
286 OBJECT_NAME NULL
287 EVENT_NAME statement/sql/create_table
288 SQL_TEXT CREATE TABLE t1 (a INT NOT NULL)
289 OBJECT_TYPE NULL
290 OBJECT_SCHEMA NULL
291 OBJECT_NAME NULL
292 EVENT_NAME statement/sql/insert
293 SQL_TEXT INSERT INTO t1 VALUES (4), (8), (11), (32), (80)
294 OBJECT_TYPE NULL
295 OBJECT_SCHEMA NULL
296 OBJECT_NAME NULL
297 EVENT_NAME statement/sql/prepare_sql
298 SQL_TEXT PREPARE st1 FROM ...
299 OBJECT_TYPE NULL
300 OBJECT_SCHEMA NULL
301 OBJECT_NAME NULL
302 EVENT_NAME statement/sql/set_option
303 SQL_TEXT SET @table = 't1'
304 OBJECT_TYPE NULL
305 OBJECT_SCHEMA NULL
306 OBJECT_NAME NULL
307 EVENT_NAME statement/sql/set_option
308 SQL_TEXT SET @s = CONCAT('SELECT * FROM ', @table)
309 OBJECT_TYPE NULL
310 OBJECT_SCHEMA NULL
311 OBJECT_NAME NULL
312 EVENT_NAME statement/sql/prepare_sql
313 SQL_TEXT PREPARE st2 FROM @s
314 OBJECT_TYPE NULL
315 OBJECT_SCHEMA NULL
316 OBJECT_NAME NULL
317 EVENT_NAME statement/sql/prepare_sql
318 SQL_TEXT PREPARE st3 FROM ...
319 OBJECT_TYPE NULL
320 OBJECT_SCHEMA NULL
321 OBJECT_NAME NULL
322 EVENT_NAME statement/sql/prepare_sql
323 SQL_TEXT PREPARE st4 FROM ...
324 OBJECT_TYPE NULL
325 OBJECT_SCHEMA NULL
326 OBJECT_NAME NULL
327 EVENT_NAME statement/sql/select
328 SQL_TEXT SELECT STATEMENT_NAME, SQL_TEXT, COUNT_REPREPARE, COUNT_EXECUTE, SUM_ROWS_SENT, SUM_SELECT_SCAN, SUM_NO_INDEX_USED FROM performance_schema.prepared_statements_instances
329 OBJECT_TYPE NULL
330 OBJECT_SCHEMA NULL
331 OBJECT_NAME NULL
332 EVENT_NAME statement/sql/select
333 SQL_TEXT SELECT EVENT_NAME, SQL_TEXT, OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME FROM performance_schema.events_statements_history_long WHERE CURRENT_SCHEMA='db'
334 OBJECT_TYPE NULL
335 OBJECT_SCHEMA NULL
336 OBJECT_NAME NULL
337 EVENT_NAME statement/sql/set_option
338 SQL_TEXT SET @a = 3
339 OBJECT_TYPE NULL
340 OBJECT_SCHEMA NULL
341 OBJECT_NAME NULL
342 EVENT_NAME statement/sql/set_option
343 SQL_TEXT SET @b = 4
344 OBJECT_TYPE NULL
345 OBJECT_SCHEMA NULL
346 OBJECT_NAME NULL
347 EVENT_NAME statement/sql/execute_sql
348 SQL_TEXT EXECUTE st1 USING @a, @b
349 OBJECT_TYPE NULL
350 OBJECT_SCHEMA NULL
351 OBJECT_NAME NULL
352 EVENT_NAME statement/sql/execute_sql
353 SQL_TEXT EXECUTE st2
354 OBJECT_TYPE NULL
355 OBJECT_SCHEMA NULL
356 OBJECT_NAME NULL
357 EVENT_NAME statement/sql/set_option
358 SQL_TEXT SET @c=3
359 OBJECT_TYPE NULL
360 OBJECT_SCHEMA NULL
361 OBJECT_NAME NULL
362 EVENT_NAME statement/sql/execute_sql
363 SQL_TEXT EXECUTE st3 using @c
364 OBJECT_TYPE NULL
365 OBJECT_SCHEMA NULL
366 OBJECT_NAME NULL
367 EVENT_NAME statement/sql/execute_sql
368 SQL_TEXT EXECUTE st4
369 OBJECT_TYPE NULL
370 OBJECT_SCHEMA NULL
371 OBJECT_NAME NULL
372 EVENT_NAME statement/sql/select
373 SQL_TEXT SELECT STATEMENT_NAME, SQL_TEXT, COUNT_REPREPARE, COUNT_EXECUTE, SUM_ROWS_SENT, SUM_SELECT_SCAN, SUM_NO_INDEX_USED FROM performance_schema.prepared_statements_instances
374 OBJECT_TYPE NULL
375 OBJECT_SCHEMA NULL
376 OBJECT_NAME NULL
377 EVENT_NAME statement/sql/select
378 SQL_TEXT SELECT EVENT_NAME, SQL_TEXT, OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME FROM performance_schema.events_statements_history_long WHERE CURRENT_SCHEMA='db'
379 OBJECT_TYPE NULL
380 OBJECT_SCHEMA NULL
381 OBJECT_NAME NULL
382 EVENT_NAME statement/sql/truncate
383 SQL_TEXT TRUNCATE TABLE performance_schema.prepared_statements_instances
384 OBJECT_TYPE NULL
385 OBJECT_SCHEMA NULL
386 OBJECT_NAME NULL
387 EVENT_NAME statement/sql/select
388 SQL_TEXT SELECT STATEMENT_NAME, SQL_TEXT, COUNT_REPREPARE, COUNT_EXECUTE, SUM_ROWS_SENT, SUM_SELECT_SCAN, SUM_NO_INDEX_USED FROM performance_schema.prepared_statements_instances
389 OBJECT_TYPE NULL
390 OBJECT_SCHEMA NULL
391 OBJECT_NAME NULL
392 EVENT_NAME statement/sql/dealloc_sql
393 SQL_TEXT DEALLOCATE PREPARE st1
394 OBJECT_TYPE NULL
395 OBJECT_SCHEMA NULL
396 OBJECT_NAME NULL
397 EVENT_NAME statement/sql/dealloc_sql
398 SQL_TEXT DEALLOCATE PREPARE st2
399 OBJECT_TYPE NULL
400 OBJECT_SCHEMA NULL
401 OBJECT_NAME NULL
402 EVENT_NAME statement/sql/dealloc_sql
403 SQL_TEXT DEALLOCATE PREPARE st3
404 OBJECT_TYPE NULL
405 OBJECT_SCHEMA NULL
406 OBJECT_NAME NULL
407 EVENT_NAME statement/sql/dealloc_sql
408 SQL_TEXT DEALLOCATE PREPARE st4
409 OBJECT_TYPE NULL
410 OBJECT_SCHEMA NULL
411 OBJECT_NAME NULL
412 EVENT_NAME statement/sql/drop_table
413 SQL_TEXT DROP TABLE t1
414 OBJECT_TYPE NULL
415 OBJECT_SCHEMA NULL
416 OBJECT_NAME NULL
417 EVENT_NAME statement/sql/select
418 SQL_TEXT SELECT STATEMENT_NAME, SQL_TEXT, COUNT_REPREPARE, COUNT_EXECUTE, SUM_ROWS_SENT, SUM_SELECT_SCAN, SUM_NO_INDEX_USED FROM performance_schema.prepared_statements_instances
419 OBJECT_TYPE NULL
420 OBJECT_SCHEMA NULL
421 OBJECT_NAME NULL
422 TRUNCATE TABLE performance_schema.events_statements_history_long ;
423 UPDATE performance_schema.setup_consumers SET ENABLED = 'NO';
424 CREATE TABLE t1 (a INT NOT NULL);
425 INSERT INTO t1 VALUES (4), (8), (11), (32), (80);
426 PREPARE st1 FROM 'SELECT SQRT(POW(?,2) + POW(?,2)) AS hypotenuse';
427 SET @table = 't1';
428 SET @s = CONCAT('SELECT * FROM ', @table);
429 PREPARE st2 FROM @s;
430 PREPARE st3 FROM 'INSERT INTO t1 SELECT * FROM t1 WHERE a<=?';
431 PREPARE st4 FROM
432 '(SELECT a FROM t1) UNION (SELECT a+10 FROM t1) ORDER BY RAND()*0+a';
433 SELECT STATEMENT_NAME, SQL_TEXT, COUNT_REPREPARE, COUNT_EXECUTE, SUM_ROWS_SENT, SUM_SELECT_SCAN, SUM_NO_INDEX_USED FROM performance_schema.prepared_statements_instances ;
434 SELECT EVENT_NAME, SQL_TEXT, OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME FROM performance_schema.events_statements_history_long WHERE CURRENT_SCHEMA='db' ;
435 EVENT_NAME statement/sql/truncate
436 SQL_TEXT TRUNCATE TABLE performance_schema.events_statements_history_long
437 OBJECT_TYPE NULL
438 OBJECT_SCHEMA NULL
439 OBJECT_NAME NULL
440 SET @a = 3;
441 SET @b = 4;
442 EXECUTE st1 USING @a, @b;
443 hypotenuse
444 5
445 EXECUTE st2;
446 a
447 4
448 8
449 11
450 32
451 80
452 SET @c=3;
453 EXECUTE st3 using @c;
454 EXECUTE st4;
455 a
456 4
457 8
458 11
459 14
460 18
461 21
462 32
463 42
464 80
465 90
466 SELECT STATEMENT_NAME, SQL_TEXT, COUNT_REPREPARE, COUNT_EXECUTE, SUM_ROWS_SENT, SUM_SELECT_SCAN, SUM_NO_INDEX_USED FROM performance_schema.prepared_statements_instances ;
467 SELECT EVENT_NAME, SQL_TEXT, OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME FROM performance_schema.events_statements_history_long WHERE CURRENT_SCHEMA='db' ;
468 EVENT_NAME statement/sql/truncate
469 SQL_TEXT TRUNCATE TABLE performance_schema.events_statements_history_long
470 OBJECT_TYPE NULL
471 OBJECT_SCHEMA NULL
472 OBJECT_NAME NULL
473 DEALLOCATE PREPARE st1;
474 DEALLOCATE PREPARE st2;
475 DEALLOCATE PREPARE st3;
476 DEALLOCATE PREPARE st4;
477 DROP TABLE t1;
478 SELECT STATEMENT_NAME, SQL_TEXT, COUNT_REPREPARE, COUNT_EXECUTE, SUM_ROWS_SENT, SUM_SELECT_SCAN, SUM_NO_INDEX_USED FROM performance_schema.prepared_statements_instances ;
479 SELECT EVENT_NAME, SQL_TEXT, OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME FROM performance_schema.events_statements_history_long WHERE CURRENT_SCHEMA='db' ;
480 EVENT_NAME statement/sql/truncate
481 SQL_TEXT TRUNCATE TABLE performance_schema.events_statements_history_long
482 OBJECT_TYPE NULL
483 OBJECT_SCHEMA NULL
484 OBJECT_NAME NULL
485 TRUNCATE TABLE performance_schema.events_statements_history_long ;
486 UPDATE performance_schema.setup_consumers SET ENABLED = 'YES';
487 PREPARE st FROM 'SELECT SUM(1000 + ?) AS total';
488 SELECT STATEMENT_NAME, SQL_TEXT, COUNT_REPREPARE, COUNT_EXECUTE, SUM_ROWS_SENT, SUM_SELECT_SCAN, SUM_NO_INDEX_USED FROM performance_schema.prepared_statements_instances ;
489 STATEMENT_NAME st
490 SQL_TEXT SELECT SUM(1000 + ?) AS total
491 COUNT_REPREPARE 0
492 COUNT_EXECUTE 0
493 SUM_ROWS_SENT 0
494 SUM_SELECT_SCAN 0
495 SUM_NO_INDEX_USED 0
496 SET @d=100;
497 EXECUTE st USING @d;
498 total
499 1100
500 SELECT STATEMENT_NAME, SQL_TEXT, COUNT_REPREPARE, COUNT_EXECUTE, SUM_ROWS_SENT, SUM_SELECT_SCAN, SUM_NO_INDEX_USED FROM performance_schema.prepared_statements_instances ;
501 STATEMENT_NAME st
502 SQL_TEXT SELECT SUM(1000 + ?) AS total
503 COUNT_REPREPARE 0
504 COUNT_EXECUTE 1
505 SUM_ROWS_SENT 1
506 SUM_SELECT_SCAN 0
507 SUM_NO_INDEX_USED 0
508 SET @d = @d + 100;
509 EXECUTE st USING @d;
510 total
511 1200
512 SELECT STATEMENT_NAME, SQL_TEXT, COUNT_REPREPARE, COUNT_EXECUTE, SUM_ROWS_SENT, SUM_SELECT_SCAN, SUM_NO_INDEX_USED FROM performance_schema.prepared_statements_instances ;
513 STATEMENT_NAME st
514 SQL_TEXT SELECT SUM(1000 + ?) AS total
515 COUNT_REPREPARE 0
516 COUNT_EXECUTE 2
517 SUM_ROWS_SENT 2
518 SUM_SELECT_SCAN 0
519 SUM_NO_INDEX_USED 0
520 SET @d = @d + 100;
521 EXECUTE st USING @d;
522 total
523 1300
524 SELECT STATEMENT_NAME, SQL_TEXT, COUNT_REPREPARE, COUNT_EXECUTE, SUM_ROWS_SENT, SUM_SELECT_SCAN, SUM_NO_INDEX_USED FROM performance_schema.prepared_statements_instances ;
525 STATEMENT_NAME st
526 SQL_TEXT SELECT SUM(1000 + ?) AS total
527 COUNT_REPREPARE 0
528 COUNT_EXECUTE 3
529 SUM_ROWS_SENT 3
530 SUM_SELECT_SCAN 0
531 SUM_NO_INDEX_USED 0
532 SET @d = @d + 100;
533 EXECUTE st USING @d;
534 total
535 1400
536 SELECT STATEMENT_NAME, SQL_TEXT, COUNT_REPREPARE, COUNT_EXECUTE, SUM_ROWS_SENT, SUM_SELECT_SCAN, SUM_NO_INDEX_USED FROM performance_schema.prepared_statements_instances ;
537 STATEMENT_NAME st
538 SQL_TEXT SELECT SUM(1000 + ?) AS total
539 COUNT_REPREPARE 0
540 COUNT_EXECUTE 4
541 SUM_ROWS_SENT 4
542 SUM_SELECT_SCAN 0
543 SUM_NO_INDEX_USED 0
544 SET @d = @d + 100;
545 EXECUTE st USING @d;
546 total
547 1500
548 SELECT STATEMENT_NAME, SQL_TEXT, COUNT_REPREPARE, COUNT_EXECUTE, SUM_ROWS_SENT, SUM_SELECT_SCAN, SUM_NO_INDEX_USED FROM performance_schema.prepared_statements_instances ;
549 STATEMENT_NAME st
550 SQL_TEXT SELECT SUM(1000 + ?) AS total
551 COUNT_REPREPARE 0
552 COUNT_EXECUTE 5
553 SUM_ROWS_SENT 5
554 SUM_SELECT_SCAN 0
555 SUM_NO_INDEX_USED 0
556 SET @d = @d + 100;
557 EXECUTE st USING @d;
558 total
559 1600
560 SELECT STATEMENT_NAME, SQL_TEXT, COUNT_REPREPARE, COUNT_EXECUTE, SUM_ROWS_SENT, SUM_SELECT_SCAN, SUM_NO_INDEX_USED FROM performance_schema.prepared_statements_instances ;
561 STATEMENT_NAME st
562 SQL_TEXT SELECT SUM(1000 + ?) AS total
563 COUNT_REPREPARE 0
564 COUNT_EXECUTE 6
565 SUM_ROWS_SENT 6
566 SUM_SELECT_SCAN 0
567 SUM_NO_INDEX_USED 0
568 TRUNCATE TABLE performance_schema.prepared_statements_instances ;
569 SELECT STATEMENT_NAME, SQL_TEXT, COUNT_REPREPARE, COUNT_EXECUTE, SUM_ROWS_SENT, SUM_SELECT_SCAN, SUM_NO_INDEX_USED FROM performance_schema.prepared_statements_instances ;
570 STATEMENT_NAME st
571 SQL_TEXT SELECT SUM(1000 + ?) AS total
572 COUNT_REPREPARE 0
573 COUNT_EXECUTE 0
574 SUM_ROWS_SENT 0
575 SUM_SELECT_SCAN 0
576 SUM_NO_INDEX_USED 0
577 UPDATE performance_schema.setup_instruments SET ENABLED = 'NO'
578 WHERE NAME like "statement/sql/execute%";
579 SET @d=3274;
580 EXECUTE st USING @d;
581 total
582 4274
583 SELECT STATEMENT_NAME, SQL_TEXT, COUNT_REPREPARE, COUNT_EXECUTE, SUM_ROWS_SENT, SUM_SELECT_SCAN, SUM_NO_INDEX_USED FROM performance_schema.prepared_statements_instances ;
584 STATEMENT_NAME st
585 SQL_TEXT SELECT SUM(1000 + ?) AS total
586 COUNT_REPREPARE 0
587 COUNT_EXECUTE 0
588 SUM_ROWS_SENT 0
589 SUM_SELECT_SCAN 0
590 SUM_NO_INDEX_USED 0
591 UPDATE performance_schema.setup_instruments SET ENABLED = 'NO'
592 WHERE NAME like "statement/sql/prepare%";
593 DEALLOCATE PREPARE st;
594 SELECT STATEMENT_NAME, SQL_TEXT, COUNT_REPREPARE, COUNT_EXECUTE, SUM_ROWS_SENT, SUM_SELECT_SCAN, SUM_NO_INDEX_USED FROM performance_schema.prepared_statements_instances ;
595 UPDATE performance_schema.setup_instruments SET ENABLED = 'YES'
596 WHERE NAME like "statement/sql/prepare%";
597 UPDATE performance_schema.setup_instruments SET ENABLED = 'YES'
598 WHERE NAME like "statement/sql/execute%";
599 CREATE TABLE tab(
600 Id INT,
601 name CHAR(10),
602 age INT
603 );
604 INSERT INTO tab VALUES(1,"Nakshatr",25),(2,"chanda",24),(3,"tejas",78);
605 PREPARE st FROM 'SELECT * FROM tab';
606 SELECT STATEMENT_NAME, SQL_TEXT, COUNT_REPREPARE, COUNT_EXECUTE, SUM_ROWS_SENT, SUM_SELECT_SCAN, SUM_NO_INDEX_USED FROM performance_schema.prepared_statements_instances ;
607 STATEMENT_NAME st
608 SQL_TEXT SELECT * FROM tab
609 COUNT_REPREPARE 0
610 COUNT_EXECUTE 0
611 SUM_ROWS_SENT 0
612 SUM_SELECT_SCAN 0
613 SUM_NO_INDEX_USED 0
614 EXECUTE st;
615 Id name age
616 1 Nakshatr 25
617 2 chanda 24
618 3 tejas 78
619 SELECT STATEMENT_NAME, SQL_TEXT, COUNT_REPREPARE, COUNT_EXECUTE, SUM_ROWS_SENT, SUM_SELECT_SCAN, SUM_NO_INDEX_USED FROM performance_schema.prepared_statements_instances ;
620 STATEMENT_NAME st
621 SQL_TEXT SELECT * FROM tab
622 COUNT_REPREPARE 0
623 COUNT_EXECUTE 1
624 SUM_ROWS_SENT 3
625 SUM_SELECT_SCAN 1
626 SUM_NO_INDEX_USED 1
627 ALTER TABLE tab DROP COLUMN age;
628 EXECUTE st;
629 Id name
630 1 Nakshatr
631 2 chanda
632 3 tejas
633 SELECT STATEMENT_NAME, SQL_TEXT, COUNT_REPREPARE, COUNT_EXECUTE, SUM_ROWS_SENT, SUM_SELECT_SCAN, SUM_NO_INDEX_USED FROM performance_schema.prepared_statements_instances ;
634 STATEMENT_NAME st
635 SQL_TEXT SELECT * FROM tab
636 COUNT_REPREPARE 1
637 COUNT_EXECUTE 2
638 SUM_ROWS_SENT 6
639 SUM_SELECT_SCAN 2
640 SUM_NO_INDEX_USED 2
641 ALTER TABLE tab ADD COLUMN age INT NULL;
642 EXECUTE st;
643 Id name age
644 1 Nakshatr NULL
645 2 chanda NULL
646 3 tejas NULL
647 SELECT STATEMENT_NAME, SQL_TEXT, COUNT_REPREPARE, COUNT_EXECUTE, SUM_ROWS_SENT, SUM_SELECT_SCAN, SUM_NO_INDEX_USED FROM performance_schema.prepared_statements_instances ;
648 STATEMENT_NAME st
649 SQL_TEXT SELECT * FROM tab
650 COUNT_REPREPARE 2
651 COUNT_EXECUTE 3
652 SUM_ROWS_SENT 9
653 SUM_SELECT_SCAN 3
654 SUM_NO_INDEX_USED 3
655 TRUNCATE TABLE performance_schema.prepared_statements_instances ;
656 SELECT STATEMENT_NAME, SQL_TEXT, COUNT_REPREPARE, COUNT_EXECUTE, SUM_ROWS_SENT, SUM_SELECT_SCAN, SUM_NO_INDEX_USED FROM performance_schema.prepared_statements_instances ;
657 STATEMENT_NAME st
658 SQL_TEXT SELECT * FROM tab
659 COUNT_REPREPARE 0
660 COUNT_EXECUTE 0
661 SUM_ROWS_SENT 0
662 SUM_SELECT_SCAN 0
663 SUM_NO_INDEX_USED 0
664 DEALLOCATE PREPARE st;
665 SELECT STATEMENT_NAME, SQL_TEXT, COUNT_REPREPARE, COUNT_EXECUTE, SUM_ROWS_SENT, SUM_SELECT_SCAN, SUM_NO_INDEX_USED FROM performance_schema.prepared_statements_instances ;
666 TRUNCATE TABLE performance_schema.prepared_statements_instances ;
667 TRUNCATE TABLE performance_schema.events_statements_history_long ;
668 DROP TABLE tab;
669 DROP DATABASE db;