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)
• Status: Closed
• 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

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 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

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 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:

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 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.