数据库管理系统多缓冲池的配置及其多次划分自调优算法

本文针对数据库管理系统中缓冲区的特殊重要地位,介绍了多缓冲池的配置及自调优的概念。将缓冲区分为数个独立的缓冲池,为不同性质的数据库对象分别建立独立的缓冲池 ,也为不同的负载提供最佳的配置方式,能够减少不同负载下的i/os时间,提高吞吐率。本文介绍了多缓冲池配置的模型,并基于此模型提出了多缓冲池的多次划分自调优算法。

A Self-Tuning Algorithm for Multiple Buffer Pools of DBMS

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.