Server Option, System Variable, and Status Variable Reference Name Cmd-Line Option File System Var Status Var Var Scope Dynamic innodb_data_file_path Yes Yes Yes Global No Innodb_data_fsyncs Yes Global No innodb_data_home_dir Yes Yes Yes Global No Innodb_data_pending_fsyncs Yes Global No Innodb_data_pending_reads Yes Global No Innodb_data_pending_writes Yes Global No Innodb_data_read Yes Global No Innodb_data_reads Yes Global No Innodb_data_writes Yes Global No Innodb_data_written Yes Global No Innodb_dblwr_pages_written Yes Global No Innodb_dblwr_writes Yes Global No innodb_ddl_log_crash_reset_debug Yes Yes Yes Global Yes innodb_deadlock_detect Yes Yes Yes Global Yes innodb_dedicated_server Yes Yes Yes Global No innodb_default_row_format Yes Yes Yes Global Yes innodb_directories Yes Yes Yes Global No innodb_disable_sort_file_cache Yes Yes Yes Global Yes innodb_doublewrite Yes Yes Yes Global No innodb_doublewrite_batch_size Yes Yes Yes Global No innodb_doublewrite_dir Yes Yes Yes Global No innodb_doublewrite_files Yes Yes Yes Global No innodb_doublewrite_pages Yes Yes Yes Global No innodb_extend_and_initialize Yes Yes Yes Global Yes innodb_fast_shutdown Yes Yes Yes Global Yes innodb_fil_make_page_dirty_debug Yes Yes Yes Global Yes innodb_file_per_table Yes Yes Yes Global Yes innodb_fill_factor Yes Yes Yes Global Yes innodb_flush_log_at_timeout Yes Yes Yes Global Yes innodb_flush_log_at_trx_commit Yes Yes Yes Global Yes innodb_flush_method Yes Yes Yes Global No innodb_flush_neighbors Yes Yes Yes Global Yes innodb_flush_sync Yes Yes Yes Global Yes innodb_flushing_avg_loops Yes Yes Yes Global Yes innodb_force_load_corrupted Yes Yes Yes Global No innodb_force_recovery Yes Yes Yes Global No innodb_fsync_threshold Yes Yes Yes Global Yes innodb_ft_aux_table Yes Global Yes 658