This document describes the connection pool feature. The TencentDB for MySQL proxy supports the session-level connection pool feature. It can effectively solve the problem of excessively high database instance loads caused by frequent establishments of new non-persistent connections.
You have enabled the database proxy.
The session-level connection pool is applicable to non-persistent connection scenarios.
- The session-level connection pool does not reduce the number of concurrent connections to the database, but it can reduce the overheads of the main thread of TencentDB for MySQL by lowering the speed for connecting the application to the database, so as to better process business requests. However, idle connections in the connection pool will occupy your connection quantity temporarily.
- The session-level connection pool cannot be used to solve the problem of connection heap caused by a large number of slow SQL queries, which must first be solved by yourself.
mt@test456does not, a permission error may occur when you enable the connection pool.