Database transaction request processing method, related equipment and storage medium

Abstract

The invention discloses a transaction request processing method of a database, related equipment and a storage medium. The method comprises the steps of receiving an update transaction request for a first data line in the database; if the first hot line update waiting queue of the first data line exists in the storage engine, writing the update transaction request into the first hot line update waiting queue; if the first hot line update waiting queue corresponding to the first data line does not exist in the storage engine, determining the queue length of a first line lock waiting queue corresponding to the first data line in the storage engine; when the queue length of the first row lock waiting queue exceeds a preset length threshold, creating a corresponding first hot row update waiting queue for the first data row in the storage engine, and writing the update transaction request into the first hot row update waiting queue; and in response to a preset trigger signal, adding the update transaction request in the first hot line update waiting queue into the first line lock waiting queue. According to the invention, the transaction throughput rate of the database system under thehigh concurrency condition is improved.

Description

technical field [0001] The invention relates to the field of computer technology, in particular to a database transaction request processing method, related equipment and storage media. Background technique [0002] In the database system, when a large number of concurrent transactions issue update operations on the same data row in the database, the data row becomes a hot data row. In order to ensure the transaction throughput rate of the database system under high concurrency conditions, current limiting processing is generally performed on update transaction requests for hot data rows. [0003] Taking the relational database system MySQL as an example, in related technologies, by adding SQL hotspot data row update hint syntax, MySQL users can provide the primary key of the hotspot data row when submitting SQL statements (that is, transaction requests), and MySQL receives the hint of the hotspot data row After the SQL statement, extract the primary key of the hot data row...

AI Technical Summary

Problems solved by technology

[0004] The implementation of the above-mentioned related technologies needs to change the SQL syntax, which increases the workload of the MySQL user. If the user wants to use the hot data row function, the SQL statement of the original application needs to be changed to provide the SQL statement that meets the above-mentioned functional syntax format; in addition, because MySQL The user needs to provide the primary key of the hot data row, so the perception of the hot data row needs to be done by the user, which means that the user program needs to allocate some system resources to count which data rows are hot, for example, an additional key-value cache system is needed to Store information such as the access frequency and primary key of data rows in the database, and at the same time need to update and maintain these information in real time as hot spots change, which greatly increases the maintenance cost of database users; and at the server layer, locks are used to update transaction requests for hot data rows Serialization reduces the concurrency between updating transactions for the same hot data row, and cannot make full use of idle resources of the database system, which is not conducive to improving the transaction throughput rate of the database system under high concurrency

Images