The Library
Anatomy of learned database tuning with Bayesian optimization
Tools
Barbulescu, George-Octavian and Triantafillou, Peter (2022) Anatomy of learned database tuning with Bayesian optimization. In: 2022 IEEE 38th International Conference on Data Engineering Workshops (ICDEW), Kuala Lumpur, Malaysia, 09 May 2022. Published in: 2022 IEEE 38th International Conference on Data Engineering Workshops (ICDEW) ISBN 9781665481045. doi:10.1109/icdew55742.2022.00006
Research output not available from this repository.
Request-a-Copy directly from author or use local Library Get it For Me service.
Official URL: https://doi.org/10.1109/icdew55742.2022.00006
Abstract
Database Management System (DBMS) tuning is central to the performance of the end-to-end database system. DBMSs are typically characterised by hundreds of configuration knobs that impact various facets of their behavior and planning abilities. Tuning such a system is a prohibitively-challenging task due to the obfuscated knob inter-dependencies and the intimidating size of the design space. The general vendor recommendation is to sequentially tune each knob, which further exacerbates the time-consuming nature of the task. To overcome this, recent work in the realm of self-driving database systems proxy the design problem through Machine Learning. Among the most prominent proxies in self-managing databases literature is the Bayesian-inference proxy. The purpose of this proxy, or surrogate in Bayesian Optimisation parlance, is to learn the inter-knob relationships and how they relate to the overall performance, independent of any human guidance. To this end, one of the goals of this work is to shed light on the common design patterns we identify in Bayesian-driven DBMS tuning agents. Second of all, we aim to provide a handbook for implementing such agents through the lens of a new tuning framework that leverages a multi-regression proxy.
Item Type: | Conference Item (Paper) | ||||||
---|---|---|---|---|---|---|---|
Divisions: | Faculty of Science, Engineering and Medicine > Science > Computer Science | ||||||
SWORD Depositor: | Library Publications Router | ||||||
Journal or Publication Title: | 2022 IEEE 38th International Conference on Data Engineering Workshops (ICDEW) | ||||||
Publisher: | IEEE | ||||||
ISBN: | 9781665481045 | ||||||
Official Date: | May 2022 | ||||||
Dates: |
|
||||||
DOI: | 10.1109/icdew55742.2022.00006 | ||||||
Status: | Peer Reviewed | ||||||
Publication Status: | Published | ||||||
Access rights to Published version: | Restricted or Subscription Access | ||||||
Conference Paper Type: | Paper | ||||||
Title of Event: | 2022 IEEE 38th International Conference on Data Engineering Workshops (ICDEW) | ||||||
Type of Event: | Conference | ||||||
Location of Event: | Kuala Lumpur, Malaysia | ||||||
Date(s) of Event: | 09 May 2022 |
Request changes or add full text files to a record
Repository staff actions (login required)
View Item |