Enterprise Manager
Lists the Audit Log configuration metrics and provides a brief description of each.
Table 7.1 Audit Log Configuration Metrics
| 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 | |
| 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 |