PDF (US Ltr)
- 0.7Mb
PDF (A4)
- 0.7Mb
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 |