Server Option, System Variable, and Status Variable Reference Name Cmd-Line Option File System Var Status Var Var Scope Dynamic innodb_max_undo_log_size Yes Yes Yes Global Yes innodb_merge_threshold_set_all_debug Yes Yes Yes Global Yes innodb_monitor_disable Yes Yes Yes Global Yes innodb_monitor_enable Yes Yes Yes Global Yes innodb_monitor_reset Yes Yes Yes Global Yes innodb_monitor_reset_all Yes Yes Yes Global Yes Innodb_num_open_files Yes Global No innodb_numa_interleave Yes Yes Yes Global No innodb_old_blocks_pct Yes Yes Yes Global Yes innodb_old_blocks_time Yes Yes Yes Global Yes innodb_online_alter_log_max_size Yes Yes Yes Global Yes innodb_open_files Yes Yes Yes Global No innodb_optimize_fulltext_only Yes Yes Yes Global Yes Innodb_os_log_fsyncs Yes Global No Innodb_os_log_pending_fsyncs Yes Global No Innodb_os_log_pending_writes Yes Global No Innodb_os_log_written Yes Global No innodb_page_cleaners Yes Yes Yes Global No Innodb_page_size Yes Global No innodb_page_size Yes Yes Yes Global No Innodb_pages_created Yes Global No Innodb_pages_read Yes Global No Innodb_pages_written Yes Global No innodb_parallel_read_threads Yes Yes Yes Session Yes innodb_print_all_deadlocks Yes Yes Yes Global Yes innodb_print_ddl_logs Yes Yes Yes Global Yes innodb_purge_batch_size Yes Yes Yes Global Yes innodb_purge_rseg_truncate_frequency Yes Yes Yes Global Yes innodb_purge_threads Yes Yes Yes Global No innodb_random_read_ahead Yes Yes Yes Global Yes innodb_read_ahead_threshold Yes Yes Yes Global Yes innodb_read_io_threads Yes Yes Yes Global No innodb_read_only Yes Yes Yes Global No innodb_redo_log_archive_dirs Yes Yes Yes Global Yes Innodb_redo_log_enabled Yes Global No innodb_redo_log_encrypt Yes Yes Yes Global Yes innodb_replication_delay Yes Yes Yes Global Yes innodb_rollback_on_timeout Yes Yes Yes Global No 660