My Oracle Support Banner

FAQ - MySQL Enterprise Audit (Doc ID 2991721.1)

Last updated on DECEMBER 07, 2023

Applies to:

MySQL Server - Version 8.0 and later
Information in this document applies to any platform.

Purpose

 This document is used to cover all frequently asked questions about MySQL Enterprise Audit.

Questions and Answers

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Purpose
Questions and Answers
 Q1: How to enable audit log?
 Q2: How to setup audit log for all information and what is the performance impact?
 Q3: How to setup audit log for DDL statements only and what is the performance impact?
 Q4: As per IST, current time is 10.11.2023 15:02 hrs but in the log is is 5:30 hours back, how to correct it ?
 Q5: SELECT audit_log_read() --- this command is giving error.
 Q6: What are the available options for MySQL Audit Log?
 Q7: What are the best practices in the MySQL Enterprise Audit?
 Q8: What is the recommendation configuration for audit_log_buffer_size?
 Q9: Where could I find examples for include/exclude settings for audit log filtering?
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.