InnoDB Startup Options and System Variables Name Cmd-Line Option File System Var Status Var Var Scope Dynamic innodb_force_recovery Yes Yes Yes Global No innodb_fsync_threshold Yes Yes Yes Global Yes innodb_ft_aux_table Yes Global Yes innodb_ft_cache_size Yes Yes Yes Global No innodb_ft_enable_diag_print Yes Yes Yes Global Yes innodb_ft_enable_stopword Yes Yes Yes Both Yes innodb_ft_max_token_size Yes Yes Yes Global No innodb_ft_min_token_size Yes Yes Yes Global No innodb_ft_num_word_optimize Yes Yes Yes Global Yes innodb_ft_result_cache_limit Yes Yes Yes Global Yes innodb_ft_server_stopword_table Yes Yes Yes Global Yes innodb_ft_sort_pll_degree Yes Yes Yes Global No innodb_ft_total_cache_size Yes Yes Yes Global No innodb_ft_user_stopword_table Yes Yes Yes Both Yes Innodb_have_atomic_builtins Yes Global No innodb_idle_flush_pct Yes Yes Yes Global Yes innodb_io_capacity Yes Yes Yes Global Yes innodb_io_capacity_max Yes Yes Yes Global Yes innodb_limit_optimistic_insert_debug Yes Yes Yes Global Yes innodb_lock_wait_timeout Yes Yes Yes Both Yes innodb_log_buffer_size Yes Yes Yes Global Varies innodb_log_checkpoint_fuzzy_now Yes Yes Yes Global Yes innodb_log_checkpoint_now Yes Yes Yes Global Yes innodb_log_checksums Yes Yes Yes Global Yes innodb_log_compressed_pages Yes Yes Yes Global Yes innodb_log_file_size Yes Yes Yes Global No innodb_log_files_in_group Yes Yes Yes Global No innodb_log_group_home_dir Yes Yes Yes Global No innodb_log_spin_cpu_abs_lwm Yes Yes Yes Global Yes innodb_log_spin_cpu_pct_hwm Yes Yes Yes Global Yes innodb_log_wait_for_flush_spin_hwm Yes Yes Yes Global Yes Innodb_log_waits Yes Global No innodb_log_write_ahead_size Yes Yes Yes Global Yes Innodb_log_write_requests Yes Global No innodb_log_writer_threads Yes Yes Yes Global Yes Innodb_log_writes Yes Global No innodb_lru_scan_depth Yes Yes Yes Global Yes innodb_max_dirty_pages_pct Yes Yes Yes Global Yes 3209