Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-16999

events_waits_summary_global_by_event_name + MYSQL_RELAY_LOG::update_cond

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Incomplete
    • 10.2.16
    • N/A
    • Server
    • Debian 9.6

    Description

      I was put back this in PmaControl and look it's don't work anymore : http://www.markleith.co.uk/2012/07/24/a-mysql-replication-load-average-with-performance-schema/

      look it's not working anymore in 10.1~3 (was working well in 10.0)

      this line stay definitvely empty :

      MariaDB [performance_schema]> select * from performance_schema.events_waits_summary_global_by_event_name  WHERE EVENT_NAME = 'wait/synch/cond/sql/MYSQL_RELAY_LOG::update_cond';
      +--------------------------------------------------+------------+----------------+----------------+----------------+----------------+
      | EVENT_NAME                                       | COUNT_STAR | SUM_TIMER_WAIT | MIN_TIMER_WAIT | AVG_TIMER_WAIT | MAX_TIMER_WAIT |
      +--------------------------------------------------+------------+----------------+----------------+----------------+----------------+
      | wait/synch/cond/sql/MYSQL_RELAY_LOG::update_cond |          0 |              0 |              0 |              0 |              0 |
      +--------------------------------------------------+------------+----------------+----------------+----------------+----------------+
      

      About my config I was not sure anymore so i activated all :

      MariaDB [performance_schema]> select * from setup_consumers;
      +--------------------------------+---------+
      | NAME                           | ENABLED |
      +--------------------------------+---------+
      | events_stages_current          | YES     |
      | events_stages_history          | YES     |
      | events_stages_history_long     | YES     |
      | events_statements_current      | YES     |
      | events_statements_history      | YES     |
      | events_statements_history_long | YES     |
      | events_waits_current           | YES     |
      | events_waits_history           | YES     |
      | events_waits_history_long      | YES     |
      | global_instrumentation         | YES     |
      | thread_instrumentation         | YES     |
      | statements_digest              | YES     |
      +--------------------------------+---------+
      12 rows in set (0.00 sec)
       
      MariaDB [performance_schema]> select * from 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/TC_LOG_MMAP::LOCK_pending_checkpoint                                             | 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_xid_list                                                     | YES     | YES   |
      | wait/synch/mutex/sql/MYSQL_BIN_LOG::LOCK_binlog_background_thread                                     | YES     | YES   |
      | wait/synch/mutex/sql/MYSQL_BIN_LOG::LOCK_binlog_end_pos                                               | 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_thread_id                                                                   | 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_show_status                                                                 | YES     | YES   |
      | wait/synch/mutex/sql/LOCK_system_variables_hash                                                       | YES     | YES   |
      | wait/synch/mutex/sql/LOCK_stats                                                                       | YES     | YES   |
      | wait/synch/mutex/sql/LOCK_global_user_client_stats                                                    | YES     | YES   |
      | wait/synch/mutex/sql/LOCK_global_table_stats                                                          | YES     | YES   |
      | wait/synch/mutex/sql/LOCK_global_index_stats                                                          | YES     | YES   |
      | wait/synch/mutex/sql/THD::LOCK_wakeup_ready                                                           | YES     | YES   |
      | wait/synch/mutex/sql/wait_for_commit::LOCK_wait_commit                                                | YES     | YES   |
      | wait/synch/mutex/sql/gtid_waiting::LOCK_gtid_waiting                                                  | YES     | YES   |
      | wait/synch/mutex/sql/THD::LOCK_thd_data                                                               | YES     | YES   |
      | wait/synch/mutex/sql/THD::LOCK_thd_kill                                                               | YES     | YES   |
      | wait/synch/mutex/sql/LOCK_user_conn                                                                   | YES     | YES   |
      | wait/synch/mutex/sql/LOCK_uuid_short_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::start_stop_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/Rpl_group_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/TABLE_SHARE::LOCK_share                                                          | YES     | YES   |
      | wait/synch/mutex/sql/LOCK_error_messages                                                              | YES     | YES   |
      | wait/synch/mutex/sql/LOCK_prepare_ordered                                                             | YES     | YES   |
      | wait/synch/mutex/sql/LOCK_after_binlog_sync                                                           | YES     | YES   |
      | wait/synch/mutex/sql/LOCK_commit_ordered                                                              | YES     | YES   |
      | wait/synch/mutex/sql/LOCK_slave_background                                                            | YES     | YES   |
      | wait/synch/mutex/sql/LOG_INFO::lock                                                                   | YES     | YES   |
      | wait/synch/mutex/sql/LOCK_thread_count                                                                | YES     | YES   |
      | wait/synch/mutex/sql/LOCK_thread_cache                                                                | YES     | YES   |
      | wait/synch/mutex/sql/HA_DATA_PARTITION::LOCK_auto_inc                                                 | YES     | YES   |
      | wait/synch/mutex/sql/LOCK_slave_state                                                                 | YES     | YES   |
      | wait/synch/mutex/sql/LOCK_start_thread                                                                | YES     | YES   |
      | wait/synch/mutex/sql/LOCK_binlog_state                                                                | YES     | YES   |
      | wait/synch/mutex/sql/LOCK_rpl_thread                                                                  | YES     | YES   |
      | wait/synch/mutex/sql/LOCK_rpl_thread_pool                                                             | YES     | YES   |
      | wait/synch/mutex/sql/LOCK_parallel_entry                                                              | 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/LOCK_timer                                                                     | 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_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/mysys/LOCK_uuid_generator                                                            | 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_wait::LOCK_wait_status                                                       | YES     | YES   |
      | wait/synch/mutex/sql/LOCK_unused_shares                                                               | YES     | YES   |
      | wait/synch/mutex/sql/TABLE_SHARE::tdc.LOCK_table_share                                                | YES     | YES   |
      | wait/synch/mutex/sql/LOCK_table_cache                                                                 | YES     | YES   |
      | wait/synch/mutex/sql/LOCK_slave_list                                                                  | YES     | YES   |
      | wait/synch/mutex/sql/LOCK_plugin                                                                      | YES     | YES   |
      | wait/synch/mutex/sql/LOCK_wsrep_ready                                                                 | YES     | YES   |
      | wait/synch/mutex/sql/LOCK_wsrep_sst                                                                   | YES     | YES   |
      | wait/synch/mutex/sql/wsrep_sst_thread                                                                 | YES     | YES   |
      | wait/synch/mutex/sql/LOCK_wsrep_sst_init                                                              | YES     | YES   |
      | wait/synch/mutex/sql/LOCK_wsrep_rollback                                                              | YES     | YES   |
      | wait/synch/mutex/sql/LOCK_wsrep_replaying                                                             | YES     | YES   |
      | wait/synch/mutex/sql/LOCK_wsrep_slave_threads                                                         | YES     | YES   |
      | wait/synch/mutex/sql/LOCK_wsrep_desync                                                                | YES     | YES   |
      | wait/synch/mutex/sql/LOCK_wsrep_config_state                                                          | 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/csv/tina                                                                             | YES     | YES   |
      | wait/synch/mutex/csv/TINA_SHARE::mutex                                                                | YES     | YES   |
      | wait/synch/mutex/partition/Partition_share::auto_inc_mutex                                            | YES     | YES   |
      | wait/synch/mutex/memory/HP_SHARE::intern_lock                                                         | YES     | YES   |
      | wait/synch/mutex/innodb/commit_cond_mutex                                                             | YES     | YES   |
      | wait/synch/mutex/innodb/pending_checkpoint_mutex                                                      | YES     | YES   |
      | wait/synch/mutex/innodb/innobase_share_mutex                                                          | YES     | YES   |
      | wait/synch/mutex/innodb/autoinc_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/recalc_pool_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/fts_bg_threads_mutex                                                          | YES     | YES   |
      | wait/synch/mutex/innodb/fts_delete_mutex                                                              | YES     | YES   |
      | wait/synch/mutex/innodb/fts_optimize_mutex                                                            | YES     | YES   |
      | wait/synch/mutex/innodb/fts_doc_id_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/log_sys_mutex                                                                 | YES     | YES   |
      | wait/synch/mutex/innodb/log_sys_write_mutex                                                           | YES     | YES   |
      | wait/synch/mutex/innodb/mutex_list_mutex                                                              | YES     | YES   |
      | wait/synch/mutex/innodb/page_zip_stat_per_index_mutex                                                 | YES     | YES   |
      | wait/synch/mutex/innodb/purge_sys_pq_mutex                                                            | YES     | YES   |
      | wait/synch/mutex/innodb/recv_sys_mutex                                                                | YES     | YES   |
      | wait/synch/mutex/innodb/recv_writer_mutex                                                             | YES     | YES   |
      | wait/synch/mutex/innodb/redo_rseg_mutex                                                               | YES     | YES   |
      | wait/synch/mutex/innodb/noredo_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_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/buf_dblwr_mutex                                                               | YES     | YES   |
      | wait/synch/mutex/innodb/trx_undo_mutex                                                                | YES     | YES   |
      | wait/synch/mutex/innodb/trx_pool_mutex                                                                | YES     | YES   |
      | wait/synch/mutex/innodb/trx_pool_manager_mutex                                                        | YES     | YES   |
      | wait/synch/mutex/innodb/srv_sys_mutex                                                                 | YES     | YES   |
      | wait/synch/mutex/innodb/lock_mutex                                                                    | YES     | YES   |
      | wait/synch/mutex/innodb/lock_wait_mutex                                                               | YES     | YES   |
      | wait/synch/mutex/innodb/trx_mutex                                                                     | YES     | YES   |
      | wait/synch/mutex/innodb/srv_threads_mutex                                                             | YES     | YES   |
      | wait/synch/mutex/innodb/rtr_active_mutex                                                              | YES     | YES   |
      | wait/synch/mutex/innodb/rtr_match_mutex                                                               | YES     | YES   |
      | wait/synch/mutex/innodb/rtr_path_mutex                                                                | YES     | YES   |
      | wait/synch/mutex/innodb/rtr_ssn_mutex                                                                 | YES     | YES   |
      | wait/synch/mutex/innodb/trx_sys_mutex                                                                 | YES     | YES   |
      | wait/synch/mutex/innodb/zip_pad_mutex                                                                 | YES     | YES   |
      | wait/synch/mutex/aria/THR_LOCK_maria                                                                  | YES     | YES   |
      | wait/synch/mutex/aria/LOCK_soft_sync                                                                  | YES     | YES   |
      | wait/synch/mutex/aria/LOCK_trn_list                                                                   | YES     | YES   |
      | wait/synch/mutex/aria/SHARE::bitmap::bitmap_lock                                                      | YES     | YES   |
      | wait/synch/mutex/aria/SORT_INFO::mutex                                                                | YES     | YES   |
      | wait/synch/mutex/aria/TRANSLOG_BUFFER::mutex                                                          | YES     | YES   |
      | wait/synch/mutex/aria/TRANSLOG_DESCRIPTOR::dirty_buffer_mask_lock                                     | YES     | YES   |
      | wait/synch/mutex/aria/TRANSLOG_DESCRIPTOR::sent_to_disk_lock                                          | YES     | YES   |
      | wait/synch/mutex/aria/TRANSLOG_DESCRIPTOR::log_flush_lock                                             | YES     | YES   |
      | wait/synch/mutex/aria/TRANSLOG_DESCRIPTOR::file_header_lock                                           | YES     | YES   |
      | wait/synch/mutex/aria/TRANSLOG_DESCRIPTOR::unfinished_files_lock                                      | YES     | YES   |
      | wait/synch/mutex/aria/TRANSLOG_DESCRIPTOR::purger_lock                                                | YES     | YES   |
      | wait/synch/mutex/aria/SHARE::intern_lock                                                              | YES     | YES   |
      | wait/synch/mutex/aria/SHARE::key_del_lock                                                             | YES     | YES   |
      | wait/synch/mutex/aria/SHARE::close_lock                                                               | YES     | YES   |
      | wait/synch/mutex/aria/SERVICE_THREAD_CONTROL::LOCK_control                                            | YES     | YES   |
      | wait/synch/mutex/aria/TRN::state_lock                                                                 | YES     | YES   |
      | wait/synch/mutex/aria/PAGECACHE::cache_lock                                                           | YES     | YES   |
      | wait/synch/mutex/sql/tz_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/mysys/SAFE_HASH::mutex                                                              | 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/fts_cache_rw_lock                                                            | YES     | YES   |
      | wait/synch/rwlock/innodb/fts_cache_init_rw_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/index_online_log                                                             | YES     | YES   |
      | wait/synch/rwlock/innodb/dict_table_stats                                                             | YES     | YES   |
      | wait/synch/rwlock/innodb/hash_table_locks                                                             | YES     | YES   |
      | wait/synch/rwlock/aria/KEYINFO::root_lock                                                             | YES     | YES   |
      | wait/synch/rwlock/aria/SHARE::mmap_lock                                                               | YES     | YES   |
      | wait/synch/rwlock/aria/TRANSLOG_DESCRIPTOR::open_files_lock                                           | 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/TC_LOG_MMAP::COND_queue_busy                                                      | YES     | YES   |
      | wait/synch/cond/sql/MYSQL_BIN_LOG::COND_xid_list                                                      | YES     | YES   |
      | wait/synch/cond/sql/MYSQL_BIN_LOG::update_cond                                                        | YES     | YES   |
      | wait/synch/cond/sql/MYSQL_BIN_LOG::COND_binlog_background_thread                                      | YES     | YES   |
      | wait/synch/cond/sql/MYSQL_BIN_LOG::COND_binlog_background_thread_end                                  | YES     | YES   |
      | wait/synch/cond/sql/MYSQL_BIN_LOG::COND_queue_busy                                                    | YES     | YES   |
      | wait/synch/cond/sql/MYSQL_RELAY_LOG::update_cond                                                      | YES     | YES   |
      | wait/synch/cond/sql/MYSQL_RELAY_LOG::COND_queue_busy                                                  | YES     | YES   |
      | wait/synch/cond/sql/THD::COND_wakeup_ready                                                            | YES     | YES   |
      | wait/synch/cond/sql/wait_for_commit::COND_wait_commit                                                 | 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_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/Rpl_group_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/sql/COND_rpl_thread                                                                   | YES     | YES   |
      | wait/synch/cond/sql/COND_rpl_thread_queue                                                             | YES     | YES   |
      | wait/synch/cond/sql/COND_rpl_thread_stop                                                              | YES     | YES   |
      | wait/synch/cond/sql/COND_rpl_thread_pool                                                              | YES     | YES   |
      | wait/synch/cond/sql/COND_parallel_entry                                                               | YES     | YES   |
      | wait/synch/cond/sql/COND_group_commit_orderer                                                         | YES     | YES   |
      | wait/synch/cond/sql/COND_prepare_ordered                                                              | YES     | YES   |
      | wait/synch/cond/sql/COND_slave_background                                                             | YES     | YES   |
      | wait/synch/cond/sql/COND_start_thread                                                                 | YES     | YES   |
      | wait/synch/cond/sql/COND_wait_gtid                                                                    | YES     | YES   |
      | wait/synch/cond/sql/COND_gtid_ignore_duplicates                                                       | YES     | YES   |
      | wait/synch/cond/mysys/COND_alarm                                                                      | YES     | YES   |
      | wait/synch/cond/mysys/COND_timer                                                                      | 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/mysys/WT_RESOURCE::cond                                                               | 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/show_explain                                                                      | YES     | YES   |
      | wait/synch/cond/sql/MDL_context::COND_wait_status                                                     | YES     | YES   |
      | wait/synch/cond/sql/TABLE_SHARE::tdc.COND_release                                                     | YES     | YES   |
      | wait/synch/cond/sql/COND_wsrep_ready                                                                  | YES     | YES   |
      | wait/synch/cond/sql/COND_wsrep_sst                                                                    | YES     | YES   |
      | wait/synch/cond/sql/COND_wsrep_sst_init                                                               | YES     | YES   |
      | wait/synch/cond/sql/wsrep_sst_thread                                                                  | YES     | YES   |
      | wait/synch/cond/sql/COND_wsrep_rollback                                                               | YES     | YES   |
      | wait/synch/cond/sql/COND_wsrep_replaying                                                              | YES     | YES   |
      | wait/synch/cond/myisam/MI_SORT_INFO::cond                                                             | YES     | YES   |
      | wait/synch/cond/innodb/commit_cond                                                                    | YES     | YES   |
      | wait/synch/cond/aria/COND_soft_sync                                                                   | YES     | YES   |
      | wait/synch/cond/aria/SHARE::key_del_cond                                                              | YES     | YES   |
      | wait/synch/cond/aria/SERVICE_THREAD_CONTROL::COND_control                                             | YES     | YES   |
      | wait/synch/cond/aria/SORT_INFO::cond                                                                  | YES     | YES   |
      | wait/synch/cond/aria/BITMAP::bitmap_cond                                                              | YES     | YES   |
      | wait/synch/cond/aria/TRANSLOG_BUFFER::waiting_filling_buffer                                          | YES     | YES   |
      | wait/synch/cond/aria/TRANSLOG_BUFFER::prev_sent_to_disk_cond                                          | YES     | YES   |
      | wait/synch/cond/aria/TRANSLOG_DESCRIPTOR::log_flush_cond                                              | YES     | YES   |
      | wait/synch/cond/aria/TRANSLOG_DESCRIPTOR::new_goal_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/sql/binlog_state                                                                         | 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/sql/wsrep_gra_log                                                                        | 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/csv/metadata                                                                             | YES     | YES   |
      | wait/io/file/csv/data                                                                                 | YES     | YES   |
      | wait/io/file/csv/update                                                                               | 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   |
      | wait/io/file/aria/translog                                                                            | YES     | YES   |
      | wait/io/file/aria/MAI                                                                                 | YES     | YES   |
      | wait/io/file/aria/MAD                                                                                 | YES     | YES   |
      | wait/io/file/aria/control                                                                             | YES     | YES   |
      | wait/io/table/sql/handler                                                                             | YES     | YES   |
      | wait/lock/table/sql/handler                                                                           | YES     | YES   |
      | stage/sql/after apply log event                                                                       | YES     | YES   |
      | stage/sql/After create                                                                                | YES     | YES   |
      | stage/sql/After opening tables                                                                        | YES     | YES   |
      | stage/sql/After table lock                                                                            | YES     | YES   |
      | stage/sql/allocating local table                                                                      | YES     | YES   |
      | stage/sql/altering table                                                                              | YES     | YES   |
      | stage/sql/committing alter table to storage engine                                                    | YES     | YES   |
      | stage/sql/preparing for alter table                                                                   | YES     | YES   |
      | stage/sql/apply log event                                                                             | YES     | YES   |
      | stage/sql/Processing binlog checkpoint notification                                                   | YES     | YES   |
      | stage/sql/Stopping binlog background thread                                                           | YES     | YES   |
      | stage/sql/Waiting for background binlog tasks                                                         | YES     | YES   |
      | stage/sql/Changing master                                                                             | YES     | YES   |
      | stage/sql/Checking master version                                                                     | YES     | YES   |
      | stage/sql/checking permissions                                                                        | YES     | YES   |
      | stage/sql/checking privileges on cached query                                                         | YES     | YES   |
      | stage/sql/checking query cache for query                                                              | YES     | YES   |
      | stage/sql/cleaning up                                                                                 | YES     | YES   |
      | stage/sql/closing tables                                                                              | YES     | YES   |
      | stage/sql/Connecting to master                                                                        | YES     | YES   |
      | stage/sql/converting HEAP to Aria                                                                     | YES     | YES   |
      | stage/sql/copy to tmp table                                                                           | YES     | YES   |
      | stage/sql/Copying to group table                                                                      | YES     | YES   |
      | stage/sql/Copying to tmp table                                                                        | YES     | YES   |
      | stage/sql/Creating delayed handler                                                                    | YES     | YES   |
      | stage/sql/Creating sort index                                                                         | YES     | YES   |
      | stage/sql/creating table                                                                              | YES     | YES   |
      | stage/sql/Creating tmp table                                                                          | YES     | YES   |
      | stage/sql/deleting from main table                                                                    | YES     | YES   |
      | stage/sql/deleting from reference tables                                                              | YES     | YES   |
      | stage/sql/discard_or_import_tablespace                                                                | YES     | YES   |
      | stage/sql/enabling keys                                                                               | YES     | YES   |
      | stage/sql/end                                                                                         | YES     | YES   |
      | stage/sql/executing                                                                                   | YES     | YES   |
      | stage/sql/Execution of init_command                                                                   | YES     | YES   |
      | stage/sql/explaining                                                                                  | YES     | YES   |
      | stage/sql/Finding key cache                                                                           | YES     | YES   |
      | stage/sql/Finished reading one binlog; switching to next binlog                                       | YES     | YES   |
      | stage/sql/Flushing relay log and master info repository.                                              | YES     | YES   |
      | stage/sql/Flushing relay-log info file.                                                               | YES     | YES   |
      | stage/sql/freeing items                                                                               | YES     | YES   |
      | stage/sql/FULLTEXT initialization                                                                     | YES     | YES   |
      | stage/sql/got handler lock                                                                            | YES     | YES   |
      | stage/sql/got old table                                                                               | YES     | YES   |
      | stage/sql/init                                                                                        | YES     | YES   |
      | stage/sql/insert                                                                                      | YES     | YES   |
      | stage/sql/invalidating query cache entries (table)                                                    | YES     | YES   |
      | stage/sql/invalidating query cache entries (table list)                                               | YES     | YES   |
      | stage/sql/Killing slave                                                                               | YES     | YES   |
      | stage/sql/logging slow query                                                                          | YES     | YES   |
      | stage/sql/Making temporary file (append) before replaying LOAD DATA INFILE.                           | YES     | YES   |
      | stage/sql/Making temporary file (create) before replaying LOAD DATA INFILE.                           | YES     | YES   |
      | stage/sql/manage keys                                                                                 | YES     | YES   |
      | stage/sql/Master has sent all binlog to slave; waiting for binlog to be updated                       | YES     | YES   |
      | stage/sql/Opening tables                                                                              | YES     | YES   |
      | stage/sql/optimizing                                                                                  | YES     | YES   |
      | stage/sql/preparing                                                                                   | YES     | YES   |
      | stage/sql/Purging old relay logs                                                                      | YES     | YES   |
      | stage/sql/query end                                                                                   | YES     | YES   |
      | stage/sql/Queueing master event to the relay log                                                      | YES     | YES   |
      | stage/sql/Reading event from the relay log                                                            | YES     | YES   |
      | stage/sql/recreating table                                                                            | YES     | YES   |
      | stage/sql/Registering slave on master                                                                 | YES     | YES   |
      | stage/sql/Removing duplicates                                                                         | YES     | YES   |
      | stage/sql/removing tmp table                                                                          | YES     | YES   |
      | stage/sql/rename                                                                                      | YES     | YES   |
      | stage/sql/rename result table                                                                         | YES     | YES   |
      | stage/sql/Requesting binlog dump                                                                      | YES     | YES   |
      | stage/sql/reschedule                                                                                  | YES     | YES   |
      | stage/sql/Searching rows for update                                                                   | YES     | YES   |
      | stage/sql/Sending binlog event to slave                                                               | YES     | YES   |
      | stage/sql/sending cached result to client                                                             | YES     | YES   |
      | stage/sql/Sending data                                                                                | YES     | YES   |
      | stage/sql/setup                                                                                       | YES     | YES   |
      | stage/sql/show explain                                                                                | YES     | YES   |
      | stage/sql/Slave has read all relay log; waiting for the slave I/O thread to update it                 | YES     | YES   |
      | stage/sql/Sorting                                                                                     | YES     | YES   |
      | stage/sql/Sorting for group                                                                           | YES     | YES   |
      | stage/sql/Sorting for order                                                                           | YES     | YES   |
      | stage/sql/Sorting result                                                                              | YES     | YES   |
      | stage/sql/Waiting until MASTER_DELAY seconds after master executed event                              | YES     | YES   |
      | stage/sql/statistics                                                                                  | YES     | YES   |
      | stage/sql/storing result in query cache                                                               | YES     | YES   |
      | stage/sql/storing row into queue                                                                      | YES     | YES   |
      | stage/sql/System lock                                                                                 | YES     | YES   |
      | stage/sql/Unlocking tables                                                                            | YES     | YES   |
      | stage/sql/Table lock                                                                                  | YES     | YES   |
      | stage/sql/Filling schema table                                                                        | YES     | YES   |
      | stage/sql/update                                                                                      | YES     | YES   |
      | stage/sql/updating                                                                                    | YES     | YES   |
      | stage/sql/updating main table                                                                         | YES     | YES   |
      | stage/sql/updating reference tables                                                                   | YES     | YES   |
      | stage/sql/upgrading lock                                                                              | YES     | YES   |
      | stage/sql/User lock                                                                                   | YES     | YES   |
      | stage/sql/User sleep                                                                                  | YES     | YES   |
      | stage/sql/verifying table                                                                             | YES     | YES   |
      | stage/sql/waiting for delay_list                                                                      | YES     | YES   |
      | stage/sql/waiting for GTID to be written to binary log                                                | YES     | YES   |
      | stage/sql/waiting for handler insert                                                                  | YES     | YES   |
      | stage/sql/waiting for handler lock                                                                    | YES     | YES   |
      | stage/sql/waiting for handler open                                                                    | YES     | YES   |
      | stage/sql/Waiting for INSERT                                                                          | YES     | YES   |
      | stage/sql/Waiting for master to send event                                                            | YES     | YES   |
      | stage/sql/Waiting for master update                                                                   | YES     | YES   |
      | stage/sql/Waiting for prior transaction to commit                                                     | YES     | YES   |
      | stage/sql/Waiting for prior transaction to start commit before starting next transaction              | YES     | YES   |
      | stage/sql/Waiting for query cache lock                                                                | YES     | YES   |
      | stage/sql/Waiting for the slave SQL thread to free enough relay log space                             | YES     | YES   |
      | stage/sql/Waiting for room in worker thread event queue                                               | YES     | YES   |
      | stage/sql/Waiting for slave mutex on exit                                                             | YES     | YES   |
      | stage/sql/Waiting for slave thread to start                                                           | YES     | YES   |
      | stage/sql/Waiting for table flush                                                                     | YES     | YES   |
      | stage/sql/Waiting for the next event in relay log                                                     | YES     | YES   |
      | stage/sql/Waiting for the slave SQL thread to advance position                                        | YES     | YES   |
      | stage/sql/Waiting for work from SQL thread                                                            | YES     | YES   |
      | stage/sql/Waiting to finalize termination                                                             | YES     | YES   |
      | stage/sql/Waiting to get readlock                                                                     | YES     | YES   |
      | stage/sql/Waiting in MASTER_GTID_WAIT() (primary waiter)                                              | YES     | YES   |
      | stage/sql/Waiting in MASTER_GTID_WAIT()                                                               | YES     | YES   |
      | stage/sql/Waiting for other master connection to process GTID received on multiple master connections | YES     | YES   |
      | stage/sql/Processing requests                                                                         | YES     | YES   |
      | stage/sql/Waiting for requests                                                                        | YES     | YES   |
      | stage/sql/Waiting for parallel replication deadlock handling to complete                              | YES     | YES   |
      | stage/mysys/Waiting for table level lock                                                              | YES     | YES   |
      | stage/sql/Waiting on empty queue                                                                      | YES     | YES   |
      | stage/sql/Waiting for next activation                                                                 | YES     | YES   |
      | stage/sql/Waiting for the scheduler to stop                                                           | YES     | YES   |
      | stage/sql/Waiting for global read lock                                                                | YES     | YES   |
      | stage/sql/Waiting for schema metadata lock                                                            | YES     | YES   |
      | stage/sql/Waiting for table metadata lock                                                             | YES     | YES   |
      | stage/sql/Waiting for stored function metadata lock                                                   | YES     | YES   |
      | stage/sql/Waiting for stored procedure metadata lock                                                  | YES     | YES   |
      | stage/sql/Waiting for trigger metadata lock                                                           | YES     | YES   |
      | stage/sql/Waiting for event metadata lock                                                             | YES     | YES   |
      | stage/sql/Waiting for commit lock                                                                     | YES     | YES   |
      | stage/innodb/alter table (end)                                                                        | YES     | YES   |
      | stage/innodb/alter table (flush)                                                                      | YES     | YES   |
      | stage/innodb/alter table (insert)                                                                     | YES     | YES   |
      | stage/innodb/alter table (log apply index)                                                            | YES     | YES   |
      | stage/innodb/alter table (log apply table)                                                            | YES     | YES   |
      | stage/innodb/alter table (merge sort)                                                                 | YES     | YES   |
      | stage/innodb/alter table (read PK and internal sort)                                                  | YES     | YES   |
      | stage/innodb/buffer pool load                                                                         | YES     | YES   |
      | stage/aria/Waiting for a resource                                                                     | YES     | YES   |
      | statement/sql/select                                                                                  | YES     | YES   |
      | statement/sql/create_table                                                                            | YES     | YES   |
      | statement/sql/create_index                                                                            | YES     | YES   |
      | statement/sql/alter_table                                                                             | YES     | YES   |
      | statement/sql/update                                                                                  | YES     | YES   |
      | statement/sql/insert                                                                                  | YES     | YES   |
      | statement/sql/insert_select                                                                           | YES     | YES   |
      | statement/sql/delete                                                                                  | YES     | YES   |
      | statement/sql/truncate                                                                                | YES     | YES   |
      | statement/sql/drop_table                                                                              | YES     | YES   |
      | statement/sql/drop_index                                                                              | YES     | YES   |
      | statement/sql/show_databases                                                                          | YES     | YES   |
      | statement/sql/show_tables                                                                             | YES     | YES   |
      | statement/sql/show_fields                                                                             | YES     | YES   |
      | statement/sql/show_keys                                                                               | YES     | YES   |
      | statement/sql/show_variables                                                                          | YES     | YES   |
      | statement/sql/show_status                                                                             | YES     | YES   |
      | statement/sql/show_engine_logs                                                                        | YES     | YES   |
      | statement/sql/show_engine_status                                                                      | YES     | YES   |
      | statement/sql/show_engine_mutex                                                                       | YES     | YES   |
      | statement/sql/show_processlist                                                                        | YES     | YES   |
      | statement/sql/show_master_status                                                                      | YES     | YES   |
      | statement/sql/show_slave_status                                                                       | YES     | YES   |
      | statement/sql/show_grants                                                                             | YES     | YES   |
      | statement/sql/show_create_table                                                                       | YES     | YES   |
      | statement/sql/show_charsets                                                                           | YES     | YES   |
      | statement/sql/show_collations                                                                         | YES     | YES   |
      | statement/sql/show_create_db                                                                          | YES     | YES   |
      | statement/sql/show_table_status                                                                       | YES     | YES   |
      | statement/sql/show_triggers                                                                           | YES     | YES   |
      | statement/sql/load                                                                                    | YES     | YES   |
      | statement/sql/set_option                                                                              | YES     | YES   |
      | statement/sql/lock_tables                                                                             | YES     | YES   |
      | statement/sql/unlock_tables                                                                           | YES     | YES   |
      | statement/sql/grant                                                                                   | YES     | YES   |
      | statement/sql/change_db                                                                               | YES     | YES   |
      | statement/sql/create_db                                                                               | YES     | YES   |
      | statement/sql/drop_db                                                                                 | YES     | YES   |
      | statement/sql/alter_db                                                                                | YES     | YES   |
      | statement/sql/repair                                                                                  | YES     | YES   |
      | statement/sql/replace                                                                                 | YES     | YES   |
      | statement/sql/replace_select                                                                          | YES     | YES   |
      | statement/sql/create_udf                                                                              | YES     | YES   |
      | statement/sql/drop_function                                                                           | YES     | YES   |
      | statement/sql/revoke                                                                                  | YES     | YES   |
      | statement/sql/optimize                                                                                | YES     | YES   |
      | statement/sql/check                                                                                   | YES     | YES   |
      | statement/sql/assign_to_keycache                                                                      | YES     | YES   |
      | statement/sql/preload_keys                                                                            | YES     | YES   |
      | statement/sql/flush                                                                                   | YES     | YES   |
      | statement/sql/kill                                                                                    | YES     | YES   |
      | statement/sql/analyze                                                                                 | YES     | YES   |
      | statement/sql/rollback                                                                                | YES     | YES   |
      | statement/sql/rollback_to_savepoint                                                                   | YES     | YES   |
      | statement/sql/commit                                                                                  | YES     | YES   |
      | statement/sql/savepoint                                                                               | YES     | YES   |
      | statement/sql/release_savepoint                                                                       | YES     | YES   |
      | statement/sql/start_slave                                                                             | YES     | YES   |
      | statement/sql/stop_slave                                                                              | YES     | YES   |
      | statement/sql/begin                                                                                   | YES     | YES   |
      | statement/sql/change_master                                                                           | YES     | YES   |
      | statement/sql/rename_table                                                                            | YES     | YES   |
      | statement/sql/reset                                                                                   | YES     | YES   |
      | statement/sql/purge                                                                                   | YES     | YES   |
      | statement/sql/purge_before_date                                                                       | YES     | YES   |
      | statement/sql/show_binlogs                                                                            | YES     | YES   |
      | statement/sql/show_open_tables                                                                        | YES     | YES   |
      | statement/sql/ha_open                                                                                 | YES     | YES   |
      | statement/sql/ha_close                                                                                | YES     | YES   |
      | statement/sql/ha_read                                                                                 | YES     | YES   |
      | statement/sql/show_slave_hosts                                                                        | YES     | YES   |
      | statement/sql/delete_multi                                                                            | YES     | YES   |
      | statement/sql/update_multi                                                                            | YES     | YES   |
      | statement/sql/show_binlog_events                                                                      | YES     | YES   |
      | statement/sql/do                                                                                      | YES     | YES   |
      | statement/sql/show_warnings                                                                           | YES     | YES   |
      | statement/sql/empty_query                                                                             | YES     | YES   |
      | statement/sql/show_errors                                                                             | YES     | YES   |
      | statement/sql/show_storage_engines                                                                    | YES     | YES   |
      | statement/sql/show_privileges                                                                         | YES     | YES   |
      | statement/sql/help                                                                                    | YES     | YES   |
      | statement/sql/create_user                                                                             | YES     | YES   |
      | statement/sql/drop_user                                                                               | YES     | YES   |
      | statement/sql/rename_user                                                                             | YES     | YES   |
      | statement/sql/revoke_all                                                                              | YES     | YES   |
      | statement/sql/checksum                                                                                | YES     | YES   |
      | statement/sql/create_procedure                                                                        | YES     | YES   |
      | statement/sql/create_function                                                                         | YES     | YES   |
      | statement/sql/call_procedure                                                                          | YES     | YES   |
      | statement/sql/drop_procedure                                                                          | YES     | YES   |
      | statement/sql/alter_procedure                                                                         | YES     | YES   |
      | statement/sql/alter_function                                                                          | YES     | YES   |
      | statement/sql/show_create_proc                                                                        | YES     | YES   |
      | statement/sql/show_create_func                                                                        | YES     | YES   |
      | statement/sql/show_procedure_status                                                                   | YES     | YES   |
      | statement/sql/show_function_status                                                                    | YES     | YES   |
      | statement/sql/prepare_sql                                                                             | YES     | YES   |
      | statement/sql/execute_sql                                                                             | YES     | YES   |
      | statement/sql/dealloc_sql                                                                             | YES     | YES   |
      | statement/sql/create_view                                                                             | YES     | YES   |
      | statement/sql/drop_view                                                                               | YES     | YES   |
      | statement/sql/create_trigger                                                                          | YES     | YES   |
      | statement/sql/drop_trigger                                                                            | YES     | YES   |
      | statement/sql/xa_start                                                                                | YES     | YES   |
      | statement/sql/xa_end                                                                                  | YES     | YES   |
      | statement/sql/xa_prepare                                                                              | YES     | YES   |
      | statement/sql/xa_commit                                                                               | YES     | YES   |
      | statement/sql/xa_rollback                                                                             | YES     | YES   |
      | statement/sql/xa_recover                                                                              | YES     | YES   |
      | statement/sql/                                                                                        | YES     | YES   |
      | statement/sql/alter_tablespace                                                                        | YES     | YES   |
      | statement/sql/install_plugin                                                                          | YES     | YES   |
      | statement/sql/uninstall_plugin                                                                        | YES     | YES   |
      | statement/sql/show_authors                                                                            | YES     | YES   |
      | statement/sql/binlog                                                                                  | YES     | YES   |
      | statement/sql/show_plugins                                                                            | YES     | YES   |
      | statement/sql/show_contributors                                                                       | YES     | YES   |
      | statement/sql/create_server                                                                           | YES     | YES   |
      | statement/sql/drop_server                                                                             | YES     | YES   |
      | statement/sql/alter_server                                                                            | YES     | YES   |
      | statement/sql/create_event                                                                            | YES     | YES   |
      | statement/sql/alter_event                                                                             | YES     | YES   |
      | statement/sql/drop_event                                                                              | YES     | YES   |
      | statement/sql/show_create_event                                                                       | YES     | YES   |
      | statement/sql/show_events                                                                             | YES     | YES   |
      | statement/sql/show_create_trigger                                                                     | YES     | YES   |
      | statement/sql/alter_db_upgrade                                                                        | YES     | YES   |
      | statement/sql/show_profile                                                                            | YES     | YES   |
      | statement/sql/show_profiles                                                                           | YES     | YES   |
      | statement/sql/signal                                                                                  | YES     | YES   |
      | statement/sql/resignal                                                                                | YES     | YES   |
      | statement/sql/show_relaylog_events                                                                    | YES     | YES   |
      | statement/sql/get_diagnostics                                                                         | YES     | YES   |
      | statement/sql/start_all_slaves                                                                        | YES     | YES   |
      | statement/sql/stop_all_slaves                                                                         | YES     | YES   |
      | statement/sql/show_explain                                                                            | YES     | YES   |
      | statement/sql/shutdown                                                                                | YES     | YES   |
      | statement/sql/create_role                                                                             | YES     | YES   |
      | statement/sql/drop_role                                                                               | YES     | YES   |
      | statement/sql/grant_role                                                                              | YES     | YES   |
      | statement/sql/revoke_role                                                                             | YES     | YES   |
      | statement/sql/compound_sql                                                                            | YES     | YES   |
      | statement/sql/show_generic                                                                            | YES     | YES   |
      | statement/sql/alter_user                                                                              | YES     | YES   |
      | statement/sql/show_create_user                                                                        | YES     | YES   |
      | statement/sql/execute_immediate                                                                       | YES     | YES   |
      | statement/sql/error                                                                                   | YES     | YES   |
      | statement/com/Sleep                                                                                   | YES     | YES   |
      | statement/com/Quit                                                                                    | YES     | YES   |
      | statement/com/Init DB                                                                                 | YES     | YES   |
      | statement/com/Field List                                                                              | YES     | YES   |
      | statement/com/Create DB                                                                               | YES     | YES   |
      | statement/com/Drop DB                                                                                 | YES     | YES   |
      | statement/com/Refresh                                                                                 | YES     | YES   |
      | statement/com/Shutdown                                                                                | YES     | YES   |
      | statement/com/Statistics                                                                              | YES     | YES   |
      | statement/com/Processlist                                                                             | YES     | YES   |
      | statement/com/Connect                                                                                 | YES     | YES   |
      | statement/com/Kill                                                                                    | YES     | YES   |
      | statement/com/Debug                                                                                   | YES     | YES   |
      | statement/com/Ping                                                                                    | YES     | YES   |
      | statement/com/Time                                                                                    | YES     | YES   |
      | statement/com/Delayed insert                                                                          | YES     | YES   |
      | statement/com/Change user                                                                             | YES     | YES   |
      | statement/com/Binlog Dump                                                                             | YES     | YES   |
      | statement/com/Table Dump                                                                              | YES     | YES   |
      | statement/com/Connect Out                                                                             | YES     | YES   |
      | statement/com/Register Slave                                                                          | YES     | YES   |
      | statement/com/Prepare                                                                                 | YES     | YES   |
      | statement/com/Execute                                                                                 | YES     | YES   |
      | statement/com/Long Data                                                                               | YES     | YES   |
      | statement/com/Close stmt                                                                              | YES     | YES   |
      | statement/com/Reset stmt                                                                              | YES     | YES   |
      | statement/com/Set option                                                                              | YES     | YES   |
      | statement/com/Fetch                                                                                   | YES     | YES   |
      | statement/com/Daemon                                                                                  | YES     | YES   |
      | statement/com/Unimpl get tid                                                                          | YES     | YES   |
      | statement/com/Reset connection                                                                        | YES     | YES   |
      | statement/com/Bulk_execute                                                                            | YES     | YES   |
      | statement/com/Slave_worker                                                                            | YES     | YES   |
      | statement/com/Slave_IO                                                                                | YES     | YES   |
      | statement/com/Slave_SQL                                                                               | YES     | YES   |
      | statement/com/Com_multi                                                                               | YES     | YES   |
      | statement/com/Error                                                                                   | YES     | YES   |
      | statement/abstract/Query                                                                              | YES     | YES   |
      | statement/abstract/new_packet                                                                         | YES     | YES   |
      | statement/abstract/relay_log                                                                          | YES     | YES   |
      | wait/io/socket/sql/server_tcpip_socket                                                                | YES     | YES   |
      | wait/io/socket/sql/server_unix_socket                                                                 | YES     | YES   |
      | wait/io/socket/sql/client_connection                                                                  | YES     | YES   |
      | idle                                                                                                  | YES     | YES   |
      +-------------------------------------------------------------------------------------------------------+---------+-------+
      674 rows in set (0.00 sec)
      

      my code for test :

      STOP SLAVE IO_THREAD;
      --wait 30 mniutes
      START SLAVE IO_THREAD;
       
      show slave status\G
      *************************** 1. row ***************************
                     Slave_IO_State: Waiting for master to send event
                        Master_Host: 10.243.5.220
                        Master_User: replication
                        Master_Port: 3307
                      Connect_Retry: 60
                    Master_Log_File: mariadb-bin.001060
                Read_Master_Log_Pos: 726912433
                     Relay_Log_File: mysqld-relay-bin.000392
                      Relay_Log_Pos: 22439002
              Relay_Master_Log_File: mariadb-bin.001060
                   Slave_IO_Running: Yes
                  Slave_SQL_Running: Yes
                    Replicate_Do_DB: 
                Replicate_Ignore_DB: 
                 Replicate_Do_Table: 
             Replicate_Ignore_Table: 
            Replicate_Wild_Do_Table: 
        Replicate_Wild_Ignore_Table: 
                         Last_Errno: 0
                         Last_Error: 
                       Skip_Counter: 0
                Exec_Master_Log_Pos: 572024862
                    Relay_Log_Space: 595583987
                    Until_Condition: None
                     Until_Log_File: 
                      Until_Log_Pos: 0
                 Master_SSL_Allowed: No
                 Master_SSL_CA_File: 
                 Master_SSL_CA_Path: 
                    Master_SSL_Cert: 
                  Master_SSL_Cipher: 
                     Master_SSL_Key: 
              Seconds_Behind_Master: 1449
      Master_SSL_Verify_Server_Cert: No
                      Last_IO_Errno: 0
                      Last_IO_Error: 
                     Last_SQL_Errno: 0
                     Last_SQL_Error: 
        Replicate_Ignore_Server_Ids: 
                   Master_Server_Id: 1740027789
                     Master_SSL_Crl: 
                 Master_SSL_Crlpath: 
                         Using_Gtid: No
                        Gtid_IO_Pos: 
            Replicate_Do_Domain_Ids: 
        Replicate_Ignore_Domain_Ids: 
                      Parallel_Mode: conservative
                          SQL_Delay: 0
                SQL_Remaining_Delay: NULL
            Slave_SQL_Running_State: Reading event from the relay log
      1 row in set (0.00 sec)
       
      select * from performance_schema.events_waits_summary_global_by_event_name  WHERE EVENT_NAME = 'wait/synch/cond/sql/MYSQL_RELAY_LOG::update_cond';
      +--------------------------------------------------+------------+----------------+----------------+----------------+----------------+
      | EVENT_NAME                                       | COUNT_STAR | SUM_TIMER_WAIT | MIN_TIMER_WAIT | AVG_TIMER_WAIT | MAX_TIMER_WAIT |
      +--------------------------------------------------+------------+----------------+----------------+----------------+----------------+
      | wait/synch/cond/sql/MYSQL_RELAY_LOG::update_cond |          0 |              0 |              0 |              0 |              0 |
      +--------------------------------------------------+------------+----------------+----------------+----------------+----------------+
      1 row in set (0.00 sec)
      

      Attachments

        Activity

          People

            Unassigned Unassigned
            Aurelien_LEQUOY Aurélien LEQUOY
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.