From owner-freebsd-performance@FreeBSD.ORG Wed May 21 14:10:29 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 9E16F1065672 for ; Wed, 21 May 2008 14:10:29 +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 525B98FC14 for ; Wed, 21 May 2008 14:10:29 +0000 (UTC) (envelope-from phoemix@harmless.hu) Received: from fw.publishing.hu ([82.131.181.62] helo=twoflower.in.publishing.hu) by marvin.harmless.hu with esmtpsa (TLSv1:AES256-SHA:256) (Exim 4.69 (FreeBSD)) (envelope-from ) id 1Jyome-000LEU-7K; Wed, 21 May 2008 15:55:12 +0200 Date: Wed, 21 May 2008 15:55:08 +0200 From: CZUCZY Gergely To: Message-ID: <20080521155508.6ccfcfb5@twoflower.in.publishing.hu> In-Reply-To: References: Organization: Harmless Digital X-Mailer: Claws Mail 3.3.1 (GTK+ 2.10.11; i386-portbld-freebsd6.2) Mime-Version: 1.0 Content-Type: multipart/signed; boundary="Sig_/=Rf2Coto30j9VmefrbqNFj6"; protocol="application/pgp-signature"; micalg=PGP-SHA1 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 14:10:29 -0000 --Sig_/=Rf2Coto30j9VmefrbqNFj6 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable 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 anyth= ing else? IIRC there's some hack to reduce gettimeofday()'s precision in advance to enhance it's performance, that could also help a bit. Have you built your m= ysql with linking it against libthr? On Wed, 21 May 2008 15:01:32 +0200 wrote: > Hello, >=20 > I'm using mysql 5.1.24-rc in 5 separate jails. >=20 > Question: >=20 > 10 clients are pushing queries (10 separate machines). 2 clients to 1 mys= ql > daemon. One client is performing an update on param_stat_short_level_1_0, > second on param_stat_short_level_1_1. >=20 > Each client needs to push 150000 queries (client is spawning 15 forks to = push > the 150000, so each fork is pushing 10000, each fork is opening it's own > mysql connection). >=20 > query to push: >=20 > INSERT INTO param_stat_short_level_1_0 SET param =3D '10311', object =3D = '10311', > value =3D '4283' ON DUPLICATE KEY UPDATE param =3D '10311', object =3D '1= 0311', > value =3D '4283', min =3D IF(4283max,4283= ,max), > counter =3D counter+1; >=20 > Always a different param, and object values, value is rand(1,10000). >=20 > Stats for the operations are in http://p1.kei.pl/stats. > Stats are collected after each clients pushes 150000, 100 times. >=20 > My point here is that MySQL on Linux (p5) performs 150000 queries in an > average of 18.1099, when the same queries on FreeBSD (p1) takes 28.7643. >=20 > Did I misconfigured something or this are the proper result and FreeBSD j= ust > could not give more? >=20 > My configs below, thanks for Your time. >=20 > http://p1.kei.pl/TLD > http://p1.kei.pl/dmesg > http://p1.kei.pl/boot_loader_conf > http://p1.kei.pl/sysctl_conf > http://p1.kei.pl/my_cnf > http://p1.kei.pl/stats >=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 =C3=9Cdv=C3=B6lettel, Czuczy Gergely Harmless Digital Bt mailto: gergely.czuczy@harmless.hu Tel: +36-30-9702963 --Sig_/=Rf2Coto30j9VmefrbqNFj6 Content-Type: application/pgp-signature; name=signature.asc Content-Disposition: attachment; filename=signature.asc -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.3 (FreeBSD) iD8DBQFINCm+zrC0WyuMkpsRAsBgAJ4+LMK+SgnSftn4uIvfdQKcF+YrYwCfdOfW KdZsmdSgUCozao6LAgdWf1w= =KZ7r -----END PGP SIGNATURE----- --Sig_/=Rf2Coto30j9VmefrbqNFj6--