PDF (US Ltr)
- 0.7Mb
PDF (A4)
- 0.7Mb
Lists the Logging configuration metrics and provides a brief description of each.
Table 7.18 Logging Configuration Metrics
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. |