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_plugin',
9 'stage/sql/creating table')
10 AND enabled = 'yes' AND timed = 'no'
11 ORDER BY name;
12 NAME ENABLED TIMED
13 stage/sql/creating table YES NO
14 wait/synch/mutex/sql/LOCK_plugin YES NO
15 wait/synch/mutex/sql/LOCK_user_conn YES NO
16 SELECT * FROM performance_schema.setup_instruments
17 WHERE name = 'wait/synch/mutex/sql/LOCK_thd_list'
18 AND enabled = 'no' AND timed = 'no';
19 NAME ENABLED TIMED
20 SELECT * FROM performance_schema.setup_instruments
21 WHERE name IN (
22 'wait/synch/mutex/sql/LOG_INFO::lock',
23 'wait/synch/mutex/sql/THD::LOCK_thd_list')
24 AND enabled = 'yes' AND timed = 'yes'
25 ORDER BY name;
26 NAME ENABLED TIMED
27 SELECT * FROM performance_schema.setup_instruments
28 WHERE name = 'wait/synch/mutex/sql/hash_filo::lock'
29 AND enabled = 'no' AND timed = 'no'
30 ORDER BY name;
31 NAME ENABLED TIMED
32 wait/synch/mutex/sql/hash_filo::lock NO NO
33 #
34 # Verify that the memory instruments are never timed
35 #
36 SELECT * FROM performance_schema.setup_instruments
37 WHERE name like 'memory/%'
38 AND timed = 'YES';
39 NAME ENABLED TIMED
40 #
41 # Verify that the memory/performance_schema instruments are never disabled
42 #
43 SELECT * FROM performance_schema.setup_instruments
44 WHERE name like 'memory/performance_schema/%'
45 AND enabled = 'NO';
46 NAME ENABLED TIMED
47 #
48 # Verify that the instrument startup settings are not not visible.
49 #
50 SHOW VARIABLES LIKE "%/wait/synch/mutex%";
51 Variable_name Value
52 #
53 # Verify command line options are processed correctly
54 #
55 #
56 # Verify that wait/io/table/sql/handler is enabled and timed
57 #
58 SELECT * FROM performance_schema.setup_instruments
59 WHERE name like "%wait/io/table/sql/handler%";
60 NAME ENABLED TIMED
61 wait/io/table/sql/handler YES YES
62 #
63 # Stop server
64 # Restart server with wait/io/table/sql/handler disabled
65 # Enable reconnect
66 # Wait until connected again
67 # Disable reconnect
68 #
69 # Verify that wait/io/table is disabled
70 #
71 SELECT * FROM performance_schema.setup_instruments
72 WHERE name like "%wait/io/table/sql/handler%";
73 NAME ENABLED TIMED
74 wait/io/table/sql/handler NO NO