1set global innodb_monitor_disable = All; 2select name, status from information_schema.innodb_metrics; 3name status 4metadata_table_handles_opened disabled 5metadata_table_handles_closed disabled 6metadata_table_reference_count disabled 7lock_deadlocks disabled 8lock_timeouts disabled 9lock_rec_lock_waits disabled 10lock_table_lock_waits disabled 11lock_rec_lock_requests disabled 12lock_rec_lock_created disabled 13lock_rec_lock_removed disabled 14lock_rec_locks disabled 15lock_table_lock_created disabled 16lock_table_lock_removed disabled 17lock_table_locks disabled 18lock_row_lock_current_waits disabled 19lock_row_lock_time disabled 20lock_row_lock_time_max disabled 21lock_row_lock_waits disabled 22lock_row_lock_time_avg disabled 23buffer_pool_size disabled 24buffer_pool_reads disabled 25buffer_pool_read_requests disabled 26buffer_pool_write_requests disabled 27buffer_pool_wait_free disabled 28buffer_pool_read_ahead disabled 29buffer_pool_read_ahead_evicted disabled 30buffer_pool_pages_total disabled 31buffer_pool_pages_misc disabled 32buffer_pool_pages_data disabled 33buffer_pool_bytes_data disabled 34buffer_pool_pages_dirty disabled 35buffer_pool_bytes_dirty disabled 36buffer_pool_pages_free disabled 37buffer_pages_created disabled 38buffer_pages_written disabled 39buffer_pages_read disabled 40buffer_pages0_read disabled 41buffer_data_reads disabled 42buffer_data_written disabled 43buffer_flush_batch_scanned disabled 44buffer_flush_batch_num_scan disabled 45buffer_flush_batch_scanned_per_call disabled 46buffer_flush_batch_total_pages disabled 47buffer_flush_batches disabled 48buffer_flush_batch_pages disabled 49buffer_flush_neighbor_total_pages disabled 50buffer_flush_neighbor disabled 51buffer_flush_neighbor_pages disabled 52buffer_flush_n_to_flush_requested disabled 53buffer_flush_n_to_flush_by_age disabled 54buffer_flush_adaptive_avg_time_slot disabled 55buffer_LRU_batch_flush_avg_time_slot disabled 56buffer_flush_adaptive_avg_time_thread disabled 57buffer_LRU_batch_flush_avg_time_thread disabled 58buffer_flush_adaptive_avg_time_est disabled 59buffer_LRU_batch_flush_avg_time_est disabled 60buffer_flush_avg_time disabled 61buffer_flush_adaptive_avg_pass disabled 62buffer_LRU_batch_flush_avg_pass disabled 63buffer_flush_avg_pass disabled 64buffer_LRU_get_free_loops disabled 65buffer_LRU_get_free_waits disabled 66buffer_flush_avg_page_rate disabled 67buffer_flush_lsn_avg_rate disabled 68buffer_flush_pct_for_dirty disabled 69buffer_flush_pct_for_lsn disabled 70buffer_flush_sync_waits disabled 71buffer_flush_adaptive_total_pages disabled 72buffer_flush_adaptive disabled 73buffer_flush_adaptive_pages disabled 74buffer_flush_sync_total_pages disabled 75buffer_flush_sync disabled 76buffer_flush_sync_pages disabled 77buffer_flush_background_total_pages disabled 78buffer_flush_background disabled 79buffer_flush_background_pages disabled 80buffer_LRU_batch_scanned disabled 81buffer_LRU_batch_num_scan disabled 82buffer_LRU_batch_scanned_per_call disabled 83buffer_LRU_batch_flush_total_pages disabled 84buffer_LRU_batches_flush disabled 85buffer_LRU_batch_flush_pages disabled 86buffer_LRU_batch_evict_total_pages disabled 87buffer_LRU_batches_evict disabled 88buffer_LRU_batch_evict_pages disabled 89buffer_LRU_single_flush_scanned disabled 90buffer_LRU_single_flush_num_scan disabled 91buffer_LRU_single_flush_scanned_per_call disabled 92buffer_LRU_single_flush_failure_count disabled 93buffer_LRU_get_free_search disabled 94buffer_LRU_search_scanned disabled 95buffer_LRU_search_num_scan disabled 96buffer_LRU_search_scanned_per_call disabled 97buffer_LRU_unzip_search_scanned disabled 98buffer_LRU_unzip_search_num_scan disabled 99buffer_LRU_unzip_search_scanned_per_call disabled 100buffer_page_read_index_leaf disabled 101buffer_page_read_index_non_leaf disabled 102buffer_page_read_index_ibuf_leaf disabled 103buffer_page_read_index_ibuf_non_leaf disabled 104buffer_page_read_undo_log disabled 105buffer_page_read_index_inode disabled 106buffer_page_read_ibuf_free_list disabled 107buffer_page_read_ibuf_bitmap disabled 108buffer_page_read_system_page disabled 109buffer_page_read_trx_system disabled 110buffer_page_read_fsp_hdr disabled 111buffer_page_read_xdes disabled 112buffer_page_read_blob disabled 113buffer_page_read_zblob disabled 114buffer_page_read_zblob2 disabled 115buffer_page_read_other disabled 116buffer_page_written_index_leaf disabled 117buffer_page_written_index_non_leaf disabled 118buffer_page_written_index_ibuf_leaf disabled 119buffer_page_written_index_ibuf_non_leaf disabled 120buffer_page_written_undo_log disabled 121buffer_page_written_index_inode disabled 122buffer_page_written_ibuf_free_list disabled 123buffer_page_written_ibuf_bitmap disabled 124buffer_page_written_system_page disabled 125buffer_page_written_trx_system disabled 126buffer_page_written_fsp_hdr disabled 127buffer_page_written_xdes disabled 128buffer_page_written_blob disabled 129buffer_page_written_zblob disabled 130buffer_page_written_zblob2 disabled 131buffer_page_written_other disabled 132os_data_reads disabled 133os_data_writes disabled 134os_data_fsyncs disabled 135os_pending_reads disabled 136os_pending_writes disabled 137os_log_bytes_written disabled 138os_log_fsyncs disabled 139os_log_pending_fsyncs disabled 140os_log_pending_writes disabled 141trx_rw_commits disabled 142trx_ro_commits disabled 143trx_nl_ro_commits disabled 144trx_commits_insert_update disabled 145trx_rollbacks disabled 146trx_rollbacks_savepoint disabled 147trx_rollback_active disabled 148trx_active_transactions disabled 149trx_rseg_history_len disabled 150trx_undo_slots_used disabled 151trx_undo_slots_cached disabled 152trx_rseg_current_size disabled 153purge_del_mark_records disabled 154purge_upd_exist_or_extern_records disabled 155purge_invoked disabled 156purge_undo_log_pages disabled 157purge_dml_delay_usec disabled 158purge_stop_count disabled 159purge_resume_count disabled 160log_checkpoints disabled 161log_lsn_last_flush disabled 162log_lsn_last_checkpoint disabled 163log_lsn_current disabled 164log_lsn_checkpoint_age disabled 165log_lsn_buf_pool_oldest disabled 166log_max_modified_age_async disabled 167log_max_modified_age_sync disabled 168log_pending_log_flushes disabled 169log_pending_checkpoint_writes disabled 170log_num_log_io disabled 171log_waits disabled 172log_write_requests disabled 173log_writes disabled 174log_padded disabled 175compress_pages_compressed disabled 176compress_pages_decompressed disabled 177compression_pad_increments disabled 178compression_pad_decrements disabled 179pages_encrypted disabled 180pages_decrypted disabled 181index_page_splits disabled 182index_page_merge_attempts disabled 183index_page_merge_successful disabled 184index_page_reorg_attempts disabled 185index_page_reorg_successful disabled 186index_page_discards disabled 187adaptive_hash_searches disabled 188adaptive_hash_searches_btree disabled 189adaptive_hash_pages_added disabled 190adaptive_hash_pages_removed disabled 191adaptive_hash_rows_added disabled 192adaptive_hash_rows_removed disabled 193adaptive_hash_rows_deleted_no_hash_entry disabled 194adaptive_hash_rows_updated disabled 195file_num_open_files disabled 196ibuf_merges_insert disabled 197ibuf_merges_delete_mark disabled 198ibuf_merges_delete disabled 199ibuf_merges_discard_insert disabled 200ibuf_merges_discard_delete_mark disabled 201ibuf_merges_discard_delete disabled 202ibuf_merges disabled 203ibuf_size disabled 204innodb_master_thread_sleeps disabled 205innodb_activity_count disabled 206innodb_master_active_loops disabled 207innodb_master_idle_loops disabled 208innodb_background_drop_table_usec disabled 209innodb_ibuf_merge_usec disabled 210innodb_log_flush_usec disabled 211innodb_mem_validate_usec disabled 212innodb_master_purge_usec disabled 213innodb_dict_lru_usec disabled 214innodb_dict_lru_count disabled 215innodb_checkpoint_usec disabled 216innodb_dblwr_writes disabled 217innodb_dblwr_pages_written disabled 218innodb_page_size disabled 219innodb_rwlock_s_spin_waits disabled 220innodb_rwlock_x_spin_waits disabled 221innodb_rwlock_sx_spin_waits disabled 222innodb_rwlock_s_spin_rounds disabled 223innodb_rwlock_x_spin_rounds disabled 224innodb_rwlock_sx_spin_rounds disabled 225innodb_rwlock_s_os_waits disabled 226innodb_rwlock_x_os_waits disabled 227innodb_rwlock_sx_os_waits disabled 228dml_reads disabled 229dml_inserts disabled 230dml_deletes disabled 231dml_updates disabled 232ddl_background_drop_indexes disabled 233ddl_background_drop_tables disabled 234ddl_online_create_index disabled 235ddl_pending_alter_table disabled 236ddl_sort_file_alter_table disabled 237ddl_log_file_alter_table disabled 238icp_attempts disabled 239icp_no_match disabled 240icp_out_of_range disabled 241icp_match disabled 242set global innodb_monitor_enable = all; 243select name from information_schema.innodb_metrics where status!='enabled'; 244name 245set global innodb_monitor_enable = aaa; 246ERROR 42000: Variable 'innodb_monitor_enable' can't be set to the value of 'aaa' 247set global innodb_monitor_disable = All; 248select name from information_schema.innodb_metrics where status!='disabled'; 249name 250set global innodb_monitor_reset_all = all; 251select name from information_schema.innodb_metrics where count!=0; 252name 253set global innodb_monitor_enable = "%lock%"; 254select name from information_schema.innodb_metrics 255where status != IF(name like "%lock%", 'enabled', 'disabled'); 256name 257set global innodb_monitor_disable = "%lock%"; 258select name, status from information_schema.innodb_metrics 259where name like "%lock%"; 260name status 261lock_deadlocks disabled 262lock_timeouts disabled 263lock_rec_lock_waits disabled 264lock_table_lock_waits disabled 265lock_rec_lock_requests disabled 266lock_rec_lock_created disabled 267lock_rec_lock_removed disabled 268lock_rec_locks disabled 269lock_table_lock_created disabled 270lock_table_lock_removed disabled 271lock_table_locks disabled 272lock_row_lock_current_waits disabled 273lock_row_lock_time disabled 274lock_row_lock_time_max disabled 275lock_row_lock_waits disabled 276lock_row_lock_time_avg disabled 277innodb_rwlock_s_spin_waits disabled 278innodb_rwlock_x_spin_waits disabled 279innodb_rwlock_sx_spin_waits disabled 280innodb_rwlock_s_spin_rounds disabled 281innodb_rwlock_x_spin_rounds disabled 282innodb_rwlock_sx_spin_rounds disabled 283innodb_rwlock_s_os_waits disabled 284innodb_rwlock_x_os_waits disabled 285innodb_rwlock_sx_os_waits disabled 286set global innodb_monitor_enable = "%lock*"; 287ERROR 42000: Variable 'innodb_monitor_enable' can't be set to the value of '%lock*' 288set global innodb_monitor_enable="%%%%%%%%%%%%%%%%%%%%%%%%%%%"; 289select name from information_schema.innodb_metrics where status!='enabled'; 290name 291set global innodb_monitor_disable="%%%%%"; 292select name from information_schema.innodb_metrics where status!='disabled'; 293name 294set global innodb_monitor_enable="%"; 295select name from information_schema.innodb_metrics where status!='enabled'; 296name 297set global innodb_monitor_disable="%_%"; 298select name from information_schema.innodb_metrics where status!='disabled'; 299name 300set global innodb_monitor_enable="log%%%%"; 301select name from information_schema.innodb_metrics 302where status != IF(name like "log%", 'enabled', 'disabled'); 303name 304set global innodb_monitor_enable="os_%a_fs_ncs"; 305set global innodb_monitor_enable="os%pending%"; 306select name, status from information_schema.innodb_metrics 307where name like "os%"; 308name status 309os_data_reads disabled 310os_data_writes disabled 311os_data_fsyncs enabled 312os_pending_reads enabled 313os_pending_writes enabled 314os_log_bytes_written disabled 315os_log_fsyncs disabled 316os_log_pending_fsyncs enabled 317os_log_pending_writes enabled 318set global innodb_monitor_enable=""; 319ERROR 42000: Variable 'innodb_monitor_enable' can't be set to the value of '' 320set global innodb_monitor_enable="_"; 321ERROR 42000: Variable 'innodb_monitor_enable' can't be set to the value of '_' 322SET global innodb_monitor_disable = module_metadata; 323SET global innodb_monitor_reset_all = module_metadata; 324set global innodb_monitor_enable = metadata_table_handles_opened; 325create table monitor_test(col int) engine = innodb; 326select * from monitor_test; 327col 328select name, max_count, min_count, count, 329max_count_reset, min_count_reset, count_reset, status 330from information_schema.innodb_metrics 331where name = "metadata_table_handles_opened"; 332name max_count min_count count max_count_reset min_count_reset count_reset status 333metadata_table_handles_opened 1 NULL 1 1 NULL 1 enabled 334set global innodb_monitor_reset = metadata_table_handles_opened; 335select name, max_count, min_count, count, 336max_count_reset, min_count_reset, count_reset, status 337from information_schema.innodb_metrics 338where name = "metadata_table_handles_opened"; 339name max_count min_count count max_count_reset min_count_reset count_reset status 340metadata_table_handles_opened 1 NULL 1 NULL NULL 0 enabled 341drop table monitor_test; 342create table monitor_test(col int) engine = innodb; 343select * from monitor_test; 344col 345select name, max_count, min_count, count, 346max_count_reset, min_count_reset, count_reset, status 347from information_schema.innodb_metrics 348where name = "metadata_table_handles_opened"; 349name max_count min_count count max_count_reset min_count_reset count_reset status 350metadata_table_handles_opened 2 NULL 2 1 NULL 1 enabled 351set global innodb_monitor_reset_all = metadata_table_handles_opened; 352select name, max_count, min_count, count, 353max_count_reset, min_count_reset, count_reset, status 354from information_schema.innodb_metrics 355where name = "metadata_table_handles_opened"; 356name max_count min_count count max_count_reset min_count_reset count_reset status 357metadata_table_handles_opened 2 NULL 2 1 NULL 1 enabled 358set global innodb_monitor_disable = metadata_table_handles_opened; 359set global innodb_monitor_reset = metadata_table_handles_opened; 360select name, max_count, min_count, count, 361max_count_reset, min_count_reset, count_reset, status 362from information_schema.innodb_metrics 363where name = "metadata_table_handles_opened"; 364name max_count min_count count max_count_reset min_count_reset count_reset status 365metadata_table_handles_opened 2 NULL 2 NULL NULL 0 disabled 366drop table monitor_test; 367create table monitor_test(col int) engine = innodb; 368select * from monitor_test; 369col 370select name, max_count, min_count, count, 371max_count_reset, min_count_reset, count_reset, status 372from information_schema.innodb_metrics 373where name = "metadata_table_handles_opened"; 374name max_count min_count count max_count_reset min_count_reset count_reset status 375metadata_table_handles_opened 2 NULL 2 NULL NULL 0 disabled 376set global innodb_monitor_reset_all = metadata_table_handles_opened; 377select name, max_count, min_count, count, 378max_count_reset, min_count_reset, count_reset, status 379from information_schema.innodb_metrics 380where name = "metadata_table_handles_opened"; 381name max_count min_count count max_count_reset min_count_reset count_reset status 382metadata_table_handles_opened NULL NULL 0 NULL NULL 0 disabled 383set global innodb_monitor_enable = metadata_table_handles_opened; 384drop table monitor_test; 385create table monitor_test(col int) engine = innodb stats_persistent=0; 386select * from monitor_test; 387col 388select name, max_count, min_count, count, 389max_count_reset, min_count_reset, count_reset, status 390from information_schema.innodb_metrics 391where name = "metadata_table_handles_opened"; 392name max_count min_count count max_count_reset min_count_reset count_reset status 393metadata_table_handles_opened 1 NULL 1 1 NULL 1 enabled 394set global innodb_monitor_enable = metadata_table_handles_closed; 395create index idx on monitor_test(col); 396select name, max_count, min_count, count, 397max_count_reset, min_count_reset, count_reset, status 398from information_schema.innodb_metrics 399where name = "metadata_table_handles_closed"; 400name max_count min_count count max_count_reset min_count_reset count_reset status 401metadata_table_handles_closed 1 NULL 1 1 NULL 1 enabled 402select name, max_count, min_count, count, 403max_count_reset, min_count_reset, count_reset, status 404from information_schema.innodb_metrics 405where name like "metadata%"; 406name max_count min_count count max_count_reset min_count_reset count_reset status 407metadata_table_handles_opened 2 NULL 2 2 NULL 2 enabled 408metadata_table_handles_closed 1 NULL 1 1 NULL 1 enabled 409metadata_table_reference_count NULL NULL 0 NULL NULL 0 disabled 410set global innodb_monitor_disable = module_metadata; 411set global innodb_monitor_reset = module_metadata; 412select name, max_count, min_count, count, 413max_count_reset, min_count_reset, count_reset, status 414from information_schema.innodb_metrics 415where name like "metadata%"; 416name max_count min_count count max_count_reset min_count_reset count_reset status 417metadata_table_handles_opened 2 NULL 2 NULL NULL 0 disabled 418metadata_table_handles_closed 1 NULL 1 NULL NULL 0 disabled 419metadata_table_reference_count NULL NULL 0 NULL NULL 0 disabled 420set global innodb_monitor_reset_all = module_metadata; 421select name, max_count, min_count, count, 422max_count_reset, min_count_reset, count_reset, status 423from information_schema.innodb_metrics 424where name like "metadata%"; 425name max_count min_count count max_count_reset min_count_reset count_reset status 426metadata_table_handles_opened NULL NULL 0 NULL NULL 0 disabled 427metadata_table_handles_closed NULL NULL 0 NULL NULL 0 disabled 428metadata_table_reference_count NULL NULL 0 NULL NULL 0 disabled 429set global innodb_monitor_enable = module_trx; 430begin; 431insert into monitor_test values(9); 432commit; 433begin; 434insert into monitor_test values(9); 435rollback; 436select name, max_count, min_count, count, 437max_count_reset, min_count_reset, count_reset, status 438from information_schema.innodb_metrics 439where name like "trx_rollbacks" or name like "trx_active_transactions"; 440name max_count min_count count max_count_reset min_count_reset count_reset status 441trx_rollbacks 1 NULL 1 1 NULL 1 enabled 442trx_active_transactions 1 0 0 1 0 0 enabled 443set global innodb_monitor_disable = module_trx; 444set global innodb_monitor_enable = module_dml; 445insert into monitor_test values(9); 446update monitor_test set col = 10 where col = 9; 447select name, max_count, min_count, count, 448max_count_reset, min_count_reset, count_reset, status 449from information_schema.innodb_metrics 450where name like "dml%"; 451name max_count min_count count max_count_reset min_count_reset count_reset status 452dml_reads 4 NULL 4 4 NULL 4 enabled 453dml_inserts 1 NULL 1 1 NULL 1 enabled 454dml_deletes 0 NULL 0 0 NULL 0 enabled 455dml_updates 2 NULL 2 2 NULL 2 enabled 456delete from monitor_test; 457select name, max_count, min_count, count, 458max_count_reset, min_count_reset, count_reset, status 459from information_schema.innodb_metrics 460where name like "dml%"; 461name max_count min_count count max_count_reset min_count_reset count_reset status 462dml_reads 6 NULL 6 6 NULL 6 enabled 463dml_inserts 1 NULL 1 1 NULL 1 enabled 464dml_deletes 2 NULL 2 2 NULL 2 enabled 465dml_updates 2 NULL 2 2 NULL 2 enabled 466set global innodb_monitor_reset = module_dml; 467select name, max_count, min_count, count, 468max_count_reset, min_count_reset, count_reset, status 469from information_schema.innodb_metrics 470where name like "dml%"; 471name max_count min_count count max_count_reset min_count_reset count_reset status 472dml_reads 6 NULL 6 0 NULL 0 enabled 473dml_inserts 1 NULL 1 0 NULL 0 enabled 474dml_deletes 2 NULL 2 0 NULL 0 enabled 475dml_updates 2 NULL 2 0 NULL 0 enabled 476insert into monitor_test values(9); 477insert into monitor_test values(1); 478delete from monitor_test; 479select name, max_count, min_count, count, 480max_count_reset, min_count_reset, count_reset, status 481from information_schema.innodb_metrics 482where name like "dml%"; 483name max_count min_count count max_count_reset min_count_reset count_reset status 484dml_reads 8 NULL 8 2 NULL 2 enabled 485dml_inserts 3 NULL 3 2 NULL 2 enabled 486dml_deletes 4 NULL 4 2 NULL 2 enabled 487dml_updates 2 NULL 2 0 NULL 0 enabled 488set global innodb_monitor_reset_all = module_dml; 489select name, max_count, min_count, count, 490max_count_reset, min_count_reset, count_reset, status 491from information_schema.innodb_metrics 492where name like "dml%"; 493name max_count min_count count max_count_reset min_count_reset count_reset status 494dml_reads 8 NULL 8 2 NULL 2 enabled 495dml_inserts 3 NULL 3 2 NULL 2 enabled 496dml_deletes 4 NULL 4 2 NULL 2 enabled 497dml_updates 2 NULL 2 0 NULL 0 enabled 498set global innodb_monitor_disable = module_dml; 499select name, max_count, min_count, count, 500max_count_reset, min_count_reset, count_reset, status 501from information_schema.innodb_metrics 502where name like "dml%"; 503name max_count min_count count max_count_reset min_count_reset count_reset status 504dml_reads 8 NULL 8 2 NULL 2 disabled 505dml_inserts 3 NULL 3 2 NULL 2 disabled 506dml_deletes 4 NULL 4 2 NULL 2 disabled 507dml_updates 2 NULL 2 0 NULL 0 disabled 508set global innodb_monitor_reset_all = module_dml; 509select name, max_count, min_count, count, 510max_count_reset, min_count_reset, count_reset, status 511from information_schema.innodb_metrics 512where name like "dml%"; 513name max_count min_count count max_count_reset min_count_reset count_reset status 514dml_reads NULL NULL 0 NULL NULL 0 disabled 515dml_inserts NULL NULL 0 NULL NULL 0 disabled 516dml_deletes NULL NULL 0 NULL NULL 0 disabled 517dml_updates NULL NULL 0 NULL NULL 0 disabled 518set global innodb_monitor_enable = dml_inserts; 519insert into monitor_test values(9); 520insert into monitor_test values(1); 521delete from monitor_test; 522select name, max_count, min_count, count, 523max_count_reset, min_count_reset, count_reset, status 524from information_schema.innodb_metrics 525where name like "dml%"; 526name max_count min_count count max_count_reset min_count_reset count_reset status 527dml_reads NULL NULL 0 NULL NULL 0 disabled 528dml_inserts 2 NULL 2 2 NULL 2 enabled 529dml_deletes NULL NULL 0 NULL NULL 0 disabled 530dml_updates NULL NULL 0 NULL NULL 0 disabled 531set global innodb_monitor_disable = module_dml; 532drop table monitor_test; 533set global innodb_monitor_enable = file_num_open_files; 534select name, max_count, min_count, count, 535max_count_reset, min_count_reset, count_reset, status 536from information_schema.innodb_metrics 537where name like "file_num_open_files"; 538name max_count min_count count max_count_reset min_count_reset count_reset status 539file_num_open_files # # # # # # enabled 540set global innodb_monitor_disable = file_num_open_files; 541set global innodb_monitor_enable = "icp%"; 542create table monitor_test(a char(3), b int, c char(2), 543primary key (a(1), c(1)), key(b)) engine = innodb; 544insert into monitor_test values("13", 2, "aa"); 545select a from monitor_test where b < 1 for update; 546a 547select name, count from information_schema.innodb_metrics 548where name like "icp%"; 549name count 550icp_attempts 1 551icp_no_match 0 552icp_out_of_range 1 553icp_match 0 554select a from monitor_test where b < 3 for update; 555a 55613 557select name, count from information_schema.innodb_metrics 558where name like "icp%"; 559name count 560icp_attempts 2 561icp_no_match 0 562icp_out_of_range 1 563icp_match 1 564drop table monitor_test; 565set global innodb_monitor_disable = All; 566set global innodb_monitor_reset_all = all; 567set global innodb_monitor_enable = default; 568set global innodb_monitor_disable = default; 569set global innodb_monitor_reset = default; 570set global innodb_monitor_reset_all = default; 571