SARD: A statistical approach for ranking database tuning parameters

Biplob K. Debnath, David J Lilja, Mohamed F Mokbel

Research output: Chapter in Book/Report/Conference proceedingConference contribution

24 Scopus citations

Abstract

Traditionally, DBMSs are shipped with hundreds of configuration parameters. Since the database performance highly depends on the appropriate settings of the configuration parameters, DBAs spend a lot of their time and effort to find the best parameter values for tuning the performance of the application of interest. In many cases, they rely on their experience and some rules of thumbs. However, time and effort may be wasted by tuning those parameters which may have no or marginal effects. Moreover, tuning effects also vary depending on the expertise of the DBAs, but skilled DBAs are increasingly becoming rare and expensive to employ. To address these problems, we present a Statistical Approach for Ranking Database parameters (SARD), which is based on the Plackett & Burman statistical design methodology. SARD takes the query workload and the number of configuration parameters as inputs, and using only a linear number of experiments, generates a ranking of database parameters based on their relative impacts on the DBMS performance. Preliminary experimental results using TPC-H and PostgreSQL show that SARD generated ranking can correctly identify critical configuration parameters.

Original languageEnglish (US)
Title of host publicationProceedings of the 2008 - IEEE 24th International Conference on Data Engineering Workshop, ICDE'08
Pages11-18
Number of pages8
DOIs
StatePublished - Sep 1 2008
Event2008 - IEEE 24th International Conference on Data Engineering Workshop, ICDE'08 - Cancun, Mexico
Duration: Apr 7 2008Apr 12 2008

Publication series

NameProceedings - International Conference on Data Engineering
ISSN (Print)1084-4627

Other

Other2008 - IEEE 24th International Conference on Data Engineering Workshop, ICDE'08
CountryMexico
CityCancun
Period4/7/084/12/08

Fingerprint Dive into the research topics of 'SARD: A statistical approach for ranking database tuning parameters'. Together they form a unique fingerprint.

Cite this