mirror of
https://github.com/MariaDB/server.git
synced 2025-07-03 01:48:12 +02:00
83212632e4
- In 10.6, trx_rseg_t mutex was ported to use latch. As part of this porting profiling of the patch was removed. This patch reenables it given that the said latch continues to occupy the top-slots in the contention list.
56 lines
2.4 KiB
Text
56 lines
2.4 KiB
Text
UPDATE performance_schema.setup_instruments SET enabled = 'NO', timed = 'YES';
|
|
UPDATE performance_schema.setup_instruments SET enabled = 'YES'
|
|
WHERE name like 'wait/synch/sxlock/%';
|
|
UPDATE performance_schema.setup_instruments SET enabled = 'YES'
|
|
WHERE name like 'wait/synch/rwlock/innodb/%';
|
|
SELECT DISTINCT name FROM performance_schema.setup_instruments
|
|
WHERE name LIKE 'wait/synch/rwlock/innodb/%'
|
|
AND name!='wait/synch/rwlock/innodb/btr_search_latch' ORDER BY name;
|
|
name
|
|
wait/synch/rwlock/innodb/dict_operation_lock
|
|
wait/synch/rwlock/innodb/fil_space_latch
|
|
wait/synch/rwlock/innodb/lock_latch
|
|
wait/synch/rwlock/innodb/trx_i_s_cache_lock
|
|
wait/synch/rwlock/innodb/trx_purge_latch
|
|
wait/synch/rwlock/innodb/trx_rseg_latch
|
|
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/%" order by name;
|
|
name
|
|
wait/synch/sxlock/innodb/index_tree_rw_lock
|
|
SELECT DISTINCT name FROM performance_schema.rwlock_instances
|
|
WHERE name LIKE 'wait/synch/sxlock/innodb/%'
|
|
ORDER BY name;
|
|
name
|
|
wait/synch/sxlock/innodb/index_tree_rw_lock
|
|
create table t1(a int) engine=innodb;
|
|
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 DISTINCT event_name FROM performance_schema.events_waits_history_long
|
|
WHERE event_name LIKE 'wait/synch/rwlock/innodb/%'
|
|
AND event_name NOT IN
|
|
('wait/synch/rwlock/innodb/btr_search_latch',
|
|
'wait/synch/rwlock/innodb/dict_operation_lock',
|
|
'wait/synch/rwlock/innodb/trx_rseg_latch',
|
|
'wait/synch/rwlock/innodb/trx_purge_latch')
|
|
ORDER BY event_name;
|
|
event_name
|
|
wait/synch/rwlock/innodb/fil_space_latch
|
|
wait/synch/rwlock/innodb/lock_latch
|
|
SELECT event_name FROM performance_schema.events_waits_history_long
|
|
WHERE event_name = 'wait/synch/sxlock/innodb/index_tree_rw_lock'
|
|
AND operation IN ('try_shared_lock','shared_lock') LIMIT 1;
|
|
event_name
|
|
wait/synch/sxlock/innodb/index_tree_rw_lock
|
|
SELECT event_name from performance_schema.events_waits_history_long
|
|
WHERE event_name = 'wait/synch/sxlock/innodb/index_tree_rw_lock'
|
|
AND operation IN ('try_exclusive_lock','exclusive_lock') LIMIT 1;
|
|
event_name
|
|
wait/synch/sxlock/innodb/index_tree_rw_lock
|
|
UPDATE performance_schema.setup_instruments SET enabled = 'YES', timed = 'YES';
|