How to exclude MySQL Router metadata cache access logs in MySQL Enterprise Audit (Doc ID 2893716.1)

Last updated on DECEMBER 19, 2022

Applies to:

Goal

MySQL Router performs metadata retrieval every 0.5 seconds by default and that will generate audit records of 500 KB to 1 MB in size per second (the file can exceed 100 GB in size in a few days).
The following sample filter will exclude everything but query errors that are being executed by the MySQL Router user.

Solution

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