MFTune: An Efficient Multi-fidelity Framework for Spark SQL Configuration Tuning

Fuente: arXiv
Salvato in:
Dettagli Bibliografici
Autori principali: Xu, Beicheng, Tung, Lingching, Wang, Yuchen, Lu, Yupeng, Cui, Bin
Natura: Preprint
Pubblicazione: 2026
Soggetti:
Accesso online:
Tags: Aggiungi Tag
Nessun Tag, puoi essere il primo ad aggiungerne!!
_version_ 1866917349950488576
author Xu, Beicheng
Tung, Lingching
Wang, Yuchen
Lu, Yupeng
Cui, Bin
author_facet Xu, Beicheng
Tung, Lingching
Wang, Yuchen
Lu, Yupeng
Cui, Bin
contents Apache Spark SQL is a cornerstone of modern big data analytics.However,optimizing Spark SQL performance is challenging due to its vast configuration space and the prohibitive cost of evaluating massive workloads. Existing tuning methods predominantly rely on full-fidelity evaluations, which are extremely time-consuming,often leading to suboptimal performance within practical budgets.While multi-fidelity optimization offers a potential solution, directly applying standard techniques-such as data volume reduction or early stopping-proves ineffective for Spark SQL as they fail to preserve performance correlations or represent true system bottlenecks. To address these challenges, we propose MFTune, an efficient multi-fidelity framework that introduces a query-based fidelity partitioning strategy, utilizing representative SQL subsets to provide accurate, low-cost proxies. To navigate the huge search space, MFTune incorporates a density-based optimization mechanism for automated knob and range compression, alongside an adapted transfer learning approach and a two-phase warm start to further accelerate the tuning process. Experimental results on TPC-H and TPC-DS benchmarks demonstrate that MFTune significantly outperforms five state-of-the-art tuning methods, identifying superior configurations within practical time constraints.
format Preprint
id arxiv_https___arxiv_org_abs_2603_16450
institution arXiv
publishDate 2026
record_format arxiv
spellingShingle MFTune: An Efficient Multi-fidelity Framework for Spark SQL Configuration Tuning
Xu, Beicheng
Tung, Lingching
Wang, Yuchen
Lu, Yupeng
Cui, Bin
Databases
Apache Spark SQL is a cornerstone of modern big data analytics.However,optimizing Spark SQL performance is challenging due to its vast configuration space and the prohibitive cost of evaluating massive workloads. Existing tuning methods predominantly rely on full-fidelity evaluations, which are extremely time-consuming,often leading to suboptimal performance within practical budgets.While multi-fidelity optimization offers a potential solution, directly applying standard techniques-such as data volume reduction or early stopping-proves ineffective for Spark SQL as they fail to preserve performance correlations or represent true system bottlenecks. To address these challenges, we propose MFTune, an efficient multi-fidelity framework that introduces a query-based fidelity partitioning strategy, utilizing representative SQL subsets to provide accurate, low-cost proxies. To navigate the huge search space, MFTune incorporates a density-based optimization mechanism for automated knob and range compression, alongside an adapted transfer learning approach and a two-phase warm start to further accelerate the tuning process. Experimental results on TPC-H and TPC-DS benchmarks demonstrate that MFTune significantly outperforms five state-of-the-art tuning methods, identifying superior configurations within practical time constraints.
title MFTune: An Efficient Multi-fidelity Framework for Spark SQL Configuration Tuning
topic Databases
url https://arxiv.org/abs/2603.16450