Debian Codegraph @

mysql-test/suite/perfschema/r/dml_setup_instruments.result

raw
1 select * from performance_schema.setup_instruments;
2 select * from performance_schema.setup_instruments
3 where name like 'Wait/Synch/Mutex/sql/%'
4 and name not in ('wait/synch/mutex/sql/DEBUG_SYNC::mutex')
5 order by name limit 10;
6 NAME ENABLED TIMED
7 wait/synch/mutex/sql/Ack_receiver::mutex YES YES
8 wait/synch/mutex/sql/Cversion_lock YES YES
9 wait/synch/mutex/sql/Delayed_insert::mutex YES YES
10 wait/synch/mutex/sql/Event_scheduler::LOCK_scheduler_state YES YES
11 wait/synch/mutex/sql/Gtid_index_writer::gtid_index_mutex YES YES
12 wait/synch/mutex/sql/gtid_waiting::LOCK_gtid_waiting YES YES
13 wait/synch/mutex/sql/hash_filo::lock YES YES
14 wait/synch/mutex/sql/HA_DATA_PARTITION::LOCK_auto_inc YES YES
15 wait/synch/mutex/sql/LOCK_active_mi YES YES
16 wait/synch/mutex/sql/LOCK_after_binlog_sync YES YES
17 select * from performance_schema.setup_instruments
18 where 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')
22 order by name limit 10;
23 NAME ENABLED TIMED
24 wait/synch/rwlock/sql/LOCK_all_status_vars YES YES
25 wait/synch/rwlock/sql/LOCK_dbnames YES YES
26 wait/synch/rwlock/sql/LOCK_dboptions YES YES
27 wait/synch/rwlock/sql/LOCK_grant YES YES
28 wait/synch/rwlock/sql/LOCK_rmdir YES YES
29 wait/synch/rwlock/sql/LOCK_SEQUENCE YES YES
30 wait/synch/rwlock/sql/LOCK_ssl_refresh YES YES
31 wait/synch/rwlock/sql/LOCK_system_variables_hash YES YES
32 wait/synch/rwlock/sql/LOCK_sys_init_connect YES YES
33 wait/synch/rwlock/sql/LOCK_sys_init_slave YES YES
34 select * from performance_schema.setup_instruments
35 where name like 'Wait/Synch/Cond/sql/%'
36 and name not in (
37 'wait/synch/cond/sql/COND_open',
38 'wait/synch/cond/sql/COND_handler_count',
39 'wait/synch/cond/sql/DEBUG_SYNC::cond',
40 'wait/synch/cond/sql/COND_socket_listener_active',
41 'wait/synch/cond/sql/COND_start_signal_handler')
42 order by name limit 10;
43 NAME ENABLED TIMED
44 wait/synch/cond/sql/Ack_receiver::cond YES YES
45 wait/synch/cond/sql/COND_binlog_send YES YES
46 wait/synch/cond/sql/COND_flush_thread_cache YES YES
47 wait/synch/cond/sql/COND_group_commit_orderer YES YES
48 wait/synch/cond/sql/COND_gtid_ignore_duplicates YES YES
49 wait/synch/cond/sql/COND_manager YES YES
50 wait/synch/cond/sql/COND_parallel_entry YES YES
51 wait/synch/cond/sql/COND_prepare_ordered YES YES
52 wait/synch/cond/sql/COND_queue_state YES YES
53 wait/synch/cond/sql/COND_rpl_thread YES YES
54 select * from performance_schema.setup_instruments
55 where name='Wait';
56 select * from performance_schema.setup_instruments
57 where enabled='YES';
58 insert into performance_schema.setup_instruments
59 set name='FOO', enabled='YES', timed='YES';
60 ERROR 42000: INSERT command denied to user 'root'@'localhost' for table `performance_schema`.`setup_instruments`
61 update performance_schema.setup_instruments
62 set name='FOO';
63 ERROR HY000: Invalid performance_schema usage
64 update performance_schema.setup_instruments
65 set enabled='NO';
66 update performance_schema.setup_instruments
67 set timed='NO';
68 select * from performance_schema.setup_instruments;
69 update performance_schema.setup_instruments
70 set enabled='YES', timed='YES';
71 delete from performance_schema.setup_instruments;
72 ERROR 42000: DELETE command denied to user 'root'@'localhost' for table `performance_schema`.`setup_instruments`
73 delete from performance_schema.setup_instruments
74 where name like 'Wait/Synch/%';
75 ERROR 42000: DELETE command denied to user 'root'@'localhost' for table `performance_schema`.`setup_instruments`
76 LOCK TABLES performance_schema.setup_instruments READ;
77 UNLOCK TABLES;
78 LOCK TABLES performance_schema.setup_instruments WRITE;
79 UNLOCK TABLES;
80 #
81 # Bug#13813193 ASSERTION `TABLE->READ_SET ==
82 # &TABLE->DEF_READ_SET' FAILED / MYSQL_UPDATE
83 #
84 UPDATE performance_schema.setup_instruments SET timed='NO'
85 ORDER BY RAND();
86 update performance_schema.setup_instruments
87 set enabled='YES', TIMED='YES';
88 #
89 # MDEV-25325 column_comment for performance_schema tables
90 #
91 select column_name, column_comment
92 from information_schema.columns
93 where table_schema='performance_schema' and table_name='setup_instruments';
94 column_name column_comment
95 NAME Instrument name
96 ENABLED Whether or not the instrument is enabled. It can be disabled, and the instrument will produce no events.
97 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.