Method and device for data persistence processing and data base system

Abstract

The invention discloses a method and a device for data persistence processing and a data base system. The method for data persistence processing includes: adding page identification respectively corresponding to generated dirty pages into a checking point queue every time an internal memory of the data base system generates dirty pages; determining an activity set and a current set in the checking point queue, and sequentially unloading the dirty pages corresponding to identification of each page and included by the activity set into a disc at a preset checking point occurring occasion; checking the page identification respectively corresponding to the plurality of dirty pages which are going to be uploaded into the disc in the point queue to form the activity set; enabling an inserted set added into the checking point queue to serve as the current set; and determining a next activity set in the checking point queue if unloading of relative dirty pages of the activity set is finished, and sequentially unloading the dirty pages corresponding to the identification of each page included by the next activity set into the disc. By means of the method and the device for data persistence processing and the data base system, the efficiency in dirty pages unloading is improved on the basis that dirty page unloading has small influence on normal business operation.

Description

technical field [0001] The invention relates to the field of computer technology, in particular to a data persistence processing method, device and database system. Background technique [0002] Compared with disk, memory can provide higher throughput and fast response. Database systems usually store certain data such as data that is more cumbersome to read and write in memory first, so as to improve the speed of data reading and writing and realize high-speed caching. Database systems usually use pages as the unit of cache. When a process modifies the data in the cache, the page is marked as a dirty page (Dirty Page) by the kernel, and the database system will save the data of the dirty page at an appropriate time. Write to disk to keep the data in the cache consistent with the data on disk. [0003] The checkpoint mechanism is a mechanism that enables the database to recover after a failure. The traditional checkpoint mechanism, also known as the full checkpoint mechanis...

AI Technical Summary

Problems solved by technology

[0004] In order to overcome the disadvantages of the traditional full checkpoint mechanism affecting normal transaction execution, a mechanism called "fuzzy checkpoint" was proposed

The purpose of the fuzzy checkpoint mechanism is to gradually flush the generated dirty pages to the disk, thereby reducing the impact of data persistence processing on the user's normal transaction operations. However, the existing technology still lacks an effective solution for how to implement it. Program

Images