1select * from performance_schema.setup_instruments; 2select * from performance_schema.setup_instruments 3where name like 'Wait/Synch/Mutex/sql/%' 4 and name not in ('wait/synch/mutex/sql/DEBUG_SYNC::mutex') 5order by name limit 10; 6NAME ENABLED TIMED 7wait/synch/mutex/sql/Bloom_filter YES YES 8wait/synch/mutex/sql/Commit_order_manager::m_mutex YES YES 9wait/synch/mutex/sql/Cost_constant_cache::LOCK_cost_const YES YES 10wait/synch/mutex/sql/Event_scheduler::LOCK_scheduler_state YES YES 11wait/synch/mutex/sql/Gtid_set::gtid_executed::free_intervals_mutex YES YES 12wait/synch/mutex/sql/Gtid_state YES YES 13wait/synch/mutex/sql/hash_filo::lock YES YES 14wait/synch/mutex/sql/key_mts_gaq_LOCK YES YES 15wait/synch/mutex/sql/key_mts_temp_table_LOCK YES YES 16wait/synch/mutex/sql/LOCK_audit_mask YES YES 17select * from performance_schema.setup_instruments 18where name like 'Wait/Synch/Rwlock/sql/%' 19 and name not in ( 20'wait/synch/rwlock/sql/CRYPTO_dynlock_value::lock', 21'wait/synch/rwlock/sql/LOCK_named_pipe_full_access_group') 22order by name limit 11; 23NAME ENABLED TIMED 24wait/synch/rwlock/sql/Binlog_relay_IO_delegate::lock YES YES 25wait/synch/rwlock/sql/Binlog_storage_delegate::lock YES YES 26wait/synch/rwlock/sql/Binlog_transmit_delegate::lock YES YES 27wait/synch/rwlock/sql/channel_lock YES YES 28wait/synch/rwlock/sql/channel_map_lock YES YES 29wait/synch/rwlock/sql/gtid_commit_rollback YES YES 30wait/synch/rwlock/sql/gtid_mode_lock YES YES 31wait/synch/rwlock/sql/LOCK_consistent_snapshot YES YES 32wait/synch/rwlock/sql/LOCK_dboptions YES YES 33wait/synch/rwlock/sql/LOCK_grant YES YES 34wait/synch/rwlock/sql/LOCK_system_variables_hash YES YES 35select * from performance_schema.setup_instruments 36where name like 'Wait/Synch/Cond/sql/%' 37 and name not in ( 38'wait/synch/cond/sql/COND_open', 39'wait/synch/cond/sql/COND_handler_count', 40'wait/synch/cond/sql/DEBUG_SYNC::cond', 41'wait/synch/cond/sql/COND_socket_listener_active', 42'wait/synch/cond/sql/COND_start_signal_handler') 43order by name limit 10; 44NAME ENABLED TIMED 45wait/synch/cond/sql/Commit_order_manager::m_workers.cond YES YES 46wait/synch/cond/sql/COND_compress_gtid_table YES YES 47wait/synch/cond/sql/COND_connection_count YES YES 48wait/synch/cond/sql/COND_flush_thread_cache YES YES 49wait/synch/cond/sql/COND_manager YES YES 50wait/synch/cond/sql/COND_queue_state YES YES 51wait/synch/cond/sql/COND_server_started YES YES 52wait/synch/cond/sql/COND_thd_list YES YES 53wait/synch/cond/sql/COND_thread_cache YES YES 54wait/synch/cond/sql/COND_thr_lock YES YES 55select * from performance_schema.setup_instruments 56where name='Wait'; 57select * from performance_schema.setup_instruments 58where enabled='YES'; 59insert into performance_schema.setup_instruments 60set name='FOO', enabled='YES', timed='YES'; 61ERROR 42000: INSERT command denied to user 'root'@'localhost' for table 'setup_instruments' 62update performance_schema.setup_instruments 63set name='FOO'; 64ERROR HY000: Invalid performance_schema usage. 65update performance_schema.setup_instruments 66set enabled='NO'; 67update performance_schema.setup_instruments 68set timed='NO'; 69select * from performance_schema.setup_instruments; 70update performance_schema.setup_instruments 71set enabled='YES', timed='YES'; 72delete from performance_schema.setup_instruments; 73ERROR 42000: DELETE command denied to user 'root'@'localhost' for table 'setup_instruments' 74delete from performance_schema.setup_instruments 75where name like 'Wait/Synch/%'; 76ERROR 42000: DELETE command denied to user 'root'@'localhost' for table 'setup_instruments' 77LOCK TABLES performance_schema.setup_instruments READ; 78UNLOCK TABLES; 79LOCK TABLES performance_schema.setup_instruments WRITE; 80UNLOCK TABLES; 81 82# Bug#13813193 ASSERTION `TABLE->READ_SET == 83# &TABLE->DEF_READ_SET' FAILED / MYSQL_UPDATE 84 85UPDATE performance_schema.setup_instruments SET timed='NO' 86ORDER BY RAND(); 87update performance_schema.setup_instruments 88set enabled='YES', TIMED='YES'; 89