Latest Version: 0.5.5


mysqlmymonlite.sh supports Performance Schema output

mysqlmymonlite.sh v0.4.2 adds support for outputting MySQL 5.5+ Performance Schema statistics if you have enabled Performance Schema Engine and are using MySQL 5.5 or higher versions.

Download link: [download zip] (Latest Version: 0.5.5)

[Back to index]


To output performance_schema stats and save to text file called mysqlmymonlite_performance_schema_stats.txt, type the following in SSH2 telnet as root user:


    cd /root
    ./mysqlmymonlite.sh pschema 2>/dev/null > mysqlmymonlite_performance_schema_stats.txt

Example output

.

mysqlmymonlite.sh command options

./mysqlmymonlite.sh 

install mysqlmymonlite.sh at /root
chmod +x mysqlmymonlite.sh

./mysqlmymonlite.sh --help
./mysqlmymonlite.sh check
./mysqlmymonlite.sh run
./mysqlmymonlite.sh mysql
./mysqlmymonlite.sh vmstat
./mysqlmymonlite.sh showcreate
./mysqlmymonlite.sh showindex
./mysqlmymonlite.sh vbshowtables
./mysqlmymonlite.sh dblist
./mysqlmymonlite.sh mysqlreport
./mysqlmymonlite.sh mysqlfullreport
./mysqlmymonlite.sh mysqltuner
./mysqlmymonlite.sh psmem
./mysqlmymonlite.sh pschema
Performance Schema Output ( Performance Schema Variables )

./mysqlmymonlite.sh pschema               

-------------------------------------------------------------
System MySQL monitoring stats
mysqlmymonlite.sh - 0.4.2 mysqlmymon.com
compiled by George Liu (eva2000) vbtechsupport.com
-------------------------------------------------------------

Report Generated:
Tue Jul 3 12:11:00 EST 2012
---------------------------------------
Process List
+-----------+----------------+----------------------------------------+
| THREAD_ID | PROCESSLIST_ID | NAME                                   |
+-----------+----------------+----------------------------------------+
|         0 |              0 | thread/sql/main                        |
|         1 |              0 | thread/innodb/io_handler_thread        |
|         2 |              0 | thread/innodb/io_handler_thread        |
|         3 |              0 | thread/innodb/io_handler_thread        |
|         4 |              0 | thread/innodb/io_handler_thread        |
|         5 |              0 | thread/innodb/io_handler_thread        |
|         6 |              0 | thread/innodb/io_handler_thread        |
|         7 |              0 | thread/innodb/srv_lock_timeout_thread  |
|         8 |              0 | thread/innodb/srv_error_monitor_thread |
|         9 |              0 | thread/innodb/srv_monitor_thread       |
|        10 |              0 | thread/innodb/srv_master_thread        |
|        11 |              0 | thread/sql/signal_handler              |
|        49 |             38 | thread/sql/one_connection              |
+-----------+----------------+----------------------------------------+

---------------------------------------
PERFORMANCE_SCHEMA Var status
+---------------------------------------------------+---------+
| Variable_name                                     | Value   |
+---------------------------------------------------+---------+
| performance_schema                                | ON      |
| performance_schema_events_waits_history_long_size | 10000   |
| performance_schema_events_waits_history_size      | 10      |
| performance_schema_max_cond_classes               | 80      |
| performance_schema_max_cond_instances             | 1000    |
| performance_schema_max_file_classes               | 50      |
| performance_schema_max_file_handles               | 32768   |
| performance_schema_max_file_instances             | 10000   |
| performance_schema_max_mutex_classes              | 200     |
| performance_schema_max_mutex_instances            | 1000000 |
| performance_schema_max_rwlock_classes             | 30      |
| performance_schema_max_rwlock_instances           | 1000000 |
| performance_schema_max_table_handles              | 100000  |
| performance_schema_max_table_instances            | 50000   |
| performance_schema_max_thread_classes             | 50      |
| performance_schema_max_thread_instances           | 1000    |
+---------------------------------------------------+---------+

---------------------------------------
PERFORMANCE_SCHEMA Status
+------------------------------------------+-------+
| Variable_name                            | Value |
+------------------------------------------+-------+
| Performance_schema_cond_classes_lost     | 0     |
| Performance_schema_cond_instances_lost   | 0     |
| Performance_schema_file_classes_lost     | 0     |
| Performance_schema_file_handles_lost     | 0     |
| Performance_schema_file_instances_lost   | 0     |
| Performance_schema_locker_lost           | 0     |
| Performance_schema_mutex_classes_lost    | 0     |
| Performance_schema_mutex_instances_lost  | 0     |
| Performance_schema_rwlock_classes_lost   | 0     |
| Performance_schema_rwlock_instances_lost | 0     |
| Performance_schema_table_handles_lost    | 0     |
| Performance_schema_table_instances_lost  | 0     |
| Performance_schema_thread_classes_lost   | 0     |
| Performance_schema_thread_instances_lost | 0     |
+------------------------------------------+-------+

---------------------------------------
PERFORMANCE_SCHEMA Engine status
+--------------------+--------------------------------------------------------+-----------+
| Type               | Name                                                   | Status    |
+--------------------+--------------------------------------------------------+-----------+
| performance_schema | events_waits_current.row_size                          | 136       |
| performance_schema | events_waits_current.row_count                         | 3000      |
| performance_schema | events_waits_history.row_size                          | 120       |
| performance_schema | events_waits_history.row_count                         | 10000     |
| performance_schema | events_waits_history.memory                            | 1200000   |
| performance_schema | events_waits_history_long.row_size                     | 120       |
| performance_schema | events_waits_history_long.row_count                    | 10000     |
| performance_schema | events_waits_history_long.memory                       | 1200000   |
| performance_schema | (pfs_mutex_class).row_size                             | 248       |
| performance_schema | (pfs_mutex_class).row_count                            | 200       |
| performance_schema | (pfs_mutex_class).memory                               | 49600     |
| performance_schema | (pfs_rwlock_class).row_size                            | 296       |
| performance_schema | (pfs_rwlock_class).row_count                           | 30        |
| performance_schema | (pfs_rwlock_class).memory                              | 8880      |
| performance_schema | (pfs_cond_class).row_size                              | 216       |
| performance_schema | (pfs_cond_class).row_count                             | 80        |
| performance_schema | (pfs_cond_class).memory                                | 17280     |
| performance_schema | (pfs_thread_class).row_size                            | 136       |
| performance_schema | (pfs_thread_class).row_count                           | 50        |
| performance_schema | (pfs_thread_class).memory                              | 6800      |
| performance_schema | (pfs_file_class).row_size                              | 240       |
| performance_schema | (pfs_file_class).row_count                             | 50        |
| performance_schema | (pfs_file_class).memory                                | 12000     |
| performance_schema | mutex_instances.row_size                               | 136       |
| performance_schema | mutex_instances.row_count                              | 1000000   |
| performance_schema | mutex_instances.memory                                 | 136000000 |
| performance_schema | rwlock_instances.row_size                              | 200       |
| performance_schema | rwlock_instances.row_count                             | 1000000   |
| performance_schema | rwlock_instances.memory                                | 200000000 |
| performance_schema | cond_instances.row_size                                | 88        |
| performance_schema | cond_instances.row_count                               | 1000      |
| performance_schema | cond_instances.memory                                  | 88000     |
| performance_schema | threads.row_size                                       | 504       |
| performance_schema | threads.row_count                                      | 1000      |
| performance_schema | threads.memory                                         | 504000    |
| performance_schema | file_instances.row_size                                | 624       |
| performance_schema | file_instances.row_count                               | 10000     |
| performance_schema | file_instances.memory                                  | 6240000   |
| performance_schema | (pfs_file_handle).row_size                             | 8         |
| performance_schema | (pfs_file_handle).row_count                            | 32768     |
| performance_schema | (pfs_file_handle).memory                               | 262144    |
| performance_schema | events_waits_summary_by_thread_by_event_name.row_size  | 48        |
| performance_schema | events_waits_summary_by_thread_by_event_name.row_count | 360000    |
| performance_schema | events_waits_summary_by_thread_by_event_name.memory    | 17280000  |
| performance_schema | (pfs_table_share).row_size                             | 488       |
| performance_schema | (pfs_table_share).row_count                            | 50000     |
| performance_schema | (pfs_table_share).memory                               | 24400000  |
| performance_schema | (pfs_table).row_size                                   | 72        |
| performance_schema | (pfs_table).row_count                                  | 100000    |
| performance_schema | (pfs_table).memory                                     | 7200000   |
| performance_schema | performance_schema.memory                              | 394468704 |
+--------------------+--------------------------------------------------------+-----------+

