Why Are Slow SQL Statements Displayed in Slow Query Log Monitoring, but No Information About Them Is Displayed on the Slow Query Logs Tab Page in the Logs Module?
When log_slow_admin_statements is set to ON, the database kernel records management SQL statements, such as Binlog Dump GTID, ANALYZE TABLE and OPTIMIZE TABLE, in slow query logs. However, these SQL statements are usually initiated by O&M operations and are not closely related to workloads. So, they are filtered out when uploaded to the Logs module, helping users efficiently and accurately check, locate, and analyze slow queries generated on workloads.
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.
For any further questions, feel free to contact us through the chatbot.
Chatbot