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/Cversion_lock YES YES 8wait/synch/mutex/sql/Delayed_insert::mutex YES YES 9wait/synch/mutex/sql/Event_scheduler::LOCK_scheduler_state YES YES 10wait/synch/mutex/sql/Gtid_state YES YES 11wait/synch/mutex/sql/hash_filo::lock YES YES 12wait/synch/mutex/sql/LOCK_active_mi YES YES 13wait/synch/mutex/sql/LOCK_audit_mask YES YES 14wait/synch/mutex/sql/LOCK_connection_count YES YES 15wait/synch/mutex/sql/LOCK_crypt YES YES 16wait/synch/mutex/sql/LOCK_delayed_create 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 10; 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/gtid_commit_rollback YES YES 28wait/synch/rwlock/sql/LOCK_consistent_snapshot YES YES 29wait/synch/rwlock/sql/LOCK_dboptions YES YES 30wait/synch/rwlock/sql/LOCK_grant YES YES 31wait/synch/rwlock/sql/LOCK_system_variables_hash YES YES 32wait/synch/rwlock/sql/LOCK_sys_init_connect YES YES 33wait/synch/rwlock/sql/LOCK_sys_init_slave YES YES 34select * from performance_schema.setup_instruments 35where name like 'Wait/Synch/Cond/sql/%' 36 and name not in ( 37'wait/synch/cond/sql/COND_handler_count', 38'wait/synch/cond/sql/DEBUG_SYNC::cond') 39order by name limit 10; 40NAME ENABLED TIMED 41wait/synch/cond/sql/COND_connection_count YES YES 42wait/synch/cond/sql/COND_flush_thread_cache YES YES 43wait/synch/cond/sql/COND_manager YES YES 44wait/synch/cond/sql/COND_queue_state YES YES 45wait/synch/cond/sql/COND_server_started YES YES 46wait/synch/cond/sql/COND_thread_cache YES YES 47wait/synch/cond/sql/COND_thread_count YES YES 48wait/synch/cond/sql/Delayed_insert::cond YES YES 49wait/synch/cond/sql/Delayed_insert::cond_client YES YES 50wait/synch/cond/sql/Event_scheduler::COND_state YES YES 51select * from performance_schema.setup_instruments 52where name='Wait'; 53select * from performance_schema.setup_instruments 54where enabled='YES'; 55insert into performance_schema.setup_instruments 56set name='FOO', enabled='YES', timed='YES'; 57ERROR 42000: INSERT command denied to user 'root'@'localhost' for table 'setup_instruments' 58update performance_schema.setup_instruments 59set name='FOO'; 60ERROR HY000: Invalid performance_schema usage. 61update performance_schema.setup_instruments 62set enabled='NO'; 63update performance_schema.setup_instruments 64set timed='NO'; 65select * from performance_schema.setup_instruments; 66update performance_schema.setup_instruments 67set enabled='YES', timed='YES'; 68delete from performance_schema.setup_instruments; 69ERROR 42000: DELETE command denied to user 'root'@'localhost' for table 'setup_instruments' 70delete from performance_schema.setup_instruments 71where name like 'Wait/Synch/%'; 72ERROR 42000: DELETE command denied to user 'root'@'localhost' for table 'setup_instruments' 73LOCK TABLES performance_schema.setup_instruments READ; 74UNLOCK TABLES; 75LOCK TABLES performance_schema.setup_instruments WRITE; 76UNLOCK TABLES; 77 78# Bug#13813193 ASSERTION `TABLE->READ_SET == 79# &TABLE->DEF_READ_SET' FAILED / MYSQL_UPDATE 80 81UPDATE performance_schema.setup_instruments SET timed='NO' 82ORDER BY RAND(); 83update performance_schema.setup_instruments 84set enabled='YES', TIMED='YES'; 85