Debian Codegraph @

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

raw
1 #
2 # Verify that the configuration file defaults were processed correctly
3 #
4 SELECT * FROM performance_schema.setup_instruments
5 WHERE name IN (
6 'wait/synch/mutex/sql/LOCK_user_conn',
7 'wait/synch/mutex/sql/LOCK_uuid_generator',
8 'wait/synch/mutex/sql/LOCK_transaction_cache',
9 'stage/sql/creating table')
10 AND enabled = 'yes' AND timed = 'no'
11 ORDER BY name;
12 NAME ENABLED TIMED PROPERTIES FLAGS VOLATILITY DOCUMENTATION
13 stage/sql/creating table YES NO NULL 0 NULL
14 wait/synch/mutex/sql/LOCK_transaction_cache YES NO singleton NULL 0 NULL
15 wait/synch/mutex/sql/LOCK_user_conn YES NO singleton NULL 0 NULL
16 wait/synch/mutex/sql/LOCK_uuid_generator YES NO singleton NULL 0 NULL
17 SELECT * FROM performance_schema.setup_instruments
18 WHERE name = 'wait/synch/mutex/sql/LOCK_thd_list'
19 AND enabled = 'no' AND timed = 'no';
20 NAME ENABLED TIMED PROPERTIES FLAGS VOLATILITY DOCUMENTATION
21 SELECT * FROM performance_schema.setup_instruments
22 WHERE name IN (
23 'wait/synch/mutex/sql/LOG_INFO::lock',
24 'wait/synch/mutex/sql/THD::LOCK_thd_list')
25 AND enabled = 'yes' AND timed = 'yes'
26 ORDER BY name;
27 NAME ENABLED TIMED PROPERTIES FLAGS VOLATILITY DOCUMENTATION
28 SELECT * FROM performance_schema.setup_instruments
29 WHERE name = 'wait/synch/mutex/sql/hash_filo::lock'
30 AND enabled = 'no' AND timed = 'no'
31 ORDER BY name;
32 NAME ENABLED TIMED PROPERTIES FLAGS VOLATILITY DOCUMENTATION
33 wait/synch/mutex/sql/hash_filo::lock NO NO NULL 0 NULL
34 #
35 # Verify that the memory instruments are never timed
36 #
37 SELECT * FROM performance_schema.setup_instruments
38 WHERE name like 'memory/%'
39 AND timed = 'YES';
40 NAME ENABLED TIMED PROPERTIES FLAGS VOLATILITY DOCUMENTATION
41 #
42 # Verify that the memory/performance_schema instruments are never disabled
43 #
44 SELECT * FROM performance_schema.setup_instruments
45 WHERE name like 'memory/performance_schema/%'
46 AND enabled = 'NO';
47 NAME ENABLED TIMED PROPERTIES FLAGS VOLATILITY DOCUMENTATION
48 #
49 # Verify that the instrument startup settings are not not visible.
50 #
51 SHOW VARIABLES LIKE "%/wait/synch/mutex%";
52 Variable_name Value
53 #
54 # Verify command line options are processed correctly
55 #
56 #
57 # Verify that wait/io/table/sql/handler is enabled and timed
58 #
59 SELECT * FROM performance_schema.setup_instruments
60 WHERE name like "%wait/io/table/sql/handler%";
61 NAME ENABLED TIMED PROPERTIES FLAGS VOLATILITY DOCUMENTATION
62 wait/io/table/sql/handler YES YES NULL 0 NULL
63 #
64 # Verify that stored programs micro instructions are documented
65 #
66 SELECT NAME, DOCUMENTATION FROM performance_schema.setup_instruments
67 WHERE NAME like "statement/sp/%" ORDER BY NAME;
68 NAME DOCUMENTATION
69 statement/sp/cclose Stored Program: CLOSE cursor
70 statement/sp/cfetch Stored Program: FETCH cursor
71 statement/sp/copen Stored Program: OPEN cursor
72 statement/sp/cpop Stored Program: uninstall a DECLARE CURSOR microcode instruction
73 statement/sp/cpush Stored Program: install a DECLARE CURSOR microcode instruction
74 statement/sp/error Stored Program: CASE WHEN not found microcode instruction
75 statement/sp/freturn Stored Program: RETURN from STORED FUNCTION
76 statement/sp/hpop Stored Program: uninstall a DECLARE HANDLER microcode instruction
77 statement/sp/hpush_jump Stored Program: install a DECLARE HANDLER microcode instruction
78 statement/sp/hreturn Stored Program: return from a DECLARE HANDLER microcode instruction
79 statement/sp/jump Stored Program: jump microcode instruction
80 statement/sp/jump_if_not Stored Program: jump if false microcode instruction
81 statement/sp/set Stored Program: SET statement
82 statement/sp/set_case_expr Stored Program: CASE microcode instruction
83 statement/sp/set_trigger_field Stored Program: SET NEW.<field> in TRIGGER
84 statement/sp/stmt Stored Program: SQL statement