Help Center/ TaurusDB/ FAQs/ Log Management/ 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?
Updated on 2024-12-30 GMT+08:00

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.