Re: MySQL Performance 6.0rc1

From: Robert Watson (rwatson_at_FreeBSD.org)
Date: 10/26/05

  • Next message: Marian Hettwer: "Re: MySQL Performance 6.0rc1" 
    Date: Wed, 26 Oct 2005 13:38:07 +0100 (BST)
To: Marian Hettwer <MH@kernel32.de>

    On Wed, 26 Oct 2005, Marian Hettwer wrote:

    >> - Use libmap to configure the mysql server to use libthr instead of
    >> libpthread
    >>
    > uh. Last time I fiddled around with libmap.conf was back in FreeBSD 5.1
    > ... could you enlighten me a wee bit in regards to libmap.conf ? :) If
    > not, I'll stress google a bit and hopefully find something useful...

    libmap.conf(5) has the details, including examples. The easy (cheating)
    way to accomplish the same thing is to replace /usr/lib/libpthread with
    /usr/lib/libthr :-). Remember that for linker changes to the thread
    library to affect an application, you need to stop and restart the
    application.

    > my.cnf is pretty much my-medium.cnf on Debian and FreeBSD. Although,
    > Debian has MySQL 4.1.11 and FreeBSD Ports has MySQL 4.1.14. As mentioned
    > before, this benchmark here is a quick shot. However, the difference
    > shouldn't be _that_ large (3600 vs. 14000).

    I think you will find people generally agree with this viewpoint. :-)

    BTW, you're running MySQL over UNIX domain sockets, not TCP, right?

    Robert N M Watson
    _______________________________________________
    freebsd-current@freebsd.org mailing list
    http://lists.freebsd.org/mailman/listinfo/freebsd-current
    To unsubscribe, send any mail to "freebsd-current-unsubscribe@freebsd.org"

  • Next message: Marian Hettwer: "Re: MySQL Performance 6.0rc1"

    Relevant Pages

    • Re: Fixing -pthreads (Re: ports and -current)
      ... multiple platforms knows that most thread libraries are ... called libpthread and are linked to with -lpthread. ... > compile a third-party app in FreeBSD is via the ports system, ... will be on the link command and it should be very obvious ...
      (freebsd-current)
    • Re: loading multi threaded library into executable enabled for single thread
      ... loads a lib that is linked with libpthread. ... to work in FreeBSD v5.5? ... Are you referring to tclsh? ... rebuild tclsh from source to link with libpthread. ...
      (freebsd-hackers)
    • Re: loading multi threaded library into executable enabled for single thread
      ... I have an exe that does not use threads that loads a lib that is linked with libpthread. ... Is there no way for this to work in FreeBSD v5.5? ... load this lib into a tclsh process on FreeBSD, I get this error, ...
      (freebsd-hackers)
    • Re: loading multi threaded library into executable enabled for single thread
      ... I have a multi-threaded library that is linked against libpthread. ... load this lib into a tclsh process on FreeBSD, I get this error, "Recurse on ... My feeling is that this is a FreeBSD issue because it's not happening on ... different threading libraries. ...
      (freebsd-hackers)
    • Re: MySQL Performance 6.0rc1
      ... On Wed, 26 Oct 2005, Marian Hettwer wrote: ... > On FreeBSD I took a pretty much generic kernel, ... You might also consider installing MySQL 4.0.x on freebsd and linux and ... > FreeBSD just by compiling mysql myself... ...
      (freebsd-current)