Redo log management method and device and storage medium

A redo and log technology, applied in the database field, can solve problems such as low efficiency, achieve the effect of improving efficiency and reducing file lock conflicts

Active Publication Date: 2020-05-08
HUAWEI TECH CO LTD
View PDF7 Cites 13 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0005] The present application provides a method, device and storage medium for managing redo logs, which can solve the problem of low efficiency in the process of writing redo logs in the redo log cache to redo log files

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Redo log management method and device and storage medium
  • Redo log management method and device and storage medium
  • Redo log management method and device and storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0037] In order to make the purpose, technical solution and advantages of the present application clearer, the implementation manners of the present application will be further described in detail below in conjunction with the accompanying drawings.

[0038] Before explaining the embodiment of the present application in detail, the application scenarios involved in the embodiment of the present application are briefly described. At present, in the database system, the data modification is usually completed in the memory first, and then the data is persisted from the memory to the hard disk. Since the read and write speed of the hard disk is far behind the read and write speed of the memory, if the corresponding data is flushed every time the data is modified, the overhead is very large, which seriously affects the throughput of the system. Moreover, if the system crashes during the data flashing process, there is a high possibility of data loss.

[0039] In order to avoid the...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

PUM

No PUM Login to view more

Abstract

The invention discloses a redo log management method and device and a storage medium, and belongs to the technical field of databases. The method comprises the following steps of receiving a submission instruction of the first transaction, selecting the first redo log file for the first transaction from the multiple redo log files, and then using the determined first non-persistent redo log directly as the first redo log file, so that the situation that the file locks for the multiple redo logs need to be queued and competed is avoided, and the redo log writing efficiency can be improved.

Description

technical field [0001] The present application relates to the technical field of databases, in particular to a method, device and storage medium for managing redo logs. Background technique [0002] Currently, data modification operations in database systems are performed in units of transactions, and one transaction may include multiple data modification operations. In the process of implementing a transaction, for any data modification operation, the modified data will be stored in memory, and a redo log for the data modification operation will be generated. The redo log includes information such as the storage address and modification content of the data before modification corresponding to the data modification operation in the hard disk. Later, the redo log is written to the redo log file through a certain strategy. The redo log file is stored in the hard disk, so that if the database system crashes, the data can be recovered according to the redo log file, so as to en...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

Application Information

Patent Timeline
no application Login to view more
Patent Type & Authority Applications(China)
IPC IPC(8): G06F16/18G06F16/172G06F16/23G06F9/46
CPCG06F9/466
Inventor 刘玉
Owner HUAWEI TECH CO LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap