On Wed, 21 May 2008 16:45:07 +0200 <[EMAIL PROTECTED]> wrote: > > May I ask whether you are using innodb or myisam? both on freebsd > > and Linux. And what filesystem are you using for mysql's data > > files? UFS, ZFS or anything else? > > MySQL engine used is MEMORY, filesystem is ufs, but it's not relevant. sure it is relevant. check my results: http://phoemix.harmless.hu/dbtests/
> > IIRC there's some hack to reduce gettimeofday()'s precision in > > advance to enhance it's performance, that could also help a bit. > > What do You mean? I mean what I've told you, no more, no less. google://freebsd+gettimeofday+mysql+tuning > > Have you built your mysql with linking it against libthr? > > It's a standard build from ports-current. Standard build from ports"-current" pops up a dialog called "OPTIONS", where you can set these options. How have you set them? > > Stats are at http://p1.kei.pl/mon/ > > > > _______________________________________________ > freebsd-performance@freebsd.org mailing list > http://lists.freebsd.org/mailman/listinfo/freebsd-performance > To unsubscribe, send any mail to > "[EMAIL PROTECTED]" -- Sincerely, Gergely CZUCZY, Harmless Digital mailto: [EMAIL PROTECTED] Legacy software is software that works.
signature.asc
Description: PGP signature