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


7.1 Audit Log Configuration Metrics

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

Table 7.1 Audit Log Configuration Metrics

NameDescription
Buffer SizeWhen the audit log plugin writes events to the log asynchronously, it uses a buffer to store event contents prior to writing them. This variable controls the size of that buffer, in bytes. The server adjusts the value to a multiple of 4096. The plugin uses a single buffer, which it allocates when it initializes and removes when it terminates. The plugin allocates this buffer only if logging is asynchronous.
Connection PolicyThe policy controlling how the audit log plugin writes connection events to its log file. Permitted values: 'ALL' - Log all connection events, 'ERRORS' - Log only failed connection events, 'NONE' - Do not log connection events
Enabled StateThis option controls how the server loads the audit_log plugin at startup.
Exclude AccountsThe accounts for which events are not logged. The value is NULL or a string containing a list of one or more comma-separated account names
FileThe name of the file to which the audit log plugin writes events.
Flush 
FormatThe audit log file format. Permitted values are OLD and NEW (default OLD).
Include AccountsThe accounts for which events are logged. The value is NULL or a string containing a list of one or more comma-separated account names.
PolicyThe policy controlling how the audit log plugin writes events to its log file. Permitted values: 'ALL' - Log all events, 'LOGINS' - Log only login events, 'QUERIES' - Log only query events ,'NONE' - Log nothing (disable the audit stream)
Rotate On SizeIf the audit_log_rotate_on_size value is greater than 0, the audit log plugin closes and reopens its log file if a write to the file causes its size to exceed this value. The original file is renamed to have a timestamp extension.
Statement PolicyThe policy controlling how the audit log plugin writes statement events to its log file. Permitted values: 'ALL' - Log all statement events, 'ERRORS' - Log only failed statement events, 'NONE' - Do not log statement events
StrategyThe logging method used by the audit log plugin. Permitted values: 'ASYNCHRONOUS' - Log asynchronously, wait for space in output buffer, 'PERFORMANCE' - Log asynchronously, drop request if insufficient space in output buffer, 'SEMISYNCHRONOUS' - Log synchronously, permit caching by operating system, 'SYNCHRONOUS' - Log synchronously, call sync() after each request