Documentation Home
Oracle Enterprise Manager for MySQL Database User's Guide
Download this Manual
PDF (US Ltr) - 0.7Mb
PDF (A4) - 0.7Mb
HTML Download (TGZ) - 223.8Kb
HTML Download (Zip) - 231.3Kb


7.18 Logging Configuration Metrics

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

Table 7.18 Logging Configuration Metrics

NameDescription
General Log EnabledThis option enables logging to the general query log, which contains entries that record client connections and SQL statements received from clients.
General Log FileThe name of the general query log file.
Log Backward Compatible User Definitions EnabledWhether to log the user_specification part of CREATE USER, ALTER USER, and GRANT statements in backward-compatible (pre-5.7.6) fashion
Log ErrorLog errors and startup messages to this file.
Log Error ServicesA list of semicolon-separated components to enable for error logging. The server executes components in the listed order.
Log Error VerbosityThis variable controls verbosity of the server in writing error, warning, and note messages to the error log.
Log OutputThis option determines the destination for general query log and slow query log output.
Log TimestampsThis variable controls the timestamp time zone of error log messages, and of general query log and slow query log messages written to files.
Log WarningsPrint out warnings such as Aborted connection... to the error log.
SQL Log DisabledIf set to true, no logging is done to the general query log for this client.
Syslog EnabledWhether to write error log output to syslog (on Unix and Unix-like systems) or Event Log (on Windows).
Syslog FacilityThe 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 EnabledWhether 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 TagThe 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.