---------------------------------------
PERFORMANCE_SCHEMA setup_instruments
+------------------------------------------------------------+---------+-------+
| NAME                                                       | ENABLED | TIMED |
+------------------------------------------------------------+---------+-------+
| wait/synch/mutex/sql/PAGE::lock                            | YES     | YES   |
| wait/synch/mutex/sql/TC_LOG_MMAP::LOCK_sync                | YES     | YES   |
| wait/synch/mutex/sql/TC_LOG_MMAP::LOCK_active              | YES     | YES   |
| wait/synch/mutex/sql/TC_LOG_MMAP::LOCK_pool                | YES     | YES   |
| wait/synch/mutex/sql/LOCK_des_key_file                     | YES     | YES   |
| wait/synch/mutex/sql/MYSQL_BIN_LOG::LOCK_index             | YES     | YES   |
| wait/synch/mutex/sql/MYSQL_BIN_LOG::LOCK_prep_xids         | YES     | YES   |
| wait/synch/mutex/sql/MYSQL_RELAY_LOG::LOCK_index           | YES     | YES   |
| wait/synch/mutex/sql/Delayed_insert::mutex                 | YES     | YES   |
| wait/synch/mutex/sql/hash_filo::lock                       | YES     | YES   |
| wait/synch/mutex/sql/LOCK_active_mi                        | YES     | YES   |
| wait/synch/mutex/sql/LOCK_connection_count                 | YES     | YES   |
| wait/synch/mutex/sql/LOCK_crypt                            | YES     | YES   |
| wait/synch/mutex/sql/LOCK_delayed_create                   | YES     | YES   |
| wait/synch/mutex/sql/LOCK_delayed_insert                   | YES     | YES   |
| wait/synch/mutex/sql/LOCK_delayed_status                   | YES     | YES   |
| wait/synch/mutex/sql/LOCK_error_log                        | YES     | YES   |
| wait/synch/mutex/sql/LOCK_gdl                              | YES     | YES   |
| wait/synch/mutex/sql/LOCK_global_system_variables          | YES     | YES   |
| wait/synch/mutex/sql/LOCK_manager                          | YES     | YES   |
| wait/synch/mutex/sql/LOCK_prepared_stmt_count              | YES     | YES   |
| wait/synch/mutex/sql/LOCK_rpl_status                       | YES     | YES   |
| wait/synch/mutex/sql/LOCK_server_started                   | YES     | YES   |
| wait/synch/mutex/sql/LOCK_status                           | YES     | YES   |
| wait/synch/mutex/sql/LOCK_system_variables_hash            | YES     | YES   |
| wait/synch/mutex/sql/LOCK_table_share                      | YES     | YES   |
| wait/synch/mutex/sql/THD::LOCK_thd_data                    | YES     | YES   |
| wait/synch/mutex/sql/LOCK_user_conn                        | YES     | YES   |
| wait/synch/mutex/sql/LOCK_uuid_generator                   | YES     | YES   |
| wait/synch/mutex/sql/LOG::LOCK_log                         | YES     | YES   |
| wait/synch/mutex/sql/Master_info::data_lock                | YES     | YES   |
| wait/synch/mutex/sql/Master_info::run_lock                 | YES     | YES   |
| wait/synch/mutex/sql/Master_info::sleep_lock               | YES     | YES   |
| wait/synch/mutex/sql/Slave_reporting_capability::err_lock  | YES     | YES   |
| wait/synch/mutex/sql/Relay_log_info::data_lock             | YES     | YES   |
| wait/synch/mutex/sql/Relay_log_info::log_space_lock        | YES     | YES   |
| wait/synch/mutex/sql/Relay_log_info::run_lock              | YES     | YES   |
| wait/synch/mutex/sql/Relay_log_info::sleep_lock            | YES     | YES   |
| wait/synch/mutex/sql/Query_cache::structure_guard_mutex    | YES     | YES   |
| wait/synch/mutex/sql/TABLE_SHARE::LOCK_ha_data             | YES     | YES   |
| wait/synch/mutex/sql/LOCK_error_messages                   | YES     | YES   |
| wait/synch/mutex/sql/LOG_INFO::lock                        | YES     | YES   |
| wait/synch/mutex/sql/LOCK_thread_count                     | YES     | YES   |
| wait/synch/mutex/sql/HA_DATA_PARTITION::LOCK_auto_inc      | YES     | YES   |
| wait/synch/mutex/mysys/BITMAP::mutex                       | YES     | YES   |
| wait/synch/mutex/mysys/IO_CACHE::append_buffer_lock        | YES     | YES   |
| wait/synch/mutex/mysys/IO_CACHE::SHARE_mutex               | YES     | YES   |
| wait/synch/mutex/mysys/KEY_CACHE::cache_lock               | YES     | YES   |
| wait/synch/mutex/mysys/LOCK_alarm                          | YES     | YES   |
| wait/synch/mutex/mysys/my_thread_var::mutex                | YES     | YES   |
| wait/synch/mutex/mysys/THR_LOCK_charset                    | YES     | YES   |
| wait/synch/mutex/mysys/THR_LOCK_heap                       | YES     | YES   |
| wait/synch/mutex/mysys/THR_LOCK_isam                       | YES     | YES   |
| wait/synch/mutex/mysys/THR_LOCK_lock                       | YES     | YES   |
| wait/synch/mutex/mysys/THR_LOCK_malloc                     | YES     | YES   |
| wait/synch/mutex/mysys/THR_LOCK::mutex                     | YES     | YES   |
| wait/synch/mutex/mysys/THR_LOCK_myisam                     | YES     | YES   |
| wait/synch/mutex/mysys/THR_LOCK_net                        | YES     | YES   |
| wait/synch/mutex/mysys/THR_LOCK_open                       | YES     | YES   |
| wait/synch/mutex/mysys/THR_LOCK_threads                    | YES     | YES   |
| wait/synch/mutex/mysys/TMPDIR_mutex                        | YES     | YES   |
| wait/synch/mutex/mysys/THR_LOCK_myisam_mmap                | YES     | YES   |
| wait/synch/mutex/sql/LOCK_audit_mask                       | YES     | YES   |
| wait/synch/mutex/sql/Cversion_lock                         | YES     | YES   |
| wait/synch/mutex/sql/LOCK_event_queue                      | YES     | YES   |
| wait/synch/mutex/sql/Event_scheduler::LOCK_scheduler_state | YES     | YES   |
| wait/synch/mutex/sql/LOCK_user_locks                       | YES     | YES   |
| wait/synch/mutex/sql/MDL_map::mutex                        | YES     | YES   |
| wait/synch/mutex/sql/MDL_wait::LOCK_wait_status            | YES     | YES   |
| wait/synch/mutex/sql/LOCK_open                             | YES     | YES   |
| wait/synch/mutex/sql/LOCK_slave_list                       | YES     | YES   |
| wait/synch/mutex/sql/LOCK_xid_cache                        | YES     | YES   |
| wait/synch/mutex/sql/LOCK_plugin                           | YES     | YES   |
| wait/synch/mutex/csv/tina                                  | YES     | YES   |
| wait/synch/mutex/csv/TINA_SHARE::mutex                     | YES     | YES   |
| wait/synch/mutex/myisam/MI_SORT_INFO::mutex                | YES     | YES   |
| wait/synch/mutex/myisam/MYISAM_SHARE::intern_lock          | YES     | YES   |
| wait/synch/mutex/myisam/MI_CHECK::print_msg                | YES     | YES   |
| wait/synch/mutex/myisammrg/MYRG_INFO::mutex                | YES     | YES   |
| wait/synch/mutex/memory/HP_SHARE::intern_lock              | YES     | YES   |
| wait/synch/mutex/blackhole/blackhole                       | YES     | YES   |
| wait/synch/mutex/archive/archive_mutex                     | YES     | YES   |
| wait/synch/mutex/archive/ARCHIVE_SHARE::mutex              | YES     | YES   |
| wait/synch/mutex/innodb/commit_threads_m                   | YES     | YES   |
| wait/synch/mutex/innodb/commit_cond_mutex                  | YES     | YES   |
| wait/synch/mutex/innodb/innobase_share_mutex               | YES     | YES   |
| wait/synch/mutex/innodb/prepare_commit_mutex               | YES     | YES   |
| wait/synch/mutex/innodb/autoinc_mutex                      | YES     | YES   |
| wait/synch/mutex/innodb/btr_search_enabled_mutex           | YES     | YES   |
| wait/synch/mutex/innodb/buf_pool_mutex                     | YES     | YES   |
| wait/synch/mutex/innodb/buf_pool_zip_mutex                 | YES     | YES   |
| wait/synch/mutex/innodb/cache_last_read_mutex              | YES     | YES   |
| wait/synch/mutex/innodb/dict_foreign_err_mutex             | YES     | YES   |
| wait/synch/mutex/innodb/dict_sys_mutex                     | YES     | YES   |
| wait/synch/mutex/innodb/file_format_max_mutex              | YES     | YES   |
| wait/synch/mutex/innodb/fil_system_mutex                   | YES     | YES   |
| wait/synch/mutex/innodb/flush_list_mutex                   | YES     | YES   |
| wait/synch/mutex/innodb/log_flush_order_mutex              | YES     | YES   |
| wait/synch/mutex/innodb/hash_table_mutex                   | YES     | YES   |
| wait/synch/mutex/innodb/ibuf_bitmap_mutex                  | YES     | YES   |
| wait/synch/mutex/innodb/ibuf_mutex                         | YES     | YES   |
| wait/synch/mutex/innodb/ibuf_pessimistic_insert_mutex      | YES     | YES   |
| wait/synch/mutex/innodb/kernel_mutex                       | YES     | YES   |
| wait/synch/mutex/innodb/log_sys_mutex                      | YES     | YES   |
| wait/synch/mutex/innodb/mem_pool_mutex                     | YES     | YES   |
| wait/synch/mutex/innodb/mutex_list_mutex                   | YES     | YES   |
| wait/synch/mutex/innodb/purge_sys_bh_mutex                 | YES     | YES   |
| wait/synch/mutex/innodb/recv_sys_mutex                     | YES     | YES   |
| wait/synch/mutex/innodb/rseg_mutex                         | YES     | YES   |
| wait/synch/mutex/innodb/rw_lock_list_mutex                 | YES     | YES   |
| wait/synch/mutex/innodb/rw_lock_mutex                      | YES     | YES   |
| wait/synch/mutex/innodb/srv_dict_tmpfile_mutex             | YES     | YES   |
| wait/synch/mutex/innodb/srv_innodb_monitor_mutex           | YES     | YES   |
| wait/synch/mutex/innodb/srv_misc_tmpfile_mutex             | YES     | YES   |
| wait/synch/mutex/innodb/srv_monitor_file_mutex             | YES     | YES   |
| wait/synch/mutex/innodb/syn_arr_mutex                      | YES     | YES   |
| wait/synch/mutex/innodb/trx_doublewrite_mutex              | YES     | YES   |
| wait/synch/mutex/innodb/trx_undo_mutex                     | YES     | YES   |
| wait/synch/mutex/sql/tz_LOCK                               | YES     | YES   |
| wait/synch/rwlock/sql/CRYPTO_dynlock_value::lock           | YES     | YES   |
| wait/synch/rwlock/sql/LOCK_grant                           | YES     | YES   |
| wait/synch/rwlock/sql/LOGGER::LOCK_logger                  | YES     | YES   |
| wait/synch/rwlock/sql/LOCK_sys_init_connect                | YES     | YES   |
| wait/synch/rwlock/sql/LOCK_sys_init_slave                  | YES     | YES   |
| wait/synch/rwlock/sql/LOCK_system_variables_hash           | YES     | YES   |
| wait/synch/rwlock/sql/Query_cache_query::lock              | YES     | YES   |
| wait/synch/rwlock/sql/LOCK_dboptions                       | YES     | YES   |
| wait/synch/rwlock/sql/MDL_lock::rwlock                     | YES     | YES   |
| wait/synch/rwlock/sql/MDL_context::LOCK_waiting_for        | YES     | YES   |
| wait/synch/rwlock/myisam/MYISAM_SHARE::key_root_lock       | YES     | YES   |
| wait/synch/rwlock/myisam/MYISAM_SHARE::mmap_lock           | YES     | YES   |
| wait/synch/rwlock/innodb/btr_search_latch                  | YES     | YES   |
| wait/synch/rwlock/innodb/dict_operation_lock               | YES     | YES   |
| wait/synch/rwlock/innodb/fil_space_latch                   | YES     | YES   |
| wait/synch/rwlock/innodb/checkpoint_lock                   | YES     | YES   |
| wait/synch/rwlock/innodb/trx_i_s_cache_lock                | YES     | YES   |
| wait/synch/rwlock/innodb/trx_purge_latch                   | YES     | YES   |
| wait/synch/rwlock/innodb/index_tree_rw_lock                | YES     | YES   |
| wait/synch/rwlock/innodb/dict_table_stats                  | YES     | YES   |
| wait/synch/rwlock/sql/THR_LOCK_servers                     | YES     | YES   |
| wait/synch/rwlock/sql/THR_LOCK_udf                         | YES     | YES   |
| wait/synch/cond/sql/PAGE::cond                             | YES     | YES   |
| wait/synch/cond/sql/TC_LOG_MMAP::COND_active               | YES     | YES   |
| wait/synch/cond/sql/TC_LOG_MMAP::COND_pool                 | YES     | YES   |
| wait/synch/cond/sql/MYSQL_BIN_LOG::COND_prep_xids          | YES     | YES   |
| wait/synch/cond/sql/MYSQL_BIN_LOG::update_cond             | YES     | YES   |
| wait/synch/cond/sql/MYSQL_RELAY_LOG::update_cond           | YES     | YES   |
| wait/synch/cond/sql/Query_cache::COND_cache_status_changed | YES     | YES   |
| wait/synch/cond/sql/COND_manager                           | YES     | YES   |
| wait/synch/cond/sql/COND_rpl_status                        | YES     | YES   |
| wait/synch/cond/sql/COND_server_started                    | YES     | YES   |
| wait/synch/cond/sql/Delayed_insert::cond                   | YES     | YES   |
| wait/synch/cond/sql/Delayed_insert::cond_client            | YES     | YES   |
| wait/synch/cond/sql/Item_func_sleep::cond                  | YES     | YES   |
| wait/synch/cond/sql/Master_info::data_cond                 | YES     | YES   |
| wait/synch/cond/sql/Master_info::start_cond                | YES     | YES   |
| wait/synch/cond/sql/Master_info::stop_cond                 | YES     | YES   |
| wait/synch/cond/sql/Master_info::sleep_cond                | YES     | YES   |
| wait/synch/cond/sql/Relay_log_info::data_cond              | YES     | YES   |
| wait/synch/cond/sql/Relay_log_info::log_space_cond         | YES     | YES   |
| wait/synch/cond/sql/Relay_log_info::start_cond             | YES     | YES   |
| wait/synch/cond/sql/Relay_log_info::stop_cond              | YES     | YES   |
| wait/synch/cond/sql/Relay_log_info::sleep_cond             | YES     | YES   |
| wait/synch/cond/sql/TABLE_SHARE::cond                      | YES     | YES   |
| wait/synch/cond/sql/User_level_lock::cond                  | YES     | YES   |
| wait/synch/cond/sql/COND_thread_count                      | YES     | YES   |
| wait/synch/cond/sql/COND_thread_cache                      | YES     | YES   |
| wait/synch/cond/sql/COND_flush_thread_cache                | YES     | YES   |
| wait/synch/cond/mysys/COND_alarm                           | YES     | YES   |
| wait/synch/cond/mysys/IO_CACHE_SHARE::cond                 | YES     | YES   |
| wait/synch/cond/mysys/IO_CACHE_SHARE::cond_writer          | YES     | YES   |
| wait/synch/cond/mysys/my_thread_var::suspend               | YES     | YES   |
| wait/synch/cond/mysys/THR_COND_threads                     | YES     | YES   |
| wait/synch/cond/sql/Event_scheduler::COND_state            | YES     | YES   |
| wait/synch/cond/sql/COND_queue_state                       | YES     | YES   |
| wait/synch/cond/sql/MDL_context::COND_wait_status          | YES     | YES   |
| wait/synch/cond/myisam/MI_SORT_INFO::cond                  | YES     | YES   |
| wait/synch/cond/innodb/commit_cond                         | YES     | YES   |
| wait/io/file/sql/map                                       | YES     | YES   |
| wait/io/file/sql/binlog                                    | YES     | YES   |
| wait/io/file/sql/binlog_index                              | YES     | YES   |
| wait/io/file/sql/relaylog                                  | YES     | YES   |
| wait/io/file/sql/relaylog_index                            | YES     | YES   |
| wait/io/file/sql/casetest                                  | YES     | YES   |
| wait/io/file/sql/dbopt                                     | YES     | YES   |
| wait/io/file/sql/des_key_file                              | YES     | YES   |
| wait/io/file/sql/ERRMSG                                    | YES     | YES   |
| wait/io/file/sql/select_to_file                            | YES     | YES   |
| wait/io/file/sql/file_parser                               | YES     | YES   |
| wait/io/file/sql/FRM                                       | YES     | YES   |
| wait/io/file/sql/global_ddl_log                            | YES     | YES   |
| wait/io/file/sql/load                                      | YES     | YES   |
| wait/io/file/sql/LOAD_FILE                                 | YES     | YES   |
| wait/io/file/sql/log_event_data                            | YES     | YES   |
| wait/io/file/sql/log_event_info                            | YES     | YES   |
| wait/io/file/sql/master_info                               | YES     | YES   |
| wait/io/file/sql/misc                                      | YES     | YES   |
| wait/io/file/sql/partition                                 | YES     | YES   |
| wait/io/file/sql/pid                                       | YES     | YES   |
| wait/io/file/sql/query_log                                 | YES     | YES   |
| wait/io/file/sql/relay_log_info                            | YES     | YES   |
| wait/io/file/sql/send_file                                 | YES     | YES   |
| wait/io/file/sql/slow_log                                  | YES     | YES   |
| wait/io/file/sql/tclog                                     | YES     | YES   |
| wait/io/file/sql/trigger_name                              | YES     | YES   |
| wait/io/file/sql/trigger                                   | YES     | YES   |
| wait/io/file/sql/init                                      | YES     | YES   |
| wait/io/file/mysys/proc_meminfo                            | YES     | YES   |
| wait/io/file/mysys/charset                                 | YES     | YES   |
| wait/io/file/mysys/cnf                                     | YES     | YES   |
| wait/io/file/csv/metadata                                  | YES     | YES   |
| wait/io/file/csv/data                                      | YES     | YES   |
| wait/io/file/csv/update                                    | YES     | YES   |
| wait/io/file/myisam/data_tmp                               | YES     | YES   |
| wait/io/file/myisam/dfile                                  | YES     | YES   |
| wait/io/file/myisam/kfile                                  | YES     | YES   |
| wait/io/file/myisam/log                                    | YES     | YES   |
| wait/io/file/myisammrg/MRG                                 | YES     | YES   |
| wait/io/file/innodb/innodb_data_file                       | YES     | YES   |
| wait/io/file/innodb/innodb_log_file                        | YES     | YES   |
| wait/io/file/innodb/innodb_temp_file                       | YES     | YES   |
+------------------------------------------------------------+---------+-------+

