Debian Codegraph @

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

raw
1 UPDATE performance_schema.setup_instruments
2 SET FLAGS = '', ENABLED='NO'
3 WHERE NAME LIKE 'memory/%';
4 UPDATE performance_schema.setup_instruments
5 SET FLAGS = 'controlled', ENABLED='YES'
6 WHERE NAME IN ('memory/sql/Prepared_statement::infrastructure',
7 'memory/sql/Prepared_statement::main_mem_root');
8 # Switch to (con1, localhost, root, , )
9 # Switch to (con2, localhost, root, , )
10 PREPARE stmt1 FROM "SELECT 1 FROM DUAL;";
11 PREPARE stmt2a FROM "SELECT 2 FROM DUAL;";
12 PREPARE stmt2b FROM "SELECT 2+2 FROM DUAL;";
13 # Switch to connection default
14 connection check_status
15 CON1 threads PASSED
16 connection check_status
17 CON1 statement history PASSED
18 offending_ctrl_digests DIGEST_TEXT MAX_CONTROLLED_MEMORY max_ctrl
19 offending_total_digests DIGEST_TEXT MAX_TOTAL_MEMORY max_total
20 connection check_status
21 CON2 threads PASSED
22 connection check_status
23 CON2 statement history PASSED
24 offending_ctrl_digests DIGEST_TEXT MAX_CONTROLLED_MEMORY max_ctrl
25 offending_total_digests DIGEST_TEXT MAX_TOTAL_MEMORY max_total
26 EXECUTE stmt1;
27 1
28 1
29 EXECUTE stmt2a;
30 2
31 2
32 EXECUTE stmt2b;
33 2+2
34 4
35 # Switch to connection default
36 connection check_status
37 CON1 threads PASSED
38 connection check_status
39 CON1 statement history PASSED
40 offending_ctrl_digests DIGEST_TEXT MAX_CONTROLLED_MEMORY max_ctrl
41 offending_total_digests DIGEST_TEXT MAX_TOTAL_MEMORY max_total
42 connection check_status
43 CON2 threads PASSED
44 connection check_status
45 CON2 statement history PASSED
46 offending_ctrl_digests DIGEST_TEXT MAX_CONTROLLED_MEMORY max_ctrl
47 offending_total_digests DIGEST_TEXT MAX_TOTAL_MEMORY max_total
48 EXECUTE stmt1;
49 1
50 1
51 EXECUTE stmt2a;
52 2
53 2
54 EXECUTE stmt2b;
55 2+2
56 4
57 # Switch to connection default
58 connection check_status
59 CON1 threads PASSED
60 connection check_status
61 CON1 statement history PASSED
62 offending_ctrl_digests DIGEST_TEXT MAX_CONTROLLED_MEMORY max_ctrl
63 offending_total_digests DIGEST_TEXT MAX_TOTAL_MEMORY max_total
64 connection check_status
65 CON2 threads PASSED
66 connection check_status
67 CON2 statement history PASSED
68 offending_ctrl_digests DIGEST_TEXT MAX_CONTROLLED_MEMORY max_ctrl
69 offending_total_digests DIGEST_TEXT MAX_TOTAL_MEMORY max_total
70 DEALLOCATE PREPARE stmt1;
71 DEALLOCATE PREPARE stmt2a;
72 DEALLOCATE PREPARE stmt2b;
73 # Switch to connection default
74 connection check_status
75 CON1 threads PASSED
76 connection check_status
77 CON1 statement history PASSED
78 offending_ctrl_digests DIGEST_TEXT MAX_CONTROLLED_MEMORY max_ctrl
79 offending_total_digests DIGEST_TEXT MAX_TOTAL_MEMORY max_total
80 connection check_status
81 CON2 threads PASSED
82 connection check_status
83 CON2 statement history PASSED
84 offending_ctrl_digests DIGEST_TEXT MAX_CONTROLLED_MEMORY max_ctrl
85 offending_total_digests DIGEST_TEXT MAX_TOTAL_MEMORY max_total
86 UPDATE performance_schema.setup_instruments
87 SET FLAGS = '', ENABLED='YES';
88 UPDATE performance_schema.setup_instruments
89 SET FLAGS = 'controlled'
90 where (find_in_set('controlled_by_default', PROPERTIES));
91 UPDATE performance_schema.setup_threads SET ENABLED = 'YES';
92 UPDATE performance_schema.threads SET INSTRUMENTED = 'YES';
93 DROP PROCEDURE test.verify_thread;
94 DROP TABLE test.enforced;