From owner-freebsd-smp@FreeBSD.ORG Thu Apr 6 10:21:54 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 957F316A400 for ; Thu, 6 Apr 2006 10:21:54 +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 E7B5E43D60 for ; Thu, 6 Apr 2006 10:21:53 +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 k36ALkbR020476; Thu, 6 Apr 2006 12:21:46 +0200 Message-ID: <002201c65963$e86e3990$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><000a01c6588e$c3201da0$65fd24c0@Eric> <44339F80.3040704@paradise.net.nz> Date: Thu, 6 Apr 2006 12:21:45 +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: RESOLVED : Low perf with smp on DELL server 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: Thu, 06 Apr 2006 10:21:54 -0000 Hi Mark, I do a lot new test, re-install all system and arrive now to this : Test without SMP : 29 sec Test with SMP : 37 sec Wich is very far from the 62 sec we have before with SMP and seems to be "normal" for most people saying SMP and 4.11 are not so friend they seems to be. Ok for you? It seems that problem before, came from perc4 controller configuration. It seems that if you change configuration on fly you don't have the same result ;=( as if you re-create the logical drive with good param and put same param onfly . Good configuration is for me disable any cache : On creation and on configuration : Write Policy --> Writethru Read Policy --> non-adaptive Don't know why difference was more important with SMP but it seems to be now ok. As there is still few difference with SMP, I now do same test but launching 1, 2, or 3 test in same time to see if it's usefulle for me to have SMP kernel. Result is really near but I doubt that it's not hardrive that slow down all system. Do you know a way to know the hard drive utilisation as with top? (iostat always return 0) Do you know a way to do high ramdrive? (I try with mount_mfs but it always limit me to 400 Mo) Many thanks, Eric. ----- Original Message ----- From: "Mark Kirkwood" To: "Eric" Cc: "Lucas Holt" ; Sent: Wednesday, April 05, 2006 12:44 PM Subject: Re: Low perf with smp > Eric wrote: >> 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]= "-"; >> } >> } >> > > Excellent! Well yes, 2G of data is too big to mail! However, generating 2G > of synthetic test data is no problem at all. > > However to do this, a little more information is needed: > > 1/ A create statement for the table histo_perfs_x, along with its indexes, > explicitly specifying if using an engine other than myisam. > > 2/ An estimate of proportion of the histo_perfs_x table a query like: > > select avg(total) from histo_perfs_x > where id1 = ? and id2 = ? and date > ? and date < ?; > > is likely to scan (for typical values of the 4 bind variables). > > 3/ (If possible) the output of explain of the above query so we can > duplicate the access plan. > > 4/ The number of iterations you were using in the php loop for your test. > > 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" >