Server Option, System Variable, and Status Variable Reference Name Cmd-Line Option File System Var Status Var Var Scope Dynamic lock_order_trace_missing_unlock Yes Yes Yes Global No lock_wait_timeout Yes Yes Yes Both Yes Locked_connects Yes Global No locked_in_memory Yes Global No log-bin Yes Yes log_bin Yes Global No log_bin_basename Yes Global No log_bin_index Yes Yes Yes Global No log_bin_trust_function_creators Yes Yes Yes Global Yes log_bin_use_v1_row_events Yes Yes Yes Global Yes log_error Yes Yes Yes Global No log_error_services Yes Yes Yes Global Yes log_error_suppression_list Yes Yes Yes Global Yes log_error_verbosity Yes Yes Yes Global Yes log-isam Yes Yes log_output Yes Yes Yes Global Yes log_queries_not_using_indexes Yes Yes Yes Global Yes log_raw Yes Yes Yes Global Yes log-short- format Yes Yes log_slave_updates Yes Yes Yes Global No log_slow_admin_statements Yes Yes Yes Global Yes log_slow_extra Yes Yes Yes Global Yes log_slow_slave_statements Yes Yes Yes Global Yes log_statements_unsafe_for_binlog Yes Yes Yes Global Yes log_syslog Yes Yes Yes Global Yes log_syslog_facility Yes Yes Yes Global Yes log_syslog_include_pid Yes Yes Yes Global Yes log_syslog_tag Yes Yes Yes Global Yes log-tc Yes Yes log-tc-size Yes Yes log_throttle_queries_not_using_indexes Yes Yes Yes Global Yes log_timestamps Yes Yes Yes Global Yes long_query_time Yes Yes Yes Both Yes low_priority_updates Yes Yes Yes Both Yes lower_case_file_system Yes Global No lower_case_table_names Yes Yes Yes Global No mandatory_roles Yes Yes Yes Global Yes 665