tencent cloud

Feedback

Setting Session-Level Connection Pool

Last updated: 2022-03-18 19:51:43

    This document describes how to configure the session-level connection pool.

    Prerequisites

    Database Proxy Disabled

    1. Log in to the TencentDB 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 instance to enter the instance management page.
    3. On the Database Proxy tab on the instance 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 TencentDB 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 instance to enter the instance management page.
    3. On the Database Proxy tab on the instance management page, click Enable after Connection Pool at the bottom of the overview.
    4. In the pop-up window, 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 TencentDB 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 instance to enter the instance management page.
    3. On the Database Proxy tab on the instance management page, click View/Edit after Connection Pool under the overview.
    4. In the pop-up window, set the relevant configuration items and click OK.
    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 avaliable.

    7x24 Phone Support