Debian Codegraph @

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

raw
1
2 UPDATE performance_schema.setup_instruments
3 SET FLAGS = '', ENABLED='NO'
4 WHERE NAME LIKE 'memory/%';
5
6 UPDATE performance_schema.setup_instruments
7 SET FLAGS = 'controlled', ENABLED='YES'
8 WHERE NAME IN ('memory/sql/Prepared_statement::infrastructure');
9
10 UPDATE performance_schema.setup_instruments
11 SET ENABLED='YES'
12 WHERE NAME IN ('memory/sql/Prepared_statement::main_mem_root');
13
14 --source ../include/controlled_memory_setup.inc
15
16 --connection con1
17
18 PREPARE stmt1 FROM "SELECT 1 FROM DUAL;";
19
20 --connection con2
21
22 PREPARE stmt2a FROM "SELECT 2 FROM DUAL;";
23 PREPARE stmt2b FROM "SELECT 2+2 FROM DUAL;";
24
25 --source ../include/controlled_memory_dump.inc
26
27 --connection con1
28
29 EXECUTE stmt1;
30
31 --connection con2
32
33 EXECUTE stmt2a;
34 EXECUTE stmt2b;
35
36 --source ../include/controlled_memory_dump.inc
37
38 --connection con1
39
40 EXECUTE stmt1;
41
42 --connection con2
43
44 EXECUTE stmt2a;
45 EXECUTE stmt2b;
46
47 --source ../include/controlled_memory_dump.inc
48
49 --connection con1
50
51 DEALLOCATE PREPARE stmt1;
52
53 --connection con2
54
55 DEALLOCATE PREPARE stmt2a;
56 DEALLOCATE PREPARE stmt2b;
57
58 --source ../include/controlled_memory_dump.inc
59
60 --source ../include/controlled_memory_cleanup.inc
61