TuningChef: an approach for choosing the best cost-benefit database tuning actions

Abstract

While many research works propose a way to list a set of fine-tuning options for a given workload, only a few offer a way to help the DBA make better decisions when encountering a set of available options, especially when taking his possibilities into consideration. We propose and develop a step-by-step decision process. Given a set of fine-tuning options, we recommend the most cost-benefit subset. Enough context for the DBA accompanies the recommendation to understand its reasoning, with the possibility of letting the user build his own subset and check the expected impact. We show some experimental results on actual database systems that further explain our approach and solution.

Tuningchef: Uma Abordagem Para Escolher as Ações De Sintonia Fina De Banco De Dados Com Melhor Custo-Benefício

“…A estratégia de índices foi implementada para dois SGBDs para demonstrar que a TuningChef não está restrita a um único sistema de banco de dados. Resultados parciais desse trabalho foram publicados antes da defesa desta dissertação [37].…”