Automatic knobs-tuning for DB2 using deep reinforcement learning

Modern database management systems have hundreds of different configuration parameters (knobs) that control various aspects of how they behave and perform. These knobs must be properly tuned in order to maximize the performance of the database for a given query workload. Traditionally, database administrators would be responsible for database performance tuning. However, manual configuration tuning is a difficult process for humans, as there are hundreds of different inter-dependent knobs to be tuned. Different queries and workloads also benefit from configurations differently, there is no one single database configuration that can fit all scenarios. We propose BLUTune, a system to automatically produce effective knob configuration for IBM DB2. BLUTune utilizes deep reinforcement learning and features a unique transfer-learning approach to training which allows for fast learning. In experimental validation, BLUTune demonstrates its capability of producing effective configurations across differing sizes of the TPC-DS OLAP benchmark in a timely manner.

Name thesis:degree_name

Master of Science (MSc)

Discipline thesis:degree_discipline

Computer Science

Grantor

University of Ontario Institute of Technology

Year dc:date.issued

2021

Author dc:creator

• Bryson, Spencer C.

Advisor dc:contributor.advisor

• Szlichta, Jarek

• Database tuning
• Knob tuning
• Deep reinforcement learning
• DB2

Language dc:language.iso

en

Handle dc:identifier.uri

https://hdl.handle.net/10155/1391

OAI identifier oai:identifier

oai:ontariotechu.scholaris.ca:10155/1391