From owner-freebsd-performance@FreeBSD.ORG Wed May 21 16:25:35 2008 Return-Path: Delivered-To: freebsd-performance@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id B779F106564A for ; Wed, 21 May 2008 16:25:35 +0000 (UTC) (envelope-from phoemix@harmless.hu) Received: from marvin.harmless.hu (www.ssl.harmless.hu [195.56.55.205]) by mx1.freebsd.org (Postfix) with ESMTP id 684648FC22 for ; Wed, 21 May 2008 16:25:35 +0000 (UTC) (envelope-from phoemix@harmless.hu) Received: from pool-0461.adsl.interware.hu ([213.178.101.205] helo=mort.in.publishing.hu) by marvin.harmless.hu with esmtpa (Exim 4.69 (FreeBSD)) (envelope-from ) id 1Jyr8A-000Ocz-20; Wed, 21 May 2008 18:25:34 +0200 Date: Wed, 21 May 2008 18:25:30 +0200 From: CZUCZY Gergely To: Message-ID: <20080521182530.23c8f787@mort.in.publishing.hu> In-Reply-To: <3abeb97e28be5b2107ea97e65ae88762.t.pajor@kei.pl> References: <20080521155508.6ccfcfb5@twoflower.in.publishing.hu> <3abeb97e28be5b2107ea97e65ae88762.t.pajor@kei.pl> Organization: Harmless Digital Bt X-Mailer: Claws Mail 3.3.1 (GTK+ 2.12.1; i386-portbld-freebsd6.3) Mime-Version: 1.0 Content-Type: multipart/signed; boundary="Sig_/_mRAHXFx=3V+x4cE_FebhMm"; protocol="application/pgp-signature"; micalg=PGP-SHA1 Sender: Czuczy Gergely Cc: freebsd-performance@freebsd.org Subject: Re: mysql performance on freebsd 7 X-BeenThere: freebsd-performance@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Performance/tuning List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 21 May 2008 16:25:35 -0000 --Sig_/_mRAHXFx=3V+x4cE_FebhMm Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: quoted-printable On Wed, 21 May 2008 16:45:07 +0200 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? >=20 > 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/ =20 > > IIRC there's some hack to reduce gettimeofday()'s precision in > > advance to enhance it's performance, that could also help a bit. >=20 > 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? >=20 > 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? >=20 > Stats are at http://p1.kei.pl/mon/ >=20 >=20 >=20 > _______________________________________________ > 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" --=20 Sincerely, Gergely CZUCZY, Harmless Digital mailto: gergely.czuczy@harmless.hu Legacy software is software that works. --Sig_/_mRAHXFx=3V+x4cE_FebhMm Content-Type: application/pgp-signature; name=signature.asc Content-Disposition: attachment; filename=signature.asc -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.4 (FreeBSD) iD8DBQFINEz8zrC0WyuMkpsRAjC+AJwLfldpgS7ZwLjEw56C6D6pM5i+mwCcDO/d r+zsKMtyiKOURpvIYDGz9vs= =/rl2 -----END PGP SIGNATURE----- --Sig_/_mRAHXFx=3V+x4cE_FebhMm--