Date: Tue, 30 Dec 2008 15:46:14 -0800 From: "Periko Support" <pheriko.support@gmail.com> To: freebsd-performance@freebsd.org Subject: Re: bonnie++ result, can someone tech me how to understand this data and help me tunning my system a little more? Message-ID: <5b1d935a0812301546u34392c13nd3675349a6e63bca@mail.gmail.com> In-Reply-To: <200812300850.37429.fjwcash@gmail.com> References: <5b1d935a0812291750p46b4da74s92f756c646ff4601@mail.gmail.com> <200812300850.37429.fjwcash@gmail.com>
next in thread | previous in thread | raw e-mail | index | archive | help
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 <fjwcash@gmail.com> 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/%7Ekris/scaling/mysql.html>; > http://people.freebsd.org/~kris/scaling/7.0%20Preview.pdf<http://people.freebsd.org/%7Ekris/scaling/7.0%20Preview.pdf>; > http://people.freebsd.org/~kris/scaling/7.0%20and%20beyond.pdf<http://people.freebsd.org/%7Ekris/scaling/7.0%20and%20beyond.pdf>; > http://people.freebsd.org/~kris/scaling/Filesystem%20Performance.pdf<http://people.freebsd.org/%7Ekris/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" >
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?5b1d935a0812301546u34392c13nd3675349a6e63bca>