A Self-Tuning Algorithm for Multiple Buffer Pools of DBMS
Meiyi Xie · Computer Engineering and Science · 2007
This paper introduces the concept of configuring and self-tuning multiple buffer pools according to the specialty of the buffer area in DBMS.The whole buffer area is partitioned into a number of independent buffer pools.Database objects with different features are assigned to individual buffer pools.Also it can offer the most appropriate configuration for a specific workload,which can reduce the time consumption of i/os delays and improve the throughput rate.This paper introduces the model for configuring multiple buffer pools,and gives a multiple classification algorithm for self-tuning multiple buffer pools based on the model.