Bug #38636 why are 6.0 binaries built without pool-of-threads support?
Submitted: 7 Aug 2008 17:58 Modified: 28 Sep 2009 16:15
Reporter: Shane Bester (Platinum Quality Contributor) Email Updates:
Status: Closed Impact on me:
Category:MySQL Server: Compiling Severity:S3 (Non-critical)
Version:6.0.4, 6.0.5 OS:Any
Assigned to: Jonathan Perkin CPU Architecture:Any

[7 Aug 2008 17:58] Shane Bester
according to http://dev.mysql.com/doc/refman/6.0/en/server-system-variables.html#option_mysqld_thread_h...

you have to build your own binaries to use this.  why?

E:\mysql-6.0.5-alpha-winx64\bin>mysqld  --console --thread_handling=pool-of-threads
Unknown option to thread_handling: pool-of-threads
Alternatives are: 'one-thread-per-connection','no-threads'

080729 20:01:19 mysqld_safe Starting mysqld daemon with databases from /home/sbester/mysql/6.0/mysql-6.0.4-alpha-linux-i686-glibc23/data
Unknown option to thread_handling: pool-of-threads
Alternatives are: 'one-thread-per-connection','no-threads'

How to repeat:
download some version of >=6.0.4 from http://dev.mysql.com/downloads/mysql/6.0.html and install it, then run: mysqld  --console --thread_handling=pool-of-threads

Suggested fix:
i suggest binaries are built with the feature enabled so that majority of users will actually test it
[9 Aug 2008 20:53] MySQL Verification Team
setting as verified, as we need more community testing on this.
[10 Sep 2008 10:32] Konstantin Osipov
This option should be enabled on platforms that support it: Linux, Solaris, Mac OS X.
[11 Nov 2008 11:42] Kent Boortz
In 6.0.8 all Linux, Mac OS X and Solaris binaries have
pool-of-threads support.
[11 Nov 2008 21:18] Paul DuBois

"according to

you have to build your own binaries to use this."

The manual does not say that. It says only that MySQL must be configured with --with-libevent. It is neutral on the question of whether binary builds are configured that way.
[11 Nov 2008 21:19] Paul DuBois
Noted in 6.0.8 changelog.

Binary distributions for Solaris, Linux, and Mac OS X now are built
with support for the pool-of-threads value of thread_handling.
[13 Feb 2009 12:26] Kent Boortz
Linux RPMs still don't have the "--with-libevent" option needed
[24 Mar 2009 18:01] Jonathan Perkin
As of 6.0.10 the following platforms are still missing libevent support, in addition to RPMs:


I will verify these to see whether they can be enabled, but I have a feeling this is only likely to be the case for FreeBSD, and enable them as well as RPMs for the 6.0.11 build.
[28 Sep 2009 16:15] Jonathan Perkin
6.0.11 was built with libevent on all platforms except Windows.
[28 Sep 2009 16:43] Jonathan Perkin
For the record, Windows does in fact include libevent.