Server System Variable Reference Name Cmd-Line Option File System Var Var Scope Dynamic 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_page_cleaners Yes Yes Yes Global No innodb_page_size Yes Yes 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_encrypt Yes Yes Yes Global Yes innodb_replication_delay Yes Yes Yes Global Yes innodb_rollback_on_timeout Yes Yes Yes Global No innodb_rollback_segments Yes Yes Yes Global Yes innodb_saved_page_number_debug Yes Yes Yes Global Yes innodb_segment_reserve_factor Yes Yes Yes Global Yes innodb_sort_buffer_size Yes Yes Yes Global No innodb_spin_wait_delay Yes Yes Yes Global Yes innodb_spin_wait_pause_multiplier Yes Yes Yes Global Yes innodb_stats_auto_recalc Yes Yes Yes Global Yes innodb_stats_include_delete_marked Yes Yes Yes Global Yes innodb_stats_method Yes Yes Yes Global Yes innodb_stats_on_metadata Yes Yes Yes Global Yes innodb_stats_persistent Yes Yes Yes Global Yes innodb_stats_persistent_sample_pages Yes Yes Yes Global Yes innodb_stats_transient_sample_pages Yes Yes Yes Global Yes innodb_status_output Yes Yes Yes Global Yes innodb_status_output_locks Yes Yes Yes Global Yes innodb_strict_mode Yes Yes Yes Both Yes 700