tencent cloud

All product documents
TDSQL-C for MySQL
Setting Session-Level Connection Pool
Last updated: 2023-01-03 17:21:17
Setting Session-Level Connection Pool
Last updated: 2023-01-03 17:21:17
This document describes how to configure the session-level connection pool.

Database Proxy Disabled

1. Log in to the TDSQL-C for MySQL console.
2. Select the region at the top of the page and click the ID or Manage in the Operation column of the target cluster to enter the cluster management page.
3. On the Database Proxy tab on the cluster management page, click Enable Now.
4. In the pop-up dialog box, enable the connection pool feature.

Database Proxy Enabled

1. Log in to the TDSQL-C for MySQL console.
2. Select the region at the top of the page and click the ID or Manage in the Operation column of the target cluster to enter the cluster management page.
3. On the Database Proxy tab on the cluster management page, click Enable after Connection Pool at the bottom of the overview.

4. In the pop-up dialog box, set the relevant configuration items and click OK.
Connection Pool Status: Enable connection pool.
Connection Pool Type: Session-level connection pool is supported.
Connection Persistence Timeout: The time threshold for idle connections to be retained in the connection pool of the proxy, which can be 1–300 seconds.
Note:
A flash disconnection will occur upon adjustment completion. Make sure that your business has a reconnection mechanism.

5. After the connection pool is successfully enabled, you can view the details and edit the configuration in Overview > Basic Info on the Database Proxy tab.

Disabling Connection Pool

1. Log in to the TDSQL-C for MySQL console.
2. Select the region at the top of the page and click the ID or Manage in the Operation column of the target cluster to enter the cluster management page.
3. On the Database Proxy tab on the cluster management page, click View/Edit next to Connection Pool at the bottom of the overview.
4. In the pop-up dialog box, toggle off the Connection Pool Status option and click OK.

Was this page helpful?
You can also Contact Sales or Submit a Ticket for help.
Yes
No

Feedback

Contact Us

Contact our sales team or business advisors to help your business.

Technical Support

Open a ticket if you're looking for further assistance. Our Ticket is 7x24 available.

7x24 Phone Support
Hong Kong, China
+852 800 906 020 (Toll Free)
United States
+1 844 606 0804 (Toll Free)
United Kingdom
+44 808 196 4551 (Toll Free)
Canada
+1 888 605 7930 (Toll Free)
Australia
+61 1300 986 386 (Toll Free)
EdgeOne hotline
+852 300 80699
More local hotlines coming soon