# LlamaTune: Sample-Efficient DBMS Configuration Tuning

arXiv: https://arxiv.org/abs/2203.05128 · HTML: https://mlsanity.com/paper/2203.05128/

## Key facts

- Cited by 14 papers in the map (data through 14 Oct 2026).
- First posted on arXiv 10 Mar 2022.

## Built on by (most cited first, 14 of 14)

- [OpenBox: A Python Toolkit for Generalized Black-box Optimization](https://mlsanity.com/paper/2304.13339/) (2023)
- [E2ETune: End-to-End Knob Tuning via Fine-tuned Generative Language Model](https://mlsanity.com/paper/2404.11581/) (2024)
- [Is Large Language Model Good at Database Knob Tuning? A Comprehensive Experimental Evaluation](https://mlsanity.com/paper/2408.02213/) (2024)
- [A Unified and Efficient Coordinating Framework for Autonomous DBMS Tuning](https://mlsanity.com/paper/2303.05710/) (2023)
- [Dividable Configuration Performance Learning](https://mlsanity.com/paper/2409.07629/) (2024)
- [Navigating in High-Dimensional Search Space: A Hierarchical Bayesian Optimization Approach](https://mlsanity.com/paper/2410.23148/) (2024)
- [AI-Driven Research for Databases](https://mlsanity.com/paper/2604.06566/) (2026)
- [Evaluating Useful Surrogate Models for Configuration Tuning Beyond Accuracy: A Fitness Landscape Analysis Perspective](https://mlsanity.com/paper/2509.21945/) (2025)
- [Tesserae: Scalable Placement Policies for Deep Learning Workloads](https://mlsanity.com/paper/2508.04953/) (2025)
- [Can AI autonomously build, operate, and use the entire data stack?](https://mlsanity.com/paper/2512.07926/) (2025)
- [WAter: A Workload-Adaptive Knob Tuning System based on Workload Compression](https://mlsanity.com/paper/2603.28809/) (2026)
- [TuxBot: Semantic-Aware Online OS Tuning with Large Language Models](https://mlsanity.com/paper/2605.15026/) (2026)
- [A Case for Agentic Tuning: From Documentation to Action in PostgreSQL](https://mlsanity.com/paper/2605.19988/) (2026)
- [Accelerating Cross-Model LLM Inference via Attention Map Reuse](https://mlsanity.com/paper/2610.14688/) (2026)

## Abstract (arXiv)

Tuning a database system to achieve optimal performance on a given workload is a long-standing problem in the database community. A number of recent works have leveraged ML-based approaches to guide the sampling of large parameter spaces (hundreds of tuning knobs) in search for high performance configurations. Looking at Microsoft production services operating millions of databases, sample efficiency emerged as a crucial requirement to use tuners on diverse workloads. This motivates our investigation in LlamaTune, a tuner design that leverages domain knowledge to improve the sample efficiency of existing optimizers. LlamaTune employs an automated dimensionality reduction technique based on randomized projections, a biased-sampling approach to handle special values for certain knobs, and knob values bucketization, to reduce the size of the search space. LlamaTune compares favorably with the state-of-the-art optimizers across a diverse set of workloads. It identifies the best performing configurations with up to 11× fewer workload runs, and reaching up to 21% higher throughput. We also show that benefits from LlamaTune generalize across both BO-based and RL-based optimizers, as well as different DBMS versions. While the journey to perform database tuning at cloud-scale remains long, LlamaTune goes a long way in making automatic DBMS tuning practical at scale.