---------------------------------------
PERFORMANCE_SCHEMA setup_timers
+-------------+-----------------+------------------+----------------+
| TIMER_NAME  | TIMER_FREQUENCY | TIMER_RESOLUTION | TIMER_OVERHEAD |
+-------------+-----------------+------------------+----------------+
| CYCLE       |      3349467661 |                1 |           7418 |
| NANOSECOND  |      1000000000 |                1 |          11567 |
| MICROSECOND |         1000000 |                1 |          11520 |
| MILLISECOND |            1041 |                1 |          11770 |
| TICK        |             102 |                1 |           2256 |
+-------------+-----------------+------------------+----------------+
+------+------------+
| NAME | TIMER_NAME |
+------+------------+
| wait | CYCLE      |
+------+------------+

---------------------------------------
InnoDB Engine Mutex List
+--------+----------------+-------------+
| Type   | Name           | Status      |
+--------+----------------+-------------+
| InnoDB | buf0buf.c:1166 | os_waits=44 |
| InnoDB | fil0fil.c:1608 | os_waits=1  |
| InnoDB | log0log.c:832  | os_waits=7  |
+--------+----------------+-------------+

---------------------------------------
Event Waits Summary - All
+-----------------------------------------------+-----------+------------+
| EVENT_NAME                                    | WAIT_MS   | COUNT_STAR |
+-----------------------------------------------+-----------+------------+
| wait/io/file/innodb/innodb_log_file           | 2315.8433 |       1044 |
| wait/io/file/innodb/innodb_log_file           |  177.9255 |          7 |
| wait/synch/rwlock/innodb/checkpoint_lock      |  165.0938 |         12 |
| wait/io/file/innodb/innodb_data_file          |  143.1848 |        150 |
| wait/io/file/innodb/innodb_log_file           |  109.6981 |          3 |
| wait/io/file/innodb/innodb_data_file          |   79.5981 |        197 |
| wait/io/file/sql/FRM                          |   60.8595 |        429 |
| wait/synch/mutex/innodb/mutex_list_mutex      |   44.7356 |      16546 |
| wait/synch/mutex/innodb/rw_lock_list_mutex    |   44.4718 |      16464 |
| wait/synch/mutex/innodb/flush_list_mutex      |   22.6376 |       8395 |
| wait/io/file/myisam/kfile                     |   19.3142 |         71 |
| wait/synch/mutex/innodb/flush_list_mutex      |   17.6950 |       6454 |
| wait/synch/rwlock/innodb/checkpoint_lock      |   13.5572 |          2 |
| wait/synch/mutex/innodb/buf_pool_mutex        |   11.6377 |        188 |
| wait/synch/mutex/innodb/buf_pool_mutex        |   11.3442 |       3829 |
| wait/synch/mutex/innodb/fil_system_mutex      |    6.6077 |       2371 |
| wait/synch/mutex/innodb/buf_pool_mutex        |    3.3445 |        128 |
| wait/synch/mutex/innodb/log_sys_mutex         |    3.0194 |        918 |
| wait/synch/rwlock/innodb/fil_space_latch      |    2.1868 |        756 |
| wait/synch/mutex/innodb/kernel_mutex          |    1.5821 |        458 |
| wait/synch/mutex/innodb/log_sys_mutex         |    1.1328 |        397 |
| wait/io/file/myisam/dfile                     |    1.1081 |         43 |
| wait/synch/mutex/innodb/fil_system_mutex      |    0.9816 |        309 |
| wait/synch/mutex/innodb/fil_system_mutex      |    0.8764 |        188 |
| wait/synch/mutex/innodb/flush_list_mutex      |    0.8683 |        188 |
| wait/synch/mutex/innodb/buf_pool_mutex        |    0.8517 |        292 |
| wait/synch/mutex/sql/LOCK_plugin              |    0.6744 |        230 |
| wait/synch/mutex/innodb/trx_doublewrite_mutex |    0.5484 |        148 |
| wait/synch/mutex/innodb/kernel_mutex          |    0.5033 |        181 |
| wait/synch/mutex/innodb/log_flush_order_mutex |    0.5027 |        195 |
+-----------------------------------------------+-----------+------------+

