Digital Marketing

If the #MySQL audit log plugin is enabled, it exposes several system variables that permit control over logging

mysql> SHOW VARIABLES LIKE 'audit_log%';
+-----------------------------+--------------+
| Variable_name               | Value        |
+-----------------------------+--------------+
| audit_log_buffer_size       | 1048576      |
| audit_log_compression       | NONE         |
| audit_log_connection_policy | ALL          |
| audit_log_current_session   | OFF          |
| audit_log_encryption        | NONE         |
| audit_log_exclude_accounts  |              |
| audit_log_file              | audit.log    |
| audit_log_filter_id         | 49           |
| audit_log_flush             | OFF          |
| audit_log_format            | NEW          |
| audit_log_include_accounts  |              |
| audit_log_policy            | ALL          |
| audit_log_read_buffer_size  | 32768        |
| audit_log_rotate_on_size    | 0            |
| audit_log_statement_policy  | ALL          |
| audit_log_strategy          | ASYNCHRONOUS |
+-----------------------------+--------------+

Comments

Popular posts from this blog

MySQL Sandbox with the Sakila sample database