Abstract:With the growing market of cloud databases, careful detection and elimination of slow queries are of great importance to service stability. Previous studies focus on optimizing the slow queries that result from internal reasons (e.g., poorly-written SQLs). In this work, we discover a different set of slow queries which might be more hazardous to database users than other slow queries. We name such queries Intermittent Slow Queries (iSQs), because they usually result from intermittent performance issues that are external (e.g., at database or machine levels). Diagnosing root causes of iSQs is a tough but very valuable task. This paper presents iSQUAD, Intermittent Slow QUery Anomaly Diagnoser, a framework that can diagnose the root causes of iSQs with a loose requirement for human intervention. Due to the complexity of this issue, a machine learning approach comes to light naturally to draw the interconnection between iSQs and root causes, but it faces challenges in terms of versatility, labeling overhead and interpretability. To tackle these challenges, we design four components, i.e., Anomaly Extraction, Dependency Cleansing, Type-Oriented Pattern Integration Clustering (TOPIC) and Bayesian Case Model. iSQUAD consists of an offline clustering & explanation stage and an online root cause diagnosis & update stage. DBAs need to label each iSQ cluster only once at the offline stage unless a new type of iSQs emerges at the online stage. Our evaluations on real-world datasets from Alibaba OLTP Database show that iSQUAD achieves an iSQ root cause diagnosis average F1-score of 80.4%, and outperforms existing diagnostic tools in terms of accuracy and efficiency.

Real-Time Diagnosis of Configuration Errors for Software of AI Server Infrastructure

Practical and accurate pinpointing of configuration errors using static analysis

Can We Use Programmer's Knowledge? Fixing Parameter Configuration Errors in Hadoop Through Analyzing Q&A Sites

Automated diagnosis of software misconfigurations based on static analysis

Integrated distributed intelligent system architecture for incidents monitoring and diagnosis

Anytime Diagnosis for Reconfiguration

ConfMapper: Automated Variable Finding for Configuration Items in Source Code.

ServerRCA: Root Cause Analysis for Server Failure Using Operating System Logs

Multi-misconfiguration Diagnosis via Identifying Correlated Configuration Parameters

Static Code Analysis in the AI Era: An In-depth Exploration of the Concept, Function, and Potential of Intelligent Code Analysis Agents

Intelligent Fault Diagnosis for AIT-Based Smart Farming Applications

Revisiting artificial intelligence diagnosis of hepatocellular carcinoma with DIKWH framework

Fault Diagnosis for Test Alarms in Microservices Through Multi-source Data

Mining Configuration Items From System Logs through Distant Supervision

A Novel Method to Prevent Misconfigurations of Industrial Automation and Control Systems

Diagnosing Root Causes of Intermittent Slow Queries in Cloud Databases

Research on anomaly detection and real-time reliability evaluation with the log of cloud platform

Intelligent Cross-Working Condition Fault Detection and Diagnosis Using Isolation Forest and Adversarial Discriminant Domain Adaptation

Research ON Satellites Fault Diagnosis Method Based on Artificial Intelligence

Research on Hardware Automatic Inspection System of Computer Big Data Server.

XAI-LCS: Explainable AI-Based Fault Diagnosis of Low-Cost Sensors