1 This screen is inspired by this post:
3 http://www.percona.com/blog/2015/01/06/getting-mutex-information-from-mysqls-performance_schema/i
5 root@localhost [performance_schema]> select * from setup_instruments limit 10;
6 +---------------------------------------------------------+---------+-------+
7 | NAME | ENABLED | TIMED |
8 +---------------------------------------------------------+---------+-------+
9 | wait/synch/mutex/sql/TC_LOG_MMAP::LOCK_tc | NO | NO |
10 | wait/synch/mutex/sql/LOCK_des_key_file | NO | NO |
11 | wait/synch/mutex/sql/MYSQL_BIN_LOG::LOCK_commit | NO | NO |
12 | wait/synch/mutex/sql/MYSQL_BIN_LOG::LOCK_commit_queue | NO | NO |
13 | wait/synch/mutex/sql/MYSQL_BIN_LOG::LOCK_done | NO | NO |
14 | wait/synch/mutex/sql/MYSQL_BIN_LOG::LOCK_flush_queue | NO | NO |
15 | wait/synch/mutex/sql/MYSQL_BIN_LOG::LOCK_index | NO | NO |
16 | wait/synch/mutex/sql/MYSQL_BIN_LOG::LOCK_log | NO | NO |
17 | wait/synch/mutex/sql/MYSQL_BIN_LOG::LOCK_binlog_end_pos | NO | NO |
18 | wait/synch/mutex/sql/MYSQL_BIN_LOG::LOCK_sync | NO | NO |
19 +---------------------------------------------------------+---------+-------+
20 10 rows in set (0.00 sec)
22 root@localhost [performance_schema]> update setup_instruments set enabled = 'YES', timed = 'YES' where NAME like 'wait/synch/mutex/innodb/%';
23 Query OK, 49 rows affected (0.02 sec)
24 Rows matched: 49 Changed: 49 Warnings: 0