diff options
Diffstat (limited to 'mysql-test/suite/perfschema/r/dml_setup_instruments.result')
| -rw-r--r-- | mysql-test/suite/perfschema/r/dml_setup_instruments.result | 97 |
1 files changed, 97 insertions, 0 deletions
diff --git a/mysql-test/suite/perfschema/r/dml_setup_instruments.result b/mysql-test/suite/perfschema/r/dml_setup_instruments.result new file mode 100644 index 00000000..cdc52da5 --- /dev/null +++ b/mysql-test/suite/perfschema/r/dml_setup_instruments.result @@ -0,0 +1,97 @@ +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 +wait/synch/mutex/sql/Ack_receiver::mutex YES YES +wait/synch/mutex/sql/Cversion_lock YES YES +wait/synch/mutex/sql/Delayed_insert::mutex YES YES +wait/synch/mutex/sql/Event_scheduler::LOCK_scheduler_state YES YES +wait/synch/mutex/sql/gtid_waiting::LOCK_gtid_waiting YES YES +wait/synch/mutex/sql/hash_filo::lock YES YES +wait/synch/mutex/sql/HA_DATA_PARTITION::LOCK_auto_inc YES YES +wait/synch/mutex/sql/LOCK_active_mi YES YES +wait/synch/mutex/sql/LOCK_after_binlog_sync YES YES +wait/synch/mutex/sql/LOCK_audit_mask YES YES +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 +wait/synch/rwlock/sql/LOCK_all_status_vars YES YES +wait/synch/rwlock/sql/LOCK_dbnames YES YES +wait/synch/rwlock/sql/LOCK_dboptions YES YES +wait/synch/rwlock/sql/LOCK_grant YES YES +wait/synch/rwlock/sql/LOCK_rmdir YES YES +wait/synch/rwlock/sql/LOCK_SEQUENCE YES YES +wait/synch/rwlock/sql/LOCK_ssl_refresh YES YES +wait/synch/rwlock/sql/LOCK_system_variables_hash YES YES +wait/synch/rwlock/sql/LOCK_sys_init_connect YES YES +wait/synch/rwlock/sql/LOCK_sys_init_slave YES YES +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 +wait/synch/cond/sql/Ack_receiver::cond YES YES +wait/synch/cond/sql/COND_binlog_send YES YES +wait/synch/cond/sql/COND_flush_thread_cache YES YES +wait/synch/cond/sql/COND_group_commit_orderer YES YES +wait/synch/cond/sql/COND_gtid_ignore_duplicates YES YES +wait/synch/cond/sql/COND_manager YES YES +wait/synch/cond/sql/COND_parallel_entry YES YES +wait/synch/cond/sql/COND_prepare_ordered YES YES +wait/synch/cond/sql/COND_queue_state YES YES +wait/synch/cond/sql/COND_rpl_thread YES YES +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 `performance_schema`.`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 `performance_schema`.`setup_instruments` +delete from performance_schema.setup_instruments +where name like 'Wait/Synch/%'; +ERROR 42000: DELETE command denied to user 'root'@'localhost' for table `performance_schema`.`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 enabled='YES', TIMED='YES'; +# +# MDEV-25325 column_comment for performance_schema tables +# +select column_name, column_comment +from information_schema.columns +where table_schema='performance_schema' and table_name='setup_instruments'; +column_name column_comment +NAME Instrument name +ENABLED Whether or not the instrument is enabled. It can be disabled, and the instrument will produce no events. +TIMED Whether or not the instrument is timed. It can be set, but if disabled, events produced by the instrument will have NULL values for the corresponding TIMER_START, TIMER_END, and TIMER_WAIT values. |