---------------------------------------
Event Waits Summary - wait/io/file only
+--------------------------------------+-----------+------------+
| EVENT_NAME                           | WAIT_MS   | COUNT_STAR |
+--------------------------------------+-----------+------------+
| wait/io/file/innodb/innodb_log_file  | 2315.8433 |       1044 |
| wait/io/file/innodb/innodb_log_file  |  177.9255 |          7 |
| wait/io/file/innodb/innodb_data_file |  143.1848 |        150 |
| wait/io/file/innodb/innodb_log_file  |  109.6981 |          3 |
| wait/io/file/innodb/innodb_data_file |   79.5981 |        197 |
| wait/io/file/sql/FRM                 |   60.8595 |        429 |
| wait/io/file/myisam/kfile            |   19.3142 |         71 |
| wait/io/file/myisam/dfile            |    1.1081 |         43 |
| wait/io/file/sql/casetest            |    0.1842 |         10 |
| wait/io/file/mysys/charset           |    0.0913 |          3 |
| wait/io/file/sql/ERRMSG              |    0.0677 |          5 |
| wait/io/file/sql/pid                 |    0.0561 |          3 |
| wait/io/file/sql/query_log           |    0.0410 |          4 |
| wait/io/file/sql/query_log           |    0.0341 |          3 |
| wait/io/file/sql/global_ddl_log      |    0.0141 |          2 |
| wait/io/file/myisam/log              |    0.0000 |          0 |
| wait/io/file/mysys/proc_meminfo      |    0.0000 |          0 |
| wait/io/file/mysys/charset           |    0.0000 |          0 |
| wait/io/file/mysys/cnf               |    0.0000 |          0 |
| wait/io/file/csv/metadata            |    0.0000 |          0 |
| wait/io/file/csv/data                |    0.0000 |          0 |
| wait/io/file/csv/update              |    0.0000 |          0 |
| wait/io/file/myisam/data_tmp         |    0.0000 |          0 |
| wait/io/file/myisam/dfile            |    0.0000 |          0 |
| wait/io/file/myisam/kfile            |    0.0000 |          0 |
| wait/io/file/sql/init                |    0.0000 |          0 |
| wait/io/file/sql/query_log           |    0.0000 |          0 |
| wait/io/file/sql/LOAD_FILE           |    0.0000 |          0 |
| wait/io/file/sql/log_event_data      |    0.0000 |          0 |
| wait/io/file/sql/log_event_info      |    0.0000 |          0 |
+--------------------------------------+-----------+------------+

