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
Image
Examples
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...
PUM
Login to View More Abstract
Description
Claims
Application Information
- IPC
- G06F16/28; G06F16/25
- CPC
- G06F16/284; G06F16/25; G06F16/2343; G06F16/2358; G06F16/252; G06F9/466
- Inventors
- 林品; 丁岩