Documentation Home
MySQL 8.0 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 37.9Mb
PDF (A4) - 37.9Mb
PDF (RPM) - 32.8Mb
HTML Download (TGZ) - 8.0Mb
HTML Download (Zip) - 8.1Mb
HTML Download (RPM) - 6.9Mb
Man Pages (TGZ) - 132.7Kb
Man Pages (Zip) - 189.0Kb
Info (Gzip) - 3.4Mb
Info (Zip) - 3.4Mb
Excerpts from this Manual

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

5.1.8.1 Nonpersistent System Variables

SET PERSIST and SET PERSIST_ONLY enable 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:

  • These system variables cannot be persisted:

    auto_generate_certs
    basedir
    bind_address
    character_set_system
    character_sets_dir
    core_file
    datadir
    default_authentication_plugin
    ft_stopword_file
    have_statement_timeout
    have_symlink
    hostname
    init_file
    keyring_operations
    large_files_support
    large_page_size
    lc_messages_dir
    license
    locked_in_memory
    log_bin
    log_bin_basename
    log_bin_index
    log_bin_use_v1_row_events
    log_error
    lower_case_file_system
    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
    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
  • These plugin system variables cannot be persisted:

    audit_log_current_session
    audit_log_file
    audit_log_filter_id
    audit_log_format
    caching_sha2_password_auto_generate_rsa_keys
    caching_sha2_password_private_key_path
    caching_sha2_password_public_key_path
    daemon_memcached_engine_lib_name
    daemon_memcached_engine_lib_path
    daemon_memcached_option
    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_undo_directory
    innodb_undo_tablespaces
    innodb_version
    keyring_encrypted_file_data
    keyring_encrypted_file_password
    mecab_rc_file
    sha256_password_auto_generate_rsa_keys
    sha256_password_private_key_path
    sha256_password_public_key_path
    version_tokens_session

User Comments
Sign Up Login You must be logged in to post a comment.