MySQL Bugs: #62287: don't serialize thread cache

Bug #62287	don't serialize thread cache
Submitted:	28 Aug 2011 22:07	Modified:	29 Aug 2011 10:19
Reporter:	Domas Mituzas	Email Updates:
Status:	Verified	Impact on me:	None
Category:	MySQL Server: Locking	Severity:	S3 (Non-critical)
Version:	5.1, 5.5	OS:	Any
Assigned to:		CPU Architecture:	Any

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
currently thread cache operates in fully serialized mode - accept thread holds LOCK_thread_count while signaling threads - so only one thread a time gets picked up by workers, and only one thread at a time is added to thread cache. 

How to repeat:
connect a lot to mysql

Suggested fix:
allow to wake up multiple threads, don't hold LOCK_thread_count while signaling worker threads to wake up from thread cache