69 lines
2.5 KiB
Plaintext
69 lines
2.5 KiB
Plaintext
UPDATE performance_schema.setup_instruments SET enabled = 'NO', timed = 'YES';
|
|
UPDATE performance_schema.setup_instruments SET enabled = 'YES'
|
|
WHERE name like 'wait/synch/sxlock/%';
|
|
TRUNCATE TABLE performance_schema.events_waits_history_long;
|
|
TRUNCATE TABLE performance_schema.events_waits_history;
|
|
TRUNCATE TABLE performance_schema.events_waits_current;
|
|
select name from performance_schema.setup_instruments
|
|
where name like "wait/synch/sxlock/%"
|
|
and name not in
|
|
("wait/synch/sxlock/innodb/buf_block_lock",
|
|
"wait/synch/sxlock/innodb/buf_block_debug_latch")
|
|
order by name;
|
|
name
|
|
wait/synch/sxlock/innodb/btr_search_latch
|
|
wait/synch/sxlock/innodb/dict_operation_lock
|
|
wait/synch/sxlock/innodb/dict_table_stats
|
|
wait/synch/sxlock/innodb/fil_space_latch
|
|
wait/synch/sxlock/innodb/fts_cache_init_rw_lock
|
|
wait/synch/sxlock/innodb/fts_cache_rw_lock
|
|
wait/synch/sxlock/innodb/hash_table_locks
|
|
wait/synch/sxlock/innodb/index_online_log
|
|
wait/synch/sxlock/innodb/index_tree_rw_lock
|
|
wait/synch/sxlock/innodb/log_sn_lock
|
|
wait/synch/sxlock/innodb/rsegs_lock
|
|
wait/synch/sxlock/innodb/trx_i_s_cache_lock
|
|
wait/synch/sxlock/innodb/trx_purge_latch
|
|
wait/synch/sxlock/innodb/undo_spaces_lock
|
|
select name from performance_schema.rwlock_instances
|
|
where name in
|
|
(
|
|
'wait/synch/sxlock/innodb/btr_search_latch',
|
|
'wait/synch/sxlock/innodb/checkpoint_lock',
|
|
'wait/synch/sxlock/innodb/dict_operation_lock',
|
|
'wait/synch/sxlock/innodb/trx_i_s_cache_lock',
|
|
'wait/synch/sxlock/innodb/trx_purge_latch'
|
|
)
|
|
order by name;
|
|
name
|
|
wait/synch/sxlock/innodb/btr_search_latch
|
|
wait/synch/sxlock/innodb/btr_search_latch
|
|
wait/synch/sxlock/innodb/btr_search_latch
|
|
wait/synch/sxlock/innodb/btr_search_latch
|
|
wait/synch/sxlock/innodb/btr_search_latch
|
|
wait/synch/sxlock/innodb/btr_search_latch
|
|
wait/synch/sxlock/innodb/btr_search_latch
|
|
wait/synch/sxlock/innodb/btr_search_latch
|
|
wait/synch/sxlock/innodb/dict_operation_lock
|
|
wait/synch/sxlock/innodb/trx_i_s_cache_lock
|
|
wait/synch/sxlock/innodb/trx_purge_latch
|
|
drop table if exists t1;
|
|
create table t1(a int) engine=XENGINE;
|
|
begin;
|
|
insert into t1 values (1), (2), (3);
|
|
insert into t1 values (1), (2), (3);
|
|
insert into t1 values (1), (2), (3);
|
|
commit;
|
|
drop table t1;
|
|
select operation from performance_schema.events_waits_history_long
|
|
where event_name like "wait/synch/sxlock/%"
|
|
and operation = "shared_lock" limit 1;
|
|
operation
|
|
shared_lock
|
|
select operation from performance_schema.events_waits_history_long
|
|
where event_name like "wait/synch/sxlock/%"
|
|
and operation = "exclusive_lock" limit 1;
|
|
operation
|
|
exclusive_lock
|
|
UPDATE performance_schema.setup_instruments SET enabled = 'YES', timed = 'YES';
|