Re: Performance versus FreeBSD 7.0



"Stephen Cuppett" <cuppett@xxxxxxxxx> writes:

Not lobbing the first artillery shell by any means, but I saw this
bullet on the FreeBSD release announcement:

I posted a comment on that on the LWN thread, but their website
has eaten it.

Anyways I would be very careful with any benchmarks testing mysql
especially on sysbench on larger systems (like they did with a 8 core
system). I did some similar testing on a slightly larger system (16 core)
some time ago and found that mysql itself didn't scale at all.
With sysbench which only exercises a single table it would end up basically
just banging on a single mysql user space lock and spend nearly all
the kernel time in the scheduler over-scheduling like crazy.

The FreeBSD people are not very clear on what they exactly benchmarked
(MySQL has lots of configuration options and engines), but I'll assume
they used the standard MyISAM.

I don't think that's a very useful benchmark to tune for in this
form at least not until MySQL is fixed to actually scale and sysbench
replaced with some a little more sane. It's worse than dbench.

-Andi
--
To unsubscribe from this list: send the line "unsubscribe linux-kernel" in
the body of a message to majordomo@xxxxxxxxxxxxxxx
More majordomo info at http://vger.kernel.org/majordomo-info.html
Please read the FAQ at http://www.tux.org/lkml/



Relevant Pages

  • Re: FreeBSD 5.3 MySQL Performance
    ... benchmarks "look" fast but are completely unsafe. ... > he won't be a pioneer in using large MySQL databases on FreeBSD. ... drives are more expensive than those wimpy ATA drives. ...
    (freebsd-questions)
  • 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: mysql scaling questions
    ... I am using sysbench, with read-write tests. ... As Mike Tancsa suggested - rebuild MySQL dynamic and use these values in /etc/libmap.conf ... The freebsd has mysql-5.0.45_1. ... As you see for the best case linux outperforms fbsd7 around twice, ...
    (freebsd-performance)
  • 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: 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)