aurora - log types

Types of logs

Error log (Generated by default)

Slow query log (need to specify in db parameter groups)

• slow_query_log 1 or 0 - enables slow query log
• general_log 1 or 0 - enabled general log
• log_output to Table (mysql.general_log) or file
• long_query_time specify the threshold, fast queries are identified based on this

To send the logs to cloudwatch, use the agent and push the file in file system

General log (need to specify in db parameter groups)

Audit log (Advanced auditing) 1

• server_audit_logging - enable or disable Advanced Auditing
• server_audit_events - what events to log
  • server_audit_incl_users - include users
  • server_audit_excl_users - exclude users
• The audit logs can be downloaded from the console

Instance log

IAM database authentication error log

References

1. Using Advanced Auditing with an Amazon Aurora MySQL DB cluster