When a connection pool is used to access the database, database connections are established and then stored in the memory as objects during system running. When you need to access the database, no new connection is established. Instead, an existing idle connection is selected from the connection pool. After you finish accessing the database, the database does not disable the connection but puts it back into the connection pool. The connection can be used for the next access request.
min_pool_size
Parameter description: Specifies the minimum number of connections between a CN's connection pool and another CN/DN.
Type: POSTMASTER
Value range: an integer ranging from 1 to 65535
Default value: 1
max_pool_size
Parameter description: Specifies the maximum number of connections between a CN's connection pool and another CN/DN.
Type: POSTMASTER
Value range: an integer ranging from 1 to 65535
Default value: 800
persistent_datanode_connections
Parameter description: Specifies whether to release the connection for the current session.
Type: USERSET
Value range: Boolean
- off indicates that the connection for the current session will be released.
- on indicates that the connection for the current session will not be released.
After this function is enabled, a session may hold a connection but does not run a query. As a result, other query requests fail to be connected. To fix this problem, the number of sessions must be less than or equal to max_active_statements.
Default value: off
max_coordinators
Parameter description: Specifies the maximum number of CNs in a cluster.
Type: POSTMASTER
Value range: an integer ranging from 2 to 40
Default value: 40
max_datanodes
Parameter description: Specifies the maximum number of DNs in a cluster.
Type: POSTMASTER
Value range: an integer ranging from 2 to 65535
Default value: 4096
cache_connection
Parameter description: Specifies whether to reclaim the connections of a connection pool.
Type: SIGHUP
Value range: Boolean
- on indicates that the connections of a connection pool will be reclaimed.
- off indicates that the connections of a connection pool will not be reclaimed.
Default value: on
enable_force_reuse_connections
Parameter description: Specifies whether a session forcibly reuses a new connection.
Type: BACKEND
Value range: Boolean
- on indicates that the new connection is forcibly used.
- off indicates that the current connection is used.
Default value: off
Session connection parameter. Users are not advised to configure this parameter.
enable_pooler_parallel
Parameter description: Specifies whether a CN's connection pool can be connected in parallel mode.
Type: SIGHUP
Value range: Boolean
- on indicates that a CN's connection pool can be connected in parallel mode.
- off indicates that a CN's connection pool cannot be connected in parallel mode.
Default value: on