Dynamic database memory management according to swap rates

摘要

Memory of a database management system (DBMS) that is running in a virtual or physical machine is managed using techniques that that reduce the effect of memory swaps on the performance of the physical or virtual machine. One such technique includes the steps of determining a swap rate while the database application is in an executing state, and decreasing the size of memory space available to the database application if the swap rate is above a threshold.

主权项

1. In a computer system having an operating system and a database application running as a user-level application on top of the operating system, a method of dynamically adjusting a size of memory space available to the database application, said method comprising the steps of:
determining a swap rate of memory pages swapped into memory from disk by the operating system while the database application is in an executing state; and decreasing the size of memory space available to the database application if the swap rate is above a threshold, wherein the decreasing is carried out at a rate proportional to the swap rate.