Adaptive Tuning of Buffer Pool Size in Database Server Based on Iterative Algorithm

Junya SHIMIZU  Yixin DIAO  Maheswaran SURENDRA  

IEICE TRANSACTIONS on Information and Systems   Vol.E90-D   No.2   pp.594-597
Publication Date: 2007/02/01
Online ISSN: 1745-1361
DOI: 10.1093/ietisy/e90-d.2.594
Print ISSN: 0916-8532
Type of Manuscript: LETTER
Category: System Programs
database server,  buffer pool,  performance control,  extended Kalman filtering,  iterative algorithm,  

Full Text: PDF(157.6KB)>>
Buy this Article

One of the system greatly affecting the performance of a database server is the size-division of buffer pools. This letter proposes an adaptive control method of the buffer pool sizes. This method obtains the nearly optimal division using only observed response times in a comparatively short duration.