---------------------------------------
Disk I/O + Data
+--------------------------------------+------------+-----------+----------+----------+-----------+------------+---------+-------------+----------+
| event_name                           | count_star | total_sec | min_usec | avg_usec | max_usec  | count_read | read_mb | count_write | write_mb |
+--------------------------------------+------------+-----------+----------+----------+-----------+------------+---------+-------------+----------+
| wait/io/file/innodb/innodb_log_file  |       1054 |      2.60 |     6.19 |  2470.08 | 391703.09 |          0 |    0.00 |        1036 |  1025.52 |
| wait/io/file/innodb/innodb_data_file |        347 |      0.22 |     5.31 |   642.03 |  48549.80 |          0 |    0.00 |         337 |    25.17 |
| wait/io/file/sql/FRM                 |        429 |      0.06 |     1.97 |   141.86 |  47247.03 |        231 |    0.05 |           0 |     0.00 |
| wait/io/file/myisam/kfile            |         71 |      0.02 |     3.76 |   272.03 |  12662.12 |         32 |    0.01 |           0 |     0.00 |
| wait/io/file/sql/query_log           |        175 |      0.01 |     0.00 |    67.58 |   9198.93 |          0 |    0.00 |         172 |     0.01 |
| wait/io/file/myisam/dfile            |         43 |      0.00 |     3.35 |    25.77 |    296.90 |          3 |    0.00 |           0 |     0.00 |
| wait/io/file/sql/casetest            |         10 |      0.00 |     4.99 |    18.42 |     64.08 |          0 |    0.00 |           0 |     0.00 |
| wait/io/file/sql/dbopt               |         16 |      0.00 |     3.33 |    10.18 |     56.85 |          0 |    0.00 |           0 |     0.00 |
| wait/io/file/mysys/charset           |          3 |      0.00 |    10.78 |    30.43 |     67.14 |          1 |    0.02 |           0 |     0.00 |
| wait/io/file/sql/ERRMSG              |          5 |      0.00 |     4.56 |    13.53 |     24.75 |          3 |    0.04 |           0 |     0.00 |
| wait/io/file/sql/pid                 |          3 |      0.00 |    11.54 |    18.70 |     29.38 |          0 |    0.00 |           1 |     0.00 |
| wait/io/file/sql/global_ddl_log      |          2 |      0.00 |     5.36 |     7.03 |      8.70 |          0 |    0.00 |           0 |     0.00 |
| wait/io/file/sql/trigger_name        |          0 |      0.00 |     0.00 |     0.00 |      0.00 |          0 |    0.00 |           0 |     0.00 |
| wait/io/file/sql/log_event_data      |          0 |      0.00 |     0.00 |     0.00 |      0.00 |          0 |    0.00 |           0 |     0.00 |
| wait/io/file/sql/relaylog_index      |          0 |      0.00 |     0.00 |     0.00 |      0.00 |          0 |    0.00 |           0 |     0.00 |
| wait/io/file/sql/tclog               |          0 |      0.00 |     0.00 |     0.00 |      0.00 |          0 |    0.00 |           0 |     0.00 |
| wait/io/file/sql/LOAD_FILE           |          0 |      0.00 |     0.00 |     0.00 |      0.00 |          0 |    0.00 |           0 |     0.00 |
| wait/io/file/myisam/data_tmp         |          0 |      0.00 |     0.00 |     0.00 |      0.00 |          0 |    0.00 |           0 |     0.00 |
| wait/io/file/sql/relaylog            |          0 |      0.00 |     0.00 |     0.00 |      0.00 |          0 |    0.00 |           0 |     0.00 |
| wait/io/file/sql/slow_log            |          0 |      0.00 |     0.00 |     0.00 |      0.00 |          0 |    0.00 |           0 |     0.00 |
+--------------------------------------+------------+-----------+----------+----------+-----------+------------+---------+-------------+----------+

