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