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
|
#
# Verify that the configuration file defaults were processed correctly
#
SELECT * FROM performance_schema.setup_instruments
WHERE name IN (
'wait/synch/mutex/sql/LOCK_user_conn',
'wait/synch/mutex/sql/LOCK_uuid_generator',
'wait/synch/mutex/sql/LOCK_transaction_cache',
'stage/sql/creating table')
AND enabled = 'yes' AND timed = 'no'
ORDER BY name;
NAME ENABLED TIMED PROPERTIES FLAGS VOLATILITY DOCUMENTATION
stage/sql/creating table YES NO NULL 0 NULL
wait/synch/mutex/sql/LOCK_transaction_cache YES NO singleton NULL 0 NULL
wait/synch/mutex/sql/LOCK_user_conn YES NO singleton NULL 0 NULL
wait/synch/mutex/sql/LOCK_uuid_generator YES NO singleton NULL 0 NULL
SELECT * FROM performance_schema.setup_instruments
WHERE name = 'wait/synch/mutex/sql/LOCK_thd_list'
AND enabled = 'no' AND timed = 'no';
NAME ENABLED TIMED PROPERTIES FLAGS VOLATILITY DOCUMENTATION
SELECT * FROM performance_schema.setup_instruments
WHERE name IN (
'wait/synch/mutex/sql/LOG_INFO::lock',
'wait/synch/mutex/sql/THD::LOCK_thd_list')
AND enabled = 'yes' AND timed = 'yes'
ORDER BY name;
NAME ENABLED TIMED PROPERTIES FLAGS VOLATILITY DOCUMENTATION
SELECT * FROM performance_schema.setup_instruments
WHERE name = 'wait/synch/mutex/sql/hash_filo::lock'
AND enabled = 'no' AND timed = 'no'
ORDER BY name;
NAME ENABLED TIMED PROPERTIES FLAGS VOLATILITY DOCUMENTATION
wait/synch/mutex/sql/hash_filo::lock NO NO NULL 0 NULL
#
# Verify that the memory instruments are never timed
#
SELECT * FROM performance_schema.setup_instruments
WHERE name like 'memory/%'
AND timed = 'YES';
NAME ENABLED TIMED PROPERTIES FLAGS VOLATILITY DOCUMENTATION
#
# Verify that the memory/performance_schema instruments are never disabled
#
SELECT * FROM performance_schema.setup_instruments
WHERE name like 'memory/performance_schema/%'
AND enabled = 'NO';
NAME ENABLED TIMED PROPERTIES FLAGS VOLATILITY DOCUMENTATION
#
# Verify that the instrument startup settings are not not visible.
#
SHOW VARIABLES LIKE "%/wait/synch/mutex%";
Variable_name Value
#
# Verify command line options are processed correctly
#
#
# Verify that wait/io/table/sql/handler is enabled and timed
#
SELECT * FROM performance_schema.setup_instruments
WHERE name like "%wait/io/table/sql/handler%";
NAME ENABLED TIMED PROPERTIES FLAGS VOLATILITY DOCUMENTATION
wait/io/table/sql/handler YES YES NULL 0 NULL
#
# Verify that stored programs micro instructions are documented
#
SELECT NAME, DOCUMENTATION FROM performance_schema.setup_instruments
WHERE NAME like "statement/sp/%" ORDER BY NAME;
NAME DOCUMENTATION
statement/sp/cclose Stored Program: CLOSE cursor
statement/sp/cfetch Stored Program: FETCH cursor
statement/sp/copen Stored Program: OPEN cursor
statement/sp/cpop Stored Program: uninstall a DECLARE CURSOR microcode instruction
statement/sp/cpush Stored Program: install a DECLARE CURSOR microcode instruction
statement/sp/error Stored Program: CASE WHEN not found microcode instruction
statement/sp/freturn Stored Program: RETURN from STORED FUNCTION
statement/sp/hpop Stored Program: uninstall a DECLARE HANDLER microcode instruction
statement/sp/hpush_jump Stored Program: install a DECLARE HANDLER microcode instruction
statement/sp/hreturn Stored Program: return from a DECLARE HANDLER microcode instruction
statement/sp/jump Stored Program: jump microcode instruction
statement/sp/jump_if_not Stored Program: jump if false microcode instruction
statement/sp/set Stored Program: SET statement
statement/sp/set_case_expr Stored Program: CASE microcode instruction
statement/sp/set_trigger_field Stored Program: SET NEW.<field> in TRIGGER
statement/sp/stmt Stored Program: SQL statement
|
