path: root/mysql-test/suite/sys_vars/r/innodb_monitor_disable_basic.result

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;