Date: Wed, 21 May 2008 18:25:30 +0200 From: CZUCZY Gergely <gergely.czuczy@harmless.hu> To: <t.pajor@kei.pl> Cc: freebsd-performance@freebsd.org Subject: Re: mysql performance on freebsd 7 Message-ID: <20080521182530.23c8f787@mort.in.publishing.hu> In-Reply-To: <3abeb97e28be5b2107ea97e65ae88762.t.pajor@kei.pl> References: <be8c1fa47808266f0e520175c6bbbf1e.t.pajor@kei.pl> <20080521155508.6ccfcfb5@twoflower.in.publishing.hu> <3abeb97e28be5b2107ea97e65ae88762.t.pajor@kei.pl>
next in thread | previous in thread | raw e-mail | index | archive | help
[-- Attachment #1 --] On Wed, 21 May 2008 16:45:07 +0200 <t.pajor@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@freebsd.org mailing list > http://lists.freebsd.org/mailman/listinfo/freebsd-performance > To unsubscribe, send any mail to > "freebsd-performance-unsubscribe@freebsd.org" -- Sincerely, Gergely CZUCZY, Harmless Digital mailto: gergely.czuczy@harmless.hu Legacy software is software that works. [-- Attachment #2 --] -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.4 (FreeBSD) iD8DBQFINEz8zrC0WyuMkpsRAjC+AJwLfldpgS7ZwLjEw56C6D6pM5i+mwCcDO/d r+zsKMtyiKOURpvIYDGz9vs= =/rl2 -----END PGP SIGNATURE-----
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20080521182530.23c8f787>