Please use this identifier to cite or link to this item: https://doi.org/10.1145/1353452.1353455
Title: A new approach to dynamic self-tuning of database buffers
Authors: Tran, D.N.
Huynh, P.C.
Tay, Y.C. 
Tung, A.K.H. 
Keywords: Autonomic computing
Buffer allocation
Miss probability
Issue Date: 2008
Source: Tran, D.N.,Huynh, P.C.,Tay, Y.C.,Tung, A.K.H. (2008). A new approach to dynamic self-tuning of database buffers. ACM Transactions on Storage 4 (1). ScholarBank@NUS Repository. https://doi.org/10.1145/1353452.1353455
Abstract: Current businesses rely heavily on efficient access to their databases. Manual tuning of these database systems by performance experts is increasingly infeasible: For small companies, hiring an expert may be too expensive; for large enterprises, even an expert may not fully understand the interaction between a large system and its multiple changing workloads. This trend has led major vendors to offer tools that automatically and dynamically tune a database system. Many database tuning knobs concern the buffer pool for caching data and disk pages. Specifically, these knobs control the buffer allocation and thus the cache miss probability, which has direct impact on performance. Previous methods for automatic buffer tuning are based on simulation, black-box control, gradient descent, and empirical equations. This article presents a new approach, using calculations with an analytically-derived equation that relates miss probability to buffer allocation; this equation fits four buffer replacement policies, as well as twelve datasets from mainframes running commercial databases in large corporations. The equation identifies a buffer-size limit that is useful for buffer tuning and powering down idle buffers. It can also replace simulation in predicting I/O costs. Experiments with PostgreSQL illustrate how the equation can help optimize online buffer partitioning, ensure fairness in buffer reclamation, and dynamically retune the allocation when workloads change. It is also used, in conjunction with DB2's interface for retrieving miss data, for tuning DB2 buffer allocation to achieve targets for differentiated service. © 2008 ACM.
Source Title: ACM Transactions on Storage
URI: http://scholarbank.nus.edu.sg/handle/10635/43090
ISSN: 15533077
DOI: 10.1145/1353452.1353455
Appears in Collections:Staff Publications

Show full item record
Files in This Item:
There are no files associated with this item.

SCOPUSTM   
Citations

25
checked on Dec 12, 2017

Page view(s)

78
checked on Dec 15, 2017

Google ScholarTM

Check

Altmetric


Items in DSpace are protected by copyright, with all rights reserved, unless otherwise indicated.