drchuck
drchuck

Reputation: 4675

How do I enable a slow query log for Amazon "Aurora MySQL" engine?

There seems to be no information on AWS "Aurora MySQL" about how to pull out slow query logs. I am not using RDS / MySQL - I am using Aurora.

Upvotes: 6

Views: 11234

Answers (2)

Vlam
Vlam

Reputation: 1798

In the "mysql" database, open the "slow_log" table and you can view the slow queries.

Upvotes: 1

Brad McCoy
Brad McCoy

Reputation: 366

Go Into AWS > RDS > Parameter Groups > { select the parameter group you you db is in } > Click Edit Parameters > find slow query log and set to 1.

enter image description here

Upvotes: 5

Related Questions