Documentation Home
MySQL 8.0 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 38.2Mb
PDF (A4) - 38.3Mb
PDF (RPM) - 33.1Mb
HTML Download (TGZ) - 8.1Mb
HTML Download (Zip) - 8.1Mb
HTML Download (RPM) - 7.0Mb
Man Pages (TGZ) - 133.2Kb
Man Pages (Zip) - 189.3Kb
Info (Gzip) - 3.4Mb
Info (Zip) - 3.4Mb
Excerpts from this Manual

MySQL 8.0 Reference Manual  /  ...  /  Nonpersistent System Variables

5.1.8.4 Nonpersistent System Variables

SET PERSIST and SET PERSIST_ONLY enable global system variables to be persisted to the mysqld-auto.cnf option file in the data directory (see Section 13.7.5.1, “SET Syntax for Variable Assignment”). However, not all system variables can be persisted. Here are some reasons why a variable might be persist-restricted:

  • A system variable might be read only. In this case, it cannot be set at all, whether at server startup or at runtime.

  • A system variable might be intended only for internal use.

  • A system variable might involve sensitive data. A variable such as secure_file_priv should be settable only by a user who has direct access to the server host file system, not a remote user why by setting this variable and restarting the server could cause a privilege escalation for remote users to access the server host file system.

  • Session system variables cannot be persisted. They cannot be set at server startup, so there is no reason to persist them.

These system variables cannot be persisted:

audit_log_current_session
audit_log_file
audit_log_filter_id
audit_log_format
auto_generate_certs
basedir
bind_address
caching_sha2_password_auto_generate_rsa_keys
caching_sha2_password_private_key_path
caching_sha2_password_public_key_path
character_set_system
character_sets_dir
core_file
daemon_memcached_engine_lib_name
daemon_memcached_engine_lib_path
daemon_memcached_option
datadir
default_authentication_plugin
ft_stopword_file
have_statement_timeout
have_symlink
hostname
init_file
innodb_buffer_pool_load_at_startup
innodb_data_file_path
innodb_data_home_dir
innodb_dedicated_server
innodb_directories
innodb_force_load_corrupted
innodb_log_group_home_dir
innodb_page_size
innodb_read_only
innodb_temp_data_file_path
innodb_temp_tablespaces_dir
innodb_undo_directory
innodb_undo_tablespaces
innodb_version
keyring_encrypted_file_data
keyring_encrypted_file_password
large_files_support
large_page_size
lc_messages_dir
license
locked_in_memory
log_bin
log_bin_basename
log_bin_index
log_error
lower_case_file_system
mecab_rc_file
named_pipe
persisted_globals_load
pid_file
plugin_dir
port
protocol_version
relay_log
relay_log_basename
relay_log_index
relay_log_info_file
secure_file_priv
server_uuid
sha256_password_auto_generate_rsa_keys
sha256_password_private_key_path
sha256_password_public_key_path
shared_memory
shared_memory_base_name
skip_external_locking
skip_networking
slave_load_tmpdir
socket
ssl_ca
ssl_capath
ssl_cert
ssl_crl
ssl_crlpath
ssl_key
system_time_zone
tmpdir
version_comment
version_compile_machine
version_compile_os
version_compile_zlib
version_tokens_session_number

User Comments
User comments in this section are, as the name implies, provided by MySQL users. The MySQL documentation team is not responsible for, nor do they endorse, any of the information provided here.
Sign Up Login You must be logged in to post a comment.