Re: FreeBSD MySQL still WAY slower than Linux

From: Robert Watson (rwatson_at_FreeBSD.org)
Date: 06/29/05

  • Next message: David Sze: "Re: FreeBSD MySQL still WAY slower than Linux" 
    Date: Wed, 29 Jun 2005 13:33:56 +0100 (BST)
To: Steve Roome <steve@pepcross.com>

    On Thu, 23 Jun 2005, Steve Roome wrote:

    >> The different threading libraries are more for completeness. In my
    >> last test I saw <10% difference between them on amd64.
    >
    > Well, I finally got some tests out for FreeBSD/i386 with -current, Here
    > we go with a bunch of results of FreeBSD 6 with mysql and different
    > threading libraries, as for you, there's sadly not enough in it so far.
    > Maybe I need to tune a whole bunch of stuff I've missed ?

    What version of MySQL are you using? I saw much better FreeBSD MySQL
    performance with 4.0.x than 4.1.x in terms of transactions per second, and
    am wondering what changed in MySQL -- did it start using different IPC
    primitives, threading primitives, etc? I realize it complicates testing,
    but if you have a chance to compare 4.0.x and 4.1.x across linux and
    freebsd, that would be quite helpful, so we can see if there's a change in
    relative performance. Most of my work to optimize MySQL performance with
    SMP has been using 4.0.x, FYI, so 4.1.x might require different
    optimization strategies.

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

  • Next message: David Sze: "Re: FreeBSD MySQL still WAY slower than Linux"

    Relevant Pages

    • Re: MySQL Performance 6.0rc1
      ... Nevertheless I run a production MySQL on a double-Xeon (Supermicro ... etc) which eventually kill MySQL with FreeBSD ... CPU: AMD OpteronProcessor 246 ... <ACPI PCI bus> on pcib0 ...
      (freebsd-current)
    • What am I doing wrong with MOUNT?
      ... I'm brand new to FreeBSD and Unix world in general. ... I installed MySQL version 3.23 from the ports ... of his database that I had MySQL dump on his FreeBSD server and FTP'd it to ... I mounted the new drive 1 to a temporary mount point and used the cp command ...
      (freebsd-newbies)
    • Re: FreeBSD MySQL still WAY slower than Linux
      ... I hope this can help us out to get MySQL humming on -STABLE, ... >> To make benchmarks a help provided to improve FreeBSD, ... > This box is currently setup to slave from the master. ... > System crashed while simply slaving from the master. ...
      (freebsd-stable)
    • Re: FreeBSD MySQL still WAY slower than Linux
      ... >>threading libraries, as for you, there's sadly not enough in it so far. ... >>Maybe I need to tune a whole bunch of stuff I've missed? ... >What version of MySQL are you using? ... I saw much better FreeBSD MySQL ...
      (freebsd-performance)
    • Re: FreeBSD MySQL still WAY slower than Linux
      ... is that the Mysql folks have agreed to setup ... >tests to profile mysql on identical hardware running FreeBSD and Linux ... I was seeing the same sort of super-smack numbers that everyone's been ...
      (freebsd-stable)