Full usage of ODP threads

By default, 8,192 ODP threads are used. If the number of connections requested by applications is greater than this value, connections are denied. This topic describes the solution to the full usage of ODP threads.

Emergency procedure

If ODP threads are fully used, which is rare, you can resolve the issue based on one of the following two deployment modes of the ODP cluster:

• Centralized deployment

  If the ODP threads are fully used in an ODP cluster that is deployed in centralized mode, add ODPs to process extra connection requests. You can add ODPs in the OceanBase Cloud Platform (OCP) console. Perform the following steps:

  1. Log on to the OCP console.

  2. In the left-side navigation pane, click OBProxy.

  3. In the ODP cluster list, click the target ODP cluster. Then, the Overview page of the ODP cluster appears.

  4. Click Add OBProxy.

  5. In the dialog box that appears, set the following parameters: Software Version, IDC, SQL Port Number, Exporter Port Number, Host Type, Selection Method, and Host.

  6. Click OK.

  For more information, see Add an ODP.

• Standalone deployment, or an unscalable ODP cluster

  If the ODP threads are fully used in an ODP cluster that is deployed in standalone mode, increase the maximum allowed number of connection threads. You can modify this parameter of the ODP cluster in the OCP console. For more information, see OCP User Guide. You can also modify the parameter by running a command in the CLI.

  Sample command:

  ALTER proxyconfig SET client_max_connections = 16384;