Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Incomplete
-
10.2.16
-
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) |