Low watermark buffer cache

A system comprising:

• at least one processor;
• and
• at least one memory including instructions, which when executed by the at least one processor, causes the system to provide operations comprising:
• configuring a low threshold and a maximum threshold for page-loadable data at a buffer cache associated with a database, wherein the low threshold is 70% of the maximum threshold;
• checking the buffer cache to determine usage of the buffer cache by the page-loadable data;
• in response to the usage of the buffer cache being below the low threshold, continuing to check the buffer cache to determine usage by the page-loadable data;
• in response to the usage of the buffer cache being above the low threshold and below the maximum threshold, causing a background job to release one or more buffers in a freelist pool of the buffer cache while one or more other database operations continue;
• checking the buffer cache after releasing the one or more buffers in the freelist pool to determine whether usage by the page-loadable data is below the low threshold;
• in response to the usage being below the low threshold, stopping the release of the one or more buffers in the freelist pool;
• in response to the usage being above the low threshold, causing the background job to release one or more buffers in a least recently used pool of the buffer cache while the one or more other database operations continue;
• checking the buffer cache after releasing the one or more buffers in the least recently used pool to determine whether usage by the page-loadable data is below the low threshold;
• in response to the usage being below the low threshold, stopping the release of the one or more buffers in the least recently used pool;
• and
• in response to the usage being above the low threshold, causing the background job to release one or more buffers in a hot buffer list pool of the buffer cache while the one or more other database operations continue.

A non-transitory computer-readable storage medium including instructions, which when executed by at least one processor, causes operations comprising:

• configuring a low threshold and a maximum threshold for page-loadable data at a buffer cache associated with a database, wherein the low threshold is 70% of the maximum threshold;
• checking the buffer cache to determine usage of the buffer cache by the page-loadable data;
• in response to the usage of the buffer cache being below the low threshold, continuing to check the buffer cache to determine usage by the page-loadable data;
• in response to the usage of the buffer cache being above the low threshold and below the maximum threshold, causing a background job to release one or more buffers in a freelist pool of the buffer cache while one or more other database operations continue;
• checking the buffer cache after releasing the one or more buffers in the freelist pool to determine whether usage by the page-loadable data is below the low threshold;
• in response to the usage being below the low threshold, stopping the release of the one or more buffers in the freelist pool;
• in response to the usage being above the low threshold, causing the background job to release one or more buffers in a least recently used pool of the buffer cache while the one or more other database operations continue;
• checking the buffer cache after releasing the one or more buffers in the least recently used pool to determine whether usage by the page-loadable data is below the low threshold;
• in response to the usage being below the low threshold, stopping the release of the one or more buffers in the least recently used pool;
• and
• in response to the usage being above the low threshold, causing the background job to release one or more buffers in a hot buffer list pool of the buffer cache while the one or more other database operations continue.