Date: Tue, 27 Nov 2007 14:00:20 +0100 From: Albert Shih <Albert.Shih@obspm.fr> To: Ted Mittelstaedt <tedm@toybox.placo.com> Cc: freebsd-questions@freebsd.org Subject: Re: Help for very bad perf for MySQL Message-ID: <20071127130020.GA81551@pcjas.obspm.fr> In-Reply-To: <BMEDLGAENEKCJFGODFOCCECDCFAA.tedm@toybox.placo.com> References: <20071126115022.GA70340@pcjas.obspm.fr> <BMEDLGAENEKCJFGODFOCCECDCFAA.tedm@toybox.placo.com>
next in thread | previous in thread | raw e-mail | index | archive | help
Le 26/11/2007 à 22:34:34-0800, Ted Mittelstaedt a écrit > > Sorry yeasterday I don't have time to answer you. > > > > I've already send a message. But I don't receive any answer :-(. > > I try again > > and hope there more solution > > > > I've a bi-proc single core Xeon 3.2ghz with FreeBSD 6.2, I'm running Mysql > > 5.X on this server and the performance of MySQL is very bad. For some > > complexe select I've got ~6secondes (on some basic Linux it's take 0.6 > > sec). And I think this is nothing about thead (that's mean I don't think > > FreeBSD 7.0 can solve my problem) because it's just for one select. > > > > The server have two SAS 10 000 tr/m disks. > > > > Anyone have some advise to tunning FreeBSD or MySQL for increase > > the perf ? > > > > Start with the obvious stuff first. How big is the database? How > big is system ram? If you have less ram than you have database then > mysql will have to go to the hard disk for the select which will kill > it's performance. > Well : Database size ~ 180Mo Ram of server = 4 Go 2 processeurs. Nothing run on this server (charge is near zero). The disk I/O is running very fast. The make buildworld is fast too (I don't have measure but it's «fast» ;-)) Regards. -- Albert SHIH Observatoire de Paris Meudon SIO batiment 15 Heure local/Local time: Mar 27 nov 2007 13:58:17 CET
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20071127130020.GA81551>