Bug #39916 pool-of-threads fails to increment the number of created threads
Submitted: 7 Oct 2008 19:48 Modified: 20 Oct 2008 0:45
Reporter: Davi Arnaut (OCA) Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: General Severity:S3 (Non-critical)
Version:6.0 OS:Any
Assigned to: Davi Arnaut CPU Architecture:Any

[7 Oct 2008 19:48] Davi Arnaut 
Description:
Threads created to handle user connection under are not being accounted for in the Threads_created variable.

How to repeat:
./mtr --mysqld=--thread-handling=pool-of-threads threads_created
SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'Threads_created';
VARIABLE_VALUE
0

Suggested fix:
Increase Threads_created by the number of threads in the pool.
[7 Oct 2008 19:59] Bugs System 
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/55624

2846 Davi Arnaut	2008-10-07
      Bug#39916: pool-of-threads fails to increment the number of created threads
      
      The problem is that threads created under the pool-of-threads mode
      weren't being properly accounted for in the Threads_created variable.
      
      The solution is to increase the number of Threads_created every time
      a thread is created and added to the pool. This means that the number
      of threads created is equal the size of the thread pool.
[7 Oct 2008 20:09] Bugs System 
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/55625

2857 Davi Arnaut	2008-10-07
      Bug#39916: pool-of-threads fails to increment the number of created threads
      
      The problem is that threads created under the pool-of-threads mode
      weren't being properly accounted for in the Threads_created variable.
      The solution is to increase the number of Threads_created every time
      a thread is created and added to the pool. This means that the number
      of threads created is equal to the size of the thread pool.
[7 Oct 2008 20:12] Davi Arnaut 
Queued to 6.0-bugteam
[13 Oct 2008 13:16] Bugs System 
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/56121

2871 Davi Arnaut	2008-10-13 [merge]
      Cherry-pick Bug#39916 from mysql-6.0-bugteam
[13 Oct 2008 14:10] Bugs System 
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/56129

2872 Davi Arnaut	2008-10-13 [merge]
      Cherry-pick Bug#39916 from mysql-6.0-bugteam
[17 Oct 2008 16:42] Bugs System 
Pushed into 6.0.8-alpha  (revid:davi.arnaut@sun.com-20081013141000-l7l1vzslxrmkj3xd) (version source revid:davi.arnaut@sun.com-20081013141000-l7l1vzslxrmkj3xd) (pib:5)
[20 Oct 2008 0:45] Paul DuBois 
Noted in 6.0.8 changelog.

The Threads_created status variable was not correctly incremented
when the server was started with the
--thread-handling=pool-of-threads option.