Method, device and equipment for executing checkpoint operation and storage medium

A checkpoint and statement execution technology, applied in the database field, can solve problems such as the inability to guarantee database read performance and write performance, and achieve the goal of improving read performance, improving write performance, optimal read performance and write performance Effect

Pending Publication Date: 2020-11-03
GUANGDONG OPPO MOBILE TELECOMM CORP LTD
View PDF0 Cites 1 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] Since the threshold corresponding to the checkpoint operation is set by the technician based on human experience, the set threshold may not guarantee the database read performance and write performance

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
  • Method, device and equipment for executing checkpoint operation and storage medium
  • Method, device and equipment for executing checkpoint operation and storage medium
  • Method, device and equipment for executing checkpoint operation and storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0079] 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.

[0080] Before explaining the embodiment of the present application in detail, the application scenario of the embodiment of the present application will be described first.

[0081] The embodiment of the present application is applied in a scenario where a checkpoint operation is performed on a WAL file of the database after the database is opened in the WAL mode. Wherein, the database is a database supporting WAL mode, such as SQLite (a lightweight database) and the like. In versions before 3.7.0, SQLite generally uses rollback log files to ensure the atomicity of transaction commits. After version 3.7.0, SQLite provides WAL mode, which is a mechanism for implementing atomic transactions.

[0082] In addition, the database may ...

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 method and device for executing checkpoint operation, equipment and a storage medium, and belongs to the technical field of databases. The method comprisesthe steps: if it is detected that the page number of a WAL file changes and the changed first page number is larger than a first threshold value and smaller than or equal to a second threshold value,determining the statement type of a currently executed statement; if the statement type of the current execution statement is a write-in statement, allowing the WAL file to continue to be subjected todata write-in according to the subsequently detected execution statement of the database; and if the statement type of the currently executed statement is a non-written statement, executing a check point operation so as to synchronize data in the WAL file into the database. Thus, the threshold value corresponding to the check point operation is dynamically adjusted according to the statement typeof the currently executed statement, so that the database can obtain better reading performance and writing performance.

Description

technical field [0001] The embodiments of the present application relate to the technical field of databases, and in particular to a method, device, device, and storage medium for performing a checkpoint operation. Background technique [0002] WAL (Write-Ahead Logging, pre-write log) mode is a new log mode added to the database to improve the concurrency of the database. The working principle of WAL mode is: database changes are not directly written into the database file, but are first written into the WAL file, and after a period of time, the data in the WAL file is synchronized to the database. Among them, the operation of synchronizing the data in the WAL file to the database is called a checkpoint operation. [0003] In the related technology, the technician generally uses the wal_autocheckpoint method to configure a threshold for the checkpoint operation. When the page number of the WAL file is greater than the threshold, the checkpoint operation is automatically per...

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/27G06F16/20
CPCG06F16/27G06F16/20
Inventor 管玉伟
Owner GUANGDONG OPPO MOBILE TELECOMM CORP 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