From owner-freebsd-performance@FreeBSD.ORG Tue Dec 30 17:09: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 1C4A1106568D for ; Tue, 30 Dec 2008 17:09:15 +0000 (UTC) (envelope-from fjwcash@gmail.com) Received: from smtp.sd73.bc.ca (smtp.sd73.bc.ca [142.24.13.140]) by mx1.freebsd.org (Postfix) with ESMTP id EC8B78FC1F for ; Tue, 30 Dec 2008 17:09:14 +0000 (UTC) (envelope-from fjwcash@gmail.com) Received: from localhost (localhost [127.0.0.1]) by localhost.sd73.bc.ca (Postfix) with ESMTP id 9F97E1A000B39 for ; Tue, 30 Dec 2008 08:50:39 -0800 (PST) X-Virus-Scanned: Debian amavisd-new at smtp.sd73.bc.ca Received: from coal.localnet (unknown [192.168.0.10]) by smtp.sd73.bc.ca (Postfix) with ESMTP id D76B81A000B21 for ; Tue, 30 Dec 2008 08:50:37 -0800 (PST) From: Freddie Cash To: freebsd-performance@freebsd.org Date: Tue, 30 Dec 2008 08:50:37 -0800 User-Agent: KMail/1.10.3 (Linux/2.6.26-1-686; KDE/4.1.3; i686; ; ) References: <5b1d935a0812291750p46b4da74s92f756c646ff4601@mail.gmail.com> In-Reply-To: <5b1d935a0812291750p46b4da74s92f756c646ff4601@mail.gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-15" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200812300850.37429.fjwcash@gmail.com> 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 17:09:15 -0000 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