I want to find out the connections to all my databases in a database instance and I used the instructions below to enable General log on a RDS MariaDB database instance:
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_LogAccess.MySQLDB.PublishtoCloudWatchLogs.html
Unfortunately, I am not able to find the general log under log group in CloudWatch.
I can see a General (hyperlink) on the RDS database instance: RDS->Configure->Published Logs->Cloudwatch logs. When I clicked on the hyperlink, CloudWatch was opened but displayed an error: There was an error filtering log events. The specified log group does not exist.
I have set general_log to 1 on RDS->Parameter Groups, and enabled the check box for General Log for the DB Instance (Modify->Log export)
And also, will I be able to stop the General logging afterwards?
What is the performance impact on the database when General Loggin is turned on?
What is the performance impact on the database when Audit Logging is turned on?