Method and device for controlling memory in database rollback synchronization

Abstract

The embodiment of the present invention provides a memory control method and device in database rollback synchronization. The method includes: if the log analysis thread resolves to the DML operation transaction of the database, then locate the corresponding transaction structure in the hash table according to the ID of the DML operation transaction; if the transaction structure to which the DML operation transaction belongs is located, and the DML operation transaction The value of the dba information stored in the first dba_array structure exceeds the storage threshold of the first dba_array structure, then the second dba_array structure is allocated to the DML operation transaction, and the dba information is stored in the first dba_array structure and the second dba_array structure simultaneously; If the value of the dba information exceeds the sum of the storage threshold of the first dba_array structure and the storage threshold of the second dba_array structure, the dba information is stored in the storage disk, and the memory space occupied by the dba information is released, and the first dba_array structure is added to The end of the dba_array linked list. The method and device for controlling the memory in the database rollback synchronization provided by the embodiments of the present invention alleviate the shortage of memory resources when performing partial rollback synchronization.

Description

technical field [0001] Embodiments of the present invention relate to the technical field of database synchronization, and in particular to a method and device for controlling memory in database rollback synchronization. Background technique [0002] Data synchronization from the database to other heterogeneous databases based on log parsing is to capture the incremental REDO records by reading the REDO log files or archived log files of the database in real time, and then analyze the change vector (Change vector) in the REDO records The content of the database is parsed to obtain the DML (Data Manipulation Language) operation of the database and the corresponding data, and the information is converted and sent to the target database for SQL reverse recovery, and then the synchronization is performed. In order to perform transaction-level synchronization and support partial transaction rollback synchronization, the capture analysis synchronization thread needs to collect all...

AI Technical Summary

Problems solved by technology

However, when the source-end database executes a large number of transaction operations, the DBA information of a large number of transaction DML operations needs to be cached in the memory, causing the memory resources of the source-end system to be tight.

Images