Database check point construction method based on virtual memory snapshot

Abstract

The invention discloses a database check point construction method based on a virtual memory snapshot. The method comprises the steps that only one affair process exists in a database, and when a write-in or modification request is received, turning can be carried out to complete the request through writing in the memory; only one scheduling process exists in the database, when the conditions are met, the scheduling process actively notices an affair process to initiate the action of establishing a check point, then the scheduling process receives reports of the affair process and a check point process, and the system state is updated; after the affair process receives the notice of the scheduling process, the operation of virtually storing snapshot pictures is established, and then the check point process is started; after the check point process is started, the check point writes all updated data and logs in the current memory into a disk according to the virtually stored snapshoot pictures, and the advantages that the throughput rate of affairs in a database system is increased, and database affair blocking or performance shaking caused by check point establishing is avoided are achieved.

Description

technical field [0001] The invention relates to the field of computer software, in particular to a database checkpoint construction method based on virtual memory snapshots. Background technique [0002] In recent years, online transaction processing (OLTP) is facing higher and higher performance requirements in the big data environment, requiring the database to be more efficient, more accurate, and more reliable to handle high-concurrency transactions. In order to meet reliability requirements, traditional databases must rely on logs written to disk to achieve reliability. The speed of the disk is much slower than our memory, even if it is a solid state drive, its speed is an order of magnitude different from that of memory. Traditional databases mostly use logs to ensure the reliability of the database, similar to Oracle's redo log (redo log) and undo log (undo log), and the bin-log in Mysql. When writing data, frequently moving the magnetic head for random writing will...

AI Technical Summary

Problems solved by technology

[0005] The invention provides a method for constructing a database checkpoint based on a virtual memory snapshot, which solves the technical problems that the log write disk in the traditional database reduces the transaction performance, and the checkpoint blocks the transaction or brings transaction performance jitter, and realizes the avoidance of log file writing. The decrease in transaction performance caused by the disk improves the transaction throughput rate in the database system, and at the same time avoids the blocking of database transactions or performance jitter caused by the establishment of checkpoints. The technical effect of relying on hardware to provide reliability guarantees while improving transaction performance

Images