Server Option, System Variable, and Status Variable Reference 662 Name Cmd-Line Option File System Var Status Var Var Scope Dynamic innodb_tmpdir Yes Yes Yes Both Yes Innodb_truncated_status_writes Yes Global No 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_undo_tablespaces_active Yes Global No Innodb_undo_tablespaces_explicit Yes Global No Innodb_undo_tablespaces_implicit Yes Global No Innodb_undo_tablespaces_total Yes Global No 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 install Yes install-manual 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_blocks_not_flushed Yes Global No Key_blocks_unused Yes Global No Key_blocks_used Yes Global No 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 Key_read_requests Yes Global No Key_reads Yes Global No Key_write_requests Yes Global No Key_writes Yes Global No keyring_aws_cmk_id Yes Yes Yes Global Yes keyring_aws_conf_file Yes Yes Yes Global No