Logging Configuration Metrics

Lists the Logging configuration metrics and provides a brief description of each.

Name Description
General Log Enabled This option enables logging to the general query log, which contains entries that record client connections and SQL statements received from clients.
General Log File The name of the general query log file.
Log Backward Compatible User Definitions Enabled Whether to log the user_specification part of CREATE USER, ALTER USER, and GRANT statements in backward-compatible (pre-5.7.6) fashion.
Log Error Log errors and startup messages to this file.
Log Error Services A list of semicolon-separated components to enable for error logging. The server executes components in the listed order.
Log Error Verbosity This variable controls verbosity of the server in writing error, warning, and note messages to the error log.
Log Output This option determines the destination for general query log and slow query log output.
Log Timestamps This variable controls the timestamp time zone of error log messages, and of general query log and slow query log messages written to files.
Log Warnings Print out warnings such as Aborted connection... to the error log.
SQL Log Disabled If set to true, no logging is done to the general query log for this client.
Syslog Enabled Whether to write error log output to syslog (on Unix and Unix-like systems) or Event Log (on Windows).
Syslog Facility The facility for error log output written to syslog (what type of program is sending the message). This variable has no effect unless the log_syslog system variable is enabled.
Syslog Include Pid Enabled Whether to include the server process ID in each line of error log output written to syslog. This variable has no effect unless the log_syslog system variable is enabled.
Syslog Tag The tag to be added to the server identifier in error log output written to syslog. This variable has no effect unless the log_syslog system variable is enabled.