---------------------------------------
Current Event Waits
+-----------+----------+------------------------------------------+----------------+------------+-------+---------------+-------------+-------------+------------------+-----------+-----------------+
| THREAD_ID | EVENT_ID | EVENT_NAME                               | SOURCE         | TIMER_WAIT | SPINS | OBJECT_SCHEMA | OBJECT_NAME | OBJECT_TYPE | NESTING_EVENT_ID | OPERATION | NUMBER_OF_BYTES |
+-----------+----------+------------------------------------------+----------------+------------+-------+---------------+-------------+-------------+------------------+-----------+-----------------+
|        11 |        7 | wait/synch/mutex/sql/LOCK_thread_count   | mysqld.cc:2724 |    2621931 |  NULL | NULL          | NULL        | NULL        |             NULL | lock      |            NULL |
|        56 |       30 | wait/synch/mutex/mysys/THR_LOCK::mutex   | thr_lock.c:550 |    2664987 |  NULL | NULL          | NULL        | NULL        |             NULL | lock      |            NULL |
|         2 |       35 | wait/synch/mutex/innodb/log_sys_mutex    | log0log.c:1696 |    2505022 |  NULL | NULL          | NULL        | NULL        |             NULL | lock      |            NULL |
|         6 |      384 | wait/synch/mutex/innodb/flush_list_mutex | buf0flu.c:512  |    2542098 |  NULL | NULL          | NULL        | NULL        |             NULL | lock      |            NULL |
|         7 |      458 | wait/synch/mutex/innodb/kernel_mutex     | srv0srv.c:2291 |    2830932 |  NULL | NULL          | NULL        | NULL        |             NULL | lock      |            NULL |
|         5 |      564 | wait/synch/mutex/innodb/flush_list_mutex | buf0flu.c:512  |    2480205 |  NULL | NULL          | NULL        | NULL        |             NULL | lock      |            NULL |
|         8 |      926 | wait/synch/mutex/innodb/log_sys_mutex    | log0log.ic:405 |    2533128 |  NULL | NULL          | NULL        | NULL        |             NULL | lock      |            NULL |
|        10 |     9482 | wait/synch/mutex/innodb/kernel_mutex     | srv0srv.c:3127 |    2499939 |  NULL | NULL          | NULL        | NULL        |             NULL | lock      |            NULL |
|         0 |    50223 | wait/synch/mutex/sql/LOCK_thread_count   | mysqld.cc:5080 |    2605187 |  NULL | NULL          | NULL        | NULL        |             NULL | lock      |            NULL |
+-----------+----------+------------------------------------------+----------------+------------+-------+---------------+-------------+-------------+------------------+-----------+-----------------+

