From owner-freebsd-performance@FreeBSD.ORG Tue Dec 30 23:46: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 0711A106566B for ; Tue, 30 Dec 2008 23:46:15 +0000 (UTC) (envelope-from pheriko.support@gmail.com) Received: from rv-out-0506.google.com (rv-out-0506.google.com [209.85.198.237]) by mx1.freebsd.org (Postfix) with ESMTP id C93FC8FC19 for ; Tue, 30 Dec 2008 23:46:14 +0000 (UTC) (envelope-from pheriko.support@gmail.com) Received: by rv-out-0506.google.com with SMTP id b25so6682437rvf.43 for ; Tue, 30 Dec 2008 15:46:14 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to :subject:in-reply-to:mime-version:content-type:references; bh=y7d1j9fECY1ksnDLnlZstEIHqRKbyCGi5SvlGGfLORg=; b=S0xWEa4xzxqHqwwLSjKtRnnqdTrfz/Vp6PoJgJ9ROs7fZu9dtk/4O04ouP426hg0s8 ql8tCaAW2l/1UcWEyG+WjeIkUlvYTlinmHZoaLh4BhJjhjL3RMwZoH84TsXM17jW+4PO 9g7oQXHWjVM/TCFwccFwu7pW9AQyl4gi/KgNY= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:in-reply-to:mime-version :content-type:references; b=TNuZig/wEnxZpQktU3ikyadGmB9SDRv/WP/coRdz51ImHE+iy96T69hJmZToUWesgs CrkG1F6/QOLqdGCl50C5aDEXr4nM3TCokTQfDqFVPBHcpH+DaDfNCDkVXlZi4+OxAJdx YkgnxsyWaFi9KWTTNqBEJA/l+klzPllNXelpk= Received: by 10.114.81.1 with SMTP id e1mr10068960wab.212.1230680774205; Tue, 30 Dec 2008 15:46:14 -0800 (PST) Received: by 10.114.209.9 with HTTP; Tue, 30 Dec 2008 15:46:14 -0800 (PST) Message-ID: <5b1d935a0812301546u34392c13nd3675349a6e63bca@mail.gmail.com> Date: Tue, 30 Dec 2008 15:46:14 -0800 From: "Periko Support" To: freebsd-performance@freebsd.org In-Reply-To: <200812300850.37429.fjwcash@gmail.com> MIME-Version: 1.0 References: <5b1d935a0812291750p46b4da74s92f756c646ff4601@mail.gmail.com> <200812300850.37429.fjwcash@gmail.com> Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline X-Content-Filtered-By: Mailman/MimeDel 2.1.5 Subject: Re: bonnie++ result, can someone tech me how to understand this data and help me tunning my system a little more? 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: Tue, 30 Dec 2008 23:46:15 -0000 I'm not the developer, I don't know how to answer u the question. But I will test both version using mysql 5.0/5.1 with InnoDB and see who give better performance. Now, about my bonnie++ results, some one what is the meaning, thanks!!! On Tue, Dec 30, 2008 at 8:50 AM, Freddie Cash wrote: > On December 29, 2008 5:50 pm Periko Support wrote: > > I want to learn how to get more from my system, I will run a new > > application with mysql 5.1.30, this app is develop en .NET(I'm the > > Are there specific features in MySQL 5.1.x that you need to use, that are > not available in MySQL 5.0.x? If not, you should look at moving back to > 5.0.x. Kris Kenneway did several different benchmarks of various versions > of MySQL on FreeBSD 6 and 7 and found MySQL 5.0.x to be significantly > faster > than 5.1.x, especially on 8+ core systems. > > http://people.freebsd.org/~kris/scaling/mysql.html > http://people.freebsd.org/~kris/scaling/7.0%20Preview.pdf > http://people.freebsd.org/~kris/scaling/7.0%20and%20beyond.pdf > http://people.freebsd.org/~kris/scaling/Filesystem%20Performance.pdf > > You should also consider moving to the InnoDB backend instead of MyISAM. > The days when MyISAM is faster then InnoDB for all but the simplest of > queries is long gone. > > -- > Freddie > fjwcash@gmail.com > _______________________________________________ > 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" >