Help Center> Relational Database Service> FAQs> Log Management> How Do I View Deadlock Logs of RDS for MySQL?
View PDF

How Do I View Deadlock Logs of RDS for MySQL?

Database deadlock logs are not recorded in error logs. To view deadlock logs, use Data Admin Service (DAS), a visualized and professional database management tool, to quickly execute SQL statements.

Procedure

  1. Log in to the management console.
  2. Click in the upper left corner and select a region and a project.
  3. Click Service List. Under Database, click Relational Database Service. The RDS console is displayed.
  4. On the Instance Management page, locate the target DB instance and click Log In in the Operation column.

    Figure 1 Logging in to a database

  5. On the displayed login page, enter the correct username and password and click Log In.
  6. Select the target database and choose SQL Operations > SQL Window. In the displayed SQL window, run show engine innodb status to view the latest deadlock logs of the selected database. The latest deadlock logs will overwrite the historical deadlock logs.
Parent topic: Log Management