thread_handling

Support CLI: Yes

Support configuration file: Yes

Support dynamic modification: No

Scope: global

Parameter type: string

Default value: one-thread-per-connection

Possible values: one-thread-per-connection, pool-of-threads, and no-threads

This parameter specifies how the server handles threads for client connections. The options are described as follows:

• one-thread-per-connection: A thread is allocated to each connection to handle the requests of the connection. This mode applies to scenarios with a small number of connections.
• pool-of-threads: The thread pool is used to handle all requests of all connections. This mode applies to short queries with a large number of connections.
• no-threads: The main thread is used to process all connections. This mode is generally used for debugging.