Bug #38636 why are 6.0 binaries built without pool-of-threads support?
Submitted: 7 Aug 2008 19:58 Modified: 28 Sep 18:15
Reporter: Shane Bester
Status: Closed
Category:Server: Compiling Severity:S3 (Non-critical)
Version:6.0.4, 6.0.5 OS:Any
Assigned to: Jonathan Perkin Target Version:
Triage: Triaged: D2 (Serious)

[7 Aug 2008 19:58] Shane Bester
Description:
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 22:53] Shane Bester
setting as verified, as we need more community testing on this.
[10 Sep 2008 12:32] Konstantin Osipov
This option should be enabled on platforms that support it: Linux, Solaris, Mac OS X.
[11 Nov 2008 12:42] Kent Boortz
In 6.0.8 all Linux, Mac OS X and Solaris binaries have
pool-of-threads support.
[11 Nov 2008 22:18] Paul DuBois
re:

"according to
http://dev.mysql.com/doc/refman/6.0/en/server-system-variables.html#option_mysqld_thread_h
andling

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 22: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 13:26] Kent Boortz
Linux RPMs still don't have the "--with-libevent" option needed
[24 Mar 19:01] Jonathan Perkin
As of 6.0.10 the following platforms are still missing libevent support, in addition to
RPMs:

aix5.2-powerpc-32bit
aix5.2-powerpc-64bit
aix5.3-powerpc-32bit
aix5.3-powerpc-64bit
freebsd6.3-x86
freebsd6.3-x86_64
freebsd7.0-x86
freebsd7.0-x86_64
hpux11.11-hppa-32bit
hpux11.11-hppa-64bit
hpux11.23-ia64
i5os-power-32bit
i5os-power-64bit

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 18:15] Jonathan Perkin
6.0.11 was built with libevent on all platforms except Windows.
[28 Sep 18:43] Jonathan Perkin
For the record, Windows does in fact include libevent.