Re: FreeBSD 5.3 MySQL Performance

From: Joe Kelsey (joe_at_zircon.seattle.wa.us)
Date: 02/10/05

  • Next message: Martin Paredes: "Re: configuracion en la red" 
    To: Matt Olander <matt@offmyserver.com>
Date: Wed, 09 Feb 2005 19:26:15 -0800

    On Wed, 2005-02-09 at 16:44 -0800, Matt Olander wrote:
    > On Wed, Feb 09, 2005 at 07:58:56PM -0500, Alec Berryman wrote:
    > > > Also, does anybody have any FreeBSD 5.3/MySQL benchmarks? I searched
    > > > the mailing lists but didn't turn up anything.
    > >
    > > There was an article posted to Newsforge today about benchmarking
    > > MySQL on different operating systems.
    >
    > oh! thanks...but according to this article, Linux outperformed FreeBSD
    > in every metric shown :-(
    >
    > is that accurate?

    LinuxThreads is the WORST implementation of threading that anyone can
    imagine. Do not ever use Linux or the horrid LinuxThreads for anything
    that you want to save.

    Any so-called "benchmark" comparing Linux to anything else (especially
    windoze) has been polluted by the tradition in the linux/windoze world
    of running their disks in the completely unsafe "asynchronous" mode so
    popular with the ATA disk drive manufacturers. This method means that
    you never actually know whether or not the drive ever writes your data
    on the disk. It could just sit in the cache waiting for a power failure
    so that you lose everything. This "async" mode means that the
    benchmarks "look" fast but are completely unsafe.

    > > > The customer is looking for some kind of validation that he'll be
    > > > safe running his database on FreeBSD.
    > >
    > > I don't usually look at benchmarks when wondering if my databases are
    > > 'safe'.
    >
    > Perhaps you misunderstood or I fired that email off to quickly. In
    > addition to benchmarks, he's also looking for anything to show that
    > he won't be a pioneer in using large MySQL databases on FreeBSD.
    >
    > In other words, I'd love to point this customer to FreeBSD if it makes
    > sense for them. any help appreciated!

    Many companies have used FreeBSD and MySQL for years and years. There
    is no reason to not jump to FreeBSD and start using MySQL. At my last
    job, we ran very large MySQL databases on FreeBSD. For speed we used
    15,000 RPM SCSI-3 disk drives. This gives you all the speed you need
    with the guaranteed safety of FreeBSD. Of course, SCSI-3 15,000 RPM
    drives are more expensive than those wimpy ATA drives.

    Go to FreeBSD. Leave that unsafe Linux crap in the dust.

    /Joe

    _______________________________________________
    freebsd-questions@freebsd.org mailing list
    http://lists.freebsd.org/mailman/listinfo/freebsd-questions
    To unsubscribe, send any mail to "freebsd-questions-unsubscribe@freebsd.org"

  • Next message: Martin Paredes: "Re: configuracion en la red"

    Relevant Pages

    • Re: What version of FBSD does Yahoo run?
      ... I will repeat what I have said before - FreeBSD for my stands for a strict ... weren't you demanding an email ago that I produce benchmarks ... So I guess you recommend that anyone running a network ... Are the gains in mySQL greater that the 40% ...
      (freebsd-questions)
    • Re: FreeBSD 5.3 MySQL Performance
      ... >> the mailing lists but didn't turn up anything. ... >> safe running his database on FreeBSD. ... > I don't usually look at benchmarks when wondering if my databases are ... he won't be a pioneer in using large MySQL databases on FreeBSD. ...
      (freebsd-questions)
    • Re: Performance versus FreeBSD 7.0
      ... Anyways I would be very careful with any benchmarks testing mysql ... With sysbench which only exercises a single table it would end up basically ... The FreeBSD people are not very clear on what they exactly benchmarked ...
      (Linux-Kernel)
    • Re: FreeBSD MySQL still WAY slower than Linux
      ... >> assertion that location does not matter in disk performance benchmarks. ... > Say I install FreeBSD, install MySQL from ... > repeat the process with a Linux installed over the previous FreeBSD ...
      (freebsd-stable)
    • 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)