Yueyang Zhan

Yueyang Zhan

Auto-generated profile, based on publicly available information

Yueyang Zhan

University of Electronic Science and Technology of China

Research Focus & Metrics

Academic Career Length

3Years (2024-Present)

(Calculated once Scilit publication data is synced: current year − year of first publication + 1)

Representative Publications

View All Publications
12 April 2024
Verified
Conference Paper
Open access
YZYueyang Zhan
Yueyang Zhan
RXRui Xi
Rui Xi
JLJianming Liao
Jianming Liao
SFShuhuan Fan
Shuhuan Fan
MHMengshu Hou
Mengshu Hou
Confronted with an abundance of adjustable parameters and ever-shifting workloads, database configuration tuning grapples with persistent challenges. The intricate task of thoroughly optimizing all these configuration "knobs" to attain peak performance proves arduous and time-consuming. Current strategies often necessitate numerous performance assessments preceding configuration tuning, alongside the selection of pivotal knobs aimed at reducing the parameter space. Nonetheless, crafting a database configuration tuning strategy that accommodates dynamically fluctuating workloads remains a formidable challenge, owing to the substantial variations in optimization requirements across diverse application scenarios and workloads. This paper introduces an innovative configuration tuning approach, coined as KnobTune. Initially, it leverages SHAP (SHapley Additive exPlanations) values to assess the significance of historical tuning tasks’ key knobs. Subsequently, it integrates SQL textual features and internal database operational metrics as workload attributes, assigning weights based on their similarity to historical workloads to select key knobs. Comparative evaluations of some benchmarks are conducted to validate the efficacy of this methodology. The results show that our proposed strategy adeptly identifies and adjusts critical knobs when confronted with varying workloads, delivering substantial enhancements in performance optimization compared to prevailing approaches.

15 June 2025
Verified
Book Chapter
Closed access
PDF file
WXWentao Xiao
Wentao Xiao
YZYueyang Zhan
Yueyang Zhan
RXRui Xi
Rui Xi
ZHZhuohan Hou
Zhuohan Hou
JLJianming Liao
Jianming Liao
YSYufang Sun
Yufang Sun