661 Server Option, System Variable, and Status Variable Reference Name Cmd-Line Option File System Var Status Var Var Scope Dynamic innodb_rollback_segments Yes Yes Yes Global Yes Innodb_row_lock_current_waits Yes Global No Innodb_row_lock_time Yes Global No Innodb_row_lock_time_avg Yes Global No Innodb_row_lock_time_max Yes Global No Innodb_row_lock_waits Yes Global No Innodb_rows_deleted Yes Global No Innodb_rows_inserted Yes Global No Innodb_rows_read Yes Global No Innodb_rows_updated Yes Global No 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-file Yes 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 innodb_sync_array_size Yes Yes Yes Global No innodb_sync_debug Yes Yes Yes Global No innodb_sync_spin_loops Yes Yes Yes Global Yes Innodb_system_rows_deleted Yes Global No Innodb_system_rows_inserted Yes Global No Innodb_system_rows_read Yes Global No innodb_table_locks Yes Yes Yes Both Yes innodb_temp_data_file_path Yes Yes Yes Global No innodb_temp_tablespaces_dir Yes Yes Yes Global No innodb_thread_concurrency Yes Yes Yes Global Yes innodb_thread_sleep_delay Yes Yes Yes Global Yes