Server System Variable Reference Name Cmd-Line Option File System Var Var Scope Dynamic 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_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 innodb_tmpdir Yes Yes Yes Both Yes innodb_trx_purge_view_update_only_debug Yes Yes Yes Global Yes innodb_trx_rseg_n_slots_debug Yes Yes Yes Global Yes innodb_undo_directory Yes Yes Yes Global No innodb_undo_log_encrypt Yes Yes Yes Global Yes innodb_undo_log_truncate Yes Yes Yes Global Yes innodb_undo_tablespaces Yes Yes Yes Global Varies innodb_use_fdatasync Yes Yes Yes Global Yes innodb_use_native_aio Yes Yes Yes Global No innodb_validate_tablespace_paths Yes Yes Yes Global No innodb_version Yes Global No innodb_write_io_threads Yes Yes Yes Global No insert_id Yes Session Yes interactive_timeout Yes Yes Yes Both Yes internal_tmp_disk_storage_engine Yes Yes Yes Global Yes internal_tmp_mem_storage_engine Yes Yes Yes Both Yes join_buffer_size Yes Yes Yes Both Yes keep_files_on_create Yes Yes Yes Both Yes key_buffer_size Yes Yes Yes Global Yes key_cache_age_threshold Yes Yes Yes Global Yes key_cache_block_size Yes Yes Yes Global Yes key_cache_division_limit Yes Yes Yes Global Yes keyring_aws_cmk_id Yes Yes Yes Global Yes keyring_aws_conf_file Yes Yes Yes Global No keyring_aws_data_file Yes Yes Yes Global No keyring_aws_region Yes Yes Yes Global Yes keyring_encrypted_file_data Yes Yes Yes Global Yes keyring_encrypted_file_password Yes Yes Yes Global Yes keyring_file_data Yes Yes Yes Global Yes keyring_hashicorp_auth_path Yes Yes Yes Global Yes 701