mysql performance on freebsd 7

[CZUCZY Gergely]

On Wed, 21 May 2008 16:45:07 +0200
<t.pajor at kei.pl> 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 at freebsd.org mailing list
> http://lists.freebsd.org/mailman/listinfo/freebsd-performance
> To unsubscribe, send any mail to
> "freebsd-performance-unsubscribe at freebsd.org"


-- 

Sincerely,

Gergely CZUCZY,
Harmless Digital
mailto: gergely.czuczy at harmless.hu

Legacy software is software that works.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 187 bytes
Desc: not available
Url : http://lists.freebsd.org/pipermail/freebsd-performance/attachments/20080521/bff4f7ff/signature.pgp