How can I enable/disable MySQL slow query logging on Amazon RDS without restarting I would like to enable/disable slow query logging on an Amazon RDS instance without having to restart. I'm aware that I can do this by changing the slow_query_log parameter in the instance's parameter group, but this requires me to restart.

On the other hand, I've seen that this is possible with SET GLOBAL slow_query_log = 'ON'; in MySQL, but this requires super privileges, which are restricted to the rdsadmin user on Amazon RDS.

I've also found this resource: How do I enable functions, procedures, and triggers for my Amazon RDS MySQL instance? but the description says "when binary logging is enabled", which is not what I need.
The slow_query_log variable is a dynamic variable.

Dynamic variables can be updated without a restart:


  When you change a dynamic parameter and save the DB parameter group,
  the change is applied immediately regardless of the Apply Immediately
  setting.


So just change it and you should see the effects immediately.