1use performance_schema; 2select count(name) from mutex_instances 3where name like "wait/synch/mutex/mysys/THR_LOCK_threads"; 4count(name) 51 6select count(name) from mutex_instances 7where name like "wait/synch/mutex/mysys/THR_LOCK_malloc"; 8count(name) 91 10select count(name) from mutex_instances 11where name like "wait/synch/mutex/mysys/THR_LOCK_open"; 12count(name) 131 14select count(name) from mutex_instances 15where name like "wait/synch/mutex/mysys/THR_LOCK_myisam"; 16count(name) 171 18select count(name) from mutex_instances 19where name like "wait/synch/mutex/mysys/THR_LOCK_heap"; 20count(name) 211 22select count(name) from mutex_instances 23where name like "wait/synch/mutex/mysys/THR_LOCK_net"; 24count(name) 251 26select count(name) from mutex_instances 27where name like "wait/synch/mutex/mysys/THR_LOCK_charset"; 28count(name) 291 30select count(name) from cond_instances 31where name like "wait/synch/cond/mysys/THR_COND_threads"; 32count(name) 331 34select count(name) from mutex_instances 35where name like "wait/synch/mutex/sql/LOCK_open"; 36count(name) 371 38select count(name) from mutex_instances 39where name like "wait/synch/mutex/sql/LOCK_thread_count"; 40count(name) 411 42select count(name) from mutex_instances 43where name like "wait/synch/mutex/sql/LOCK_log_throttle_qni"; 44count(name) 451 46select count(name) from mutex_instances 47where name like "wait/synch/mutex/sql/LOCK_status"; 48count(name) 491 50select count(name) from mutex_instances 51where name like "wait/synch/mutex/sql/LOCK_error_log"; 52count(name) 531 54select count(name) from mutex_instances 55where name like "wait/synch/mutex/sql/LOCK_delayed_insert"; 56count(name) 571 58select count(name) from mutex_instances 59where name like "wait/synch/mutex/sql/LOCK_uuid_generator"; 60count(name) 611 62select count(name) from mutex_instances 63where name like "wait/synch/mutex/sql/LOCK_delayed_status"; 64count(name) 651 66select count(name) from mutex_instances 67where name like "wait/synch/mutex/sql/LOCK_delayed_create"; 68count(name) 691 70select count(name) from mutex_instances 71where name like "wait/synch/mutex/sql/LOCK_crypt"; 72count(name) 731 74select count(name) from mutex_instances 75where name like "wait/synch/mutex/sql/LOCK_slave_list"; 76count(name) 771 78select count(name) from mutex_instances 79where name like "wait/synch/mutex/sql/LOCK_active_mi"; 80count(name) 811 82select count(name) from mutex_instances 83where name like "wait/synch/mutex/sql/LOCK_manager"; 84count(name) 851 86select count(name) from mutex_instances 87where name like "wait/synch/mutex/sql/LOCK_global_system_variables"; 88count(name) 891 90select count(name) from mutex_instances 91where name like "wait/synch/mutex/sql/LOCK_user_conn"; 92count(name) 931 94select count(name) from mutex_instances 95where name like "wait/synch/mutex/sql/LOCK_prepared_stmt_count"; 96count(name) 971 98select count(name) from mutex_instances 99where name like "wait/synch/mutex/sql/LOCK_connection_count"; 100count(name) 1011 102select count(name) from mutex_instances 103where name like "wait/synch/mutex/sql/LOCK_server_started"; 104count(name) 1051 106select count(name) from mutex_instances 107where name like "wait/synch/mutex/sql/Query_cache::structure_guard_mutex"; 108count(name) 1091 110select count(name) from mutex_instances 111where name like "wait/synch/mutex/sql/LOCK_event_queue"; 112count(name) 1131 114select count(name) from mutex_instances 115where name like "wait/synch/mutex/sql/LOCK_user_locks"; 116count(name) 1171 118select count(name) from mutex_instances 119where name like "wait/synch/mutex/sql/Cversion_lock"; 120count(name) 1211 122select count(name) from mutex_instances 123where name like "wait/synch/mutex/sql/LOCK_audit_mask"; 124count(name) 1251 126select count(name) from mutex_instances 127where name like "wait/synch/mutex/sql/LOCK_xid_cache"; 128count(name) 1291 130select count(name) from mutex_instances 131where name like "wait/synch/mutex/sql/LOCK_plugin"; 132count(name) 1331 134select count(name) from mutex_instances 135where name like "wait/synch/mutex/sql/tz_LOCK"; 136count(name) 1371 138select count(name) from rwlock_instances 139where name like "wait/synch/rwlock/sql/LOCK_grant"; 140count(name) 1411 142select count(name) from rwlock_instances 143where name like "wait/synch/rwlock/sql/LOCK_sys_init_connect"; 144count(name) 1451 146select count(name) from rwlock_instances 147where name like "wait/synch/rwlock/sql/LOCK_sys_init_slave"; 148count(name) 1491 150select count(name) from rwlock_instances 151where name like "wait/synch/rwlock/sql/LOCK_system_variables_hash"; 152count(name) 1531 154select count(name) from cond_instances 155where name like "wait/synch/cond/sql/COND_server_started"; 156count(name) 1571 158select count(name) from cond_instances 159where name like "wait/synch/cond/sql/COND_refresh"; 160count(name) 1610 162select count(name) from cond_instances 163where name like "wait/synch/cond/sql/COND_thread_count"; 164count(name) 1651 166select count(name) from cond_instances 167where name like "wait/synch/cond/sql/COND_manager"; 168count(name) 1691 170select count(name) from cond_instances 171where name like "wait/synch/cond/sql/COND_thread_cache"; 172count(name) 1731 174select count(name) from cond_instances 175where name like "wait/synch/cond/sql/COND_flush_thread_cache"; 176count(name) 1771 178select count(name) from cond_instances 179where name like "wait/synch/cond/sql/Query_cache::COND_cache_status_changed"; 180count(name) 1811 182select count(name) from cond_instances 183where name like "wait/synch/cond/sql/COND_queue_state"; 184count(name) 1851 186