p_s/events_waits_summary_global_by_event_name/readme.txt

   1 This screen is inspired by this post:
   2
   3 http://www.percona.com/blog/2015/01/06/getting-mutex-information-from-mysqls-performance_schema/i
   4
   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)
  21
  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
  25