Server System Variable Reference 699 Name Cmd-Line Option File System Var Var Scope Dynamic 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_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_write_ahead_size Yes Yes Yes Global Yes innodb_log_writer_threads Yes Yes Yes Global Yes innodb_lru_scan_depth Yes Yes Yes Global Yes innodb_max_dirty_pages_pct Yes Yes Yes Global Yes innodb_max_dirty_pages_pct_lwm Yes Yes Yes Global Yes innodb_max_purge_lag Yes Yes Yes Global Yes innodb_max_purge_lag_delay Yes Yes Yes Global Yes 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