diff options
Diffstat (limited to 'mysql-test/suite/sys_vars/r/innodb_monitor_reset_all_basic.result')
-rw-r--r-- | mysql-test/suite/sys_vars/r/innodb_monitor_reset_all_basic.result | 1709 |
1 files changed, 35 insertions, 1674 deletions
diff --git a/mysql-test/suite/sys_vars/r/innodb_monitor_reset_all_basic.result b/mysql-test/suite/sys_vars/r/innodb_monitor_reset_all_basic.result index 8bb508c877e..7a7c0a6b6a2 100644 --- a/mysql-test/suite/sys_vars/r/innodb_monitor_reset_all_basic.result +++ b/mysql-test/suite/sys_vars/r/innodb_monitor_reset_all_basic.result @@ -25,14 +25,15 @@ buffer_pool_size disabled buffer_pool_reads disabled buffer_pool_read_requests disabled buffer_pool_write_requests disabled -buffer_pool_pages_in_flush disabled buffer_pool_wait_free disabled buffer_pool_read_ahead disabled buffer_pool_read_ahead_evicted disabled buffer_pool_pages_total disabled buffer_pool_pages_misc disabled buffer_pool_pages_data disabled +buffer_pool_bytes_data disabled buffer_pool_pages_dirty disabled +buffer_pool_bytes_dirty disabled buffer_pool_pages_free disabled buffer_pages_created disabled buffer_pages_written disabled @@ -48,15 +49,15 @@ buffer_flush_batch_pages disabled buffer_flush_neighbor_total_pages disabled buffer_flush_neighbor disabled buffer_flush_neighbor_pages disabled -buffer_flush_max_dirty_total_pages disabled -buffer_flush_max_dirty disabled -buffer_flush_max_dirty_pages disabled +buffer_flush_n_to_flush_requested disabled +buffer_flush_avg_page_rate disabled +buffer_flush_lsn_avg_rate disabled +buffer_flush_pct_for_dirty disabled +buffer_flush_pct_for_lsn disabled +buffer_flush_sync_waits disabled buffer_flush_adaptive_total_pages disabled buffer_flush_adaptive disabled buffer_flush_adaptive_pages disabled -buffer_flush_async_total_pages disabled -buffer_flush_async disabled -buffer_flush_async_pages disabled buffer_flush_sync_total_pages disabled buffer_flush_sync disabled buffer_flush_sync_pages disabled @@ -156,6 +157,8 @@ log_write_requests disabled log_writes disabled compress_pages_compressed disabled compress_pages_decompressed disabled +compression_pad_increments disabled +compression_pad_decrements disabled index_splits disabled index_merges disabled adaptive_hash_searches disabled @@ -199,657 +202,29 @@ dml_reads disabled dml_inserts disabled dml_deletes disabled dml_updates disabled +ddl_background_drop_indexes disabled ddl_background_drop_tables disabled +ddl_online_create_index disabled +ddl_pending_alter_table disabled icp_attempts disabled icp_no_match disabled icp_out_of_range disabled icp_match disabled set global innodb_monitor_enable = all; -select name, status from information_schema.innodb_metrics; -name status -metadata_table_handles_opened enabled -metadata_table_handles_closed enabled -metadata_table_reference_count enabled -metadata_mem_pool_size enabled -lock_deadlocks enabled -lock_timeouts enabled -lock_rec_lock_waits enabled -lock_table_lock_waits enabled -lock_rec_lock_requests enabled -lock_rec_lock_created enabled -lock_rec_lock_removed enabled -lock_rec_locks enabled -lock_table_lock_created enabled -lock_table_lock_removed enabled -lock_table_locks enabled -lock_row_lock_current_waits enabled -lock_row_lock_time enabled -lock_row_lock_time_max enabled -lock_row_lock_waits enabled -lock_row_lock_time_avg enabled -buffer_pool_size enabled -buffer_pool_reads enabled -buffer_pool_read_requests enabled -buffer_pool_write_requests enabled -buffer_pool_pages_in_flush enabled -buffer_pool_wait_free enabled -buffer_pool_read_ahead enabled -buffer_pool_read_ahead_evicted enabled -buffer_pool_pages_total enabled -buffer_pool_pages_misc enabled -buffer_pool_pages_data enabled -buffer_pool_pages_dirty enabled -buffer_pool_pages_free enabled -buffer_pages_created enabled -buffer_pages_written enabled -buffer_pages_read enabled -buffer_data_reads enabled -buffer_data_written enabled -buffer_flush_batch_scanned enabled -buffer_flush_batch_num_scan enabled -buffer_flush_batch_scanned_per_call enabled -buffer_flush_batch_total_pages enabled -buffer_flush_batches enabled -buffer_flush_batch_pages enabled -buffer_flush_neighbor_total_pages enabled -buffer_flush_neighbor enabled -buffer_flush_neighbor_pages enabled -buffer_flush_max_dirty_total_pages enabled -buffer_flush_max_dirty enabled -buffer_flush_max_dirty_pages enabled -buffer_flush_adaptive_total_pages enabled -buffer_flush_adaptive enabled -buffer_flush_adaptive_pages enabled -buffer_flush_async_total_pages enabled -buffer_flush_async enabled -buffer_flush_async_pages enabled -buffer_flush_sync_total_pages enabled -buffer_flush_sync enabled -buffer_flush_sync_pages enabled -buffer_flush_background_total_pages enabled -buffer_flush_background enabled -buffer_flush_background_pages enabled -buffer_LRU_batch_scanned enabled -buffer_LRU_batch_num_scan enabled -buffer_LRU_batch_scanned_per_call enabled -buffer_LRU_batch_total_pages enabled -buffer_LRU_batches enabled -buffer_LRU_batch_pages enabled -buffer_LRU_single_flush_scanned enabled -buffer_LRU_single_flush_num_scan enabled -buffer_LRU_single_flush_scanned_per_call enabled -buffer_LRU_single_flush_failure_count enabled -buffer_LRU_get_free_search enabled -buffer_LRU_search_scanned enabled -buffer_LRU_search_num_scan enabled -buffer_LRU_search_scanned_per_call enabled -buffer_LRU_unzip_search_scanned enabled -buffer_LRU_unzip_search_num_scan enabled -buffer_LRU_unzip_search_scanned_per_call enabled -buffer_page_read_index_leaf enabled -buffer_page_read_index_non_leaf enabled -buffer_page_read_index_ibuf_leaf enabled -buffer_page_read_index_ibuf_non_leaf enabled -buffer_page_read_undo_log enabled -buffer_page_read_index_inode enabled -buffer_page_read_ibuf_free_list enabled -buffer_page_read_ibuf_bitmap enabled -buffer_page_read_system_page enabled -buffer_page_read_trx_system enabled -buffer_page_read_fsp_hdr enabled -buffer_page_read_xdes enabled -buffer_page_read_blob enabled -buffer_page_read_zblob enabled -buffer_page_read_zblob2 enabled -buffer_page_read_other enabled -buffer_page_written_index_leaf enabled -buffer_page_written_index_non_leaf enabled -buffer_page_written_index_ibuf_leaf enabled -buffer_page_written_index_ibuf_non_leaf enabled -buffer_page_written_undo_log enabled -buffer_page_written_index_inode enabled -buffer_page_written_ibuf_free_list enabled -buffer_page_written_ibuf_bitmap enabled -buffer_page_written_system_page enabled -buffer_page_written_trx_system enabled -buffer_page_written_fsp_hdr enabled -buffer_page_written_xdes enabled -buffer_page_written_blob enabled -buffer_page_written_zblob enabled -buffer_page_written_zblob2 enabled -buffer_page_written_other enabled -os_data_reads enabled -os_data_writes enabled -os_data_fsyncs enabled -os_pending_reads enabled -os_pending_writes enabled -os_log_bytes_written enabled -os_log_fsyncs enabled -os_log_pending_fsyncs enabled -os_log_pending_writes enabled -trx_rw_commits enabled -trx_ro_commits enabled -trx_nl_ro_commits enabled -trx_commits_insert_update enabled -trx_rollbacks enabled -trx_rollbacks_savepoint enabled -trx_rollback_active enabled -trx_active_transactions enabled -trx_rseg_history_len enabled -trx_undo_slots_used enabled -trx_undo_slots_cached enabled -trx_rseg_current_size enabled -purge_del_mark_records enabled -purge_upd_exist_or_extern_records enabled -purge_invoked enabled -purge_undo_log_pages enabled -purge_dml_delay_usec enabled -purge_stop_count enabled -purge_resume_count enabled -log_checkpoints enabled -log_lsn_last_flush enabled -log_lsn_last_checkpoint enabled -log_lsn_current enabled -log_lsn_checkpoint_age enabled -log_lsn_buf_pool_oldest enabled -log_max_modified_age_async enabled -log_max_modified_age_sync enabled -log_pending_log_writes enabled -log_pending_checkpoint_writes enabled -log_num_log_io enabled -log_waits enabled -log_write_requests enabled -log_writes enabled -compress_pages_compressed enabled -compress_pages_decompressed enabled -index_splits enabled -index_merges enabled -adaptive_hash_searches enabled -adaptive_hash_searches_btree enabled -adaptive_hash_pages_added enabled -adaptive_hash_pages_removed enabled -adaptive_hash_rows_added enabled -adaptive_hash_rows_removed enabled -adaptive_hash_rows_deleted_no_hash_entry enabled -adaptive_hash_rows_updated enabled -file_num_open_files enabled -ibuf_merges_insert enabled -ibuf_merges_delete_mark enabled -ibuf_merges_delete enabled -ibuf_merges_discard_insert enabled -ibuf_merges_discard_delete_mark enabled -ibuf_merges_discard_delete enabled -ibuf_merges enabled -ibuf_size enabled -innodb_master_thread_sleeps enabled -innodb_activity_count enabled -innodb_master_active_loops enabled -innodb_master_idle_loops enabled -innodb_background_drop_table_usec enabled -innodb_ibuf_merge_usec enabled -innodb_log_flush_usec enabled -innodb_mem_validate_usec enabled -innodb_master_purge_usec enabled -innodb_dict_lru_usec enabled -innodb_checkpoint_usec enabled -innodb_dblwr_writes enabled -innodb_dblwr_pages_written enabled -innodb_page_size enabled -innodb_rwlock_s_spin_waits enabled -innodb_rwlock_x_spin_waits enabled -innodb_rwlock_s_spin_rounds enabled -innodb_rwlock_x_spin_rounds enabled -innodb_rwlock_s_os_waits enabled -innodb_rwlock_x_os_waits enabled -dml_reads enabled -dml_inserts enabled -dml_deletes enabled -dml_updates enabled -ddl_background_drop_tables enabled -icp_attempts enabled -icp_no_match enabled -icp_out_of_range enabled -icp_match enabled +select name from information_schema.innodb_metrics where status!='enabled'; +name set global innodb_monitor_enable = aaa; ERROR 42000: Variable 'innodb_monitor_enable' can't be set to the value of 'aaa' set global innodb_monitor_disable = All; -select name, status from information_schema.innodb_metrics; -name status -metadata_table_handles_opened disabled -metadata_table_handles_closed disabled -metadata_table_reference_count disabled -metadata_mem_pool_size disabled -lock_deadlocks disabled -lock_timeouts disabled -lock_rec_lock_waits disabled -lock_table_lock_waits disabled -lock_rec_lock_requests disabled -lock_rec_lock_created disabled -lock_rec_lock_removed disabled -lock_rec_locks disabled -lock_table_lock_created disabled -lock_table_lock_removed disabled -lock_table_locks disabled -lock_row_lock_current_waits disabled -lock_row_lock_time disabled -lock_row_lock_time_max disabled -lock_row_lock_waits disabled -lock_row_lock_time_avg disabled -buffer_pool_size disabled -buffer_pool_reads disabled -buffer_pool_read_requests disabled -buffer_pool_write_requests disabled -buffer_pool_pages_in_flush disabled -buffer_pool_wait_free disabled -buffer_pool_read_ahead disabled -buffer_pool_read_ahead_evicted disabled -buffer_pool_pages_total disabled -buffer_pool_pages_misc disabled -buffer_pool_pages_data disabled -buffer_pool_pages_dirty disabled -buffer_pool_pages_free disabled -buffer_pages_created disabled -buffer_pages_written disabled -buffer_pages_read disabled -buffer_data_reads disabled -buffer_data_written disabled -buffer_flush_batch_scanned disabled -buffer_flush_batch_num_scan disabled -buffer_flush_batch_scanned_per_call disabled -buffer_flush_batch_total_pages disabled -buffer_flush_batches disabled -buffer_flush_batch_pages disabled -buffer_flush_neighbor_total_pages disabled -buffer_flush_neighbor disabled -buffer_flush_neighbor_pages disabled -buffer_flush_max_dirty_total_pages disabled -buffer_flush_max_dirty disabled -buffer_flush_max_dirty_pages disabled -buffer_flush_adaptive_total_pages disabled -buffer_flush_adaptive disabled -buffer_flush_adaptive_pages disabled -buffer_flush_async_total_pages disabled -buffer_flush_async disabled -buffer_flush_async_pages disabled -buffer_flush_sync_total_pages disabled -buffer_flush_sync disabled -buffer_flush_sync_pages disabled -buffer_flush_background_total_pages disabled -buffer_flush_background disabled -buffer_flush_background_pages disabled -buffer_LRU_batch_scanned disabled -buffer_LRU_batch_num_scan disabled -buffer_LRU_batch_scanned_per_call disabled -buffer_LRU_batch_total_pages disabled -buffer_LRU_batches disabled -buffer_LRU_batch_pages disabled -buffer_LRU_single_flush_scanned disabled -buffer_LRU_single_flush_num_scan disabled -buffer_LRU_single_flush_scanned_per_call disabled -buffer_LRU_single_flush_failure_count disabled -buffer_LRU_get_free_search disabled -buffer_LRU_search_scanned disabled -buffer_LRU_search_num_scan disabled -buffer_LRU_search_scanned_per_call disabled -buffer_LRU_unzip_search_scanned disabled -buffer_LRU_unzip_search_num_scan disabled -buffer_LRU_unzip_search_scanned_per_call disabled -buffer_page_read_index_leaf disabled -buffer_page_read_index_non_leaf disabled -buffer_page_read_index_ibuf_leaf disabled -buffer_page_read_index_ibuf_non_leaf disabled -buffer_page_read_undo_log disabled -buffer_page_read_index_inode disabled -buffer_page_read_ibuf_free_list disabled -buffer_page_read_ibuf_bitmap disabled -buffer_page_read_system_page disabled -buffer_page_read_trx_system disabled -buffer_page_read_fsp_hdr disabled -buffer_page_read_xdes disabled -buffer_page_read_blob disabled -buffer_page_read_zblob disabled -buffer_page_read_zblob2 disabled -buffer_page_read_other disabled -buffer_page_written_index_leaf disabled -buffer_page_written_index_non_leaf disabled -buffer_page_written_index_ibuf_leaf disabled -buffer_page_written_index_ibuf_non_leaf disabled -buffer_page_written_undo_log disabled -buffer_page_written_index_inode disabled -buffer_page_written_ibuf_free_list disabled -buffer_page_written_ibuf_bitmap disabled -buffer_page_written_system_page disabled -buffer_page_written_trx_system disabled -buffer_page_written_fsp_hdr disabled -buffer_page_written_xdes disabled -buffer_page_written_blob disabled -buffer_page_written_zblob disabled -buffer_page_written_zblob2 disabled -buffer_page_written_other disabled -os_data_reads disabled -os_data_writes disabled -os_data_fsyncs disabled -os_pending_reads disabled -os_pending_writes disabled -os_log_bytes_written disabled -os_log_fsyncs disabled -os_log_pending_fsyncs disabled -os_log_pending_writes disabled -trx_rw_commits disabled -trx_ro_commits disabled -trx_nl_ro_commits disabled -trx_commits_insert_update disabled -trx_rollbacks disabled -trx_rollbacks_savepoint disabled -trx_rollback_active disabled -trx_active_transactions disabled -trx_rseg_history_len disabled -trx_undo_slots_used disabled -trx_undo_slots_cached disabled -trx_rseg_current_size disabled -purge_del_mark_records disabled -purge_upd_exist_or_extern_records disabled -purge_invoked disabled -purge_undo_log_pages disabled -purge_dml_delay_usec disabled -purge_stop_count disabled -purge_resume_count disabled -log_checkpoints disabled -log_lsn_last_flush disabled -log_lsn_last_checkpoint disabled -log_lsn_current disabled -log_lsn_checkpoint_age disabled -log_lsn_buf_pool_oldest disabled -log_max_modified_age_async disabled -log_max_modified_age_sync disabled -log_pending_log_writes disabled -log_pending_checkpoint_writes disabled -log_num_log_io disabled -log_waits disabled -log_write_requests disabled -log_writes disabled -compress_pages_compressed disabled -compress_pages_decompressed disabled -index_splits disabled -index_merges disabled -adaptive_hash_searches disabled -adaptive_hash_searches_btree disabled -adaptive_hash_pages_added disabled -adaptive_hash_pages_removed disabled -adaptive_hash_rows_added disabled -adaptive_hash_rows_removed disabled -adaptive_hash_rows_deleted_no_hash_entry disabled -adaptive_hash_rows_updated disabled -file_num_open_files disabled -ibuf_merges_insert disabled -ibuf_merges_delete_mark disabled -ibuf_merges_delete disabled -ibuf_merges_discard_insert disabled -ibuf_merges_discard_delete_mark disabled -ibuf_merges_discard_delete disabled -ibuf_merges disabled -ibuf_size disabled -innodb_master_thread_sleeps disabled -innodb_activity_count disabled -innodb_master_active_loops disabled -innodb_master_idle_loops disabled -innodb_background_drop_table_usec disabled -innodb_ibuf_merge_usec disabled -innodb_log_flush_usec disabled -innodb_mem_validate_usec disabled -innodb_master_purge_usec disabled -innodb_dict_lru_usec disabled -innodb_checkpoint_usec disabled -innodb_dblwr_writes disabled -innodb_dblwr_pages_written disabled -innodb_page_size disabled -innodb_rwlock_s_spin_waits disabled -innodb_rwlock_x_spin_waits disabled -innodb_rwlock_s_spin_rounds disabled -innodb_rwlock_x_spin_rounds disabled -innodb_rwlock_s_os_waits disabled -innodb_rwlock_x_os_waits disabled -dml_reads disabled -dml_inserts disabled -dml_deletes disabled -dml_updates disabled -ddl_background_drop_tables disabled -icp_attempts disabled -icp_no_match disabled -icp_out_of_range disabled -icp_match disabled +select name from information_schema.innodb_metrics where status!='disabled'; +name set global innodb_monitor_reset_all = all; -select name, count, status from information_schema.innodb_metrics; -name count status -metadata_table_handles_opened 0 disabled -metadata_table_handles_closed 0 disabled -metadata_table_reference_count 0 disabled -metadata_mem_pool_size 0 disabled -lock_deadlocks 0 disabled -lock_timeouts 0 disabled -lock_rec_lock_waits 0 disabled -lock_table_lock_waits 0 disabled -lock_rec_lock_requests 0 disabled -lock_rec_lock_created 0 disabled -lock_rec_lock_removed 0 disabled -lock_rec_locks 0 disabled -lock_table_lock_created 0 disabled -lock_table_lock_removed 0 disabled -lock_table_locks 0 disabled -lock_row_lock_current_waits 0 disabled -lock_row_lock_time 0 disabled -lock_row_lock_time_max 0 disabled -lock_row_lock_waits 0 disabled -lock_row_lock_time_avg 0 disabled -buffer_pool_size 0 disabled -buffer_pool_reads 0 disabled -buffer_pool_read_requests 0 disabled -buffer_pool_write_requests 0 disabled -buffer_pool_pages_in_flush 0 disabled -buffer_pool_wait_free 0 disabled -buffer_pool_read_ahead 0 disabled -buffer_pool_read_ahead_evicted 0 disabled -buffer_pool_pages_total 0 disabled -buffer_pool_pages_misc 0 disabled -buffer_pool_pages_data 0 disabled -buffer_pool_pages_dirty 0 disabled -buffer_pool_pages_free 0 disabled -buffer_pages_created 0 disabled -buffer_pages_written 0 disabled -buffer_pages_read 0 disabled -buffer_data_reads 0 disabled -buffer_data_written 0 disabled -buffer_flush_batch_scanned 0 disabled -buffer_flush_batch_num_scan 0 disabled -buffer_flush_batch_scanned_per_call 0 disabled -buffer_flush_batch_total_pages 0 disabled -buffer_flush_batches 0 disabled -buffer_flush_batch_pages 0 disabled -buffer_flush_neighbor_total_pages 0 disabled -buffer_flush_neighbor 0 disabled -buffer_flush_neighbor_pages 0 disabled -buffer_flush_max_dirty_total_pages 0 disabled -buffer_flush_max_dirty 0 disabled -buffer_flush_max_dirty_pages 0 disabled -buffer_flush_adaptive_total_pages 0 disabled -buffer_flush_adaptive 0 disabled -buffer_flush_adaptive_pages 0 disabled -buffer_flush_async_total_pages 0 disabled -buffer_flush_async 0 disabled -buffer_flush_async_pages 0 disabled -buffer_flush_sync_total_pages 0 disabled -buffer_flush_sync 0 disabled -buffer_flush_sync_pages 0 disabled -buffer_flush_background_total_pages 0 disabled -buffer_flush_background 0 disabled -buffer_flush_background_pages 0 disabled -buffer_LRU_batch_scanned 0 disabled -buffer_LRU_batch_num_scan 0 disabled -buffer_LRU_batch_scanned_per_call 0 disabled -buffer_LRU_batch_total_pages 0 disabled -buffer_LRU_batches 0 disabled -buffer_LRU_batch_pages 0 disabled -buffer_LRU_single_flush_scanned 0 disabled -buffer_LRU_single_flush_num_scan 0 disabled -buffer_LRU_single_flush_scanned_per_call 0 disabled -buffer_LRU_single_flush_failure_count 0 disabled -buffer_LRU_get_free_search 0 disabled -buffer_LRU_search_scanned 0 disabled -buffer_LRU_search_num_scan 0 disabled -buffer_LRU_search_scanned_per_call 0 disabled -buffer_LRU_unzip_search_scanned 0 disabled -buffer_LRU_unzip_search_num_scan 0 disabled -buffer_LRU_unzip_search_scanned_per_call 0 disabled -buffer_page_read_index_leaf 0 disabled -buffer_page_read_index_non_leaf 0 disabled -buffer_page_read_index_ibuf_leaf 0 disabled -buffer_page_read_index_ibuf_non_leaf 0 disabled -buffer_page_read_undo_log 0 disabled -buffer_page_read_index_inode 0 disabled -buffer_page_read_ibuf_free_list 0 disabled -buffer_page_read_ibuf_bitmap 0 disabled -buffer_page_read_system_page 0 disabled -buffer_page_read_trx_system 0 disabled -buffer_page_read_fsp_hdr 0 disabled -buffer_page_read_xdes 0 disabled -buffer_page_read_blob 0 disabled -buffer_page_read_zblob 0 disabled -buffer_page_read_zblob2 0 disabled -buffer_page_read_other 0 disabled -buffer_page_written_index_leaf 0 disabled -buffer_page_written_index_non_leaf 0 disabled -buffer_page_written_index_ibuf_leaf 0 disabled -buffer_page_written_index_ibuf_non_leaf 0 disabled -buffer_page_written_undo_log 0 disabled -buffer_page_written_index_inode 0 disabled -buffer_page_written_ibuf_free_list 0 disabled -buffer_page_written_ibuf_bitmap 0 disabled -buffer_page_written_system_page 0 disabled -buffer_page_written_trx_system 0 disabled -buffer_page_written_fsp_hdr 0 disabled -buffer_page_written_xdes 0 disabled -buffer_page_written_blob 0 disabled -buffer_page_written_zblob 0 disabled -buffer_page_written_zblob2 0 disabled -buffer_page_written_other 0 disabled -os_data_reads 0 disabled -os_data_writes 0 disabled -os_data_fsyncs 0 disabled -os_pending_reads 0 disabled -os_pending_writes 0 disabled -os_log_bytes_written 0 disabled -os_log_fsyncs 0 disabled -os_log_pending_fsyncs 0 disabled -os_log_pending_writes 0 disabled -trx_rw_commits 0 disabled -trx_ro_commits 0 disabled -trx_nl_ro_commits 0 disabled -trx_commits_insert_update 0 disabled -trx_rollbacks 0 disabled -trx_rollbacks_savepoint 0 disabled -trx_rollback_active 0 disabled -trx_active_transactions 0 disabled -trx_rseg_history_len 0 disabled -trx_undo_slots_used 0 disabled -trx_undo_slots_cached 0 disabled -trx_rseg_current_size 0 disabled -purge_del_mark_records 0 disabled -purge_upd_exist_or_extern_records 0 disabled -purge_invoked 0 disabled -purge_undo_log_pages 0 disabled -purge_dml_delay_usec 0 disabled -purge_stop_count 0 disabled -purge_resume_count 0 disabled -log_checkpoints 0 disabled -log_lsn_last_flush 0 disabled -log_lsn_last_checkpoint 0 disabled -log_lsn_current 0 disabled -log_lsn_checkpoint_age 0 disabled -log_lsn_buf_pool_oldest 0 disabled -log_max_modified_age_async 0 disabled -log_max_modified_age_sync 0 disabled -log_pending_log_writes 0 disabled -log_pending_checkpoint_writes 0 disabled -log_num_log_io 0 disabled -log_waits 0 disabled -log_write_requests 0 disabled -log_writes 0 disabled -compress_pages_compressed 0 disabled -compress_pages_decompressed 0 disabled -index_splits 0 disabled -index_merges 0 disabled -adaptive_hash_searches 0 disabled -adaptive_hash_searches_btree 0 disabled -adaptive_hash_pages_added 0 disabled -adaptive_hash_pages_removed 0 disabled -adaptive_hash_rows_added 0 disabled -adaptive_hash_rows_removed 0 disabled -adaptive_hash_rows_deleted_no_hash_entry 0 disabled -adaptive_hash_rows_updated 0 disabled -file_num_open_files 0 disabled -ibuf_merges_insert 0 disabled -ibuf_merges_delete_mark 0 disabled -ibuf_merges_delete 0 disabled -ibuf_merges_discard_insert 0 disabled -ibuf_merges_discard_delete_mark 0 disabled -ibuf_merges_discard_delete 0 disabled -ibuf_merges 0 disabled -ibuf_size 0 disabled -innodb_master_thread_sleeps 0 disabled -innodb_activity_count 0 disabled -innodb_master_active_loops 0 disabled -innodb_master_idle_loops 0 disabled -innodb_background_drop_table_usec 0 disabled -innodb_ibuf_merge_usec 0 disabled -innodb_log_flush_usec 0 disabled -innodb_mem_validate_usec 0 disabled -innodb_master_purge_usec 0 disabled -innodb_dict_lru_usec 0 disabled -innodb_checkpoint_usec 0 disabled -innodb_dblwr_writes 0 disabled -innodb_dblwr_pages_written 0 disabled -innodb_page_size 0 disabled -innodb_rwlock_s_spin_waits 0 disabled -innodb_rwlock_x_spin_waits 0 disabled -innodb_rwlock_s_spin_rounds 0 disabled -innodb_rwlock_x_spin_rounds 0 disabled -innodb_rwlock_s_os_waits 0 disabled -innodb_rwlock_x_os_waits 0 disabled -dml_reads 0 disabled -dml_inserts 0 disabled -dml_deletes 0 disabled -dml_updates 0 disabled -ddl_background_drop_tables 0 disabled -icp_attempts 0 disabled -icp_no_match 0 disabled -icp_out_of_range 0 disabled -icp_match 0 disabled +select name from information_schema.innodb_metrics where count!=0; +name set global innodb_monitor_enable = "%lock%"; -select name, status from information_schema.innodb_metrics -where name like "%lock%"; -name status -lock_deadlocks enabled -lock_timeouts enabled -lock_rec_lock_waits enabled -lock_table_lock_waits enabled -lock_rec_lock_requests enabled -lock_rec_lock_created enabled -lock_rec_lock_removed enabled -lock_rec_locks enabled -lock_table_lock_created enabled -lock_table_lock_removed enabled -lock_table_locks enabled -lock_row_lock_current_waits enabled -lock_row_lock_time enabled -lock_row_lock_time_max enabled -lock_row_lock_waits enabled -lock_row_lock_time_avg enabled -innodb_rwlock_s_spin_waits enabled -innodb_rwlock_x_spin_waits enabled -innodb_rwlock_s_spin_rounds enabled -innodb_rwlock_x_spin_rounds enabled -innodb_rwlock_s_os_waits enabled -innodb_rwlock_x_os_waits enabled +select name from information_schema.innodb_metrics +where status != IF(name like "%lock%", 'enabled', 'disabled'); +name set global innodb_monitor_disable = "%lock%"; select name, status from information_schema.innodb_metrics where name like "%lock%"; @@ -879,1035 +254,21 @@ innodb_rwlock_x_os_waits disabled set global innodb_monitor_enable = "%lock*"; ERROR 42000: Variable 'innodb_monitor_enable' can't be set to the value of '%lock*' set global innodb_monitor_enable="%%%%%%%%%%%%%%%%%%%%%%%%%%%"; -select name, status from information_schema.innodb_metrics; -name status -metadata_table_handles_opened enabled -metadata_table_handles_closed enabled -metadata_table_reference_count enabled -metadata_mem_pool_size enabled -lock_deadlocks enabled -lock_timeouts enabled -lock_rec_lock_waits enabled -lock_table_lock_waits enabled -lock_rec_lock_requests enabled -lock_rec_lock_created enabled -lock_rec_lock_removed enabled -lock_rec_locks enabled -lock_table_lock_created enabled -lock_table_lock_removed enabled -lock_table_locks enabled -lock_row_lock_current_waits enabled -lock_row_lock_time enabled -lock_row_lock_time_max enabled -lock_row_lock_waits enabled -lock_row_lock_time_avg enabled -buffer_pool_size enabled -buffer_pool_reads enabled -buffer_pool_read_requests enabled -buffer_pool_write_requests enabled -buffer_pool_pages_in_flush enabled -buffer_pool_wait_free enabled -buffer_pool_read_ahead enabled -buffer_pool_read_ahead_evicted enabled -buffer_pool_pages_total enabled -buffer_pool_pages_misc enabled -buffer_pool_pages_data enabled -buffer_pool_pages_dirty enabled -buffer_pool_pages_free enabled -buffer_pages_created enabled -buffer_pages_written enabled -buffer_pages_read enabled -buffer_data_reads enabled -buffer_data_written enabled -buffer_flush_batch_scanned enabled -buffer_flush_batch_num_scan enabled -buffer_flush_batch_scanned_per_call enabled -buffer_flush_batch_total_pages enabled -buffer_flush_batches enabled -buffer_flush_batch_pages enabled -buffer_flush_neighbor_total_pages enabled -buffer_flush_neighbor enabled -buffer_flush_neighbor_pages enabled -buffer_flush_max_dirty_total_pages enabled -buffer_flush_max_dirty enabled -buffer_flush_max_dirty_pages enabled -buffer_flush_adaptive_total_pages enabled -buffer_flush_adaptive enabled -buffer_flush_adaptive_pages enabled -buffer_flush_async_total_pages enabled -buffer_flush_async enabled -buffer_flush_async_pages enabled -buffer_flush_sync_total_pages enabled -buffer_flush_sync enabled -buffer_flush_sync_pages enabled -buffer_flush_background_total_pages enabled -buffer_flush_background enabled -buffer_flush_background_pages enabled -buffer_LRU_batch_scanned enabled -buffer_LRU_batch_num_scan enabled -buffer_LRU_batch_scanned_per_call enabled -buffer_LRU_batch_total_pages enabled -buffer_LRU_batches enabled -buffer_LRU_batch_pages enabled -buffer_LRU_single_flush_scanned enabled -buffer_LRU_single_flush_num_scan enabled -buffer_LRU_single_flush_scanned_per_call enabled -buffer_LRU_single_flush_failure_count enabled -buffer_LRU_get_free_search enabled -buffer_LRU_search_scanned enabled -buffer_LRU_search_num_scan enabled -buffer_LRU_search_scanned_per_call enabled -buffer_LRU_unzip_search_scanned enabled -buffer_LRU_unzip_search_num_scan enabled -buffer_LRU_unzip_search_scanned_per_call enabled -buffer_page_read_index_leaf enabled -buffer_page_read_index_non_leaf enabled -buffer_page_read_index_ibuf_leaf enabled -buffer_page_read_index_ibuf_non_leaf enabled -buffer_page_read_undo_log enabled -buffer_page_read_index_inode enabled -buffer_page_read_ibuf_free_list enabled -buffer_page_read_ibuf_bitmap enabled -buffer_page_read_system_page enabled -buffer_page_read_trx_system enabled -buffer_page_read_fsp_hdr enabled -buffer_page_read_xdes enabled -buffer_page_read_blob enabled -buffer_page_read_zblob enabled -buffer_page_read_zblob2 enabled -buffer_page_read_other enabled -buffer_page_written_index_leaf enabled -buffer_page_written_index_non_leaf enabled -buffer_page_written_index_ibuf_leaf enabled -buffer_page_written_index_ibuf_non_leaf enabled -buffer_page_written_undo_log enabled -buffer_page_written_index_inode enabled -buffer_page_written_ibuf_free_list enabled -buffer_page_written_ibuf_bitmap enabled -buffer_page_written_system_page enabled -buffer_page_written_trx_system enabled -buffer_page_written_fsp_hdr enabled -buffer_page_written_xdes enabled -buffer_page_written_blob enabled -buffer_page_written_zblob enabled -buffer_page_written_zblob2 enabled -buffer_page_written_other enabled -os_data_reads enabled -os_data_writes enabled -os_data_fsyncs enabled -os_pending_reads enabled -os_pending_writes enabled -os_log_bytes_written enabled -os_log_fsyncs enabled -os_log_pending_fsyncs enabled -os_log_pending_writes enabled -trx_rw_commits enabled -trx_ro_commits enabled -trx_nl_ro_commits enabled -trx_commits_insert_update enabled -trx_rollbacks enabled -trx_rollbacks_savepoint enabled -trx_rollback_active enabled -trx_active_transactions enabled -trx_rseg_history_len enabled -trx_undo_slots_used enabled -trx_undo_slots_cached enabled -trx_rseg_current_size enabled -purge_del_mark_records enabled -purge_upd_exist_or_extern_records enabled -purge_invoked enabled -purge_undo_log_pages enabled -purge_dml_delay_usec enabled -purge_stop_count enabled -purge_resume_count enabled -log_checkpoints enabled -log_lsn_last_flush enabled -log_lsn_last_checkpoint enabled -log_lsn_current enabled -log_lsn_checkpoint_age enabled -log_lsn_buf_pool_oldest enabled -log_max_modified_age_async enabled -log_max_modified_age_sync enabled -log_pending_log_writes enabled -log_pending_checkpoint_writes enabled -log_num_log_io enabled -log_waits enabled -log_write_requests enabled -log_writes enabled -compress_pages_compressed enabled -compress_pages_decompressed enabled -index_splits enabled -index_merges enabled -adaptive_hash_searches enabled -adaptive_hash_searches_btree enabled -adaptive_hash_pages_added enabled -adaptive_hash_pages_removed enabled -adaptive_hash_rows_added enabled -adaptive_hash_rows_removed enabled -adaptive_hash_rows_deleted_no_hash_entry enabled -adaptive_hash_rows_updated enabled -file_num_open_files enabled -ibuf_merges_insert enabled -ibuf_merges_delete_mark enabled -ibuf_merges_delete enabled -ibuf_merges_discard_insert enabled -ibuf_merges_discard_delete_mark enabled -ibuf_merges_discard_delete enabled -ibuf_merges enabled -ibuf_size enabled -innodb_master_thread_sleeps enabled -innodb_activity_count enabled -innodb_master_active_loops enabled -innodb_master_idle_loops enabled -innodb_background_drop_table_usec enabled -innodb_ibuf_merge_usec enabled -innodb_log_flush_usec enabled -innodb_mem_validate_usec enabled -innodb_master_purge_usec enabled -innodb_dict_lru_usec enabled -innodb_checkpoint_usec enabled -innodb_dblwr_writes enabled -innodb_dblwr_pages_written enabled -innodb_page_size enabled -innodb_rwlock_s_spin_waits enabled -innodb_rwlock_x_spin_waits enabled -innodb_rwlock_s_spin_rounds enabled -innodb_rwlock_x_spin_rounds enabled -innodb_rwlock_s_os_waits enabled -innodb_rwlock_x_os_waits enabled -dml_reads enabled -dml_inserts enabled -dml_deletes enabled -dml_updates enabled -ddl_background_drop_tables enabled -icp_attempts enabled -icp_no_match enabled -icp_out_of_range enabled -icp_match enabled +select name from information_schema.innodb_metrics where status!='enabled'; +name set global innodb_monitor_disable="%%%%%"; -select name, status from information_schema.innodb_metrics; -name status -metadata_table_handles_opened disabled -metadata_table_handles_closed disabled -metadata_table_reference_count disabled -metadata_mem_pool_size disabled -lock_deadlocks disabled -lock_timeouts disabled -lock_rec_lock_waits disabled -lock_table_lock_waits disabled -lock_rec_lock_requests disabled -lock_rec_lock_created disabled -lock_rec_lock_removed disabled -lock_rec_locks disabled -lock_table_lock_created disabled -lock_table_lock_removed disabled -lock_table_locks disabled -lock_row_lock_current_waits disabled -lock_row_lock_time disabled -lock_row_lock_time_max disabled -lock_row_lock_waits disabled -lock_row_lock_time_avg disabled -buffer_pool_size disabled -buffer_pool_reads disabled -buffer_pool_read_requests disabled -buffer_pool_write_requests disabled -buffer_pool_pages_in_flush disabled -buffer_pool_wait_free disabled -buffer_pool_read_ahead disabled -buffer_pool_read_ahead_evicted disabled -buffer_pool_pages_total disabled -buffer_pool_pages_misc disabled -buffer_pool_pages_data disabled -buffer_pool_pages_dirty disabled -buffer_pool_pages_free disabled -buffer_pages_created disabled -buffer_pages_written disabled -buffer_pages_read disabled -buffer_data_reads disabled -buffer_data_written disabled -buffer_flush_batch_scanned disabled -buffer_flush_batch_num_scan disabled -buffer_flush_batch_scanned_per_call disabled -buffer_flush_batch_total_pages disabled -buffer_flush_batches disabled -buffer_flush_batch_pages disabled -buffer_flush_neighbor_total_pages disabled -buffer_flush_neighbor disabled -buffer_flush_neighbor_pages disabled -buffer_flush_max_dirty_total_pages disabled -buffer_flush_max_dirty disabled -buffer_flush_max_dirty_pages disabled -buffer_flush_adaptive_total_pages disabled -buffer_flush_adaptive disabled -buffer_flush_adaptive_pages disabled -buffer_flush_async_total_pages disabled -buffer_flush_async disabled -buffer_flush_async_pages disabled -buffer_flush_sync_total_pages disabled -buffer_flush_sync disabled -buffer_flush_sync_pages disabled -buffer_flush_background_total_pages disabled -buffer_flush_background disabled -buffer_flush_background_pages disabled -buffer_LRU_batch_scanned disabled -buffer_LRU_batch_num_scan disabled -buffer_LRU_batch_scanned_per_call disabled -buffer_LRU_batch_total_pages disabled -buffer_LRU_batches disabled -buffer_LRU_batch_pages disabled -buffer_LRU_single_flush_scanned disabled -buffer_LRU_single_flush_num_scan disabled -buffer_LRU_single_flush_scanned_per_call disabled -buffer_LRU_single_flush_failure_count disabled -buffer_LRU_get_free_search disabled -buffer_LRU_search_scanned disabled -buffer_LRU_search_num_scan disabled -buffer_LRU_search_scanned_per_call disabled -buffer_LRU_unzip_search_scanned disabled -buffer_LRU_unzip_search_num_scan disabled -buffer_LRU_unzip_search_scanned_per_call disabled -buffer_page_read_index_leaf disabled -buffer_page_read_index_non_leaf disabled -buffer_page_read_index_ibuf_leaf disabled -buffer_page_read_index_ibuf_non_leaf disabled -buffer_page_read_undo_log disabled -buffer_page_read_index_inode disabled -buffer_page_read_ibuf_free_list disabled -buffer_page_read_ibuf_bitmap disabled -buffer_page_read_system_page disabled -buffer_page_read_trx_system disabled -buffer_page_read_fsp_hdr disabled -buffer_page_read_xdes disabled -buffer_page_read_blob disabled -buffer_page_read_zblob disabled -buffer_page_read_zblob2 disabled -buffer_page_read_other disabled -buffer_page_written_index_leaf disabled -buffer_page_written_index_non_leaf disabled -buffer_page_written_index_ibuf_leaf disabled -buffer_page_written_index_ibuf_non_leaf disabled -buffer_page_written_undo_log disabled -buffer_page_written_index_inode disabled -buffer_page_written_ibuf_free_list disabled -buffer_page_written_ibuf_bitmap disabled -buffer_page_written_system_page disabled -buffer_page_written_trx_system disabled -buffer_page_written_fsp_hdr disabled -buffer_page_written_xdes disabled -buffer_page_written_blob disabled -buffer_page_written_zblob disabled -buffer_page_written_zblob2 disabled -buffer_page_written_other disabled -os_data_reads disabled -os_data_writes disabled -os_data_fsyncs disabled -os_pending_reads disabled -os_pending_writes disabled -os_log_bytes_written disabled -os_log_fsyncs disabled -os_log_pending_fsyncs disabled -os_log_pending_writes disabled -trx_rw_commits disabled -trx_ro_commits disabled -trx_nl_ro_commits disabled -trx_commits_insert_update disabled -trx_rollbacks disabled -trx_rollbacks_savepoint disabled -trx_rollback_active disabled -trx_active_transactions disabled -trx_rseg_history_len disabled -trx_undo_slots_used disabled -trx_undo_slots_cached disabled -trx_rseg_current_size disabled -purge_del_mark_records disabled -purge_upd_exist_or_extern_records disabled -purge_invoked disabled -purge_undo_log_pages disabled -purge_dml_delay_usec disabled -purge_stop_count disabled -purge_resume_count disabled -log_checkpoints disabled -log_lsn_last_flush disabled -log_lsn_last_checkpoint disabled -log_lsn_current disabled -log_lsn_checkpoint_age disabled -log_lsn_buf_pool_oldest disabled -log_max_modified_age_async disabled -log_max_modified_age_sync disabled -log_pending_log_writes disabled -log_pending_checkpoint_writes disabled -log_num_log_io disabled -log_waits disabled -log_write_requests disabled -log_writes disabled -compress_pages_compressed disabled -compress_pages_decompressed disabled -index_splits disabled -index_merges disabled -adaptive_hash_searches disabled -adaptive_hash_searches_btree disabled -adaptive_hash_pages_added disabled -adaptive_hash_pages_removed disabled -adaptive_hash_rows_added disabled -adaptive_hash_rows_removed disabled -adaptive_hash_rows_deleted_no_hash_entry disabled -adaptive_hash_rows_updated disabled -file_num_open_files disabled -ibuf_merges_insert disabled -ibuf_merges_delete_mark disabled -ibuf_merges_delete disabled -ibuf_merges_discard_insert disabled -ibuf_merges_discard_delete_mark disabled -ibuf_merges_discard_delete disabled -ibuf_merges disabled -ibuf_size disabled -innodb_master_thread_sleeps disabled -innodb_activity_count disabled -innodb_master_active_loops disabled -innodb_master_idle_loops disabled -innodb_background_drop_table_usec disabled -innodb_ibuf_merge_usec disabled -innodb_log_flush_usec disabled -innodb_mem_validate_usec disabled -innodb_master_purge_usec disabled -innodb_dict_lru_usec disabled -innodb_checkpoint_usec disabled -innodb_dblwr_writes disabled -innodb_dblwr_pages_written disabled -innodb_page_size disabled -innodb_rwlock_s_spin_waits disabled -innodb_rwlock_x_spin_waits disabled -innodb_rwlock_s_spin_rounds disabled -innodb_rwlock_x_spin_rounds disabled -innodb_rwlock_s_os_waits disabled -innodb_rwlock_x_os_waits disabled -dml_reads disabled -dml_inserts disabled -dml_deletes disabled -dml_updates disabled -ddl_background_drop_tables disabled -icp_attempts disabled -icp_no_match disabled -icp_out_of_range disabled -icp_match disabled +select name from information_schema.innodb_metrics where status!='disabled'; +name set global innodb_monitor_enable="%"; -select name, status from information_schema.innodb_metrics; -name status -metadata_table_handles_opened enabled -metadata_table_handles_closed enabled -metadata_table_reference_count enabled -metadata_mem_pool_size enabled -lock_deadlocks enabled -lock_timeouts enabled -lock_rec_lock_waits enabled -lock_table_lock_waits enabled -lock_rec_lock_requests enabled -lock_rec_lock_created enabled -lock_rec_lock_removed enabled -lock_rec_locks enabled -lock_table_lock_created enabled -lock_table_lock_removed enabled -lock_table_locks enabled -lock_row_lock_current_waits enabled -lock_row_lock_time enabled -lock_row_lock_time_max enabled -lock_row_lock_waits enabled -lock_row_lock_time_avg enabled -buffer_pool_size enabled -buffer_pool_reads enabled -buffer_pool_read_requests enabled -buffer_pool_write_requests enabled -buffer_pool_pages_in_flush enabled -buffer_pool_wait_free enabled -buffer_pool_read_ahead enabled -buffer_pool_read_ahead_evicted enabled -buffer_pool_pages_total enabled -buffer_pool_pages_misc enabled -buffer_pool_pages_data enabled -buffer_pool_pages_dirty enabled -buffer_pool_pages_free enabled -buffer_pages_created enabled -buffer_pages_written enabled -buffer_pages_read enabled -buffer_data_reads enabled -buffer_data_written enabled -buffer_flush_batch_scanned enabled -buffer_flush_batch_num_scan enabled -buffer_flush_batch_scanned_per_call enabled -buffer_flush_batch_total_pages enabled -buffer_flush_batches enabled -buffer_flush_batch_pages enabled -buffer_flush_neighbor_total_pages enabled -buffer_flush_neighbor enabled -buffer_flush_neighbor_pages enabled -buffer_flush_max_dirty_total_pages enabled -buffer_flush_max_dirty enabled -buffer_flush_max_dirty_pages enabled -buffer_flush_adaptive_total_pages enabled -buffer_flush_adaptive enabled -buffer_flush_adaptive_pages enabled -buffer_flush_async_total_pages enabled -buffer_flush_async enabled -buffer_flush_async_pages enabled -buffer_flush_sync_total_pages enabled -buffer_flush_sync enabled -buffer_flush_sync_pages enabled -buffer_flush_background_total_pages enabled -buffer_flush_background enabled -buffer_flush_background_pages enabled -buffer_LRU_batch_scanned enabled -buffer_LRU_batch_num_scan enabled -buffer_LRU_batch_scanned_per_call enabled -buffer_LRU_batch_total_pages enabled -buffer_LRU_batches enabled -buffer_LRU_batch_pages enabled -buffer_LRU_single_flush_scanned enabled -buffer_LRU_single_flush_num_scan enabled -buffer_LRU_single_flush_scanned_per_call enabled -buffer_LRU_single_flush_failure_count enabled -buffer_LRU_get_free_search enabled -buffer_LRU_search_scanned enabled -buffer_LRU_search_num_scan enabled -buffer_LRU_search_scanned_per_call enabled -buffer_LRU_unzip_search_scanned enabled -buffer_LRU_unzip_search_num_scan enabled -buffer_LRU_unzip_search_scanned_per_call enabled -buffer_page_read_index_leaf enabled -buffer_page_read_index_non_leaf enabled -buffer_page_read_index_ibuf_leaf enabled -buffer_page_read_index_ibuf_non_leaf enabled -buffer_page_read_undo_log enabled -buffer_page_read_index_inode enabled -buffer_page_read_ibuf_free_list enabled -buffer_page_read_ibuf_bitmap enabled -buffer_page_read_system_page enabled -buffer_page_read_trx_system enabled -buffer_page_read_fsp_hdr enabled -buffer_page_read_xdes enabled -buffer_page_read_blob enabled -buffer_page_read_zblob enabled -buffer_page_read_zblob2 enabled -buffer_page_read_other enabled -buffer_page_written_index_leaf enabled -buffer_page_written_index_non_leaf enabled -buffer_page_written_index_ibuf_leaf enabled -buffer_page_written_index_ibuf_non_leaf enabled -buffer_page_written_undo_log enabled -buffer_page_written_index_inode enabled -buffer_page_written_ibuf_free_list enabled -buffer_page_written_ibuf_bitmap enabled -buffer_page_written_system_page enabled -buffer_page_written_trx_system enabled -buffer_page_written_fsp_hdr enabled -buffer_page_written_xdes enabled -buffer_page_written_blob enabled -buffer_page_written_zblob enabled -buffer_page_written_zblob2 enabled -buffer_page_written_other enabled -os_data_reads enabled -os_data_writes enabled -os_data_fsyncs enabled -os_pending_reads enabled -os_pending_writes enabled -os_log_bytes_written enabled -os_log_fsyncs enabled -os_log_pending_fsyncs enabled -os_log_pending_writes enabled -trx_rw_commits enabled -trx_ro_commits enabled -trx_nl_ro_commits enabled -trx_commits_insert_update enabled -trx_rollbacks enabled -trx_rollbacks_savepoint enabled -trx_rollback_active enabled -trx_active_transactions enabled -trx_rseg_history_len enabled -trx_undo_slots_used enabled -trx_undo_slots_cached enabled -trx_rseg_current_size enabled -purge_del_mark_records enabled -purge_upd_exist_or_extern_records enabled -purge_invoked enabled -purge_undo_log_pages enabled -purge_dml_delay_usec enabled -purge_stop_count enabled -purge_resume_count enabled -log_checkpoints enabled -log_lsn_last_flush enabled -log_lsn_last_checkpoint enabled -log_lsn_current enabled -log_lsn_checkpoint_age enabled -log_lsn_buf_pool_oldest enabled -log_max_modified_age_async enabled -log_max_modified_age_sync enabled -log_pending_log_writes enabled -log_pending_checkpoint_writes enabled -log_num_log_io enabled -log_waits enabled -log_write_requests enabled -log_writes enabled -compress_pages_compressed enabled -compress_pages_decompressed enabled -index_splits enabled -index_merges enabled -adaptive_hash_searches enabled -adaptive_hash_searches_btree enabled -adaptive_hash_pages_added enabled -adaptive_hash_pages_removed enabled -adaptive_hash_rows_added enabled -adaptive_hash_rows_removed enabled -adaptive_hash_rows_deleted_no_hash_entry enabled -adaptive_hash_rows_updated enabled -file_num_open_files enabled -ibuf_merges_insert enabled -ibuf_merges_delete_mark enabled -ibuf_merges_delete enabled -ibuf_merges_discard_insert enabled -ibuf_merges_discard_delete_mark enabled -ibuf_merges_discard_delete enabled -ibuf_merges enabled -ibuf_size enabled -innodb_master_thread_sleeps enabled -innodb_activity_count enabled -innodb_master_active_loops enabled -innodb_master_idle_loops enabled -innodb_background_drop_table_usec enabled -innodb_ibuf_merge_usec enabled -innodb_log_flush_usec enabled -innodb_mem_validate_usec enabled -innodb_master_purge_usec enabled -innodb_dict_lru_usec enabled -innodb_checkpoint_usec enabled -innodb_dblwr_writes enabled -innodb_dblwr_pages_written enabled -innodb_page_size enabled -innodb_rwlock_s_spin_waits enabled -innodb_rwlock_x_spin_waits enabled -innodb_rwlock_s_spin_rounds enabled -innodb_rwlock_x_spin_rounds enabled -innodb_rwlock_s_os_waits enabled -innodb_rwlock_x_os_waits enabled -dml_reads enabled -dml_inserts enabled -dml_deletes enabled -dml_updates enabled -ddl_background_drop_tables enabled -icp_attempts enabled -icp_no_match enabled -icp_out_of_range enabled -icp_match enabled +select name from information_schema.innodb_metrics where status!='enabled'; +name set global innodb_monitor_disable="%_%"; -select name, status from information_schema.innodb_metrics; -name status -metadata_table_handles_opened disabled -metadata_table_handles_closed disabled -metadata_table_reference_count disabled -metadata_mem_pool_size disabled -lock_deadlocks disabled -lock_timeouts disabled -lock_rec_lock_waits disabled -lock_table_lock_waits disabled -lock_rec_lock_requests disabled -lock_rec_lock_created disabled -lock_rec_lock_removed disabled -lock_rec_locks disabled -lock_table_lock_created disabled -lock_table_lock_removed disabled -lock_table_locks disabled -lock_row_lock_current_waits disabled -lock_row_lock_time disabled -lock_row_lock_time_max disabled -lock_row_lock_waits disabled -lock_row_lock_time_avg disabled -buffer_pool_size disabled -buffer_pool_reads disabled -buffer_pool_read_requests disabled -buffer_pool_write_requests disabled -buffer_pool_pages_in_flush disabled -buffer_pool_wait_free disabled -buffer_pool_read_ahead disabled -buffer_pool_read_ahead_evicted disabled -buffer_pool_pages_total disabled -buffer_pool_pages_misc disabled -buffer_pool_pages_data disabled -buffer_pool_pages_dirty disabled -buffer_pool_pages_free disabled -buffer_pages_created disabled -buffer_pages_written disabled -buffer_pages_read disabled -buffer_data_reads disabled -buffer_data_written disabled -buffer_flush_batch_scanned disabled -buffer_flush_batch_num_scan disabled -buffer_flush_batch_scanned_per_call disabled -buffer_flush_batch_total_pages disabled -buffer_flush_batches disabled -buffer_flush_batch_pages disabled -buffer_flush_neighbor_total_pages disabled -buffer_flush_neighbor disabled -buffer_flush_neighbor_pages disabled -buffer_flush_max_dirty_total_pages disabled -buffer_flush_max_dirty disabled -buffer_flush_max_dirty_pages disabled -buffer_flush_adaptive_total_pages disabled -buffer_flush_adaptive disabled -buffer_flush_adaptive_pages disabled -buffer_flush_async_total_pages disabled -buffer_flush_async disabled -buffer_flush_async_pages disabled -buffer_flush_sync_total_pages disabled -buffer_flush_sync disabled -buffer_flush_sync_pages disabled -buffer_flush_background_total_pages disabled -buffer_flush_background disabled -buffer_flush_background_pages disabled -buffer_LRU_batch_scanned disabled -buffer_LRU_batch_num_scan disabled -buffer_LRU_batch_scanned_per_call disabled -buffer_LRU_batch_total_pages disabled -buffer_LRU_batches disabled -buffer_LRU_batch_pages disabled -buffer_LRU_single_flush_scanned disabled -buffer_LRU_single_flush_num_scan disabled -buffer_LRU_single_flush_scanned_per_call disabled -buffer_LRU_single_flush_failure_count disabled -buffer_LRU_get_free_search disabled -buffer_LRU_search_scanned disabled -buffer_LRU_search_num_scan disabled -buffer_LRU_search_scanned_per_call disabled -buffer_LRU_unzip_search_scanned disabled -buffer_LRU_unzip_search_num_scan disabled -buffer_LRU_unzip_search_scanned_per_call disabled -buffer_page_read_index_leaf disabled -buffer_page_read_index_non_leaf disabled -buffer_page_read_index_ibuf_leaf disabled -buffer_page_read_index_ibuf_non_leaf disabled -buffer_page_read_undo_log disabled -buffer_page_read_index_inode disabled -buffer_page_read_ibuf_free_list disabled -buffer_page_read_ibuf_bitmap disabled -buffer_page_read_system_page disabled -buffer_page_read_trx_system disabled -buffer_page_read_fsp_hdr disabled -buffer_page_read_xdes disabled -buffer_page_read_blob disabled -buffer_page_read_zblob disabled -buffer_page_read_zblob2 disabled -buffer_page_read_other disabled -buffer_page_written_index_leaf disabled -buffer_page_written_index_non_leaf disabled -buffer_page_written_index_ibuf_leaf disabled -buffer_page_written_index_ibuf_non_leaf disabled -buffer_page_written_undo_log disabled -buffer_page_written_index_inode disabled -buffer_page_written_ibuf_free_list disabled -buffer_page_written_ibuf_bitmap disabled -buffer_page_written_system_page disabled -buffer_page_written_trx_system disabled -buffer_page_written_fsp_hdr disabled -buffer_page_written_xdes disabled -buffer_page_written_blob disabled -buffer_page_written_zblob disabled -buffer_page_written_zblob2 disabled -buffer_page_written_other disabled -os_data_reads disabled -os_data_writes disabled -os_data_fsyncs disabled -os_pending_reads disabled -os_pending_writes disabled -os_log_bytes_written disabled -os_log_fsyncs disabled -os_log_pending_fsyncs disabled -os_log_pending_writes disabled -trx_rw_commits disabled -trx_ro_commits disabled -trx_nl_ro_commits disabled -trx_commits_insert_update disabled -trx_rollbacks disabled -trx_rollbacks_savepoint disabled -trx_rollback_active disabled -trx_active_transactions disabled -trx_rseg_history_len disabled -trx_undo_slots_used disabled -trx_undo_slots_cached disabled -trx_rseg_current_size disabled -purge_del_mark_records disabled -purge_upd_exist_or_extern_records disabled -purge_invoked disabled -purge_undo_log_pages disabled -purge_dml_delay_usec disabled -purge_stop_count disabled -purge_resume_count disabled -log_checkpoints disabled -log_lsn_last_flush disabled -log_lsn_last_checkpoint disabled -log_lsn_current disabled -log_lsn_checkpoint_age disabled -log_lsn_buf_pool_oldest disabled -log_max_modified_age_async disabled -log_max_modified_age_sync disabled -log_pending_log_writes disabled -log_pending_checkpoint_writes disabled -log_num_log_io disabled -log_waits disabled -log_write_requests disabled -log_writes disabled -compress_pages_compressed disabled -compress_pages_decompressed disabled -index_splits disabled -index_merges disabled -adaptive_hash_searches disabled -adaptive_hash_searches_btree disabled -adaptive_hash_pages_added disabled -adaptive_hash_pages_removed disabled -adaptive_hash_rows_added disabled -adaptive_hash_rows_removed disabled -adaptive_hash_rows_deleted_no_hash_entry disabled -adaptive_hash_rows_updated disabled -file_num_open_files disabled -ibuf_merges_insert disabled -ibuf_merges_delete_mark disabled -ibuf_merges_delete disabled -ibuf_merges_discard_insert disabled -ibuf_merges_discard_delete_mark disabled -ibuf_merges_discard_delete disabled -ibuf_merges disabled -ibuf_size disabled -innodb_master_thread_sleeps disabled -innodb_activity_count disabled -innodb_master_active_loops disabled -innodb_master_idle_loops disabled -innodb_background_drop_table_usec disabled -innodb_ibuf_merge_usec disabled -innodb_log_flush_usec disabled -innodb_mem_validate_usec disabled -innodb_master_purge_usec disabled -innodb_dict_lru_usec disabled -innodb_checkpoint_usec disabled -innodb_dblwr_writes disabled -innodb_dblwr_pages_written disabled -innodb_page_size disabled -innodb_rwlock_s_spin_waits disabled -innodb_rwlock_x_spin_waits disabled -innodb_rwlock_s_spin_rounds disabled -innodb_rwlock_x_spin_rounds disabled -innodb_rwlock_s_os_waits disabled -innodb_rwlock_x_os_waits disabled -dml_reads disabled -dml_inserts disabled -dml_deletes disabled -dml_updates disabled -ddl_background_drop_tables disabled -icp_attempts disabled -icp_no_match disabled -icp_out_of_range disabled -icp_match disabled +select name from information_schema.innodb_metrics where status!='disabled'; +name set global innodb_monitor_enable="log%%%%"; -select name, status from information_schema.innodb_metrics; -name status -metadata_table_handles_opened disabled -metadata_table_handles_closed disabled -metadata_table_reference_count disabled -metadata_mem_pool_size disabled -lock_deadlocks disabled -lock_timeouts disabled -lock_rec_lock_waits disabled -lock_table_lock_waits disabled -lock_rec_lock_requests disabled -lock_rec_lock_created disabled -lock_rec_lock_removed disabled -lock_rec_locks disabled -lock_table_lock_created disabled -lock_table_lock_removed disabled -lock_table_locks disabled -lock_row_lock_current_waits disabled -lock_row_lock_time disabled -lock_row_lock_time_max disabled -lock_row_lock_waits disabled -lock_row_lock_time_avg disabled -buffer_pool_size disabled -buffer_pool_reads disabled -buffer_pool_read_requests disabled -buffer_pool_write_requests disabled -buffer_pool_pages_in_flush disabled -buffer_pool_wait_free disabled -buffer_pool_read_ahead disabled -buffer_pool_read_ahead_evicted disabled -buffer_pool_pages_total disabled -buffer_pool_pages_misc disabled -buffer_pool_pages_data disabled -buffer_pool_pages_dirty disabled -buffer_pool_pages_free disabled -buffer_pages_created disabled -buffer_pages_written disabled -buffer_pages_read disabled -buffer_data_reads disabled -buffer_data_written disabled -buffer_flush_batch_scanned disabled -buffer_flush_batch_num_scan disabled -buffer_flush_batch_scanned_per_call disabled -buffer_flush_batch_total_pages disabled -buffer_flush_batches disabled -buffer_flush_batch_pages disabled -buffer_flush_neighbor_total_pages disabled -buffer_flush_neighbor disabled -buffer_flush_neighbor_pages disabled -buffer_flush_max_dirty_total_pages disabled -buffer_flush_max_dirty disabled -buffer_flush_max_dirty_pages disabled -buffer_flush_adaptive_total_pages disabled -buffer_flush_adaptive disabled -buffer_flush_adaptive_pages disabled -buffer_flush_async_total_pages disabled -buffer_flush_async disabled -buffer_flush_async_pages disabled -buffer_flush_sync_total_pages disabled -buffer_flush_sync disabled -buffer_flush_sync_pages disabled -buffer_flush_background_total_pages disabled -buffer_flush_background disabled -buffer_flush_background_pages disabled -buffer_LRU_batch_scanned disabled -buffer_LRU_batch_num_scan disabled -buffer_LRU_batch_scanned_per_call disabled -buffer_LRU_batch_total_pages disabled -buffer_LRU_batches disabled -buffer_LRU_batch_pages disabled -buffer_LRU_single_flush_scanned disabled -buffer_LRU_single_flush_num_scan disabled -buffer_LRU_single_flush_scanned_per_call disabled -buffer_LRU_single_flush_failure_count disabled -buffer_LRU_get_free_search disabled -buffer_LRU_search_scanned disabled -buffer_LRU_search_num_scan disabled -buffer_LRU_search_scanned_per_call disabled -buffer_LRU_unzip_search_scanned disabled -buffer_LRU_unzip_search_num_scan disabled -buffer_LRU_unzip_search_scanned_per_call disabled -buffer_page_read_index_leaf disabled -buffer_page_read_index_non_leaf disabled -buffer_page_read_index_ibuf_leaf disabled -buffer_page_read_index_ibuf_non_leaf disabled -buffer_page_read_undo_log disabled -buffer_page_read_index_inode disabled -buffer_page_read_ibuf_free_list disabled -buffer_page_read_ibuf_bitmap disabled -buffer_page_read_system_page disabled -buffer_page_read_trx_system disabled -buffer_page_read_fsp_hdr disabled -buffer_page_read_xdes disabled -buffer_page_read_blob disabled -buffer_page_read_zblob disabled -buffer_page_read_zblob2 disabled -buffer_page_read_other disabled -buffer_page_written_index_leaf disabled -buffer_page_written_index_non_leaf disabled -buffer_page_written_index_ibuf_leaf disabled -buffer_page_written_index_ibuf_non_leaf disabled -buffer_page_written_undo_log disabled -buffer_page_written_index_inode disabled -buffer_page_written_ibuf_free_list disabled -buffer_page_written_ibuf_bitmap disabled -buffer_page_written_system_page disabled -buffer_page_written_trx_system disabled -buffer_page_written_fsp_hdr disabled -buffer_page_written_xdes disabled -buffer_page_written_blob disabled -buffer_page_written_zblob disabled -buffer_page_written_zblob2 disabled -buffer_page_written_other disabled -os_data_reads disabled -os_data_writes disabled -os_data_fsyncs disabled -os_pending_reads disabled -os_pending_writes disabled -os_log_bytes_written disabled -os_log_fsyncs disabled -os_log_pending_fsyncs disabled -os_log_pending_writes disabled -trx_rw_commits disabled -trx_ro_commits disabled -trx_nl_ro_commits disabled -trx_commits_insert_update disabled -trx_rollbacks disabled -trx_rollbacks_savepoint disabled -trx_rollback_active disabled -trx_active_transactions disabled -trx_rseg_history_len disabled -trx_undo_slots_used disabled -trx_undo_slots_cached disabled -trx_rseg_current_size disabled -purge_del_mark_records disabled -purge_upd_exist_or_extern_records disabled -purge_invoked disabled -purge_undo_log_pages disabled -purge_dml_delay_usec disabled -purge_stop_count disabled -purge_resume_count disabled -log_checkpoints enabled -log_lsn_last_flush enabled -log_lsn_last_checkpoint enabled -log_lsn_current enabled -log_lsn_checkpoint_age enabled -log_lsn_buf_pool_oldest enabled -log_max_modified_age_async enabled -log_max_modified_age_sync enabled -log_pending_log_writes enabled -log_pending_checkpoint_writes enabled -log_num_log_io enabled -log_waits enabled -log_write_requests enabled -log_writes enabled -compress_pages_compressed disabled -compress_pages_decompressed disabled -index_splits disabled -index_merges disabled -adaptive_hash_searches disabled -adaptive_hash_searches_btree disabled -adaptive_hash_pages_added disabled -adaptive_hash_pages_removed disabled -adaptive_hash_rows_added disabled -adaptive_hash_rows_removed disabled -adaptive_hash_rows_deleted_no_hash_entry disabled -adaptive_hash_rows_updated disabled -file_num_open_files disabled -ibuf_merges_insert disabled -ibuf_merges_delete_mark disabled -ibuf_merges_delete disabled -ibuf_merges_discard_insert disabled -ibuf_merges_discard_delete_mark disabled -ibuf_merges_discard_delete disabled -ibuf_merges disabled -ibuf_size disabled -innodb_master_thread_sleeps disabled -innodb_activity_count disabled -innodb_master_active_loops disabled -innodb_master_idle_loops disabled -innodb_background_drop_table_usec disabled -innodb_ibuf_merge_usec disabled -innodb_log_flush_usec disabled -innodb_mem_validate_usec disabled -innodb_master_purge_usec disabled -innodb_dict_lru_usec disabled -innodb_checkpoint_usec disabled -innodb_dblwr_writes disabled -innodb_dblwr_pages_written disabled -innodb_page_size disabled -innodb_rwlock_s_spin_waits disabled -innodb_rwlock_x_spin_waits disabled -innodb_rwlock_s_spin_rounds disabled -innodb_rwlock_x_spin_rounds disabled -innodb_rwlock_s_os_waits disabled -innodb_rwlock_x_os_waits disabled -dml_reads disabled -dml_inserts disabled -dml_deletes disabled -dml_updates disabled -ddl_background_drop_tables disabled -icp_attempts disabled -icp_no_match disabled -icp_out_of_range disabled -icp_match disabled +select name from information_schema.innodb_metrics +where status != IF(name like "log%", 'enabled', 'disabled'); +name set global innodb_monitor_enable="os_%a_fs_ncs"; set global innodb_monitor_enable="os%pending%"; select name, status from information_schema.innodb_metrics @@ -1989,7 +350,7 @@ name max_count min_count count max_count_reset min_count_reset count_reset statu metadata_table_handles_opened NULL NULL 0 NULL NULL 0 disabled set global innodb_monitor_enable = metadata_table_handles_opened; drop table monitor_test; -create table monitor_test(col int) engine = innodb; +create table monitor_test(col int) engine = innodb stats_persistent=0; select * from monitor_test; col select name, max_count, min_count, count, @@ -2146,7 +507,7 @@ max_count_reset, min_count_reset, count_reset, status from information_schema.innodb_metrics where name like "file_num_open_files"; name max_count min_count count max_count_reset min_count_reset count_reset status -file_num_open_files 3 3 3 3 3 3 enabled +file_num_open_files # # # # # # enabled set global innodb_monitor_disable = file_num_open_files; set global innodb_monitor_enable = "icp%"; create table monitor_test(a char(3), b int, c char(2), |