一种面向企业数据库工作负载感知根因分析的多模态机器学习框架
A Multimodal Machine Learning Framework for Enterprise Database Workload-Aware Root Cause Analysis
AI总结:
提出多模态机器学习框架,结合工作负载特征、系统遥测和操作信号,利用LightGBM等模型实现数据库根因分析,提升可解释性和自动化水平。
摘要:
企业数据库事件的根因分析通常是一个手动且耗时的过程,需要操作员检查日志、性能指标和工作负载行为。现有方法通常侧重于单一证据来源,这限制了它们捕获事件背后更广泛操作上下文的能力,例如CPU饱和、I/O瓶颈、锁争用、死锁和慢查询执行。本文提出了一种面向企业数据库环境中工作负载感知根因分析的多模态机器学习框架。所提出的方法结合了工作负载特征、系统遥测以及来自计算、存储和加速器导向数据集的操作信号。工程化的工作负载感知特征用于分类工作负载行为并支持对可能事件原因的下游诊断。该框架评估了随机森林、LightGBM和前馈神经网络模型用于工作负载分类和根因分析支持。实验结果表明,工作负载感知特征工程提高了工作负载的可分离性,其中LightGBM在预测性能和可解释性之间提供了最强的平衡。结果表明,将多模态遥测与工作负载上下文相结合可以为自动化和可解释的根因分析系统提供实用基础。
英文摘要:
Root cause analysis for enterprise database incidents is often a manual and time consuming process that requires operators to inspect logs, performance metrics, and workload behavior. Existing approaches commonly focus on a single source of evidence, which limits their ability to capture the broader operational context behind incidents such as CPU saturation, I/O bottlenecks, lock contention, deadlocks, and slow query execution. This paper presents a multimodal machine learning framework for workload-aware root cause analysis in enterprise database environments. The proposed approach combines workload characteristics, system telemetry, and operational signals from compute, storage, and accelerator oriented datasets. Engineered workload aware features are used to classify workload behavior and support downstream diagnosis of likely incident causes. The framework evaluates Random Forest, LightGBM, and feedforward neural network models for workload classification and root cause analysis support. Experimental results show that workload aware feature engineering improves workload separability, with LightGBM providing the strongest balance of predictive performance and interpretability. The results suggest that combining multimodal telemetry with workload context can provide a practical foundation for automated and explainable root cause analysis systems.
机构、总结、中文摘要均由AI分析而来,可能存在错误,请以论文正文为准。