Bug #106477 no explanation for some thread pool variables in MySQL Reference Manual
Submitted: 16 Feb 2022 15:05 Modified: 17 Nov 2022 13:56
Reporter: chen chen Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Documentation Severity:S3 (Non-critical)
Version: OS:Any
Assigned to: CPU Architecture:Any

[16 Feb 2022 15:05] chen chen
Description:
There are nine variables related to thread pool.

mysql> show variables like 'thread_pool%';
+--------------------------------------+-------+
| Variable_name                        | Value |
+--------------------------------------+-------+
| thread_pool_algorithm                | 0     |
| thread_pool_dedicated_listeners      | OFF   |
| thread_pool_high_priority_connection | 0     |
| thread_pool_max_active_query_threads | 0     |
| thread_pool_max_transactions_limit   | 0     |
| thread_pool_max_unused_threads       | 0     |
| thread_pool_prio_kickup_timer        | 1000  |
| thread_pool_size                     | 16    |
| thread_pool_stall_limit              | 6     |
+--------------------------------------+-------+
9 rows in set (0.00 sec)

but there is no any explanation for thread_pool_max_transactions_limit and thread_pool_dedicated_listeners.

https://dev.mysql.com/doc/refman/8.0/en/thread-pool-operation.html

How to repeat:
as stated above
[16 Feb 2022 15:16] MySQL Verification Team
Hi Mr. chen,

Thank you for your bug report.

However, this is not a bug. All those variables are fully described in these two chapters:

https://dev.mysql.com/doc/refman/8.0/en/thread-pool-operation.html

and

https://dev.mysql.com/doc/refman/8.0/en/thread-pool-tuning.html

Not a bug.
[18 Feb 2022 12:06] chen chen
thanks for you feedback, i read all the pages related to thread pool, But still can't find the explanation of thread_pool_dedicated_listeners and thread_pool_max_transactions_limit.
[11 Jul 2022 12:46] MySQL Verification Team
This is not described properly in the manual along with the other thread_pool configuration options.

However I did find this note in the MDS docs:

https://docs.oracle.com/en-us/iaas/mysql-database/doc/configuring-db-system.html#GUID-B11E...
[17 Nov 2022 13:56] Margaret Fisher
Posted by developer:
 
Thanks Shane! These have now been added by WL #15293 and can be seen here:

https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html