On Wed, Mar 14, 2007 at 01:27:22AM +0100, Alban Hertroys wrote: > > On Mar 13, 2007, at 22:45, Kris Kennaway wrote: > > >>I used sql-bench > >>/usr/ports/databases/mysql50-server/work/mysql-5.0.33/sql-bench/ > >>(at this time) > >>the default Makefile of port have "--without-bench" options so u > >>need > >>to make manually > > > >Hmm. This seems to be a single-user test, so while it's presumably > >testing some relevant basic ingredients of database performance it's > >probably not a realistic measure of server performance. i.e. if you > >really only have a maximum of one client accessing your database then > >your 4-core system is being more than 75% wasted :) > > Sorry, couldn't resist... > > This being mysql, the number of processors isn't going to matter > much, no matter how many connections you have. Mysql doesn't scale > very well to multiple cpu's.
This might be standard dogma, but it also appears not to be true: http://people.freebsd.org/~kris/scaling/mysql.html > It doesn't compare[1] to a tuned PostgreSQL database, which I think > is a considerably more interesting benchmark. And of course that > would include multiple simultaneous connections. On the same test postgresql is indeed faster, I haven't finished benchmarking it yet though. Kris _______________________________________________ freebsd-stable@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-stable To unsubscribe, send any mail to "[EMAIL PROTECTED]"