Automatic database knob tuning: a survey

X Zhao, X Zhou, G Li - IEEE Transactions on Knowledge and …, 2023 - ieeexplore.ieee.org
Knob tuning plays an important role in database optimization, which tunes knob settings to
optimize the database performance or improve resource utilization. However, there are …

Gptuner: A manual-reading database tuning system via gpt-guided bayesian optimization

J Lao, Y Wang, Y Li, J Wang, Y Zhang, Z Cheng… - arXiv preprint arXiv …, 2023 - arxiv.org
Modern database management systems (DBMS) expose hundreds of configurable knobs to
control system behaviours. Determining the appropriate values for these knobs to improve …

{SelfTune}: Tuning Cluster Managers

A Karthikeyan, N Natarajan, G Somashekar… - … USENIX Symposium on …, 2023 - usenix.org
Large-scale cloud providers rely on cluster managers for container allocation and load
balancing (eg, Kubernetes), VM provisioning (eg, Protean), and other management tasks …

Make your database system dream of electric sheep: towards self-driving operation

A Pavlo, M Butrovich, L Ma, P Menon, WS Lim… - Proceedings of the …, 2021 - dl.acm.org
Database management systems (DBMSs) are notoriously difficult to deploy and administer.
Self-driving DBMSs seek to remove these impediments by managing themselves …

Speedup your analytics: Automatic parameter tuning for databases and big data systems

J Lu, Y Chen, H Herodotou, S Babu - Proceedings of the VLDB …, 2019 - dl.acm.org
Database and big data analytics systems such as Hadoop and Spark have a large number
of configuration parameters that control memory distribution, I/O optimization, parallelism …

Adaptive code learning for spark configuration tuning

C Lin, J Zhuang, J Feng, H Li… - 2022 IEEE 38th …, 2022 - ieeexplore.ieee.org
Configuration tuning is vital to optimize the performance of big data analysis platforms like
Spark. Existing methods (eg auto-tuning relational databases) are not effective for tuning …

ML-Powered Index Tuning: An Overview of Recent Progress and Open Challenges

T Siddiqui, W Wu - ACM SIGMOD Record, 2024 - dl.acm.org
The increasing scale and complexity of workloads in modern cloud services highlight a
crucial challenge in automated index tuning: recommending high-quality indexes while …

UDO: universal database optimization using reinforcement learning

J Wang, I Trummer, D Basu - arXiv preprint arXiv:2104.01744, 2021 - arxiv.org
UDO is a versatile tool for offline tuning of database systems for specific workloads. UDO
can consider a variety of tuning choices, reaching from picking transaction code variants …

Towards general and efficient online tuning for spark

Y Li, H Jiang, Y Shen, Y Fang, X Yang, D Huang… - arXiv preprint arXiv …, 2023 - arxiv.org
The distributed data analytic system--Spark is a common choice for processing massive
volumes of heterogeneous data, while it is challenging to tune its parameters to achieve …

Towards optimal configuration of microservices

G Somashekar, A Gandhi - Proceedings of the 1st Workshop on …, 2021 - dl.acm.org
The microservice architecture allows applications to be designed in a modular format,
whereby each microservice can implement a single functionality and can be independently …