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.