Re: FreeBSD MySQL still WAY slower than Linux

From: Martin Nilsson (martin_at_gneto.com)
Date: 06/28/05

  • Next message: Jarrod Martin: "Re: FreeBSD MySQL still WAY slower than Linux" 
    Date: Tue, 28 Jun 2005 07:59:12 +0200
To: Steve Roome <steve@pepcross.com>

    Steve Roome wrote:
    > Sorry, good point, here's the my.cnf we're using. Please note however
    > that although the configuration may not be optimal, we have been using
    > the same config for benchmarking on Linux also. No matter how broken
    > this my.cnf is we still shouldn't find MySQL running half the speed on
    > an "identical" setups only switching from Linux to FreeBSD.

    Hi,
    Have you tested some more real-world queries on Linux vs. FreeBSD?
    The select-key.smack is a very simple test, a very small table (5.3MB on
    disk, 90k rows), no joins/sorts and only selects from index. Maybe the
    performance difference just affects the connect/communication/thread
    syncronistaion and thus this simple test is a worst case test of
    performance between Linux & FreeBSD.

    I'll try to set up something here so I can make some tests too...

    How does a P4/Xeon compare to Athlon64/Opteron on these tests (Linux vs
    FreeBSD) the long pipeline in the P4 (Prescott/Nocona) is difficult to
    optimize for, SMP syncronisation is also much more expensive on
    netburst, maybe the are better at doing this in Linux?

    Regards,
    Martin

    _______________________________________________
    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: Jarrod Martin: "Re: FreeBSD MySQL still WAY slower than Linux"

    Relevant Pages

    • Re: (Another) simple benchmark
      ... I'm NOT using PHP - it was mentioned as a reason threaded apache is not widely used. ... This performance is objectively low even by itself, without any comparison with other operating systems (such as linux). ... What I *am* doing now is looking for someone who has a 4 CPU or bigger machine idle on which he/she can replicate this simple benchmark (it really IS simple - you need apache20 port in default configuration - everything's included) and confirm or contradict my results. ... If it's Linux, FreeBSD 4, FreeBSD 6, Windows, Solaris, ...
      (freebsd-performance)
    • Re: book for 4.x and ver 5.x
      ... Knowing Linux well is a good thing and will prove to be useful under ... The boot-time kernel configuration file /boot/kernel.conf that you use ... The FreeBSD handbook and faq also tells you all about these, ... articles just by using any search-engine. ...
      (comp.unix.bsd.freebsd.misc)
    • Re: mysql scaling questions
      ... Fire up the 3ware controller's RAID management software and make sure the same write caching strategy is set for FreeBSD and Linux. ... much slower we'll know there is some configuration problem or similar. ... MyISAM, of course. ...
      (freebsd-performance)
    • init - inittab , how to monitor process like on linux ?
      ... The init process can watch daemon and respawn died ones on linux with ... simple configuration. ... I tried to reproduce this in my FreeBSD server. ... Does any FreeeBSD guru can help me make the step from linux complete as ...
      (freebsd-newbies)
    • Re: FreeBSD 4.x Opteron Question
      ... the FreeBSD developers told everyone that 5.3 was da ... initially over linux not because there's a bunch of good guys on the ... My tests measure kernel performance; ... > a networking device is a key performance indicator. ...
      (freebsd-questions)