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

Junya SHIMIZU  Yixin DIAO  Maheswaran SURENDRA  

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

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


Summary: 
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.