What tools can display MySQL audit logs in a visual interface rather than command line?

Other Questions MySQL
1

I’m working with a managed MySQL database on Oracle Cloud Infrastructure (OCI). The database has audit logging enabled through a plugin, but I’m running into some challenges with viewing and managing these logs.

Right now I can only access the audit logs using SQL commands like audit_log_read() with timestamp parameters. However, this approach has major limitations:

  • The log storage is capped at 5GB and older entries get automatically deleted
  • Each query only returns 20-40 log entries due to a 32kb read buffer
  • I can’t modify these settings since I don’t have root access on the managed service
  • Browsing logs this way is slow and tedious

I need a better solution to view audit logs from several months or even a year ago. The logs contain important information like SQL queries, timestamps, usernames, and host details.

What I’m looking for is either:

  • A GUI tool that can connect to MySQL and display audit logs in a user-friendly format
  • A way to export these logs to an external system for long-term storage and easier browsing
  • Any open source or third-party solutions that work well with OCI

Has anyone dealt with similar audit log management challenges? What tools or approaches worked best for you?

2

I’ve encountered similar audit log limitations with managed MySQL instances. One approach that worked well for me was setting up a scheduled job to regularly export audit data using the audit_log_read() function and storing it in an external system before it gets purged. For visualization, I found that tools like Grafana can work effectively when paired with a time-series database like InfluxDB or even a simple PostgreSQL instance. You can create a script that periodically pulls the audit logs via SQL, parses the relevant fields, and pushes them to your chosen storage backend. This gives you long-term retention and much better querying capabilities. Another option worth considering is MySQL Workbench’s log viewer functionality, though it has limitations with large datasets. For a more robust solution, I’ve seen people use ELK stack (Elasticsearch, Logstash, Kibana) successfully for MySQL audit log analysis. The key is getting the data out of MySQL’s limited storage first, then you have much more flexibility with visualization and analysis tools.