Server System Variable Reference Name Cmd-Line Option File System Var Var Scope Dynamic thread_stack Yes Yes Yes Global No time_zone Yes Both Yes timestamp Yes Session Yes tls_ciphersuites Yes Yes Yes Global Yes tls_version Yes Yes Yes Global Varies tmp_table_size Yes Yes Yes Both Yes tmpdir Yes Yes Yes Global No transaction_alloc_block_size Yes Yes Yes Both Yes transaction_allow_batching Yes Session Yes transaction_isolation Yes Yes Yes Both Yes transaction_prealloc_size Yes Yes Yes Both Yes transaction_read_only Yes Yes Yes Both Yes transaction_write_set_extraction Yes Yes Yes Both Yes unique_checks Yes Both Yes updatable_views_with_limit Yes Yes Yes Both Yes use_secondary_engine Yes Session Yes validate_password_check_user_name Yes Yes Yes Global Yes validate_password_dictionary_file Yes Yes Yes Global Yes validate_password_length Yes Yes Yes Global Yes validate_password_mixed_case_count Yes Yes Yes Global Yes validate_password_number_count Yes Yes Yes Global Yes validate_password_policy Yes Yes Yes Global Yes validate_password_special_char_count Yes Yes Yes Global Yes validate_password.check_user_name Yes Yes Yes Global Yes validate_password.dictionary_file Yes Yes Yes Global Yes validate_password.length Yes Yes Yes Global Yes validate_password.mixed_case_count Yes Yes Yes Global Yes validate_password.number_count Yes Yes Yes Global Yes validate_password.policy Yes Yes Yes Global Yes validate_password.special_char_count Yes Yes Yes Global Yes version Yes Global No version_comment Yes Global No version_compile_machine Yes Global No version_compile_os Yes Global No version_compile_zlib Yes Global No version_tokens_session Yes Yes Yes Both Yes version_tokens_session_number Yes Yes Yes Both No wait_timeout Yes Yes Yes Both Yes 714