Re: MySQL auditing and tracing options

Hi

• We have been using https://github.com/mcafee/mysql-audit for last ~6 years and works pretty well.
• If you use Percona MySQL build then you can use https://www.percona.com/doc/percona-server/LATEST/management/audit_log_plugin.html
• You can use ProxySQL which allows you to get the query logs.
• If the intention is to troubleshoot a performance issue then sign up for a free trial of vividcortex, it will bring you closest to Oracle OEM, I would recommend using it for solving performance issues since it will give you detailed stats about all metrics such as count, average latency, p99 latency for each SQL executed over TCP on the MySQL server.

On Fri, Mar 20, 2020 at 8:06 PM Chris King <dmarc-noreply_at_freelists.org> wrote:

> I'm new to MySQL (but not Oracle). I have a very complex system where data
> comes in and out and is shared between multiple applications. I would like
> to trace the data thru the system to help diagnose a severe performance
> issue. If in Oracle, I'd use auditing and tracing. I'm looking for
> something similar in MySQL. So far I've found that MySQL Enterprise Edition
> commercial editions has an audit add-on. But we don't use this edition. We
> don't want to add triggers because the reason I want to trace is to nail
> down a serious performance issue, and triggers will make that worse.
>
> What other options are there for auditing and tracing in MySQL?
> Thanks in advance!
> -ck
>

--
http://www.freelists.org/webpage/oracle-l