From owner-freebsd-smp@FreeBSD.ORG Wed Apr 5 08:56:08 2006 Return-Path: X-Original-To: freebsd-smp@freebsd.org Delivered-To: freebsd-smp@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id CB13416A400 for ; Wed, 5 Apr 2006 08:56:08 +0000 (UTC) (envelope-from ericd@free.fr) Received: from meteor.synten.com (ns4.synten.com [193.47.141.42]) by mx1.FreeBSD.org (Postfix) with ESMTP id E9A2343D48 for ; Wed, 5 Apr 2006 08:56:07 +0000 (GMT) (envelope-from ericd@free.fr) Received: from Eric (ericd.netvigie.com [81.255.196.158]) by meteor.synten.com (8.13.2/8.12.9) with SMTP id k358tvDk003074; Wed, 5 Apr 2006 10:55:57 +0200 Message-ID: <000a01c6588e$c3201da0$65fd24c0@Eric> From: "Eric" To: "Mark Kirkwood" References: <009301c65418$cc029f30$65fd24c0@Eric><64659004-E643-4044-AAED-076E0CC91977@foolishgames.com><01a901c65493$77ad2740$65fd24c0@Eric><442DC9B6.2090200@paradise.net.nz><442EAA0A.8030704@he.iki.fi> <442F0E1B.9090505@paradise.net.nz><027f01c657f4$0d0a66a0$65fd24c0@Eric> <4432858F.90701@he.iki.fi><008001c65825$f3c27700$65fd24c0@Eric> <44331024.7090807@paradise.net.nz> Date: Wed, 5 Apr 2006 10:56:00 +0200 MIME-Version: 1.0 Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=response Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2900.2180 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 X-SYNTEN-MailScanner-Information: Please contact the ISP for more information X-SYNTEN-MailScanner: Found to be clean X-SYNTEN-MailScanner-SpamScore: ss Cc: Lucas Holt , freebsd-smp@freebsd.org Subject: Re: Low perf with smp X-BeenThere: freebsd-smp@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: FreeBSD SMP implementation group List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 05 Apr 2006 08:56:08 -0000 Main problem is that query is done in a database of more than 2Go and it will be difficult to mail it. ;=) I try with several versions of mysql and php from mysql 4.1.18 to last 5.x and php 4.4.0 to 5.x and don't find significant change in performance. If it can help here is the loop. for($debut=$deb;$debut < $fin;$debut += $range){ $end = $debut + $range; $query = "select avg(total) from `histo_perfs_x` where id1 = '".$id1."' and id2 = '".addslashes($id2)."' and date > '".$debut."' and date < '".$end."'"; $result = mysql_query($query) or die("La requete :$query a echouee."); if(!$result)$databar_total[$j][$i]= 0; else { $ligne = mysql_fetch_array($result); if($ligne[0] != "")$databar_total[$j][$i]=$ligne[0]; else $databar_total[$j][$i]= "-"; } } ----- Original Message ----- From: "Mark Kirkwood" To: "Eric" Cc: "Lucas Holt" ; Sent: Wednesday, April 05, 2006 2:32 AM Subject: Re: Low perf with smp > Eric wrote: >> I know Pete but I downgrad because when installing 6.0 performance was >> half than with 4.11. >> I done tests and tests but still have very low perfs. I then downdgrad to >> 4.11 to see if it came from hardware or software. >> Conclusion is that my test wich is consist of loop of mysql query done by >> a php script take : >> >> - 32 sec with 4.11 without SMP >> - 54 sec with 4.11 with SMP >> - 62 sec with 6.0 or 6.1 beta 4 >> >> That's why actually I'm with 4.11. >> >> If you have any idea how improve perfs with 6.0 it will be a pleasure. >> Hardware is new dell 1850 with bi-xeon dualcore 2.8Ghz and scsi 15.000t >> HDD on raid1 perc4si 256Mo controller. > > If you could post, or link to your mysql query and php script, then I (or > in fact anyone) could try to reproduce this (I've got two almost identical > machines running 6.0, so could downgrade one to 4.x.). > > In addition, what versions of php and mysql are you using? > > Cheers > > Mark > _______________________________________________ > freebsd-smp@freebsd.org mailing list > http://lists.freebsd.org/mailman/listinfo/freebsd-smp > To unsubscribe, send any mail to "freebsd-smp-unsubscribe@freebsd.org" >