Debian Codegraph @

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

raw
1
2 UPDATE performance_schema.setup_instruments
3 SET FLAGS = '';
4
5 UPDATE performance_schema.setup_instruments
6 SET FLAGS = 'controlled'
7 WHERE NAME IN ('memory/sql/sp_head::call_mem_root', 'memory/sql/sp_head::execute_mem_root');
8
9 SELECT * FROM performance_schema.setup_instruments
10 WHERE FLAGS = 'controlled';
11
12 --source ../include/controlled_memory_setup.inc
13
14 --connection con1
15
16 delimiter $$;
17 CREATE PROCEDURE test.proc_1() BEGIN
18 SELECT "P1";
19 END
20 $$
21 delimiter ;$$
22
23 --connection con2
24
25 delimiter $$;
26 CREATE PROCEDURE test.proc_2a()
27 BEGIN
28 SELECT "P2A";
29 END
30 $$
31
32 CREATE PROCEDURE test.proc_2b()
33 BEGIN
34 SELECT "P2B";
35 END
36 $$
37 delimiter ;$$
38
39 --source ../include/controlled_memory_dump.inc
40
41 --connection con1
42
43 CALL test.proc_1();
44
45 --connection con2
46
47 CALL test.proc_2a();
48 CALL test.proc_2b();
49
50 --source ../include/controlled_memory_dump.inc
51
52 --source ../include/controlled_memory_cleanup.inc
53
54 DROP PROCEDURE test.proc_1;
55 DROP PROCEDURE test.proc_2a;
56 DROP PROCEDURE test.proc_2b;
57