368 lines
19 KiB
Plaintext
368 lines
19 KiB
Plaintext
|
|
34 rows affected
|
|
Rows matched: 34 Changed: 0 Warnings: 0
|
|
|
|
1 rows affected
|
|
Rows matched: 1 Changed: 1 Warnings: 0
|
|
|
|
1 rows affected
|
|
Rows matched: 1 Changed: 1 Warnings: 0
|
|
|
|
1 rows affected
|
|
Rows matched: 1 Changed: 1 Warnings: 0
|
|
|
|
3 rows affected
|
|
Rows matched: 3 Changed: 0 Warnings: 0
|
|
|
|
0 rows affected
|
|
|
|
0 rows affected
|
|
name
|
|
thread/mysqlx/acceptor_network
|
|
thread/mysqlx/worker
|
|
0 rows affected
|
|
name
|
|
wait/synch/mutex/mysqlx/broker_context_sync
|
|
wait/synch/mutex/mysqlx/client_session_exit
|
|
wait/synch/mutex/mysqlx/document_id_generate
|
|
wait/synch/mutex/mysqlx/listener_tcp_sync
|
|
wait/synch/mutex/mysqlx/lock_list_access
|
|
wait/synch/mutex/mysqlx/notice_output_queue
|
|
wait/synch/mutex/mysqlx/page_pool
|
|
wait/synch/mutex/mysqlx/scheduler_dynamic_thread_exit
|
|
wait/synch/mutex/mysqlx/scheduler_dynamic_worker_pending
|
|
wait/synch/mutex/mysqlx/scheduler_post
|
|
wait/synch/mutex/mysqlx/server_client_exit
|
|
wait/synch/mutex/mysqlx/server_state_sync
|
|
wait/synch/mutex/mysqlx/socket_acceptors_sync
|
|
wait/synch/mutex/mysqlx/socket_events_timers
|
|
wait/synch/mutex/mysqlx/vio_shutdown
|
|
wait/synch/mutex/mysqlx/xpl_server_accepting
|
|
0 rows affected
|
|
name
|
|
wait/synch/cond/mysqlx/broker_context_sync
|
|
wait/synch/cond/mysqlx/listener_tcp_sync
|
|
wait/synch/cond/mysqlx/scheduler_dynamic_thread_exit
|
|
wait/synch/cond/mysqlx/scheduler_dynamic_worker_pending
|
|
wait/synch/cond/mysqlx/server_state_sync
|
|
wait/synch/cond/mysqlx/socket_acceptors_sync
|
|
0 rows affected
|
|
name
|
|
wait/synch/rwlock/mysqlx/client_list_clients
|
|
wait/synch/rwlock/mysqlx/sha256_password_cache
|
|
0 rows affected
|
|
NAME ENABLED TIMED PROPERTIES VOLATILITY DOCUMENTATION
|
|
wait/synch/mutex/mysqlx/lock_list_access NO NO 0 null
|
|
wait/synch/mutex/mysqlx/scheduler_dynamic_worker_pending NO NO 0 null
|
|
wait/synch/mutex/mysqlx/scheduler_dynamic_thread_exit YES NO 0 null
|
|
wait/synch/mutex/mysqlx/document_id_generate YES NO 0 null
|
|
wait/synch/mutex/mysqlx/notice_output_queue YES NO 0 null
|
|
wait/synch/mutex/mysqlx/xpl_server_accepting YES NO 0 null
|
|
wait/synch/mutex/mysqlx/client_session_exit YES NO 0 null
|
|
wait/synch/mutex/mysqlx/socket_events_timers YES NO 0 null
|
|
wait/synch/mutex/mysqlx/scheduler_post YES NO 0 null
|
|
wait/synch/mutex/mysqlx/server_client_exit YES NO 0 null
|
|
wait/synch/mutex/mysqlx/vio_shutdown YES NO 0 null
|
|
wait/synch/mutex/mysqlx/page_pool YES NO 0 null
|
|
wait/synch/mutex/mysqlx/listener_tcp_sync YES NO 0 null
|
|
wait/synch/mutex/mysqlx/broker_context_sync YES NO 0 null
|
|
wait/synch/mutex/mysqlx/server_state_sync YES NO 0 null
|
|
wait/synch/mutex/mysqlx/socket_acceptors_sync YES NO 0 null
|
|
wait/synch/rwlock/mysqlx/client_list_clients YES NO 0 null
|
|
wait/synch/rwlock/mysqlx/sha256_password_cache YES NO 0 null
|
|
wait/synch/rwlock/mysqlx/xpl_server_instance YES NO 0 null
|
|
wait/synch/cond/mysqlx/scheduler_dynamic_worker_pending NO NO 0 null
|
|
wait/synch/cond/mysqlx/scheduler_dynamic_thread_exit YES NO 0 null
|
|
wait/synch/cond/mysqlx/listener_tcp_sync YES NO 0 null
|
|
wait/synch/cond/mysqlx/broker_context_sync YES NO 0 null
|
|
wait/synch/cond/mysqlx/server_state_sync YES NO 0 null
|
|
wait/synch/cond/mysqlx/socket_acceptors_sync YES NO 0 null
|
|
wait/io/socket/mysqlx/tcpip_socket YES NO 0 null
|
|
wait/io/socket/mysqlx/diagnostics_socket YES NO 0 null
|
|
wait/io/socket/mysqlx/client_connection YES NO 0 null
|
|
memory/mysqlx/objects YES null global_statistics 0 null
|
|
memory/mysqlx/recv_buffer YES null global_statistics 0 null
|
|
memory/mysqlx/send_buffer YES null global_statistics 0 null
|
|
0 rows affected
|
|
|
|
1 rows affected
|
|
Rows matched: 1 Changed: 1 Warnings: 0
|
|
instrumented
|
|
NO
|
|
0 rows affected
|
|
|
|
1 rows affected
|
|
Rows matched: 1 Changed: 1 Warnings: 0
|
|
instrumented
|
|
YES
|
|
0 rows affected
|
|
|
|
0 rows affected
|
|
|
|
0 rows affected
|
|
|
|
0 rows affected
|
|
|
|
0 rows affected
|
|
While executing alter table performance_schema.mutex_instances add column foo integer:
|
|
Got expected error: Access denied for user 'x_root'@'localhost' to database 'performance_schema' (code 1044)
|
|
While executing alter table performance_schema.cond_instances add column foo integer:
|
|
Got expected error: Access denied for user 'x_root'@'localhost' to database 'performance_schema' (code 1044)
|
|
While executing alter table performance_schema.threads add column foo integer:
|
|
Got expected error: Access denied for user 'x_root'@'localhost' to database 'performance_schema' (code 1044)
|
|
While executing alter table performance_schema.rwlock_instances add column foo integer:
|
|
Got expected error: Access denied for user 'x_root'@'localhost' to database 'performance_schema' (code 1044)
|
|
While executing alter table performance_schema.socket_instances add column foo integer:
|
|
Got expected error: Access denied for user 'x_root'@'localhost' to database 'performance_schema' (code 1044)
|
|
While executing alter table performance_schema.socket_summary_by_event_name add column foo integer:
|
|
Got expected error: Access denied for user 'x_root'@'localhost' to database 'performance_schema' (code 1044)
|
|
While executing alter table performance_schema.socket_summary_by_instance add column foo integer:
|
|
Got expected error: Access denied for user 'x_root'@'localhost' to database 'performance_schema' (code 1044)
|
|
While executing truncate table performance_schema.mutex_instances:
|
|
Got expected error: DROP command denied to user 'x_root'@'localhost' for table 'mutex_instances' (code 1142)
|
|
While executing truncate table performance_schema.cond_instances:
|
|
Got expected error: DROP command denied to user 'x_root'@'localhost' for table 'cond_instances' (code 1142)
|
|
While executing truncate table performance_schema.threads:
|
|
Got expected error: DROP command denied to user 'x_root'@'localhost' for table 'threads' (code 1142)
|
|
While executing truncate table performance_schema.rwlock_instances:
|
|
Got expected error: DROP command denied to user 'x_root'@'localhost' for table 'rwlock_instances' (code 1142)
|
|
While executing truncate table performance_schema.socket_instances:
|
|
Got expected error: DROP command denied to user 'x_root'@'localhost' for table 'socket_instances' (code 1142)
|
|
|
|
0 rows affected
|
|
|
|
0 rows affected
|
|
While executing ALTER TABLE performance_schema.mutex_instances ADD INDEX test_index(NAME):
|
|
Got expected error: Access denied for user 'x_root'@'localhost' to database 'performance_schema' (code 1044)
|
|
While executing ALTER TABLE performance_schema.cond_instances ADD INDEX test_index(NAME):
|
|
Got expected error: Access denied for user 'x_root'@'localhost' to database 'performance_schema' (code 1044)
|
|
While executing ALTER TABLE performance_schema.threads ADD INDEX test_index(PROCESSLIST_ID):
|
|
Got expected error: Access denied for user 'x_root'@'localhost' to database 'performance_schema' (code 1044)
|
|
While executing ALTER TABLE performance_schema.rwlock_instances ADD INDEX test_index(NAME):
|
|
Got expected error: Access denied for user 'x_root'@'localhost' to database 'performance_schema' (code 1044)
|
|
While executing ALTER TABLE performance_schema.rwlock_instances ADD INDEX socket_instances(STATE):
|
|
Got expected error: Access denied for user 'x_root'@'localhost' to database 'performance_schema' (code 1044)
|
|
While executing ALTER TABLE performance_schema.rwlock_instances ADD INDEX socket_summary_by_event_name(EVENT_NAME):
|
|
Got expected error: Access denied for user 'x_root'@'localhost' to database 'performance_schema' (code 1044)
|
|
While executing ALTER TABLE performance_schema.rwlock_instances ADD INDEX socket_summary_by_instance(EVENT_NAME):
|
|
Got expected error: Access denied for user 'x_root'@'localhost' to database 'performance_schema' (code 1044)
|
|
While executing CREATE UNIQUE INDEX test_index ON performance_schema.mutex_instances(NAME):
|
|
Got expected error: Access denied for user 'x_root'@'localhost' to database 'performance_schema' (code 1044)
|
|
While executing CREATE UNIQUE INDEX test_index ON performance_schema.cond_instances(NAME):
|
|
Got expected error: Access denied for user 'x_root'@'localhost' to database 'performance_schema' (code 1044)
|
|
While executing CREATE UNIQUE INDEX test_index ON performance_schema.threads(PROCESSLIST_ID):
|
|
Got expected error: Access denied for user 'x_root'@'localhost' to database 'performance_schema' (code 1044)
|
|
While executing CREATE UNIQUE INDEX test_index ON performance_schema.rwlock_instances(NAME):
|
|
Got expected error: Access denied for user 'x_root'@'localhost' to database 'performance_schema' (code 1044)
|
|
While executing CREATE UNIQUE INDEX test_index ON performance_schema.socket_instances(STATE):
|
|
Got expected error: Access denied for user 'x_root'@'localhost' to database 'performance_schema' (code 1044)
|
|
While executing CREATE UNIQUE INDEX test_index ON performance_schema.socket_summary_by_event_name(EVENT_NAME):
|
|
Got expected error: Access denied for user 'x_root'@'localhost' to database 'performance_schema' (code 1044)
|
|
While executing CREATE UNIQUE INDEX test_index ON performance_schema.socket_summary_by_instance(EVENT_NAME):
|
|
Got expected error: Access denied for user 'x_root'@'localhost' to database 'performance_schema' (code 1044)
|
|
While executing insert into performance_schema.mutex_instances
|
|
set name='FOO', object_instance_begin=12:
|
|
Got expected error: INSERT command denied to user 'x_root'@'localhost' for table 'mutex_instances' (code 1142)
|
|
While executing insert into performance_schema.cond_instances
|
|
set name='FOO', object_instance_begin=12:
|
|
Got expected error: INSERT command denied to user 'x_root'@'localhost' for table 'cond_instances' (code 1142)
|
|
While executing insert into performance_schema.threads
|
|
set name='FOO', thread_id=1, processlist_id=2:
|
|
Got expected error: INSERT command denied to user 'x_root'@'localhost' for table 'threads' (code 1142)
|
|
While executing insert into performance_schema.rwlock_instances
|
|
set name='FOO', object_instance_begin=12:
|
|
Got expected error: INSERT command denied to user 'x_root'@'localhost' for table 'rwlock_instances' (code 1142)
|
|
While executing insert into performance_schema.socket_instances
|
|
set ip='', port=12:
|
|
Got expected error: INSERT command denied to user 'x_root'@'localhost' for table 'socket_instances' (code 1142)
|
|
While executing insert into performance_schema.socket_summary_by_event_name
|
|
set event_name='FOO', count_read=12:
|
|
Got expected error: INSERT command denied to user 'x_root'@'localhost' for table 'socket_summary_by_event_name' (code 1142)
|
|
While executing insert into performance_schema.socket_summary_by_instance
|
|
set event_name='FOO', count_misc=12:
|
|
Got expected error: INSERT command denied to user 'x_root'@'localhost' for table 'socket_summary_by_instance' (code 1142)
|
|
While executing update performance_schema.mutex_instances
|
|
set name='FOO':
|
|
Got expected error: UPDATE command denied to user 'x_root'@'localhost' for table 'mutex_instances' (code 1142)
|
|
While executing update performance_schema.cond_instances
|
|
set name='FOO':
|
|
Got expected error: UPDATE command denied to user 'x_root'@'localhost' for table 'cond_instances' (code 1142)
|
|
While executing update performance_schema.threads
|
|
set thread_id=12 where PROCESSLIST_ID=connection_id():
|
|
Got expected error: Invalid performance_schema usage. (code 1683)
|
|
While executing update performance_schema.threads
|
|
set thread_id=12:
|
|
Got expected error: Invalid performance_schema usage. (code 1683)
|
|
While executing update performance_schema.rwlock_instances
|
|
set name='FOO':
|
|
Got expected error: UPDATE command denied to user 'x_root'@'localhost' for table 'rwlock_instances' (code 1142)
|
|
While executing update performance_schema.socket_instances
|
|
set ip='FOO':
|
|
Got expected error: UPDATE command denied to user 'x_root'@'localhost' for table 'socket_instances' (code 1142)
|
|
While executing update performance_schema.socket_summary_by_event_name
|
|
set event_name='FOO':
|
|
Got expected error: UPDATE command denied to user 'x_root'@'localhost' for table 'socket_summary_by_event_name' (code 1142)
|
|
While executing update performance_schema.socket_summary_by_instance
|
|
set event_name='FOO':
|
|
Got expected error: UPDATE command denied to user 'x_root'@'localhost' for table 'socket_summary_by_instance' (code 1142)
|
|
While executing delete from performance_schema.mutex_instances
|
|
where name like "wait/%":
|
|
Got expected error: DELETE command denied to user 'x_root'@'localhost' for table 'mutex_instances' (code 1142)
|
|
While executing delete from performance_schema.cond_instances
|
|
where name like "wait/%":
|
|
Got expected error: DELETE command denied to user 'x_root'@'localhost' for table 'cond_instances' (code 1142)
|
|
While executing delete from performance_schema.threads
|
|
where id=1:
|
|
Got expected error: DELETE command denied to user 'x_root'@'localhost' for table 'threads' (code 1142)
|
|
While executing delete from performance_schema.rwlock_instances
|
|
where name like "wait/%":
|
|
Got expected error: DELETE command denied to user 'x_root'@'localhost' for table 'rwlock_instances' (code 1142)
|
|
While executing delete from performance_schema.socket_instances
|
|
where event_name like "wait/%":
|
|
Got expected error: DELETE command denied to user 'x_root'@'localhost' for table 'socket_instances' (code 1142)
|
|
While executing delete from performance_schema.socket_summary_by_event_name
|
|
where event_name like "wait/%":
|
|
Got expected error: DELETE command denied to user 'x_root'@'localhost' for table 'socket_summary_by_event_name' (code 1142)
|
|
While executing delete from performance_schema.socket_summary_by_instance
|
|
where event_name like "wait/%":
|
|
Got expected error: DELETE command denied to user 'x_root'@'localhost' for table 'socket_summary_by_instance' (code 1142)
|
|
While executing delete from performance_schema.mutex_instances:
|
|
Got expected error: DELETE command denied to user 'x_root'@'localhost' for table 'mutex_instances' (code 1142)
|
|
While executing delete from performance_schema.cond_instances:
|
|
Got expected error: DELETE command denied to user 'x_root'@'localhost' for table 'cond_instances' (code 1142)
|
|
While executing delete from performance_schema.threads:
|
|
Got expected error: DELETE command denied to user 'x_root'@'localhost' for table 'threads' (code 1142)
|
|
While executing delete from performance_schema.rwlock_instances:
|
|
Got expected error: DELETE command denied to user 'x_root'@'localhost' for table 'rwlock_instances' (code 1142)
|
|
While executing delete from performance_schema.socket_instances:
|
|
Got expected error: DELETE command denied to user 'x_root'@'localhost' for table 'socket_instances' (code 1142)
|
|
While executing delete from performance_schema.socket_summary_by_event_name:
|
|
Got expected error: DELETE command denied to user 'x_root'@'localhost' for table 'socket_summary_by_event_name' (code 1142)
|
|
While executing delete from performance_schema.socket_summary_by_instance:
|
|
Got expected error: DELETE command denied to user 'x_root'@'localhost' for table 'socket_summary_by_instance' (code 1142)
|
|
While executing LOCK TABLES performance_schema.mutex_instances READ:
|
|
Got expected error: SELECT, LOCK TABLES command denied to user 'x_root'@'localhost' for table 'mutex_instances' (code 1142)
|
|
|
|
0 rows affected
|
|
While executing LOCK TABLES performance_schema.cond_instances READ:
|
|
Got expected error: SELECT, LOCK TABLES command denied to user 'x_root'@'localhost' for table 'cond_instances' (code 1142)
|
|
|
|
0 rows affected
|
|
While executing LOCK TABLES performance_schema.rwlock_instances READ:
|
|
Got expected error: SELECT, LOCK TABLES command denied to user 'x_root'@'localhost' for table 'rwlock_instances' (code 1142)
|
|
|
|
0 rows affected
|
|
While executing LOCK TABLES performance_schema.socket_instances READ:
|
|
Got expected error: SELECT, LOCK TABLES command denied to user 'x_root'@'localhost' for table 'socket_instances' (code 1142)
|
|
|
|
0 rows affected
|
|
While executing LOCK TABLES performance_schema.socket_summary_by_event_name READ:
|
|
Got expected error: SELECT, LOCK TABLES command denied to user 'x_root'@'localhost' for table 'socket_summary_by_event_name' (code 1142)
|
|
|
|
0 rows affected
|
|
While executing LOCK TABLES performance_schema.socket_summary_by_instance READ:
|
|
Got expected error: SELECT, LOCK TABLES command denied to user 'x_root'@'localhost' for table 'socket_summary_by_instance' (code 1142)
|
|
|
|
0 rows affected
|
|
While executing LOCK TABLES performance_schema.mutex_instances WRITE:
|
|
Got expected error: SELECT, LOCK TABLES command denied to user 'x_root'@'localhost' for table 'mutex_instances' (code 1142)
|
|
|
|
0 rows affected
|
|
While executing LOCK TABLES performance_schema.cond_instances WRITE:
|
|
Got expected error: SELECT, LOCK TABLES command denied to user 'x_root'@'localhost' for table 'cond_instances' (code 1142)
|
|
|
|
0 rows affected
|
|
While executing LOCK TABLES performance_schema.rwlock_instances WRITE:
|
|
Got expected error: SELECT, LOCK TABLES command denied to user 'x_root'@'localhost' for table 'rwlock_instances' (code 1142)
|
|
|
|
0 rows affected
|
|
While executing LOCK TABLES performance_schema.socket_instances WRITE:
|
|
Got expected error: SELECT, LOCK TABLES command denied to user 'x_root'@'localhost' for table 'socket_instances' (code 1142)
|
|
|
|
0 rows affected
|
|
While executing LOCK TABLES performance_schema.socket_summary_by_event_name WRITE:
|
|
Got expected error: SELECT, LOCK TABLES command denied to user 'x_root'@'localhost' for table 'socket_summary_by_event_name' (code 1142)
|
|
|
|
0 rows affected
|
|
While executing LOCK TABLES performance_schema.socket_summary_by_instance WRITE:
|
|
Got expected error: SELECT, LOCK TABLES command denied to user 'x_root'@'localhost' for table 'socket_summary_by_instance' (code 1142)
|
|
|
|
0 rows affected
|
|
name
|
|
thread/mysqlx/acceptor_network
|
|
thread/mysqlx/worker
|
|
command ok
|
|
name
|
|
wait/synch/mutex/mysqlx/broker_context_sync
|
|
wait/synch/mutex/mysqlx/client_session_exit
|
|
wait/synch/mutex/mysqlx/document_id_generate
|
|
wait/synch/mutex/mysqlx/listener_tcp_sync
|
|
wait/synch/mutex/mysqlx/lock_list_access
|
|
wait/synch/mutex/mysqlx/notice_output_queue
|
|
wait/synch/mutex/mysqlx/page_pool
|
|
wait/synch/mutex/mysqlx/scheduler_dynamic_thread_exit
|
|
wait/synch/mutex/mysqlx/scheduler_dynamic_worker_pending
|
|
wait/synch/mutex/mysqlx/scheduler_post
|
|
wait/synch/mutex/mysqlx/server_client_exit
|
|
wait/synch/mutex/mysqlx/server_state_sync
|
|
wait/synch/mutex/mysqlx/socket_acceptors_sync
|
|
wait/synch/mutex/mysqlx/socket_events_timers
|
|
wait/synch/mutex/mysqlx/vio_shutdown
|
|
wait/synch/mutex/mysqlx/xpl_server_accepting
|
|
command ok
|
|
name
|
|
wait/synch/cond/mysqlx/broker_context_sync
|
|
wait/synch/cond/mysqlx/listener_tcp_sync
|
|
wait/synch/cond/mysqlx/scheduler_dynamic_thread_exit
|
|
wait/synch/cond/mysqlx/scheduler_dynamic_worker_pending
|
|
wait/synch/cond/mysqlx/server_state_sync
|
|
wait/synch/cond/mysqlx/socket_acceptors_sync
|
|
command ok
|
|
name
|
|
wait/synch/rwlock/mysqlx/client_list_clients
|
|
wait/synch/rwlock/mysqlx/sha256_password_cache
|
|
command ok
|
|
event_name
|
|
wait/io/socket/mysqlx/client_connection
|
|
wait/io/socket/mysqlx/tcpip_socket
|
|
command ok
|
|
event_name
|
|
wait/io/socket/mysqlx/client_connection
|
|
wait/io/socket/mysqlx/tcpip_socket
|
|
command ok
|
|
event_name
|
|
wait/io/socket/mysqlx/client_connection
|
|
wait/io/socket/mysqlx/diagnostics_socket
|
|
wait/io/socket/mysqlx/tcpip_socket
|
|
command ok
|
|
event_name
|
|
wait/io/socket/mysqlx/client_connection
|
|
wait/io/socket/mysqlx/tcpip_socket
|
|
command ok
|
|
|
|
command ok
|
|
sleep(1)
|
|
0
|
|
0 rows affected
|
|
|
|
command ok
|
|
|
|
command ok
|
|
Mysqlx.Ok {
|
|
msg: "bye!"
|
|
}
|
|
ok
|
|
select DISTINCT EVENT_NAME from performance_schema.events_waits_history
|
|
where EVENT_NAME rlike '^wait/synch/mutex/mysqlx/(client_session|obuffer|queue)$' ORDER BY EVENT_NAME;
|
|
EVENT_NAME
|
|
select DISTINCT EVENT_NAME from performance_schema.events_waits_history_long
|
|
where EVENT_NAME rlike '^wait/synch/(cond|mutex)/mysqlx/(queue|client_session|obuffer|queue)$' ORDER BY EVENT_NAME;
|
|
EVENT_NAME
|
|
update performance_schema.setup_instruments set ENABLED='YES'
|
|
where NAME rlike '^wait/synch/(cond|mutex)/mysqlx/(lock_list_access|scheduler_dynamic_worker_pending)$';
|
|
# Check if any classes are not lost, this may happen if they are already
|
|
# just on the limit
|
|
SELECT * FROM performance_schema.global_status
|
|
WHERE variable_name LIKE '%_LOST' AND variable_value > 0;
|
|
VARIABLE_NAME VARIABLE_VALUE
|