On Mar 14, 2007, at 1:55, Kris Kennaway wrote:
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
Interesting. Results I have seen using a 16 CPU SGI Altex(?) showed
an almost linear rise for postgres while mysql topped off after about
4 threads. Sorry, don't have the URL at hand (I probably still have
it in my work mail).
Now this may well have been a version before 5.0.33. I'm not sure
what OS was used either, I suppose it was either Irix or Linux.
Now I am curious whether the same performance drop on Linux would
occur with a postgres benchmark. It probably will, but if not it
seems like there's a problem in the way that mysql and linux interact.
--
Alban Hertroys
"If you can't see the forest through the trees,
cut the trees and you'll see there is no forest"
!DSPAM:74,45f7b2c29417620521737!
_______________________________________________
freebsd-stable@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-stable
To unsubscribe, send any mail to "[EMAIL PROTECTED]"
