Debian Codegraph @

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

raw
1 UPDATE performance_schema.setup_instruments SET enabled = 'NO', timed = 'YES';
2 UPDATE performance_schema.setup_instruments SET enabled = 'YES'
3 WHERE name like 'wait/synch/sxlock/%';
4 TRUNCATE TABLE performance_schema.events_waits_history_long;
5 TRUNCATE TABLE performance_schema.events_waits_history;
6 TRUNCATE TABLE performance_schema.events_waits_current;
7 select name from performance_schema.setup_instruments
8 where name like "wait/synch/sxlock/%"
9 and name not in
10 ("wait/synch/sxlock/innodb/buf_block_lock",
11 "wait/synch/sxlock/innodb/buf_block_debug_latch")
12 order by name;
13 name
14 wait/synch/sxlock/innodb/btr_search_latch
15 wait/synch/sxlock/innodb/dict_operation_lock
16 wait/synch/sxlock/innodb/dict_table_stats
17 wait/synch/sxlock/innodb/fil_space_latch
18 wait/synch/sxlock/innodb/fts_cache_init_rw_lock
19 wait/synch/sxlock/innodb/fts_cache_rw_lock
20 wait/synch/sxlock/innodb/hash_table_locks
21 wait/synch/sxlock/innodb/index_online_log
22 wait/synch/sxlock/innodb/index_tree_rw_lock
23 wait/synch/sxlock/innodb/lock_sys_global_rw_lock
24 wait/synch/sxlock/innodb/log_sn_lock
25 wait/synch/sxlock/innodb/rsegs_lock
26 wait/synch/sxlock/innodb/trx_i_s_cache_lock
27 wait/synch/sxlock/innodb/trx_purge_latch
28 wait/synch/sxlock/innodb/undo_spaces_lock
29 select name from performance_schema.rwlock_instances
30 where name in
31 (
32 'wait/synch/sxlock/innodb/btr_search_latch',
33 'wait/synch/sxlock/innodb/checkpoint_lock',
34 'wait/synch/sxlock/innodb/dict_operation_lock',
35 'wait/synch/sxlock/innodb/trx_i_s_cache_lock',
36 'wait/synch/sxlock/innodb/trx_purge_latch'
37 )
38 order by name;
39 name
40 wait/synch/sxlock/innodb/btr_search_latch
41 wait/synch/sxlock/innodb/btr_search_latch
42 wait/synch/sxlock/innodb/btr_search_latch
43 wait/synch/sxlock/innodb/btr_search_latch
44 wait/synch/sxlock/innodb/btr_search_latch
45 wait/synch/sxlock/innodb/btr_search_latch
46 wait/synch/sxlock/innodb/btr_search_latch
47 wait/synch/sxlock/innodb/btr_search_latch
48 wait/synch/sxlock/innodb/dict_operation_lock
49 wait/synch/sxlock/innodb/trx_i_s_cache_lock
50 wait/synch/sxlock/innodb/trx_purge_latch
51 drop table if exists t1;
52 create table t1(a int) engine=innodb;
53 begin;
54 insert into t1 values (1), (2), (3);
55 insert into t1 values (1), (2), (3);
56 insert into t1 values (1), (2), (3);
57 commit;
58 drop table t1;
59 select operation from performance_schema.events_waits_history_long
60 where event_name like "wait/synch/sxlock/%"
61 and operation = "shared_lock" limit 1;
62 operation
63 shared_lock
64 select operation from performance_schema.events_waits_history_long
65 where event_name like "wait/synch/sxlock/%"
66 and operation = "exclusive_lock" limit 1;
67 operation
68 exclusive_lock
69 UPDATE performance_schema.setup_instruments SET enabled = 'YES', timed = 'YES';