Log processing method and device for database

A processing method and database technology, applied in the direction of file system function, file system type, file system, etc., can solve the problem of prolonging the log lock time, and achieve the effect of reducing the impact of blocking and shortening the operation time.

Active Publication Date: 2019-07-02
BEIJING BAIDU NETCOM SCI & TECH CO LTD
View PDF5 Cites 13 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

The read and write requests of the database need to obtain the log lock to write the log. When there are many dirty pages in the log, the time of the log lock will be extended accordingly.

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
  • Log processing method and device for database
  • Log processing method and device for database
  • Log processing method and device for database

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0029] The application will be further described in detail below in conjunction with the accompanying drawings and embodiments. It should be understood that the specific embodiments described here are only used to explain related inventions, rather than to limit the invention. It should also be noted that, for the convenience of description, only the parts related to the related invention are shown in the drawings.

[0030] It should be noted that, in the case of no conflict, the embodiments in the present application and the features in the embodiments can be combined with each other. The present application will be described in detail below with reference to the accompanying drawings and embodiments.

[0031] figure 1 An exemplary system architecture of a database log processing method or a database log processing device to which the present application can be applied is shown.

[0032] Such as figure 1 As shown, the system architecture 100 may include a user equipment 1...

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 embodiment of the invention discloses a log processing method and device for a database, electronic equipment and a computer readable medium. A specific embodiment of the method comprises the steps of renaming a log file stored in a disk in response to determining that the log file stored in the disk reaches a preset log cutting condition; periodically brushing dirty pages of the renamed log file in a memory into a disk at preset dirty page brushing time; calling the log refreshing command to create a new null log file so as to cut out a renamed log file; and clearing the cache informationof the cut log file in the memory. According to the embodiment, the blocking influence of the log lock on the database read-write request during log cutting can be reduced.

Description

technical field [0001] The embodiments of the present application relate to the field of computer technology, specifically to the field of database systems, and in particular to a database log processing method and device. Background technique [0002] Database log management is an important part of database operation and maintenance. Fine-grained segmentation of database logs can facilitate problem tracing and analysis of logs. [0003] The current method of database log splitting is mainly to split by refreshing the log file after backing up the log file. In this method, after issuing the command to refresh the log file, the global log is locked and the dirty pages of the log are flushed to the hard disk. However, the read and write requests of the database need to obtain the log lock to write the log. When there are many dirty pages in the log, the log lock time will be extended accordingly. Contents of the invention [0004] The embodiments of the present application...

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/17G06F16/18
Inventor 曾国伟蔡歌黄俊
Owner BEIJING BAIDU NETCOM SCI & 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