⚝
One Hat Cyber Team
⚝
Your IP:
216.73.216.124
Server IP:
50.28.103.30
Server:
Linux host.jcukjv-lwsites.com 4.18.0-553.22.1.el8_10.x86_64 #1 SMP Tue Sep 24 05:16:59 EDT 2024 x86_64
Server Software:
nginx/1.28.0
PHP Version:
8.3.12
Buat File
|
Buat Folder
Eksekusi
Dir :
~
/
www
/
server
/
mysql
/
mysql-test
/
suite
/
perfschema
/
r
/
View File Name :
sxlock_func.result
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/checkpoint_lock 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/trx_i_s_cache_lock wait/synch/sxlock/innodb/trx_purge_latch 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/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 drop table if exists t1; 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 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';