High-concurrency database access method, system and equipment based on thread pool

Abstract

The invention provides a high-concurrency database access method, system and equipment based on a thread pool, and the method comprises the steps: monitoring a database access request initiated by other threads in the system through a main thread, transmitting a signal instruction to a management thread after receiving the request, and carrying out the wake-up operation of the management thread; and after receiving the signal, enabling the management thread to check whether the task queue of the request thread is idle or not to execute the access of the database in different modes, so that the problem that a server responds slowly and even crashes when a large number of request threads request to access the database at the same time is avoided. By increasing the concurrent access number of the database and managing the threads through the thread pool, the consumption of a memory can be reduced, and the system load pressure caused by the fact that multiple processes access the database at the same time and occupy too many computer resources is relieved. The thread pool technology is adopted to solve the problem that the database timeliness is low when multiple processes are simultaneously carried out in the system, and the stability of high-concurrency database access is improved. Therefore, rapid and high-concurrency access to the database is realized.

Description

technical field [0001] The invention belongs to the processing of DCS transmission data, mainly relates to the field of high-concurrency access databases, and specifically relates to a thread pool-based high-concurrency database access method, system and equipment. Background technique [0002] In the upper computer part of the distributed control system (DCS), multiple upper computer software, that is, multiple processes, are usually run at the same time, and multiple processes in the upper computer usually initiate data access requests to the database at the same time. However, when a large number of host computer processes simultaneously request to access the database in the system, it may cause the database server to respond slowly or even crash. In addition, when there are a large number of processes in the system requesting access to the database at the same time, it may cause the processes to be suspended and suspended after system scheduling, and the subsequent proce...

AI Technical Summary

Problems solved by technology

[0003] Aiming at the problem that the server responds slowly or even crashes when a large number of processes request to access the database at the same time in the system in the prior art, the present invention provides a high-concurrency database access method, system and device based on a thread pool, through which threads can be conveniently managed , can also reduce memory consumption, and take measures such as thread pool control system access to the database to alleviate the system load pressure caused by excessive memory resources occupied by multiple application processes accessing the database at the same time, thereby achieving fast and high concurrent access to the database

Images