Debian Codegraph @

mysql-test/suite/perfschema/r/ctrl_mem_sp.result

raw
1 UPDATE performance_schema.setup_instruments
2 SET FLAGS = '';
3 UPDATE performance_schema.setup_instruments
4 SET FLAGS = 'controlled'
5 WHERE NAME IN ('memory/sql/sp_head::call_mem_root', 'memory/sql/sp_head::execute_mem_root');
6 SELECT * FROM performance_schema.setup_instruments
7 WHERE FLAGS = 'controlled';
8 NAME ENABLED TIMED PROPERTIES FLAGS VOLATILITY DOCUMENTATION
9 memory/sql/sp_head::execute_mem_root YES NULL controlled_by_default controlled 0 Mem root per instruction.
10 memory/sql/sp_head::call_mem_root YES NULL controlled_by_default controlled 0 Mem root for objects with same life time as stored program call.
11 # Switch to (con1, localhost, root, , )
12 # Switch to (con2, localhost, root, , )
13 CREATE PROCEDURE test.proc_1() BEGIN
14 SELECT "P1";
15 END
16 $$
17 CREATE PROCEDURE test.proc_2a()
18 BEGIN
19 SELECT "P2A";
20 END
21 $$
22 CREATE PROCEDURE test.proc_2b()
23 BEGIN
24 SELECT "P2B";
25 END
26 $$
27 # Switch to connection default
28 connection check_status
29 CON1 threads PASSED
30 connection check_status
31 CON1 statement history PASSED
32 offending_ctrl_digests DIGEST_TEXT MAX_CONTROLLED_MEMORY max_ctrl
33 offending_total_digests DIGEST_TEXT MAX_TOTAL_MEMORY max_total
34 connection check_status
35 CON2 threads PASSED
36 connection check_status
37 CON2 statement history PASSED
38 offending_ctrl_digests DIGEST_TEXT MAX_CONTROLLED_MEMORY max_ctrl
39 offending_total_digests DIGEST_TEXT MAX_TOTAL_MEMORY max_total
40 CALL test.proc_1();
41 P1
42 P1
43 CALL test.proc_2a();
44 P2A
45 P2A
46 CALL test.proc_2b();
47 P2B
48 P2B
49 # Switch to connection default
50 connection check_status
51 CON1 threads PASSED
52 connection check_status
53 CON1 statement history PASSED
54 offending_ctrl_digests DIGEST_TEXT MAX_CONTROLLED_MEMORY max_ctrl
55 offending_total_digests DIGEST_TEXT MAX_TOTAL_MEMORY max_total
56 connection check_status
57 CON2 threads PASSED
58 connection check_status
59 CON2 statement history PASSED
60 offending_ctrl_digests DIGEST_TEXT MAX_CONTROLLED_MEMORY max_ctrl
61 offending_total_digests DIGEST_TEXT MAX_TOTAL_MEMORY max_total
62 UPDATE performance_schema.setup_instruments
63 SET FLAGS = '', ENABLED='YES';
64 UPDATE performance_schema.setup_instruments
65 SET FLAGS = 'controlled'
66 where (find_in_set('controlled_by_default', PROPERTIES));
67 UPDATE performance_schema.setup_threads SET ENABLED = 'YES';
68 UPDATE performance_schema.threads SET INSTRUMENTED = 'YES';
69 DROP PROCEDURE test.verify_thread;
70 DROP TABLE test.enforced;
71 DROP PROCEDURE test.proc_1;
72 DROP PROCEDURE test.proc_2a;
73 DROP PROCEDURE test.proc_2b;