Millisecond-Level SQL Statements Recorded in Slow Query Logs

Scenario

The value of long_query_time for RDS for MySQL slow query logs is set to 1 second. However, there are SQL statements whose average execution time is less than 1 second in slow query logs.

Troubleshooting

Check whether log_queries_not_using_indexes is set to ON. If yes, the SQL statements not using indexes will also be recorded in slow query logs.

Parent topic: Other Issues

Previous topic: Rows Recorded in the SQL Diagnosis Result Far Less Than the Scanned Rows Recorded in Slow Query Logs

Next topic: Viewing Storage of RDS DB Instances

Feedback

Was this page helpful?

Helpful Not helpful

Provide feedback

Thank 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.

Which of the following issues have you encountered?

Content is inconsistent with the product UI

Unclear descriptions

Lack of examples or code

Incorrect steps

Can't find what I need

Lack of best practices

Feedback (optional)

0/500

Select at least one type of issue, and enter your comments or suggestions.

Enter a maximum of 500 characters.

Submit Cancel

For any further questions, feel free to contact us through the chatbot.

Chatbot