Why is MySQL nearly twice as fast on Linux/AMD64 Vs.
mike at mike2k.com
Wed May 19 11:43:43 PDT 2004
I would like to voice the same concern.
I've been running some benchmarks on my system as well:
As far as I know, it's always been libc_r - when I tried compiling MySQL
with --use-pthread or whatever, it wouldn't compile.
It's 5.2.1-RELEASE, and I read that it might not be working properly yet
I will be more than happy to try any patches (I compile my MySQL myself,
not from ports), output from dmesg/logs, kernel configs, whatever. Just
I'd love to get some sort of progress on this because I would love to be
running an all-FreeBSD server cluster so I don't have to be mixing OS'es
and distros and whatnot.
Thanks in advance,
On Wed, 19 May 2004, JG wrote:
> At 10:29 AM 5/19/2004 -0700, you wrote:
> >JG wrote this message on Wed, May 19, 2004 at 06:07 -0700:
> > > At 04:53 PM 5/19/2004 +0400, you wrote:
> > > >In first time you built MySQL statically.
> > > >Now - dinamically.
> > > >
> > > >What results with statical linked MySQL ?
> > > >
> > > >JG wrote:
> > >
> > > Those results are in earlier posts of this thread.
> > >
> > > I compiled it dynamically to be sure that libpthreads was used.
> > > (so I could use ldd against mysqld)
> >There is a patch to make use of _SYSTEM scoped threads instead of
> >process scoped threads for mysql mentioned ealier.. Also, if you
> >use libmap to remap libpthread to libthr, you'll have similar
> Afaik, that patch has been made:
> $ more mysql40-server.diffs
> Index: files/patch-libmysqld::lib_sql.cc
> RCS file: files/patch-libmysqld::lib_sql.cc
> diff -N files/patch-libmysqld::lib_sql.cc
> --- /dev/null 1 Jan 1970 00:00:00 -0000
> +++ files/patch-libmysqld::lib_sql.cc 18 Feb 2004 21:42:20 -0000
> @@ -0,0 +1,11 @@
> +--- libmysqld/lib_sql.cc.orig Tue Feb 10 13:15:49 2004
> ++++ libmysqld/lib_sql.cc Wed Feb 18 16:41:40 2004
> +@@ -467,7 +467,7 @@
> + (void) pthread_attr_setdetachstate(&connection_attrib,
> + PTHREAD_CREATE_DETACHED);
> + pthread_attr_setstacksize(&connection_attrib,thread_stack);
> +- pthread_attr_setscope(&connection_attrib, PTHREAD_SCOPE_SYSTEM);
> ++ pthread_attr_setscope(&connection_attrib, PTHREAD_SCOPE_PROCESS);
> + #if defined( SET_RLIMIT_NOFILE) || defined( OS2)
> + /* connections and databases needs lots of files */
> Index: files/patch-sql::mysqld.cc
> RCS file:
> [* snip *]
> That's the patch you're talking about right?
> If the lines in the source files are supposed to read PTHREAD_SCOPE_SYSTEM
> after the patch, then this patch was applied for all my 4.x benchmarks.
> I'm starting to think that my earlier results were ~ as good as it gets for
> FreeBSD/AMD64 at this point.
> Any other suggestions?
> Or anyone on the AMD64 dev team want to take a stab at it?
> freebsd-amd64 at freebsd.org mailing list
> To unsubscribe, send any mail to "freebsd-amd64-unsubscribe at freebsd.org"
More information about the freebsd-amd64