Debian Codegraph @

mysql-test/suite/perfschema/t/ctrl_mem_ps.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 'memory/sql/Prepared_statement::main_mem_root');
10
11 --source ../include/controlled_memory_setup.inc
12
13 --connection con1
14
15 PREPARE stmt1 FROM "SELECT 1 FROM DUAL;";
16
17 --connection con2
18
19 PREPARE stmt2a FROM "SELECT 2 FROM DUAL;";
20 PREPARE stmt2b FROM "SELECT 2+2 FROM DUAL;";
21
22 --source ../include/controlled_memory_dump.inc
23
24 --connection con1
25
26 EXECUTE stmt1;
27
28 --connection con2
29
30 EXECUTE stmt2a;
31 EXECUTE stmt2b;
32
33 --source ../include/controlled_memory_dump.inc
34
35 --connection con1
36
37 EXECUTE stmt1;
38
39 --connection con2
40
41 EXECUTE stmt2a;
42 EXECUTE stmt2b;
43
44 --source ../include/controlled_memory_dump.inc
45
46 --connection con1
47
48 DEALLOCATE PREPARE stmt1;
49
50 --connection con2
51
52 DEALLOCATE PREPARE stmt2a;
53 DEALLOCATE PREPARE stmt2b;
54
55 --source ../include/controlled_memory_dump.inc
56
57 --source ../include/controlled_memory_cleanup.inc
58