Debian Codegraph @

mysql-test/suite/x/r/performance_schema.result

raw
1
2 33 rows affected
3 Rows matched: 33 Changed: 0 Warnings: 0
4
5 1 rows affected
6 Rows matched: 1 Changed: 1 Warnings: 0
7
8 1 rows affected
9 Rows matched: 1 Changed: 1 Warnings: 0
10
11 1 rows affected
12 Rows matched: 1 Changed: 1 Warnings: 0
13
14 3 rows affected
15 Rows matched: 3 Changed: 0 Warnings: 0
16
17 0 rows affected
18
19 0 rows affected
20 name
21 thread/mysqlx/acceptor_network
22 thread/mysqlx/worker
23 0 rows affected
24 name
25 wait/synch/mutex/mysqlx/broker_context_sync
26 wait/synch/mutex/mysqlx/client_session_exit
27 wait/synch/mutex/mysqlx/document_id_generate
28 wait/synch/mutex/mysqlx/listener_tcp_sync
29 wait/synch/mutex/mysqlx/lock_list_access
30 wait/synch/mutex/mysqlx/notice_output_queue
31 wait/synch/mutex/mysqlx/page_pool
32 wait/synch/mutex/mysqlx/scheduler_dynamic_thread_exit
33 wait/synch/mutex/mysqlx/scheduler_dynamic_worker_pending
34 wait/synch/mutex/mysqlx/scheduler_post
35 wait/synch/mutex/mysqlx/server_client_exit
36 wait/synch/mutex/mysqlx/server_state_sync
37 wait/synch/mutex/mysqlx/socket_acceptors_sync
38 wait/synch/mutex/mysqlx/socket_events_timers
39 wait/synch/mutex/mysqlx/vio_shutdown
40 0 rows affected
41 name
42 wait/synch/cond/mysqlx/broker_context_sync
43 wait/synch/cond/mysqlx/listener_tcp_sync
44 wait/synch/cond/mysqlx/scheduler_dynamic_thread_exit
45 wait/synch/cond/mysqlx/scheduler_dynamic_worker_pending
46 wait/synch/cond/mysqlx/server_state_sync
47 wait/synch/cond/mysqlx/socket_acceptors_sync
48 0 rows affected
49 name
50 wait/synch/rwlock/mysqlx/client_list_clients
51 wait/synch/rwlock/mysqlx/sha256_password_cache
52 0 rows affected
53 NAME ENABLED TIMED PROPERTIES FLAGS VOLATILITY DOCUMENTATION
54 wait/synch/mutex/mysqlx/lock_list_access NO NO null 0 null
55 wait/synch/mutex/mysqlx/scheduler_dynamic_worker_pending NO NO null 0 null
56 wait/synch/mutex/mysqlx/scheduler_dynamic_thread_exit YES NO null 0 null
57 wait/synch/mutex/mysqlx/document_id_generate YES NO null 0 null
58 wait/synch/mutex/mysqlx/notice_output_queue YES NO null 0 null
59 wait/synch/mutex/mysqlx/client_session_exit YES NO null 0 null
60 wait/synch/mutex/mysqlx/socket_events_timers YES NO null 0 null
61 wait/synch/mutex/mysqlx/scheduler_post YES NO null 0 null
62 wait/synch/mutex/mysqlx/server_client_exit YES NO null 0 null
63 wait/synch/mutex/mysqlx/vio_shutdown YES NO null 0 null
64 wait/synch/mutex/mysqlx/page_pool YES NO null 0 null
65 wait/synch/mutex/mysqlx/listener_tcp_sync YES NO null 0 null
66 wait/synch/mutex/mysqlx/broker_context_sync YES NO null 0 null
67 wait/synch/mutex/mysqlx/server_state_sync YES NO null 0 null
68 wait/synch/mutex/mysqlx/socket_acceptors_sync YES NO null 0 null
69 wait/synch/rwlock/mysqlx/client_list_clients YES NO null 0 null
70 wait/synch/rwlock/mysqlx/sha256_password_cache YES NO null 0 null
71 wait/synch/rwlock/mysqlx/xpl_server_instance YES NO null 0 null
72 wait/synch/cond/mysqlx/scheduler_dynamic_worker_pending NO NO null 0 null
73 wait/synch/cond/mysqlx/scheduler_dynamic_thread_exit YES NO null 0 null
74 wait/synch/cond/mysqlx/listener_tcp_sync YES NO null 0 null
75 wait/synch/cond/mysqlx/broker_context_sync YES NO null 0 null
76 wait/synch/cond/mysqlx/server_state_sync YES NO null 0 null
77 wait/synch/cond/mysqlx/socket_acceptors_sync YES NO null 0 null
78 wait/io/socket/mysqlx/tcpip_socket YES NO null 0 null
79 wait/io/socket/mysqlx/diagnostics_socket YES NO null 0 null
80 wait/io/socket/mysqlx/client_connection YES NO null 0 null
81 memory/mysqlx/objects YES null global_statistics 0 null
82 memory/mysqlx/recv_buffer YES null global_statistics 0 null
83 memory/mysqlx/send_buffer YES null global_statistics 0 null
84 0 rows affected
85
86 1 rows affected
87 Rows matched: 1 Changed: 1 Warnings: 0
88 instrumented
89 NO
90 0 rows affected
91
92 1 rows affected
93 Rows matched: 1 Changed: 1 Warnings: 0
94 instrumented
95 YES
96 0 rows affected
97
98 0 rows affected
99
100 0 rows affected
101
102 0 rows affected
103
104 0 rows affected
105 While executing alter table performance_schema.mutex_instances add column foo integer:
106 Got expected error: Access denied for user 'x_root'@'localhost' to database 'performance_schema' (code 1044)
107 While executing alter table performance_schema.cond_instances add column foo integer:
108 Got expected error: Access denied for user 'x_root'@'localhost' to database 'performance_schema' (code 1044)
109 While executing alter table performance_schema.threads add column foo integer:
110 Got expected error: Access denied for user 'x_root'@'localhost' to database 'performance_schema' (code 1044)
111 While executing alter table performance_schema.rwlock_instances add column foo integer:
112 Got expected error: Access denied for user 'x_root'@'localhost' to database 'performance_schema' (code 1044)
113 While executing alter table performance_schema.socket_instances add column foo integer:
114 Got expected error: Access denied for user 'x_root'@'localhost' to database 'performance_schema' (code 1044)
115 While executing alter table performance_schema.socket_summary_by_event_name add column foo integer:
116 Got expected error: Access denied for user 'x_root'@'localhost' to database 'performance_schema' (code 1044)
117 While executing alter table performance_schema.socket_summary_by_instance add column foo integer:
118 Got expected error: Access denied for user 'x_root'@'localhost' to database 'performance_schema' (code 1044)
119 While executing truncate table performance_schema.mutex_instances:
120 Got expected error: DROP command denied to user 'x_root'@'localhost' for table 'mutex_instances' (code 1142)
121 While executing truncate table performance_schema.cond_instances:
122 Got expected error: DROP command denied to user 'x_root'@'localhost' for table 'cond_instances' (code 1142)
123 While executing truncate table performance_schema.threads:
124 Got expected error: DROP command denied to user 'x_root'@'localhost' for table 'threads' (code 1142)
125 While executing truncate table performance_schema.rwlock_instances:
126 Got expected error: DROP command denied to user 'x_root'@'localhost' for table 'rwlock_instances' (code 1142)
127 While executing truncate table performance_schema.socket_instances:
128 Got expected error: DROP command denied to user 'x_root'@'localhost' for table 'socket_instances' (code 1142)
129
130 0 rows affected
131
132 0 rows affected
133 While executing ALTER TABLE performance_schema.mutex_instances ADD INDEX test_index(NAME):
134 Got expected error: Access denied for user 'x_root'@'localhost' to database 'performance_schema' (code 1044)
135 While executing ALTER TABLE performance_schema.cond_instances ADD INDEX test_index(NAME):
136 Got expected error: Access denied for user 'x_root'@'localhost' to database 'performance_schema' (code 1044)
137 While executing ALTER TABLE performance_schema.threads ADD INDEX test_index(PROCESSLIST_ID):
138 Got expected error: Access denied for user 'x_root'@'localhost' to database 'performance_schema' (code 1044)
139 While executing ALTER TABLE performance_schema.rwlock_instances ADD INDEX test_index(NAME):
140 Got expected error: Access denied for user 'x_root'@'localhost' to database 'performance_schema' (code 1044)
141 While executing ALTER TABLE performance_schema.rwlock_instances ADD INDEX socket_instances(STATE):
142 Got expected error: Access denied for user 'x_root'@'localhost' to database 'performance_schema' (code 1044)
143 While executing ALTER TABLE performance_schema.rwlock_instances ADD INDEX socket_summary_by_event_name(EVENT_NAME):
144 Got expected error: Access denied for user 'x_root'@'localhost' to database 'performance_schema' (code 1044)
145 While executing ALTER TABLE performance_schema.rwlock_instances ADD INDEX socket_summary_by_instance(EVENT_NAME):
146 Got expected error: Access denied for user 'x_root'@'localhost' to database 'performance_schema' (code 1044)
147 While executing CREATE UNIQUE INDEX test_index ON performance_schema.mutex_instances(NAME):
148 Got expected error: Access denied for user 'x_root'@'localhost' to database 'performance_schema' (code 1044)
149 While executing CREATE UNIQUE INDEX test_index ON performance_schema.cond_instances(NAME):
150 Got expected error: Access denied for user 'x_root'@'localhost' to database 'performance_schema' (code 1044)
151 While executing CREATE UNIQUE INDEX test_index ON performance_schema.threads(PROCESSLIST_ID):
152 Got expected error: Access denied for user 'x_root'@'localhost' to database 'performance_schema' (code 1044)
153 While executing CREATE UNIQUE INDEX test_index ON performance_schema.rwlock_instances(NAME):
154 Got expected error: Access denied for user 'x_root'@'localhost' to database 'performance_schema' (code 1044)
155 While executing CREATE UNIQUE INDEX test_index ON performance_schema.socket_instances(STATE):
156 Got expected error: Access denied for user 'x_root'@'localhost' to database 'performance_schema' (code 1044)
157 While executing CREATE UNIQUE INDEX test_index ON performance_schema.socket_summary_by_event_name(EVENT_NAME):
158 Got expected error: Access denied for user 'x_root'@'localhost' to database 'performance_schema' (code 1044)
159 While executing CREATE UNIQUE INDEX test_index ON performance_schema.socket_summary_by_instance(EVENT_NAME):
160 Got expected error: Access denied for user 'x_root'@'localhost' to database 'performance_schema' (code 1044)
161 While executing insert into performance_schema.mutex_instances
162 set name='FOO', object_instance_begin=12:
163 Got expected error: INSERT command denied to user 'x_root'@'localhost' for table 'mutex_instances' (code 1142)
164 While executing insert into performance_schema.cond_instances
165 set name='FOO', object_instance_begin=12:
166 Got expected error: INSERT command denied to user 'x_root'@'localhost' for table 'cond_instances' (code 1142)
167 While executing insert into performance_schema.threads
168 set name='FOO', thread_id=1, processlist_id=2:
169 Got expected error: INSERT command denied to user 'x_root'@'localhost' for table 'threads' (code 1142)
170 While executing insert into performance_schema.rwlock_instances
171 set name='FOO', object_instance_begin=12:
172 Got expected error: INSERT command denied to user 'x_root'@'localhost' for table 'rwlock_instances' (code 1142)
173 While executing insert into performance_schema.socket_instances
174 set ip='', port=12:
175 Got expected error: INSERT command denied to user 'x_root'@'localhost' for table 'socket_instances' (code 1142)
176 While executing insert into performance_schema.socket_summary_by_event_name
177 set event_name='FOO', count_read=12:
178 Got expected error: INSERT command denied to user 'x_root'@'localhost' for table 'socket_summary_by_event_name' (code 1142)
179 While executing insert into performance_schema.socket_summary_by_instance
180 set event_name='FOO', count_misc=12:
181 Got expected error: INSERT command denied to user 'x_root'@'localhost' for table 'socket_summary_by_instance' (code 1142)
182 While executing update performance_schema.mutex_instances
183 set name='FOO':
184 Got expected error: UPDATE command denied to user 'x_root'@'localhost' for table 'mutex_instances' (code 1142)
185 While executing update performance_schema.cond_instances
186 set name='FOO':
187 Got expected error: UPDATE command denied to user 'x_root'@'localhost' for table 'cond_instances' (code 1142)
188 While executing update performance_schema.threads
189 set thread_id=12 where PROCESSLIST_ID=connection_id():
190 Got expected error: Invalid performance_schema usage. (code 1683)
191 While executing update performance_schema.threads
192 set thread_id=12:
193 Got expected error: Invalid performance_schema usage. (code 1683)
194 While executing update performance_schema.rwlock_instances
195 set name='FOO':
196 Got expected error: UPDATE command denied to user 'x_root'@'localhost' for table 'rwlock_instances' (code 1142)
197 While executing update performance_schema.socket_instances
198 set ip='FOO':
199 Got expected error: UPDATE command denied to user 'x_root'@'localhost' for table 'socket_instances' (code 1142)
200 While executing update performance_schema.socket_summary_by_event_name
201 set event_name='FOO':
202 Got expected error: UPDATE command denied to user 'x_root'@'localhost' for table 'socket_summary_by_event_name' (code 1142)
203 While executing update performance_schema.socket_summary_by_instance
204 set event_name='FOO':
205 Got expected error: UPDATE command denied to user 'x_root'@'localhost' for table 'socket_summary_by_instance' (code 1142)
206 While executing delete from performance_schema.mutex_instances
207 where name like "wait/%":
208 Got expected error: DELETE command denied to user 'x_root'@'localhost' for table 'mutex_instances' (code 1142)
209 While executing delete from performance_schema.cond_instances
210 where name like "wait/%":
211 Got expected error: DELETE command denied to user 'x_root'@'localhost' for table 'cond_instances' (code 1142)
212 While executing delete from performance_schema.threads
213 where id=1:
214 Got expected error: DELETE command denied to user 'x_root'@'localhost' for table 'threads' (code 1142)
215 While executing delete from performance_schema.rwlock_instances
216 where name like "wait/%":
217 Got expected error: DELETE command denied to user 'x_root'@'localhost' for table 'rwlock_instances' (code 1142)
218 While executing delete from performance_schema.socket_instances
219 where event_name like "wait/%":
220 Got expected error: DELETE command denied to user 'x_root'@'localhost' for table 'socket_instances' (code 1142)
221 While executing delete from performance_schema.socket_summary_by_event_name
222 where event_name like "wait/%":
223 Got expected error: DELETE command denied to user 'x_root'@'localhost' for table 'socket_summary_by_event_name' (code 1142)
224 While executing delete from performance_schema.socket_summary_by_instance
225 where event_name like "wait/%":
226 Got expected error: DELETE command denied to user 'x_root'@'localhost' for table 'socket_summary_by_instance' (code 1142)
227 While executing delete from performance_schema.mutex_instances:
228 Got expected error: DELETE command denied to user 'x_root'@'localhost' for table 'mutex_instances' (code 1142)
229 While executing delete from performance_schema.cond_instances:
230 Got expected error: DELETE command denied to user 'x_root'@'localhost' for table 'cond_instances' (code 1142)
231 While executing delete from performance_schema.threads:
232 Got expected error: DELETE command denied to user 'x_root'@'localhost' for table 'threads' (code 1142)
233 While executing delete from performance_schema.rwlock_instances:
234 Got expected error: DELETE command denied to user 'x_root'@'localhost' for table 'rwlock_instances' (code 1142)
235 While executing delete from performance_schema.socket_instances:
236 Got expected error: DELETE command denied to user 'x_root'@'localhost' for table 'socket_instances' (code 1142)
237 While executing delete from performance_schema.socket_summary_by_event_name:
238 Got expected error: DELETE command denied to user 'x_root'@'localhost' for table 'socket_summary_by_event_name' (code 1142)
239 While executing delete from performance_schema.socket_summary_by_instance:
240 Got expected error: DELETE command denied to user 'x_root'@'localhost' for table 'socket_summary_by_instance' (code 1142)
241 While executing LOCK TABLES performance_schema.mutex_instances READ:
242 Got expected error: SELECT, LOCK TABLES command denied to user 'x_root'@'localhost' for table 'mutex_instances' (code 1142)
243
244 0 rows affected
245 While executing LOCK TABLES performance_schema.cond_instances READ:
246 Got expected error: SELECT, LOCK TABLES command denied to user 'x_root'@'localhost' for table 'cond_instances' (code 1142)
247
248 0 rows affected
249 While executing LOCK TABLES performance_schema.rwlock_instances READ:
250 Got expected error: SELECT, LOCK TABLES command denied to user 'x_root'@'localhost' for table 'rwlock_instances' (code 1142)
251
252 0 rows affected
253 While executing LOCK TABLES performance_schema.socket_instances READ:
254 Got expected error: SELECT, LOCK TABLES command denied to user 'x_root'@'localhost' for table 'socket_instances' (code 1142)
255
256 0 rows affected
257 While executing LOCK TABLES performance_schema.socket_summary_by_event_name READ:
258 Got expected error: SELECT, LOCK TABLES command denied to user 'x_root'@'localhost' for table 'socket_summary_by_event_name' (code 1142)
259
260 0 rows affected
261 While executing LOCK TABLES performance_schema.socket_summary_by_instance READ:
262 Got expected error: SELECT, LOCK TABLES command denied to user 'x_root'@'localhost' for table 'socket_summary_by_instance' (code 1142)
263
264 0 rows affected
265 While executing LOCK TABLES performance_schema.mutex_instances WRITE:
266 Got expected error: SELECT, LOCK TABLES command denied to user 'x_root'@'localhost' for table 'mutex_instances' (code 1142)
267
268 0 rows affected
269 While executing LOCK TABLES performance_schema.cond_instances WRITE:
270 Got expected error: SELECT, LOCK TABLES command denied to user 'x_root'@'localhost' for table 'cond_instances' (code 1142)
271
272 0 rows affected
273 While executing LOCK TABLES performance_schema.rwlock_instances WRITE:
274 Got expected error: SELECT, LOCK TABLES command denied to user 'x_root'@'localhost' for table 'rwlock_instances' (code 1142)
275
276 0 rows affected
277 While executing LOCK TABLES performance_schema.socket_instances WRITE:
278 Got expected error: SELECT, LOCK TABLES command denied to user 'x_root'@'localhost' for table 'socket_instances' (code 1142)
279
280 0 rows affected
281 While executing LOCK TABLES performance_schema.socket_summary_by_event_name WRITE:
282 Got expected error: SELECT, LOCK TABLES command denied to user 'x_root'@'localhost' for table 'socket_summary_by_event_name' (code 1142)
283
284 0 rows affected
285 While executing LOCK TABLES performance_schema.socket_summary_by_instance WRITE:
286 Got expected error: SELECT, LOCK TABLES command denied to user 'x_root'@'localhost' for table 'socket_summary_by_instance' (code 1142)
287
288 0 rows affected
289 name
290 thread/mysqlx/acceptor_network
291 thread/mysqlx/worker
292 command ok
293 name
294 wait/synch/mutex/mysqlx/broker_context_sync
295 wait/synch/mutex/mysqlx/client_session_exit
296 wait/synch/mutex/mysqlx/document_id_generate
297 wait/synch/mutex/mysqlx/listener_tcp_sync
298 wait/synch/mutex/mysqlx/lock_list_access
299 wait/synch/mutex/mysqlx/notice_output_queue
300 wait/synch/mutex/mysqlx/page_pool
301 wait/synch/mutex/mysqlx/scheduler_dynamic_thread_exit
302 wait/synch/mutex/mysqlx/scheduler_dynamic_worker_pending
303 wait/synch/mutex/mysqlx/scheduler_post
304 wait/synch/mutex/mysqlx/server_client_exit
305 wait/synch/mutex/mysqlx/server_state_sync
306 wait/synch/mutex/mysqlx/socket_acceptors_sync
307 wait/synch/mutex/mysqlx/socket_events_timers
308 wait/synch/mutex/mysqlx/vio_shutdown
309 command ok
310 name
311 wait/synch/cond/mysqlx/broker_context_sync
312 wait/synch/cond/mysqlx/listener_tcp_sync
313 wait/synch/cond/mysqlx/scheduler_dynamic_thread_exit
314 wait/synch/cond/mysqlx/scheduler_dynamic_worker_pending
315 wait/synch/cond/mysqlx/server_state_sync
316 wait/synch/cond/mysqlx/socket_acceptors_sync
317 command ok
318 name
319 wait/synch/rwlock/mysqlx/client_list_clients
320 wait/synch/rwlock/mysqlx/sha256_password_cache
321 command ok
322 event_name
323 wait/io/socket/mysqlx/client_connection
324 wait/io/socket/mysqlx/tcpip_socket
325 command ok
326 event_name
327 wait/io/socket/mysqlx/client_connection
328 wait/io/socket/mysqlx/tcpip_socket
329 command ok
330 event_name
331 wait/io/socket/mysqlx/client_connection
332 wait/io/socket/mysqlx/diagnostics_socket
333 wait/io/socket/mysqlx/tcpip_socket
334 command ok
335 event_name
336 wait/io/socket/mysqlx/client_connection
337 wait/io/socket/mysqlx/tcpip_socket
338 command ok
339
340 command ok
341 sleep(1)
342 0
343 0 rows affected
344
345 command ok
346
347 command ok
348 Mysqlx.Ok {
349 msg: "bye!"
350 }
351 ok
352 select DISTINCT EVENT_NAME from performance_schema.events_waits_history
353 where EVENT_NAME rlike '^wait/synch/mutex/mysqlx/(client_session|obuffer|queue)$' ORDER BY EVENT_NAME;
354 EVENT_NAME
355 select DISTINCT EVENT_NAME from performance_schema.events_waits_history_long
356 where EVENT_NAME rlike '^wait/synch/(cond|mutex)/mysqlx/(queue|client_session|obuffer|queue)$' ORDER BY EVENT_NAME;
357 EVENT_NAME
358 update performance_schema.setup_instruments set ENABLED='YES'
359 where NAME rlike '^wait/synch/(cond|mutex)/mysqlx/(lock_list_access|scheduler_dynamic_worker_pending)$';
360 # Check if any classes are not lost, this may happen if they are already
361 # just on the limit
362 SELECT * FROM performance_schema.global_status
363 WHERE variable_name LIKE '%_LOST' AND variable_value > 0;
364 VARIABLE_NAME VARIABLE_VALUE