How long is the delay for RDS for MySQL slow logs?
The delay is related to how often the MySQL Console collects slow logs. The console collects slow logs every hour, so the delay is up to one hour.
How do I view all SQL logs executed by RDS for MySQL?
You can use the SQL audit function to view all SQL logs executed by RDS for MySQL as follows:
1. Log in to the MySQL Console.
2. Go to the Instance Management page, click the instance name, and go to the Instance Details page.
3. Click to go to the SQL audit page to start SQL audit.
How do I view deadlock logs of RDS for MySQL?
The RDS for MySQL does not support viewing the MySQL deadlock logs alone. You can locate the corresponding deadlock logs by viewing the error logs. Details are as follows:
1. Go to the MySQL Console and click the target instance.
2. Click Error Log to go to the Error Log page.
3. Quickly locate the deadlock log through the keyword LATEST DETECTED DEADLOCK.