Aurora Serverless - query logs

Hi,

The steps required for Aurora Serverless differ from those of RDS MySQL, in order to see the logs publishing to CloudWatch will need to be turned on once that is done, the logs specified will be visible from cloud watch [1].

In order allow the publishing of logs to cloud watch, you will need to create a custom cluster parameter group then attach it to your Aurora cluster. To create a cluster parameter group; navigate to the RDS console on the left pane select Parameter groups, create parameter group, under the parameter group family select “aurora5.6”, give the parameter group a name and description, then save [2].

From the list of parameter groups click on the one you just created, click on Edit parameters depending on the logs required modify the values as follows:

For general logs, set the value of parameter' general_log to 1
For slow query logs, set slow_query_log to 1
For long time query, set long_query_log to 0.1 (s) or a value of your choosing

Once the changes are saved, navigate to Databases select the Aurora cluster, modify and under Additional configuration, choose the DB cluster group from the drop down list. Click continue and apply immediately this will reboot the clustewr then apply the changes onto the cluster, once the cluster is in the available state logs will be available from cloud watch.

Hope this helps!

/MrK

References:
[1] https://aws.amazon.com/about-aws/whats-new/2019/02/amazon-aurora-serverless-publishes-logs-to-amazon-cloudwatch/
[2] https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/USER_WorkingWithParamGroups.html#USER_WorkingWithParamGroups.CreatingCluster