Percona Server with XtraDB

Inadequate default for thread_pool_max_threads

Reported by Alexey Kopytov on 2013-12-05
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Percona Server
Status tracked in 5.6
5.5
Medium
Alexey Kopytov
5.6
Medium
Alexey Kopytov

Bug Description

The default value (500) for the thread_pool_max_threads variable is rather meaningless and provides an easy way for users to shoot themselves in the foot.

Limiting the total number of threads in the threadpool can result in deadlocks and uneven distribution of worker threads between thread groups in case of stalled connections.

Making it unlimited by default makes much more sense. This is to change both the maximum and default values for thread_pool_max_threads to 100k (the maximum max_connections value).

description: updated
To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers