diff options
Diffstat (limited to 'mysql-test/suite/sys_vars/r/innodb_monitor_disable_basic.result')
-rw-r--r-- | mysql-test/suite/sys_vars/r/innodb_monitor_disable_basic.result | 2180 |
1 files changed, 2180 insertions, 0 deletions
diff --git a/mysql-test/suite/sys_vars/r/innodb_monitor_disable_basic.result b/mysql-test/suite/sys_vars/r/innodb_monitor_disable_basic.result new file mode 100644 index 00000000000..8bb508c877e --- /dev/null +++ b/mysql-test/suite/sys_vars/r/innodb_monitor_disable_basic.result @@ -0,0 +1,2180 @@ +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 +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 +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 +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 +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 +set global innodb_monitor_disable = "%lock%"; +select name, status from information_schema.innodb_metrics +where name like "%lock%"; +name status +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 +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 +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 +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 +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 +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 +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 +set global innodb_monitor_enable="os_%a_fs_ncs"; +set global innodb_monitor_enable="os%pending%"; +select name, status from information_schema.innodb_metrics +where name like "os%"; +name status +os_data_reads disabled +os_data_writes disabled +os_data_fsyncs enabled +os_pending_reads enabled +os_pending_writes enabled +os_log_bytes_written disabled +os_log_fsyncs disabled +os_log_pending_fsyncs enabled +os_log_pending_writes enabled +set global innodb_monitor_enable=""; +ERROR 42000: Variable 'innodb_monitor_enable' can't be set to the value of '' +set global innodb_monitor_enable="_"; +ERROR 42000: Variable 'innodb_monitor_enable' can't be set to the value of '_' +SET global innodb_monitor_disable = module_metadata; +SET global innodb_monitor_reset_all = module_metadata; +set global innodb_monitor_enable = metadata_table_handles_opened; +create table monitor_test(col int) engine = innodb; +select * from monitor_test; +col +select name, max_count, min_count, count, +max_count_reset, min_count_reset, count_reset, status +from information_schema.innodb_metrics +where name = "metadata_table_handles_opened"; +name max_count min_count count max_count_reset min_count_reset count_reset status +metadata_table_handles_opened 1 NULL 1 1 NULL 1 enabled +set global innodb_monitor_reset = metadata_table_handles_opened; +select name, max_count, min_count, count, +max_count_reset, min_count_reset, count_reset, status +from information_schema.innodb_metrics +where name = "metadata_table_handles_opened"; +name max_count min_count count max_count_reset min_count_reset count_reset status +metadata_table_handles_opened 1 NULL 1 NULL NULL 0 enabled +drop table monitor_test; +create table monitor_test(col int) engine = innodb; +select * from monitor_test; +col +select name, max_count, min_count, count, +max_count_reset, min_count_reset, count_reset, status +from information_schema.innodb_metrics +where name = "metadata_table_handles_opened"; +name max_count min_count count max_count_reset min_count_reset count_reset status +metadata_table_handles_opened 2 NULL 2 1 NULL 1 enabled +set global innodb_monitor_reset_all = metadata_table_handles_opened; +select name, max_count, min_count, count, +max_count_reset, min_count_reset, count_reset, status +from information_schema.innodb_metrics +where name = "metadata_table_handles_opened"; +name max_count min_count count max_count_reset min_count_reset count_reset status +metadata_table_handles_opened 2 NULL 2 1 NULL 1 enabled +set global innodb_monitor_disable = metadata_table_handles_opened; +set global innodb_monitor_reset = metadata_table_handles_opened; +select name, max_count, min_count, count, +max_count_reset, min_count_reset, count_reset, status +from information_schema.innodb_metrics +where name = "metadata_table_handles_opened"; +name max_count min_count count max_count_reset min_count_reset count_reset status +metadata_table_handles_opened 2 NULL 2 NULL NULL 0 disabled +drop table monitor_test; +create table monitor_test(col int) engine = innodb; +select * from monitor_test; +col +select name, max_count, min_count, count, +max_count_reset, min_count_reset, count_reset, status +from information_schema.innodb_metrics +where name = "metadata_table_handles_opened"; +name max_count min_count count max_count_reset min_count_reset count_reset status +metadata_table_handles_opened 2 NULL 2 NULL NULL 0 disabled +set global innodb_monitor_reset_all = metadata_table_handles_opened; +select name, max_count, min_count, count, +max_count_reset, min_count_reset, count_reset, status +from information_schema.innodb_metrics +where name = "metadata_table_handles_opened"; +name max_count min_count count max_count_reset min_count_reset count_reset status +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; +select * from monitor_test; +col +select name, max_count, min_count, count, +max_count_reset, min_count_reset, count_reset, status +from information_schema.innodb_metrics +where name = "metadata_table_handles_opened"; +name max_count min_count count max_count_reset min_count_reset count_reset status +metadata_table_handles_opened 1 NULL 1 1 NULL 1 enabled +set global innodb_monitor_enable = metadata_table_handles_closed; +create index idx on monitor_test(col); +select name, max_count, min_count, count, +max_count_reset, min_count_reset, count_reset, status +from information_schema.innodb_metrics +where name = "metadata_table_handles_closed"; +name max_count min_count count max_count_reset min_count_reset count_reset status +metadata_table_handles_closed 1 NULL 1 1 NULL 1 enabled +select name, max_count, min_count, count, +max_count_reset, min_count_reset, count_reset, status +from information_schema.innodb_metrics +where name like "metadata%"; +name max_count min_count count max_count_reset min_count_reset count_reset status +metadata_table_handles_opened 2 NULL 2 2 NULL 2 enabled +metadata_table_handles_closed 1 NULL 1 1 NULL 1 enabled +metadata_table_reference_count NULL NULL 0 NULL NULL 0 disabled +metadata_mem_pool_size NULL NULL 0 NULL NULL 0 disabled +set global innodb_monitor_disable = module_metadata; +set global innodb_monitor_reset = module_metadata; +select name, max_count, min_count, count, +max_count_reset, min_count_reset, count_reset, status +from information_schema.innodb_metrics +where name like "metadata%"; +name max_count min_count count max_count_reset min_count_reset count_reset status +metadata_table_handles_opened 2 NULL 2 NULL NULL 0 disabled +metadata_table_handles_closed 1 NULL 1 NULL NULL 0 disabled +metadata_table_reference_count NULL NULL 0 NULL NULL 0 disabled +metadata_mem_pool_size NULL NULL 0 NULL NULL 0 disabled +set global innodb_monitor_reset_all = module_metadata; +select name, max_count, min_count, count, +max_count_reset, min_count_reset, count_reset, status +from information_schema.innodb_metrics +where name like "metadata%"; +name max_count min_count count max_count_reset min_count_reset count_reset status +metadata_table_handles_opened NULL NULL 0 NULL NULL 0 disabled +metadata_table_handles_closed NULL NULL 0 NULL NULL 0 disabled +metadata_table_reference_count NULL NULL 0 NULL NULL 0 disabled +metadata_mem_pool_size NULL NULL 0 NULL NULL 0 disabled +set global innodb_monitor_enable = module_trx; +begin; +insert into monitor_test values(9); +commit; +begin; +insert into monitor_test values(9); +rollback; +select name, max_count, min_count, count, +max_count_reset, min_count_reset, count_reset, status +from information_schema.innodb_metrics +where name like "trx_rollbacks" or name like "trx_active_transactions"; +name max_count min_count count max_count_reset min_count_reset count_reset status +trx_rollbacks 1 NULL 1 1 NULL 1 enabled +trx_active_transactions 1 0 0 1 0 0 enabled +set global innodb_monitor_disable = module_trx; +set global innodb_monitor_enable = module_dml; +insert into monitor_test values(9); +update monitor_test set col = 10 where col = 9; +select name, max_count, min_count, count, +max_count_reset, min_count_reset, count_reset, status +from information_schema.innodb_metrics +where name like "dml%"; +name max_count min_count count max_count_reset min_count_reset count_reset status +dml_reads 4 NULL 4 4 NULL 4 enabled +dml_inserts 1 NULL 1 1 NULL 1 enabled +dml_deletes 0 NULL 0 0 NULL 0 enabled +dml_updates 2 NULL 2 2 NULL 2 enabled +delete from monitor_test; +select name, max_count, min_count, count, +max_count_reset, min_count_reset, count_reset, status +from information_schema.innodb_metrics +where name like "dml%"; +name max_count min_count count max_count_reset min_count_reset count_reset status +dml_reads 6 NULL 6 6 NULL 6 enabled +dml_inserts 1 NULL 1 1 NULL 1 enabled +dml_deletes 2 NULL 2 2 NULL 2 enabled +dml_updates 2 NULL 2 2 NULL 2 enabled +set global innodb_monitor_reset = module_dml; +select name, max_count, min_count, count, +max_count_reset, min_count_reset, count_reset, status +from information_schema.innodb_metrics +where name like "dml%"; +name max_count min_count count max_count_reset min_count_reset count_reset status +dml_reads 6 NULL 6 0 NULL 0 enabled +dml_inserts 1 NULL 1 0 NULL 0 enabled +dml_deletes 2 NULL 2 0 NULL 0 enabled +dml_updates 2 NULL 2 0 NULL 0 enabled +insert into monitor_test values(9); +insert into monitor_test values(1); +delete from monitor_test; +select name, max_count, min_count, count, +max_count_reset, min_count_reset, count_reset, status +from information_schema.innodb_metrics +where name like "dml%"; +name max_count min_count count max_count_reset min_count_reset count_reset status +dml_reads 8 NULL 8 2 NULL 2 enabled +dml_inserts 3 NULL 3 2 NULL 2 enabled +dml_deletes 4 NULL 4 2 NULL 2 enabled +dml_updates 2 NULL 2 0 NULL 0 enabled +set global innodb_monitor_reset_all = module_dml; +select name, max_count, min_count, count, +max_count_reset, min_count_reset, count_reset, status +from information_schema.innodb_metrics +where name like "dml%"; +name max_count min_count count max_count_reset min_count_reset count_reset status +dml_reads 8 NULL 8 2 NULL 2 enabled +dml_inserts 3 NULL 3 2 NULL 2 enabled +dml_deletes 4 NULL 4 2 NULL 2 enabled +dml_updates 2 NULL 2 0 NULL 0 enabled +set global innodb_monitor_disable = module_dml; +select name, max_count, min_count, count, +max_count_reset, min_count_reset, count_reset, status +from information_schema.innodb_metrics +where name like "dml%"; +name max_count min_count count max_count_reset min_count_reset count_reset status +dml_reads 8 NULL 8 2 NULL 2 disabled +dml_inserts 3 NULL 3 2 NULL 2 disabled +dml_deletes 4 NULL 4 2 NULL 2 disabled +dml_updates 2 NULL 2 0 NULL 0 disabled +set global innodb_monitor_reset_all = module_dml; +select name, max_count, min_count, count, +max_count_reset, min_count_reset, count_reset, status +from information_schema.innodb_metrics +where name like "dml%"; +name max_count min_count count max_count_reset min_count_reset count_reset status +dml_reads NULL NULL 0 NULL NULL 0 disabled +dml_inserts NULL NULL 0 NULL NULL 0 disabled +dml_deletes NULL NULL 0 NULL NULL 0 disabled +dml_updates NULL NULL 0 NULL NULL 0 disabled +set global innodb_monitor_enable = dml_inserts; +insert into monitor_test values(9); +insert into monitor_test values(1); +delete from monitor_test; +select name, max_count, min_count, count, +max_count_reset, min_count_reset, count_reset, status +from information_schema.innodb_metrics +where name like "dml%"; +name max_count min_count count max_count_reset min_count_reset count_reset status +dml_reads NULL NULL 0 NULL NULL 0 disabled +dml_inserts 2 NULL 2 2 NULL 2 enabled +dml_deletes NULL NULL 0 NULL NULL 0 disabled +dml_updates NULL NULL 0 NULL NULL 0 disabled +set global innodb_monitor_disable = module_dml; +drop table monitor_test; +set global innodb_monitor_enable = file_num_open_files; +select name, max_count, min_count, count, +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 +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), +primary key (a(1), c(1)), key(b)) engine = innodb; +insert into monitor_test values("13", 2, "aa"); +select a from monitor_test where b < 1 for update; +a +select name, count from information_schema.innodb_metrics +where name like "icp%"; +name count +icp_attempts 1 +icp_no_match 0 +icp_out_of_range 1 +icp_match 0 +select a from monitor_test where b < 3 for update; +a +13 +select name, count from information_schema.innodb_metrics +where name like "icp%"; +name count +icp_attempts 2 +icp_no_match 0 +icp_out_of_range 1 +icp_match 1 +drop table monitor_test; +set global innodb_monitor_disable = All; +set global innodb_monitor_reset_all = all; +set global innodb_monitor_enable = default; +set global innodb_monitor_disable = default; +set global innodb_monitor_reset = default; +set global innodb_monitor_reset_all = default; |