Help Center>
Relational Database Service>
FAQs>
Log Management>
How Do I View All SQL Logs Executed by RDS for MySQL?
Updated on 2023-04-20 GMT+08:00
How Do I View All SQL Logs Executed by RDS for MySQL?
You can use the SQL audit function of RDS to query all SQL operation records. You can also use the visualized database management service Data Admin Service (DAS) to quickly search for target SQL execution records.
Querying SQL Logs Through DAS
- 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 and choose Databases > Relational Database Service.
- On the Instances page, locate the target DB instance and click Log In in the Operation column.
- On the displayed login page, enter the correct username and password and click Log In.
- On the top menu bar, choose SQL Operations > SQL History.
- On the displayed page, search for execution information about the target SQL statement by time range, database name, or keyword.
Figure 1 SQL History
- To access the Database Management page, click a database name.
- To copy and use your required SQL statements, click the SQL statement in the SQL Statement column.
- To directly execute a SQL statement, click Open in SQL Window in the Operation column.
Parent topic: Log Management
Log Management FAQs
- How Long Is the Delay for RDS MySQL Slow Query Logs?
- How Do I View All SQL Logs Executed by RDS for MySQL?
- How Can I Obtain RDS for SQL Server Error Logs Using Commands?
- How Do I View Deadlock Logs of RDS 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