How Machine Learning Transforms SQL Performance Anomaly Diagnosis

This article summarizes Professor Cai Peng's presentation on diagnosing online database performance anomalies, covering traditional rule‑based and statistical root‑cause SQL methods, novel learning‑based techniques such as adaptive time‑window selection and multi‑metric analysis, experimental results, and real‑world case studies.

MachineLearningRootCausedatabase

0 likes · 16 min read

How Machine Learning Transforms SQL Performance Anomaly Diagnosis

Aikesheng Open Source Community

Apr 2, 2024 · Databases

Root Cause Analysis of MySQL Replica Synchronization Hang and Mitigation Recommendations

This article investigates a MySQL 8.0.27 replica that repeatedly hangs during show replica status, analyzes worker thread states, InnoDB status, checkpoint and I/O load, identifies an oversized Redo Log usage as the root cause, and provides configuration and upgrade suggestions to resolve the issue.

InnoDBMTSReplication

0 likes · 14 min read

Root Cause Analysis of MySQL Replica Synchronization Hang and Mitigation Recommendations

Sohu Tech Products

Jan 18, 2023 · Big Data

Root Cause Analysis of Flink TaskManager Failover Causing Data Reprocessing and Business Impact

An incident report details how a scheduled machine reboot on Alibaba Cloud triggered a Flink TaskManager failover, leading to excessive data replay, increased ES pressure, and significant business latency, and explains the root cause involving disabled checkpoints and timestamp‑based offset consumption.

CheckpointFlinkKafka

0 likes · 10 min read

Root Cause Analysis of Flink TaskManager Failover Causing Data Reprocessing and Business Impact