Debian Codegraph @

mysql-test/suite/perfschema/r/ctrl_mem_sp_cache.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/THD::sp_cache');
6 SELECT * FROM performance_schema.setup_instruments
7 WHERE FLAGS = 'controlled';
8 NAME ENABLED TIMED PROPERTIES FLAGS VOLATILITY DOCUMENTATION
9 memory/sql/THD::sp_cache YES NULL controlled_by_default controlled 0 Per session cache for stored programs.
10 # Switch to (con1, localhost, root, , )
11 # Switch to (con2, localhost, root, , )
12 CREATE PROCEDURE test.proc_1() BEGIN
13 SELECT "P1";
14 END
15 $$
16 CREATE PROCEDURE test.proc_2a()
17 BEGIN
18 SELECT "P2A";
19 END
20 $$
21 CREATE PROCEDURE test.proc_2b()
22 BEGIN
23 SELECT "P2B";
24 END
25 $$
26 # Switch to connection default
27 connection check_status
28 CON1 threads PASSED
29 connection check_status
30 CON1 statement history PASSED
31 offending_ctrl_digests DIGEST_TEXT MAX_CONTROLLED_MEMORY max_ctrl
32 offending_total_digests DIGEST_TEXT MAX_TOTAL_MEMORY max_total
33 connection check_status
34 CON2 threads PASSED
35 connection check_status
36 CON2 statement history PASSED
37 offending_ctrl_digests DIGEST_TEXT MAX_CONTROLLED_MEMORY max_ctrl
38 offending_total_digests DIGEST_TEXT MAX_TOTAL_MEMORY max_total
39 CALL test.proc_1();
40 P1
41 P1
42 CALL test.proc_2a();
43 P2A
44 P2A
45 CALL test.proc_2b();
46 P2B
47 P2B
48 # Switch to connection default
49 connection check_status
50 CON1 threads PASSED
51 connection check_status
52 CON1 statement history PASSED
53 offending_ctrl_digests DIGEST_TEXT MAX_CONTROLLED_MEMORY max_ctrl
54 offending_total_digests DIGEST_TEXT MAX_TOTAL_MEMORY max_total
55 connection check_status
56 CON2 threads PASSED
57 connection check_status
58 CON2 statement history PASSED
59 offending_ctrl_digests DIGEST_TEXT MAX_CONTROLLED_MEMORY max_ctrl
60 offending_total_digests DIGEST_TEXT MAX_TOTAL_MEMORY max_total
61 CALL test.proc_1();
62 P1
63 P1
64 CALL test.proc_2a();
65 P2A
66 P2A
67 CALL test.proc_2b();
68 P2B
69 P2B
70 # Switch to connection default
71 connection check_status
72 CON1 threads PASSED
73 connection check_status
74 CON1 statement history PASSED
75 offending_ctrl_digests DIGEST_TEXT MAX_CONTROLLED_MEMORY max_ctrl
76 offending_total_digests DIGEST_TEXT MAX_TOTAL_MEMORY max_total
77 connection check_status
78 CON2 threads PASSED
79 connection check_status
80 CON2 statement history PASSED
81 offending_ctrl_digests DIGEST_TEXT MAX_CONTROLLED_MEMORY max_ctrl
82 offending_total_digests DIGEST_TEXT MAX_TOTAL_MEMORY max_total
83 UPDATE performance_schema.setup_instruments
84 SET FLAGS = '', ENABLED='YES';
85 UPDATE performance_schema.setup_instruments
86 SET FLAGS = 'controlled'
87 where (find_in_set('controlled_by_default', PROPERTIES));
88 UPDATE performance_schema.setup_threads SET ENABLED = 'YES';
89 UPDATE performance_schema.threads SET INSTRUMENTED = 'YES';
90 DROP PROCEDURE test.verify_thread;
91 DROP TABLE test.enforced;
92 DROP PROCEDURE test.proc_1;
93 DROP PROCEDURE test.proc_2a;
94 DROP PROCEDURE test.proc_2b;