- Newest
- Most votes
- Most comments
Hello.
There is no need to restart RDS if the only setting is to output slow query logs.
If you want to output to CloudWatch Logs, you need to check Slow Query from the RDS changes section to reflect the changes.
According to the documentation, there doesn't seem to be any downtime, but we recommend that you try it in a verification environment before making any changes to your production environment.
Hi,
slow_query_log is a dynamic parameter. You can change it without rebooting the instance. But you need a DB reboot, if you are currently using default parameter group, you need to create a new parameter group with the slow_query_log parameter set to 1 and assign the parameter group and DB instance reboot is required.
Just adding my test results, even modifying the instance with a new custom parameter group with slow_query_log = 1 (dynamic) did not reboot the instance. It is nice!
Thank you a lot. You are right It was tested and indeed setting the value to 1 in the existing custom parameter group and enabling the export to cloudwatch from the modify section. Did not require reboot of the RDS instance
Relevant content
- asked 17 days ago
- AWS OFFICIALUpdated 2 years ago
- AWS OFFICIALUpdated 3 years ago
- AWS OFFICIALUpdated 2 years ago
- AWS OFFICIALUpdated 3 years ago