Help Center>
GaussDB(for MySQL)>
FAQs>
Log Management>
How Do I View Deadlock Logs of GaussDB(for MySQL)?
Updated on 2023-09-15 GMT+08:00
How Do I View Deadlock Logs of GaussDB(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
- Log in to the management console.
- Click in the upper left corner and select a region and a project.
- Click in the upper left corner of the page, choose .
- On the Instances page, locate the instance you want to log in and click Log In in the Operation column.
- On the displayed login page, enter the correct username and password and click Log In.
Figure 1 Logging in to an instance
- Select the target database and click SQL Operations > SQL Window.
- In the displayed SQL window, run show engine innodb status to view the latest deadlock logs of the selected database. Use the keyword LATEST DETECTED DEADLOCK to locate the latest deadlock logs. The latest deadlock logs will overwrite the historical deadlock logs.
Parent topic: Log Management
Log Management FAQs
- Can I Enable general_log for GaussDB(for MySQL)?
- How Do I View All SQL Logs Executed by GaussDB(for MySQL)?
- How Do I View Slow Query Logs of GaussDB(for MySQL)?
- How Do I Enable and View Binlog of My GaussDB(for MySQL) Instance?
- How Do I Change the Binlog Retention Period?
- How Do I View Deadlock Logs of GaussDB(for MySQL)?
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
The system is busy. Please try again later.
For any further questions, feel free to contact us through the chatbot.
Chatbotmore