关键词: 多缓冲池 配置 自调优 多次划分

Abstract:

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 through    put rate.This paper introduces the model for configuring multiple buffer pools,and gives a multiple classification algorithm for self-tuning multiple bu ffer pools based on the model.

Key words: multiple buffer pool;configuration;self-tuning;multiple classification