A database management system connection multiplexing method and device
A technology for a management system and a multiplexing device is applied in the field of database management system connection multiplexing, which can solve the problems of low use efficiency and large resource overhead, and achieve the effect of improving use efficiency and overall performance.
Active Publication Date: 2018-02-27
SHENZHEN TENCENT COMP SYST CO LTD
View PDF5 Cites 0 Cited by
- Summary
- Abstract
- Description
- Claims
- Application Information
AI Technical Summary
Problems solved by technology
[0004] The present invention provides a database management system connection multiplexing method and device, aiming to solve the problem of high resource overhead and low efficiency in the existing thread-based MySQL connection multiplexing technology system
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 moreImage
Smart Image Click on the blue labels to locate them in the text.
Smart ImageViewing Examples
Examples
Experimental program
Comparison scheme
Effect test
Embodiment Construction
[0025] In order to make the object, technical solution and advantages of the present invention clearer, the present invention will be further described in detail below in conjunction with the accompanying drawings and embodiments. It should be understood that the specific embodiments described here are only used to explain the present invention, not to limit the present invention.
[0026] see figure 1 , is a flow chart of the database management system connection multiplexing method according to the first embodiment of the present invention. The database management system connection multiplexing method of the first embodiment of the present invention includes the following steps:
[0027] Step S100: establish a database connection pool object, and create a database connection request;
[0028] Step S110: Analyze the structured query language, judge whether there is an idle reusable connection in the database connection pool according to the type of the structured query lang...
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
Login to View More Abstract
The invention belongs to the field of data storage and particularly relates to a connection multiplexing method and a connection multiplexing device for a database management system. The connection multiplexing method for the database management system comprises the following steps: establishing a database connection pool object and creating a database connection request; analyzing an SQL (Structured Query Language), judging whether a multiplexing connection which is in an idle state exists in a database connection pool or not according to the type and processing state of the SQL, if the multiplexing connection which is in an idle state exists, executing the next step; selecting the multiplexing connection which is in an idle state to perform multiplexing. The connection multiplexing method and the connection multiplexing device for the database management system can be used for setting a MySQL connection as reusable or not according to the type of the processed SQL, fully using one MySQL connection and improving the overall performance of the system; the MySQL connection is set as idle or not according to the processing state of the SQL, so that the problem that the connection multiplexing effect depends on a user is avoided, and the use efficiency is improved.
Description
technical field [0001] The invention belongs to the technical field of data storage, and in particular relates to a connection multiplexing method and device for a database management system. Background technique [0002] In the existing client library that encapsulates mysql operations or the proxy module that implements the separation of mysql reads and writes, a thread-based connection multiplexing technology is adopted, and the database connection is stored as an object in a container object. Once the database connection is established, different The database access requests can share these connections. In this way, by reusing these established database connections, the time for establishing database connections can be reduced, system resources and time can be greatly saved, and the performance of the entire system can be improved. Among them, mysql is a relational database management system. The relational database stores data in different tables instead of putting all ...
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
Login to View More Patent Type & Authority Patents(China)
IPC IPC(8): G06F17/30
CPCG06F16/25
Inventor 程彬李宇
Owner SHENZHEN TENCENT COMP SYST CO LTD