Debian Codegraph @

mysql-test/suite/perfschema/t/ctrl_mem_sp_cache.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/THD::sp_cache');
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 --connection con1
53
54 CALL test.proc_1();
55
56 --connection con2
57
58 CALL test.proc_2a();
59 CALL test.proc_2b();
60
61 --source ../include/controlled_memory_dump.inc
62
63 --source ../include/controlled_memory_cleanup.inc
64
65 DROP PROCEDURE test.proc_1;
66 DROP PROCEDURE test.proc_2a;
67 DROP PROCEDURE test.proc_2b;
68