1update performance_schema.setup_instruments set enabled='NO'; 2update performance_schema.setup_consumers set enabled='YES'; 3update performance_schema.setup_instruments set enabled='YES' 4 where name like "wait/synch/mutex/mysys/THR_LOCK_myisam"; 5drop table if exists test.t1; 6truncate table performance_schema.events_waits_current; 7truncate table performance_schema.events_waits_history; 8truncate table performance_schema.events_waits_history_long; 9show variables like "thread_handling"; 10Variable_name Value 11thread_handling no-threads 12create table test.t1(a int) engine=MYISAM; 13show variables like "performance_schema"; 14Variable_name Value 15performance_schema ON 16show variables like "performance_schema_max_thread%"; 17Variable_name Value 18performance_schema_max_thread_classes 50 19performance_schema_max_thread_instances 10 20select count(*) from performance_schema.threads 21where name like "thread/sql/main"; 22count(*) 231 24select count(*) from performance_schema.threads 25where name like "thread/sql/OneConnection"; 26count(*) 270 28select event_name, operation, 29left(source, locate(":", source)) as short_source 30from performance_schema.events_waits_current; 31event_name operation short_source 32wait/synch/mutex/mysys/THR_LOCK_myisam lock mi_create.c: 33select event_name, operation, 34left(source, locate(":", source)) as short_source 35from performance_schema.events_waits_history; 36event_name operation short_source 37wait/synch/mutex/mysys/THR_LOCK_myisam lock mi_create.c: 38select event_name, operation, 39left(source, locate(":", source)) as short_source 40from performance_schema.events_waits_history_long; 41event_name operation short_source 42wait/synch/mutex/mysys/THR_LOCK_myisam lock mi_create.c: 43update performance_schema.setup_instruments set enabled='YES'; 44drop table test.t1; 45