Using System Variables 929 Variable Name Variable Type Variable Scope innodb_parallel_read_threads Integer Session innodb_print_all_deadlocks Boolean Global innodb_print_ddl_logs Boolean Global innodb_purge_batch_size Integer Global innodb_purge_rseg_truncate_frequency Integer Global innodb_random_read_ahead Boolean Global innodb_read_ahead_threshold Integer Global innodb_redo_log_archive_dirs String Global innodb_redo_log_encrypt Boolean Global innodb_replication_delay Integer Global innodb_rollback_segments Integer Global innodb_saved_page_number_debug Integer Global innodb_segment_reserve_factor Numeric Global innodb_spin_wait_delay Integer Global innodb_spin_wait_pause_multiplier Integer Global innodb_stats_auto_recalc Boolean Global innodb_stats_include_delete_marked Boolean Global innodb_stats_method Enumeration Global innodb_stats_on_metadata Boolean Global innodb_stats_persistent Boolean Global innodb_stats_persistent_sample_pages Integer Global innodb_stats_transient_sample_pages Integer Global innodb_status_output Boolean Global innodb_status_output_locks Boolean Global innodb_strict_mode Boolean Both innodb_sync_spin_loops Integer Global innodb_table_locks Boolean Both innodb_thread_concurrency Integer Global innodb_thread_sleep_delay Integer Global innodb_tmpdir Directory name Both innodb_trx_purge_view_update_only_debug Boolean Global innodb_trx_rseg_n_slots_debug Integer Global innodb_undo_log_encrypt Boolean Global innodb_undo_log_truncate Boolean Global innodb_undo_tablespaces Integer Global innodb_use_fdatasync Boolean Global insert_id Integer Session interactive_timeout Integer Both