Debian Codegraph @

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