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
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
|
select * from performance_schema.setup_instruments;
select * from performance_schema.setup_instruments
where name like 'Wait/Synch/Mutex/sql/%'
and name not in ('wait/synch/mutex/sql/DEBUG_SYNC::mutex')
order by name limit 10;
NAME ENABLED TIMED PROPERTIES FLAGS VOLATILITY DOCUMENTATION
wait/synch/mutex/sql/Commit_order_manager::m_mutex YES YES NULL 0 NULL
wait/synch/mutex/sql/Cost_constant_cache::LOCK_cost_const YES YES singleton NULL 0 NULL
wait/synch/mutex/sql/Event_scheduler::LOCK_scheduler_state YES YES singleton NULL 0 NULL
wait/synch/mutex/sql/Gtid_set::gtid_executed::free_intervals_mutex YES YES NULL 0 NULL
wait/synch/mutex/sql/Gtid_state YES YES singleton NULL 0 NULL
wait/synch/mutex/sql/hash_filo::lock YES YES NULL 0 NULL
wait/synch/mutex/sql/key_mta_gaq_LOCK YES YES NULL 0 NULL
wait/synch/mutex/sql/key_mta_temp_table_LOCK YES YES NULL 0 NULL
wait/synch/mutex/sql/LOCK_acl_cache_flush YES YES singleton NULL 0 NULL
wait/synch/mutex/sql/LOCK_admin_tls_ctx_options YES YES NULL 0 A lock to control all of the --ssl-* CTX related command line options for administrative connection port
select * from performance_schema.setup_instruments
where name like 'Wait/Synch/Rwlock/sql/%'
and name not in (
'wait/synch/rwlock/sql/CRYPTO_dynlock_value::lock',
'wait/synch/rwlock/sql/LOCK_named_pipe_full_access_group')
order by name limit 10;
NAME ENABLED TIMED PROPERTIES FLAGS VOLATILITY DOCUMENTATION
wait/synch/rwlock/sql/Binlog_relay_IO_delegate::lock YES YES singleton NULL 0 NULL
wait/synch/rwlock/sql/Binlog_storage_delegate::lock YES YES singleton NULL 0 NULL
wait/synch/rwlock/sql/Binlog_transmit_delegate::lock YES YES singleton NULL 0 NULL
wait/synch/rwlock/sql/channel_lock YES YES NULL 0 NULL
wait/synch/rwlock/sql/channel_map_lock YES YES NULL 0 NULL
wait/synch/rwlock/sql/channel_to_filter_lock YES YES NULL 0 NULL
wait/synch/rwlock/sql/gtid_commit_rollback YES YES singleton NULL 0 NULL
wait/synch/rwlock/sql/gtid_mode_lock YES YES singleton NULL 0 NULL
wait/synch/rwlock/sql/gtid_retrieved YES YES singleton NULL 0 NULL
wait/synch/rwlock/sql/LOCK_sys_init_connect YES YES singleton NULL 0 NULL
select * from performance_schema.setup_instruments
where name like 'Wait/Synch/Cond/sql/%'
and name not in (
'wait/synch/cond/sql/COND_open',
'wait/synch/cond/sql/COND_handler_count',
'wait/synch/cond/sql/DEBUG_SYNC::cond',
'wait/synch/cond/sql/COND_socket_listener_active',
'wait/synch/cond/sql/COND_start_signal_handler')
order by name limit 10;
NAME ENABLED TIMED PROPERTIES FLAGS VOLATILITY DOCUMENTATION
wait/synch/cond/sql/Commit_order_manager::m_workers.cond YES YES NULL 0 NULL
wait/synch/cond/sql/COND_compress_gtid_table YES YES singleton NULL 0 NULL
wait/synch/cond/sql/COND_connection_count YES YES singleton NULL 0 NULL
wait/synch/cond/sql/COND_flush_thread_cache YES YES singleton NULL 0 NULL
wait/synch/cond/sql/COND_manager YES YES singleton NULL 0 NULL
wait/synch/cond/sql/COND_queue_state YES YES singleton NULL 0 NULL
wait/synch/cond/sql/COND_server_started YES YES singleton NULL 0 NULL
wait/synch/cond/sql/COND_thd_list YES YES NULL 0 NULL
wait/synch/cond/sql/COND_thr_lock YES YES NULL 0 NULL
wait/synch/cond/sql/COND_thread_cache YES YES singleton NULL 0 NULL
select * from performance_schema.setup_instruments
where name='Wait';
select * from performance_schema.setup_instruments
where enabled='YES';
insert into performance_schema.setup_instruments
set name='FOO', enabled='YES', timed='YES';
ERROR 42000: INSERT command denied to user 'root'@'localhost' for table 'setup_instruments'
update performance_schema.setup_instruments
set name='FOO';
ERROR HY000: Invalid performance_schema usage.
update performance_schema.setup_instruments
set enabled='NO';
update performance_schema.setup_instruments
set timed='NO';
select * from performance_schema.setup_instruments;
update performance_schema.setup_instruments
set enabled='YES', timed='YES';
delete from performance_schema.setup_instruments;
ERROR 42000: DELETE command denied to user 'root'@'localhost' for table 'setup_instruments'
delete from performance_schema.setup_instruments
where name like 'Wait/Synch/%';
ERROR 42000: DELETE command denied to user 'root'@'localhost' for table 'setup_instruments'
LOCK TABLES performance_schema.setup_instruments READ;
UNLOCK TABLES;
LOCK TABLES performance_schema.setup_instruments WRITE;
UNLOCK TABLES;
# Bug#13813193 ASSERTION `TABLE->READ_SET ==
# &TABLE->DEF_READ_SET' FAILED / MYSQL_UPDATE
UPDATE performance_schema.setup_instruments SET timed='NO'
ORDER BY RAND();
update performance_schema.setup_instruments
set PROPERTIES='singleton';
ERROR HY000: Invalid performance_schema usage.
select NOW() as fixme, NAME, PROPERTIES, FLAGS
from performance_schema.setup_instruments
where NAME like 'memory/%'
AND (find_in_set('global_statistics', PROPERTIES) != 0)
AND (find_in_set('controlled_by_default', PROPERTIES) != 0);
fixme NAME PROPERTIES FLAGS
select distinct FLAGS from performance_schema.setup_instruments
ORDER BY FLAGS;
FLAGS
NULL
controlled
select distinct FLAGS from performance_schema.setup_instruments
WHERE (find_in_set('controlled_by_default', PROPERTIES) != 0);
FLAGS
controlled
select distinct FLAGS from performance_schema.setup_instruments
WHERE (find_in_set('controlled_by_default', PROPERTIES) = 0);
FLAGS
NULL
select * from performance_schema.setup_instruments
WHERE (FLAGS IS NULL) AND (NAME LIKE "memory/%");
NAME ENABLED TIMED PROPERTIES FLAGS VOLATILITY DOCUMENTATION
select * from performance_schema.setup_instruments
WHERE (FLAGS IS NOT NULL) AND (NAME NOT LIKE "memory/%");
NAME ENABLED TIMED PROPERTIES FLAGS VOLATILITY DOCUMENTATION
update performance_schema.setup_instruments
set FLAGS='garbage' where name like "wait/%";
select distinct FLAGS from performance_schema.setup_instruments
where name like "wait/%";
FLAGS
NULL
update performance_schema.setup_instruments
set FLAGS = NULL where name like "wait/%";
select distinct FLAGS from performance_schema.setup_instruments
where name like "wait/%";
FLAGS
NULL
update performance_schema.setup_instruments
set FLAGS = '' where name like "wait/%";
select distinct FLAGS from performance_schema.setup_instruments
where name like "wait/%";
FLAGS
NULL
update performance_schema.setup_instruments
set FLAGS = 'controlled' where name like "wait/%";
select distinct FLAGS from performance_schema.setup_instruments
where name like "wait/%";
FLAGS
NULL
update performance_schema.setup_instruments
set FLAGS = 'garbage' where name like "memory/%";
select distinct FLAGS from performance_schema.setup_instruments
where name like "memory/%";
FLAGS
controlled
update performance_schema.setup_instruments
set FLAGS = NULL where name like "memory/%";
select distinct FLAGS from performance_schema.setup_instruments
where name like "memory/%";
FLAGS
update performance_schema.setup_instruments
set FLAGS = '' where name like "memory/%";
select distinct FLAGS from performance_schema.setup_instruments
where name like "memory/%";
FLAGS
update performance_schema.setup_instruments
set FLAGS = 'controlled' where name like "memory/%";
select count(*) from performance_schema.setup_instruments
where name like "memory/%"
and (find_in_set('global_statistics', PROPERTIES) != 0)
and (FLAGS = 'controlled');
count(*)
0
select count(*) from performance_schema.setup_instruments
where name like "memory/%"
and (find_in_set('global_statistics', PROPERTIES) = 0)
and (find_in_set('controlled', FLAGS) = 0);
count(*)
0
update performance_schema.setup_instruments
set enabled='YES', TIMED='YES';
update performance_schema.setup_instruments
set FLAGS = '';
update performance_schema.setup_instruments
set FLAGS = 'controlled'
where (find_in_set('controlled_by_default', PROPERTIES));
|
