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

22 Citations (Scopus)

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
Title of host publicationProceedings of the 2008 - IEEE 24th International Conference on Data Engineering Workshop, ICDE'08
Pages11-18
Number of pages8
DOIs
Publication statusPublished - 1 Sep 2008
Event2008 - IEEE 24th International Conference on Data Engineering Workshop, ICDE'08 - Cancun, Mexico
Duration: 7 Apr 200812 Apr 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
Period7/4/0812/4/08

    Fingerprint

ASJC Scopus subject areas

  • Software
  • Signal Processing
  • Information Systems

Cite this

Debnath, B. K., Lilja, D. J., & Mokbel, M. F. (2008). SARD: A statistical approach for ranking database tuning parameters. In Proceedings of the 2008 - IEEE 24th International Conference on Data Engineering Workshop, ICDE'08 (pp. 11-18). [4498279] (Proceedings - International Conference on Data Engineering). https://doi.org/10.1109/ICDEW.2008.4498279