thread_pool_size
Number of thread groups in the pool. This parameter is roughly equivalent to maximum number of concurrently executing threads (threads in a waiting state do not count as executing).
See also: System Variables in 10.5 ES, in 10.5 CS, in 10.4 ES, in 10.4 CS, in 10.3 ES, in 10.3 CS, in 10.2 ES, and in 10.2 CS
DETAILS
PARAMETERS
Command-line |
--thread_pool_size=# |
Configuration file |
Supported |
Dynamic |
Yes |
Scope |
Global |
Data Type |
INT UNSIGNED |
Minimum Value |
1 |
Maximum Value |
100000 |
Default Value |
8 |
SkySQL Analytical 10.5 |
Default: 4 (choices: 0, 16, 32, 64, 128, 256, 512, 1024, 2048) |
SkySQL Analytical/Multi 10.5 |
Default: 4 (choices: 0, 16, 32, 64, 128, 256, 512, 1024, 2048) |
SkySQL Galera 10.4 |
Default: 4 (choices: 0, 16, 32, 64, 128, 256, 512, 1024, 2048) |
SkySQL Galera 10.5 |
Default: 4 (choices: 0, 16, 32, 64, 128, 256, 512, 1024, 2048) |
SkySQL HTAP 10.5 |
Default: 4 (choices: 0, 16, 32, 64, 128, 256, 512, 1024, 2048) |
SkySQL HA (Primary/Replica) 10.4 |
Default: 4 (choices: 0, 16, 32, 64, 128, 256, 512, 1024, 2048) |
SkySQL HA (Primary/Replica) 10.5 |
Default: 4 (choices: 0, 16, 32, 64, 128, 256, 512, 1024, 2048) |
SkySQL Standalone 10.4 |
Default: 4 (choices: 0, 16, 32, 64, 128, 256, 512, 1024, 2048) |
SkySQL Standalone 10.5 |
Default: 2 (choices: 0, 16, 32, 64, 128, 256, 512, 1024, 2048) |
SkySQL Xpand 10.5 |
Default: 8 (choices: 0, 16, 32, 64, 128, 256, 512, 1024, 2048) |
See MariaDB SkySQL documentation to learn more about the MariaDB SkySQL database as a service.
CHANGE HISTORY
Release Series |
History |
|---|---|
10.5 Enterprise |
|
10.5 Community |
|
10.4 Enterprise |
|
10.4 Community |
|
10.3 Enterprise |
|
10.3 Community |
|
10.2 Enterprise |
|
10.2 Community |
|
EXTERNAL REFERENCES
Additional information on this topic may be found in the MariaDB Public Knowledge Base.
Information specific to MariaDB SkySQL can be found on the thread_pool_size page in the SkySQL Documentation.