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