Server System Variable Reference 5.1.5 Server System Variable Reference The following table lists all system variables applicable within  mysqld . The table lists command-line options (Cmd-line), options valid in configuration files (Option file), server system variables (System Var), and status variables (Status var) in one unified list, with an indication of where each option or variable is valid. If a server option set on the command line or in an option file differs from the name of the corresponding system variable, the variable name is noted immediately below the corresponding option. The scope of the variable (Var Scope) is Global, Session, or both. Please see the corresponding item descriptions for details on setting and using the variables. Where appropriate, direct links to further information about the items are provided. Table 5.2 System Variable Summary 690 Name Cmd-Line Option File System Var Var Scope Dynamic activate_all_roles_on_login Yes Yes Yes Global Yes admin_address Yes Yes Yes Global No admin_port Yes Yes Yes Global No admin_ssl_ca Yes Yes Yes Global Yes admin_ssl_capath Yes Yes Yes Global Yes admin_ssl_cert Yes Yes Yes Global Yes admin_ssl_cipher Yes Yes Yes Global Yes admin_ssl_crl Yes Yes Yes Global Yes admin_ssl_crlpath Yes Yes Yes Global Yes admin_ssl_key Yes Yes Yes Global Yes admin_tls_ciphersuites Yes Yes Yes Global Yes admin_tls_version Yes Yes Yes Global Yes audit_log_buffer_size Yes Yes Yes Global No audit_log_compression Yes Yes Yes Global No audit_log_connection_policy Yes Yes Yes Global Yes audit_log_current_session Yes Both No audit_log_encryption Yes Yes Yes Global No audit_log_exclude_accounts Yes Yes Yes Global Yes audit_log_file Yes Yes Yes Global No audit_log_filter_id Yes Both No audit_log_flush Yes Global Yes audit_log_format Yes Yes Yes Global No audit_log_include_accounts Yes Yes Yes Global Yes audit_log_max_size Yes Yes Yes Global Yes audit_log_password_history_keep_days Yes Yes Yes Global Yes audit_log_policy Yes Yes Yes Global No audit_log_prune_seconds Yes Yes Yes Global Yes audit_log_read_buffer_size Yes Yes Yes Varies Varies audit_log_rotate_on_size Yes Yes Yes Global Yes