Re: Progress on scaling of FreeBSD on 8 CPU systems

On Tue, Feb 27, 2007 at 03:59:52PM -0500, Kris Kennaway wrote:
On Tue, Feb 27, 2007 at 12:25:11PM -0600, Jim C. Nasby wrote:
On Sat, Feb 24, 2007 at 04:31:11PM -0500, Kris Kennaway wrote:
Now that the goals of the SMPng project are complete, for the past
year or more several of us have been working hard on profiling FreeBSD
in various multiprocessor workloads, and looking for performance
bottlenecks to be optimized.

We have recently made significant progress on optimizing for MySQL
running on an 8-core amd64 system. The graph of results may be found
here:

I do *not* want to start a database war here, but I'm wondering if any
testing has been done with PostgreSQL? The reason I'm asking is that
there are some benchmarks that show MySQL falling off drastically with
increased concurrency:

http://www.mysqlperformanceblog.com/2006/11/30/interesting-mysql-and-postgresql-benchmarks/

It would be interesting to see how the changes you've made stack up
using PostgreSQL as the benchmark.

I've mentioned this a couple of times, but postgresql didn't scale
well [on freebsd at least] when I tried it last year. I hope to
revisit when I get time.

Let me know if you need help when you get to that point. Keep in mind
that PostgreSQL's out-of-the-box configuration is pretty conservative,
so you won't get good numbers that way.
--
Jim C. Nasby, Database Architect decibel@xxxxxxxxxxx
Give your computer some brain candy! www.distributed.net Team #1828

Windows: "Where do you want to go today?"
Linux: "Where do you want to go tomorrow?"
FreeBSD: "Are you guys coming, or what?"
_______________________________________________
freebsd-current@xxxxxxxxxxx mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-current
To unsubscribe, send any mail to "freebsd-current-unsubscribe@xxxxxxxxxxx"

Relevant Pages

  • Re: Performance tests I did with FreeBSD, Linux and PostgreSQL
    ... > Like all benchmarks, I doubt these are perfect examples ... > of real-world use. ... > However, in the hopes that they will be useful for improving FreeBSD, I ... but you don't state if the postgresql fsync option was ...
    (freebsd-performance)
  • Re: Progress on scaling of FreeBSD on 8 CPU systems
    ... year or more several of us have been working hard on profiling FreeBSD ... We have recently made significant progress on optimizing for MySQL ... testing has been done with PostgreSQL? ... there are some benchmarks that show MySQL falling off drastically with ...
    (freebsd-hackers)
  • Re: FreeBSD mysql Benchmark on 4BSD/ULE scheduler and i386/amd64
    ... I have a problem with how mysql often gets falsely marketed as the fastest database. ... I am so used to seeing comparison benchmarks between mysql and postgres that I mistook this for one. ... That's probably due to me being a postgresql mailing list regular. ... In that way benchmarks like these are useful; it shows that freebsd outperforms linux if you use mysql. ...
    (freebsd-stable)
  • 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: Progress on scaling of FreeBSD on 8 CPU systems
    ... year or more several of us have been working hard on profiling FreeBSD ... We have recently made significant progress on optimizing for MySQL ... testing has been done with PostgreSQL? ... there are some benchmarks that show MySQL falling off drastically with ...
    (freebsd-current)