Database processing method and device and computer readable storage medium

A processing method and database technology, applied in database management systems, special data processing applications, database models, etc., can solve the problems of hanging playback threads, playback failures, and inability to view lock waiting information, so as to reduce the difficulty and cost of operation and maintenance , Improve the efficiency of operation and maintenance

Inactive Publication Date: 2020-12-01
金篆信科有限责任公司
View PDF5 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, the database only supports querying the lock waiting information that is currently occurring, and cannot trace back the historical lock waiting information
[0003] When the database is played back in parallel, the playback often fails due to lock waiting, and even the playback thread hangs
It is too late for the operation and maintenance personnel to check after discovering the problem, because the lock waiting information at that time can no longer be viewed

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
  • Database processing method and device and computer readable storage medium
  • Database processing method and device and computer readable storage medium
  • Database processing method and device and computer readable storage medium

Examples

Experimental program
Comparison scheme
Effect test

example 1

[0093] This example provides a method for recording lock waiting history information based on the MySQL database. Such as Figure 7 As shown, the method of recording lock waiting history information based on the MySQL database is as follows, including:

[0094] (1) Start MySQL

[0095] In step 701, a lock waiting information cache for storing lock waiting information is created during MySQL startup.

[0096] Step 702, creating a log collection thread.

[0097] Step 703, the database is started successfully.

[0098] Step 704, cyclically monitor the SQL request from the client.

[0099] (2) Business thread

[0100] Step 705, after the MySQL startup is complete, it starts to monitor the connection request from the client, and after monitoring the connection request, it will create a link to receive the SQL request on the link and create a business thread to process these requests.

[0101] Step 706, analyzing the received SQL statement;

[0102] Step 707, apply for a lock...

example 2

[0119] This example provides a method for recording lock waiting history information based on Mariadb. Such as Figure 8 As shown, the method of recording lock waiting history information based on the Mariadb database is as follows, including:

[0120] (1) Start MariaDB

[0121] In step 801, a lock waiting information cache for storing lock waiting information is created during MariaDB startup.

[0122] Step 802, creating a log collection thread.

[0123] Step 803, the database is started successfully.

[0124] Step 804, cyclically monitor the SQL request from the client.

[0125] (2) Business thread

[0126] Step 805, MariaDB begins to monitor the connection request from the client after the startup is completed, and creates a link to receive the SQL request on the link and creates a business thread to handle these requests after the connection request is monitored;

[0127] Step 806, parsing the received SQL statement;

[0128] Step 807, apply for a lock for the SQL s...

example 3

[0145] This example provides a method for recording lock waiting history information based on the Percona database, such as Figure 9 shown, including:

[0146] (1) Start Percona

[0147] In step 901, a lock waiting information cache for storing lock waiting information is created during Percona startup.

[0148] Step 902, creating a log collection thread.

[0149] Step 903, the database is started successfully.

[0150] Step 904, cyclically monitor the SQL request from the client.

[0151] (2) Business thread

[0152] Step 905, Percona begins to monitor the connection request from the client after the startup is completed, and after monitoring the connection request, it will create a link to receive the SQL request on the link and create a business thread to handle these requests;

[0153] Step 906, analyzing the received SQL statement;

[0154] Step 907, applying for a lock for the SQL statement;

[0155] Step 908, if it is found that there is a lock waiting during th...

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 database processing method and device, and a computer readable storage medium. The database processing method comprises steps that after lock waiting is generated, the lock waiting related information is written into a lock waiting log. The method is advantaged in that the lock waiting information is recorded in the lock waiting log, so subsequent query of the lock waiting information and tracing of the lock waiting historical information are facilitated, operation and maintenance difficulty and cost are reduced, and database operation and maintenance efficiency is improved.

Description

technical field [0001] Embodiments of the present invention relate to but are not limited to a database processing method, device, and computer-readable storage medium. Background technique [0002] The database receives various services sent by the client and converts them into transactions on the database that run concurrently. Since the records in the table may be locked or the entire table may be locked directly during the operation of the transaction, this will cause lock waiting and block the business operation. When the operation and maintenance personnel find that the business running time increases and the performance of the entire system decreases, they will think of querying whether there is a lock waiting. However, the database only supports querying the current lock waiting information, and cannot trace back the historical lock waiting information. [0003] During parallel playback of the database, the playback often fails due to lock waiting, and even the pla...

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/28G06F16/25
CPCG06F16/284G06F16/25G06F16/2343G06F16/2358G06F16/252G06F9/466
Inventor 林品丁岩卢勤元戚晨俞义方赵培
Owner 金篆信科有限责任公司
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