---------------------------------------
Event Waits History
+-----------+----------+---------------------------------------------------------+--------------------+-------------+-------+---------------+----------------------------+-------------+------------------+------------+-----------------+
| THREAD_ID | EVENT_ID | EVENT_NAME                                              | SOURCE             | TIMER_WAIT  | SPINS | OBJECT_SCHEMA | OBJECT_NAME                | OBJECT_TYPE | NESTING_EVENT_ID | OPERATION  | NUMBER_OF_BYTES |
+-----------+----------+---------------------------------------------------------+--------------------+-------------+-------+---------------+----------------------------+-------------+------------------+------------+-----------------+
|        11 |        1 | wait/synch/mutex/mysys/THR_LOCK_threads                 | my_thr_init.c:347  |     2927210 |  NULL | NULL          | NULL                       | NULL        |             NULL | lock       |            NULL |
|        11 |        2 | wait/io/file/sql/pid                                    | mysqld.cc:7687     |    29375554 |  NULL | NULL          | /var/run/mysqld/mysqld.pid | FILE        |             NULL | create     |            NULL |
|        11 |        3 | wait/synch/mutex/mysys/THR_LOCK_open                    | my_open.c:137      |     3007043 |  NULL | NULL          | NULL                       | NULL        |             NULL | lock       |            NULL |
|        11 |        4 | wait/io/file/sql/pid                                    | mysqld.cc:7693     |    15188901 |  NULL | NULL          | /var/run/mysqld/mysqld.pid | FILE        |             NULL | write      |               6 |
|        11 |        5 | wait/io/file/sql/pid                                    | mysqld.cc:7695     |    11539606 |  NULL | NULL          | /var/run/mysqld/mysqld.pid | FILE        |             NULL | close      |            NULL |
|        11 |        6 | wait/synch/mutex/mysys/THR_LOCK_open                    | my_open.c:73       |     2614157 |  NULL | NULL          | NULL                       | NULL        |             NULL | lock       |            NULL |
|        11 |        7 | wait/synch/mutex/sql/LOCK_thread_count                  | mysqld.cc:2724     |     2621931 |  NULL | NULL          | NULL                       | NULL        |             NULL | lock       |            NULL |
|        57 |       21 | wait/synch/mutex/sql/LOG::LOCK_log                      | log.cc:2567        |     2625220 |  NULL | NULL          | NULL                       | NULL        |             NULL | lock       |            NULL |
|        57 |       22 | wait/io/file/sql/query_log                              | mf_iocache.c:1776  |     9295611 |  NULL | NULL          | /var/log/mysql_general.log | FILE        |             NULL | write      |             222 |
|        57 |       23 | wait/synch/mutex/sql/Query_cache::structure_guard_mutex | sql_cache.cc:457   |     2511002 |  NULL | NULL          | NULL                       | NULL        |             NULL | lock       |            NULL |
|        57 |       24 | wait/synch/mutex/sql/Query_cache::structure_guard_mutex | sql_cache.cc:576   |     2769039 |  NULL | NULL          | NULL                       | NULL        |             NULL | lock       |            NULL |
|        57 |       25 | wait/synch/rwlock/sql/LOCK_grant                        | sql_acl.cc:4531    |     2809105 |  NULL | NULL          | NULL                       | NULL        |             NULL | read_lock  |            NULL |
|        57 |       26 | wait/synch/mutex/sql/MDL_map::mutex                     | mdl.cc:694         |     2708043 |  NULL | NULL          | NULL                       | NULL        |             NULL | lock       |            NULL |
|         2 |       26 | wait/synch/mutex/innodb/fil_system_mutex                | fil0fil.c:4582     |     2743923 |  NULL | NULL          | NULL                       | NULL        |             NULL | lock       |            NULL |
|        57 |       27 | wait/synch/rwlock/sql/MDL_lock::rwlock                  | mdl.cc:781         |     2817178 |  NULL | NULL          | NULL                       | NULL        |             NULL | write_lock |            NULL |
|         2 |       27 | wait/synch/mutex/innodb/fil_system_mutex                | fil0fil.c:4621     |     2528942 |  NULL | NULL          | NULL                       | NULL        |             NULL | lock       |            NULL |
|        57 |       28 | wait/synch/mutex/sql/LOCK_open                          | sql_base.cc:2945   |     2603991 |  NULL | NULL          | NULL                       | NULL        |             NULL | lock       |            NULL |
|         2 |       28 | wait/io/file/innodb/innodb_log_file                     | fil0fil.c:4685     | 41184904046 |  NULL | NULL          | /var/lib/mysql/ib_logfile0 | FILE        |             NULL | sync       |            NULL |
|        57 |       29 | wait/synch/mutex/sql/THD::LOCK_thd_data                 | sql_class.h:2782   |     2615951 |  NULL | NULL          | NULL                       | NULL        |             NULL | lock       |            NULL |
|         2 |       29 | wait/synch/mutex/innodb/fil_system_mutex                | fil0fil.c:4687     |     2557945 |  NULL | NULL          | NULL                       | NULL        |             NULL | lock       |            NULL |
|        57 |       30 | wait/synch/mutex/mysys/THR_LOCK::mutex                  | thr_lock.c:550     |     2699073 |  NULL | NULL          | NULL                       | NULL        |             NULL | lock       |            NULL |
|         2 |       30 | wait/synch/mutex/innodb/log_sys_mutex                   | log0log.c:1696     |     2506816 |  NULL | NULL          | NULL                       | NULL        |             NULL | lock       |            NULL |
|         2 |       31 | wait/synch/mutex/innodb/fil_system_mutex                | fil0fil.c:4582     |     2676050 |  NULL | NULL          | NULL                       | NULL        |             NULL | lock       |            NULL |
|         2 |       32 | wait/synch/mutex/innodb/fil_system_mutex                | fil0fil.c:4621     |     2541201 |  NULL | NULL          | NULL                       | NULL        |             NULL | lock       |            NULL |
|         2 |       33 | wait/io/file/innodb/innodb_log_file                     | fil0fil.c:4685     | 13483260882 |  NULL | NULL          | /var/lib/mysql/ib_logfile0 | FILE        |             NULL | sync       |            NULL |
|         2 |       34 | wait/synch/mutex/innodb/fil_system_mutex                | fil0fil.c:4687     |     2533128 |  NULL | NULL          | NULL                       | NULL        |             NULL | lock       |            NULL |
|         2 |       35 | wait/synch/mutex/innodb/log_sys_mutex                   | log0log.c:1696     |     2505022 |  NULL | NULL          | NULL                       | NULL        |             NULL | lock       |            NULL |
|         6 |      375 | wait/synch/mutex/innodb/flush_list_mutex                | buf0flu.c:512      |     2490969 |  NULL | NULL          | NULL                       | NULL        |             NULL | lock       |            NULL |
|         6 |      376 | wait/synch/mutex/innodb/fil_system_mutex                | fil0fil.c:4582     |     2510105 |  NULL | NULL          | NULL                       | NULL        |             NULL | lock       |            NULL |
|         6 |      377 | wait/synch/mutex/innodb/buf_pool_mutex                  | buf0buf.c:3627     |     2480803 |  NULL | NULL          | NULL                       | NULL        |             NULL | lock       |            NULL |
|         6 |      378 | wait/synch/mutex/innodb/flush_list_mutex                | buf0flu.c:512      |     2481999 |  NULL | NULL          | NULL                       | NULL        |             NULL | lock       |            NULL |
|         6 |      379 | wait/synch/mutex/innodb/fil_system_mutex                | fil0fil.c:4582     |     2503826 |  NULL | NULL          | NULL                       | NULL        |             NULL | lock       |            NULL |
|         6 |      380 | wait/synch/mutex/innodb/buf_pool_mutex                  | buf0buf.c:3627     |     2480803 |  NULL | NULL          | NULL                       | NULL        |             NULL | lock       |            NULL |
|         6 |      381 | wait/synch/mutex/innodb/flush_list_mutex                | buf0flu.c:512      |     2484989 |  NULL | NULL          | NULL                       | NULL        |             NULL | lock       |            NULL |
|         6 |      382 | wait/synch/mutex/innodb/fil_system_mutex                | fil0fil.c:4582     |     2511002 |  NULL | NULL          | NULL                       | NULL        |             NULL | lock       |            NULL |
|         6 |      383 | wait/synch/mutex/innodb/buf_pool_mutex                  | buf0buf.c:3627     |     2482896 |  NULL | NULL          | NULL                       | NULL        |             NULL | lock       |            NULL |
|         6 |      384 | wait/synch/mutex/innodb/flush_list_mutex                | buf0flu.c:512      |     2542098 |  NULL | NULL          | NULL                       | NULL        |             NULL | lock       |            NULL |
|         7 |      449 | wait/synch/mutex/innodb/kernel_mutex                    | srv0srv.c:2291     |     2682030 |  NULL | NULL          | NULL                       | NULL        |             NULL | lock       |            NULL |
|         7 |      450 | wait/synch/mutex/innodb/kernel_mutex                    | srv0srv.c:2291     |     2664090 |  NULL | NULL          | NULL                       | NULL        |             NULL | lock       |            NULL |
|         7 |      451 | wait/synch/mutex/innodb/kernel_mutex                    | srv0srv.c:2291     |     2716116 |  NULL | NULL          | NULL                       | NULL        |             NULL | lock       |            NULL |
|         7 |      452 | wait/synch/mutex/innodb/kernel_mutex                    | srv0srv.c:2291     |     2650037 |  NULL | NULL          | NULL                       | NULL        |             NULL | lock       |            NULL |
|         7 |      453 | wait/synch/mutex/innodb/kernel_mutex                    | srv0srv.c:2291     |     2667080 |  NULL | NULL          | NULL                       | NULL        |             NULL | lock       |            NULL |
|         7 |      454 | wait/synch/mutex/innodb/kernel_mutex                    | srv0srv.c:2291     |     2673060 |  NULL | NULL          | NULL                       | NULL        |             NULL | lock       |            NULL |
|         7 |      455 | wait/synch/mutex/innodb/kernel_mutex                    | srv0srv.c:2291     |     2774122 |  NULL | NULL          | NULL                       | NULL        |             NULL | lock       |            NULL |
|         7 |      456 | wait/synch/mutex/innodb/kernel_mutex                    | srv0srv.c:2291     |     2824952 |  NULL | NULL          | NULL                       | NULL        |             NULL | lock       |            NULL |
|         7 |      457 | wait/synch/mutex/innodb/kernel_mutex                    | srv0srv.c:2291     |     2635984 |  NULL | NULL          | NULL                       | NULL        |             NULL | lock       |            NULL |
|         7 |      458 | wait/synch/mutex/innodb/kernel_mutex                    | srv0srv.c:2291     |     2830932 |  NULL | NULL          | NULL                       | NULL        |             NULL | lock       |            NULL |
|         5 |      555 | wait/synch/mutex/innodb/flush_list_mutex                | buf0flu.c:512      |     2482896 |  NULL | NULL          | NULL                       | NULL        |             NULL | lock       |            NULL |
|         5 |      556 | wait/synch/mutex/innodb/fil_system_mutex                | fil0fil.c:4582     |     2490072 |  NULL | NULL          | NULL                       | NULL        |             NULL | lock       |            NULL |
|         5 |      557 | wait/synch/mutex/innodb/buf_pool_mutex                  | buf0buf.c:3627     |     2491866 |  NULL | NULL          | NULL                       | NULL        |             NULL | lock       |            NULL |
|         5 |      558 | wait/synch/mutex/innodb/flush_list_mutex                | buf0flu.c:512      |     2487979 |  NULL | NULL          | NULL                       | NULL        |             NULL | lock       |            NULL |
|         5 |      559 | wait/synch/mutex/innodb/fil_system_mutex                | fil0fil.c:4582     |     2497846 |  NULL | NULL          | NULL                       | NULL        |             NULL | lock       |            NULL |
|         5 |      560 | wait/synch/mutex/innodb/buf_pool_mutex                  | buf0buf.c:3627     |     2484989 |  NULL | NULL          | NULL                       | NULL        |             NULL | lock       |            NULL |
|         5 |      561 | wait/synch/mutex/innodb/flush_list_mutex                | buf0flu.c:512      |     2467049 |  NULL | NULL          | NULL                       | NULL        |             NULL | lock       |            NULL |
|         5 |      562 | wait/synch/mutex/innodb/fil_system_mutex                | fil0fil.c:4582     |     2517879 |  NULL | NULL          | NULL                       | NULL        |             NULL | lock       |            NULL |
|         5 |      563 | wait/synch/mutex/innodb/buf_pool_mutex                  | buf0buf.c:3627     |     2476916 |  NULL | NULL          | NULL                       | NULL        |             NULL | lock       |            NULL |
|         5 |      564 | wait/synch/mutex/innodb/flush_list_mutex                | buf0flu.c:512      |     2480205 |  NULL | NULL          | NULL                       | NULL        |             NULL | lock       |            NULL |
|         8 |      917 | wait/synch/mutex/innodb/log_sys_mutex                   | log0log.ic:405     |     2682030 |  NULL | NULL          | NULL                       | NULL        |             NULL | lock       |            NULL |
|         8 |      918 | wait/synch/mutex/innodb/log_sys_mutex                   | log0log.ic:405     |     2502929 |  NULL | NULL          | NULL                       | NULL        |             NULL | lock       |            NULL |
|         8 |      919 | wait/synch/mutex/innodb/log_sys_mutex                   | log0log.ic:405     |     2659904 |  NULL | NULL          | NULL                       | NULL        |             NULL | lock       |            NULL |
|         8 |      920 | wait/synch/mutex/innodb/log_sys_mutex                   | log0log.ic:405     |     2525952 |  NULL | NULL          | NULL                       | NULL        |             NULL | lock       |            NULL |
|         8 |      921 | wait/synch/mutex/innodb/log_sys_mutex                   | log0log.ic:405     |     2597114 |  NULL | NULL          | NULL                       | NULL        |             NULL | lock       |            NULL |
|         8 |      922 | wait/synch/mutex/innodb/log_sys_mutex                   | log0log.ic:405     |     2500836 |  NULL | NULL          | NULL                       | NULL        |             NULL | lock       |            NULL |
|         8 |      923 | wait/synch/mutex/innodb/log_sys_mutex                   | log0log.ic:405     |     2618044 |  NULL | NULL          | NULL                       | NULL        |             NULL | lock       |            NULL |
|         8 |      924 | wait/synch/mutex/innodb/log_sys_mutex                   | log0log.ic:405     |     2503826 |  NULL | NULL          | NULL                       | NULL        |             NULL | lock       |            NULL |
|         8 |      925 | wait/synch/mutex/innodb/log_sys_mutex                   | log0log.ic:405     |     2638077 |  NULL | NULL          | NULL                       | NULL        |             NULL | lock       |            NULL |
|         8 |      926 | wait/synch/mutex/innodb/log_sys_mutex                   | log0log.ic:405     |     2533128 |  NULL | NULL          | NULL                       | NULL        |             NULL | lock       |            NULL |
|        10 |     9473 | wait/synch/mutex/innodb/trx_doublewrite_mutex           | buf0flu.c:715      |     2495753 |  NULL | NULL          | NULL                       | NULL        |             NULL | lock       |            NULL |
|        10 |     9474 | wait/synch/mutex/innodb/kernel_mutex                    | srv0srv.c:3048     |     2526849 |  NULL | NULL          | NULL                       | NULL        |             NULL | lock       |            NULL |
|        10 |     9475 | wait/synch/mutex/innodb/fil_system_mutex                | fil0fil.c:4735     |     2496052 |  NULL | NULL          | NULL                       | NULL        |             NULL | lock       |            NULL |
|        10 |     9476 | wait/synch/mutex/innodb/log_sys_mutex                   | log0log.c:1990     |     2505919 |  NULL | NULL          | NULL                       | NULL        |             NULL | lock       |            NULL |
|        10 |     9477 | wait/synch/mutex/innodb/log_flush_order_mutex           | buf0buf.c:323      |     2508012 |  NULL | NULL          | NULL                       | NULL        |             NULL | lock       |            NULL |
|        10 |     9478 | wait/synch/mutex/innodb/flush_list_mutex                | buf0buf.c:330      |     2490072 |  NULL | NULL          | NULL                       | NULL        |             NULL | lock       |            NULL |
|        10 |     9479 | wait/synch/mutex/innodb/log_sys_mutex                   | log0log.c:1377     |     2503228 |  NULL | NULL          | NULL                       | NULL        |             NULL | lock       |            NULL |
|        10 |     9480 | wait/synch/mutex/innodb/log_sys_mutex                   | log0log.c:2007     |     2508012 |  NULL | NULL          | NULL                       | NULL        |             NULL | lock       |            NULL |
|        10 |     9481 | wait/synch/mutex/innodb/kernel_mutex                    | srv0srv.c:3075     |     2493959 |  NULL | NULL          | NULL                       | NULL        |             NULL | lock       |            NULL |
|        10 |     9482 | wait/synch/mutex/innodb/kernel_mutex                    | srv0srv.c:3127     |     2499939 |  NULL | NULL          | NULL                       | NULL        |             NULL | lock       |            NULL |
|         0 |    50219 | wait/synch/mutex/sql/LOCK_global_system_variables       | sql_class.cc:1168  |     3174483 |  NULL | NULL          | NULL                       | NULL        |             NULL | lock       |            NULL |
|         0 |    50220 | wait/synch/mutex/sql/LOCK_plugin                        | sql_plugin.cc:2658 |     2635087 |  NULL | NULL          | NULL                       | NULL        |             NULL | lock       |            NULL |
|         0 |    50221 | wait/synch/mutex/sql/LOCK_thread_count                  | mysqld.h:476       |     2675153 |  NULL | NULL          | NULL                       | NULL        |             NULL | lock       |            NULL |
|         0 |    50222 | wait/synch/mutex/sql/LOCK_connection_count              | mysqld.cc:5059     |     2780102 |  NULL | NULL          | NULL                       | NULL        |             NULL | lock       |            NULL |
|         0 |    50223 | wait/synch/mutex/sql/LOCK_thread_count                  | mysqld.cc:5080     |     2605187 |  NULL | NULL          | NULL                       | NULL        |             NULL | lock       |            NULL |
|         0 |    50224 | wait/synch/mutex/sql/LOCK_global_system_variables       | sql_class.cc:1168  |     3229499 |  NULL | NULL          | NULL                       | NULL        |             NULL | lock       |            NULL |
|         0 |    50225 | wait/synch/mutex/sql/LOCK_plugin                        | sql_plugin.cc:2658 |     2646150 |  NULL | NULL          | NULL                       | NULL        |             NULL | lock       |            NULL |
|         0 |    50226 | wait/synch/mutex/sql/LOCK_thread_count                  | mysqld.h:476       |     2691000 |  NULL | NULL          | NULL                       | NULL        |             NULL | lock       |            NULL |
|         0 |    50227 | wait/synch/mutex/sql/LOCK_connection_count              | mysqld.cc:5059     |     2760966 |  NULL | NULL          | NULL                       | NULL        |             NULL | lock       |            NULL |
|         0 |    50228 | wait/synch/mutex/sql/LOCK_thread_count                  | mysqld.cc:5080     |     2630004 |  NULL | NULL          | NULL                       | NULL        |             NULL | lock       |            NULL |
+-----------+----------+---------------------------------------------------------+--------------------+-------------+-------+---------------+----------------------------+-------------+------------------+------------+-----------------+