Audit Log Configuration Metrics

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

Name Description
Buffer Size When 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 Policy The 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 State This option controls how the server loads the audit_log plugin at startup.
Exclude Accounts The 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
File The name of the file to which the audit log plugin writes events.
Flush Determines whether to trigger the flushing of the audit log's in-memory cache to the audit log file, and to close and reopen the audit log file.
Format The audit log file format. Permitted values are OLD and NEW (default OLD).
Include Accounts The accounts for which events are logged. The value is NULL or a string containing a list of one or more comma-separated account names.
Policy The 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 Size If 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 Policy The 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
Strategy The 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