CGPTuner
Authors:
Open Access
- 1 April 2021
- journal article
- research article
- Published by Association for Computing Machinery (ACM) in Proceedings of the VLDB Endowment
- Vol. 14 (8) , 1401-1413
Abstract
Properly selecting the configuration of a database management system (DBMS) is essential to increase performance and reduce costs. However, the task is astonishingly tricky due to a large number of tunable configuration parameters and their inter-dependencies. Also, the optimal configuration depends upon the workload to which the DBMS is exposed. To extract the full potential of a DBMS, we must also consider the entire IT stack on which the DBMS is running, comprising layers like the Java virtual machine, the operating system and the physical machine. Each layer offers a multitude of parameters that we should take into account. The available parameters vary as new software versions are released, making it impractical to rely on historical knowledge bases. We present a novel tuning approach for the DBMS configuration auto-tuning that quickly finds a well-performing configuration of an IT stack and adapts it to workload variations, without having to rely on a knowledge base. We evaluate the proposed approach using the Cassandra and MongoDB DBMSs, showing that it adjusts the suggested configuration to the observed workload and is portable across different IT applications. We try to minimise the memory consumption without increasing the response time, showing that the proposed approach reduces the response time and increases the memory requirements only under heavy-load conditions, reducing it again when the load decreases.Keywords
This publication has 15 references indexed in Scilit:
- Automatic Database Management System Tuning Through Large-scale Machine Learning2017
- BOAT2017
- COBAYNACM Transactions on Architecture and Code Optimization, 2016
- Taking the Human Out of the Loop: A Review of Bayesian OptimizationProceedings of the IEEE, 2015
- OpenTuner2014
- Deconstructing iterative optimizationACM Transactions on Architecture and Code Optimization, 2012
- Benchmarking cloud serving systems with YCSB2010
- CassandraACM SIGOPS Operating Systems Review, 2010
- Tuning database configuration parameters with iTunedProceedings of the VLDB Endowment, 2009
- SARD: A statistical approach for ranking database tuning parameters2008