From owner-freebsd-performance@FreeBSD.ORG Wed May 21 13:28:15 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 42D921065676 for ; Wed, 21 May 2008 13:28:15 +0000 (UTC) (envelope-from t.pajor@kei.pl) Received: from smtp.kei.pl (v45.rev.tld.pl [195.149.224.45]) by mx1.freebsd.org (Postfix) with ESMTP id 73BA18FC14 for ; Wed, 21 May 2008 13:28:13 +0000 (UTC) (envelope-from t.pajor@kei.pl) Received: (qmail 12016 invoked by uid 45007); 21 May 2008 13:01:32 -0000 X-clamdmail: clamdmail 0.18a Received: from v45.rev.tld.pl (t.pajor@kei.pl@195.149.224.45) by smtp.kei.pl with ESMTPA; 21 May 2008 13:01:32 -0000 Received: from 195.149.231.62 (Poczta WWW Kei.pl authenticated user t.pajor@kei.pl) by poczta45.kei.pl with HTTP; Wed, 21 May 2008 15:01:32 +0200 (CEST) Message-ID: From: To: Content-Transfer-Encoding: quoted-printable Date: Wed, 21 May 2008 15:01:32 +0200 MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-2 X-Priority: 3 X-Mailer-Version: 1.0 X-Mailer: Poczta WWW Kei.pl X-Organisation: Kei.pl X-User-IP: 195.149.231.62 X-Http-User-Agent: Opera/9.50 (X11; Linux i686; U; en) X-Mailman-Approved-At: Wed, 21 May 2008 13:37:14 +0000 Subject: 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 13:28:15 -0000 Hello, I'm using mysql 5.1.24-rc in 5 separate jails. Question: 10= clients are pushing queries (10 separate machines). 2 clients to 1 mysql d= aemon. One client is performing an update on param_stat_short_level_1_0, se= cond on param_stat_short_level_1_1. Each client needs to push 150000 que= ries (client is spawning 15 forks to push the 150000, so each fork is pushi= ng 10000, each fork is opening it's own mysql connection). query to push= : 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', ob= ject =3D '10311', value =3D '4283', min =3D IF(4283max,4283,max), counter =3D counter+1; Always a different param, = and object values, value is rand(1,10000). Stats for the operations are = in http://p1.kei.pl/stats. Stats are collected after each clients pushes 1= 50000, 100 times. My point here is that MySQL on Linux (p5) performs 150= 000 queries in an average of 18.1099, when the same queries on FreeBSD (p1)= takes 28.7643. Did I misconfigured something or this are the proper res= ult and FreeBSD just could not give more? My configs below, thanks for Y= our time. 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 h= ttp://p1.kei.pl/stats