Date: Mon, 26 Nov 2007 13:03:19 +0100 From: Albert Shih <Albert.Shih@obspm.fr> To: Jan Catrysse <j.catrysse@proximedia.be> Cc: freebsd-questions@freebsd.org Subject: Re: Help for very bad perf for MySQL Message-ID: <20071126120319.GA70494@pcjas.obspm.fr> In-Reply-To: <20071126115816.DB21928C76@smtp.proximedia.com> References: <20071126115022.GA70340@pcjas.obspm.fr> <20071126115816.DB21928C76@smtp.proximedia.com>
next in thread | previous in thread | raw e-mail | index | archive | help
Le 26/11/2007 à 13:01:47+0100, Jan Catrysse a écrit > > -----Original Message----- > > > > 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 ? > > > > Regards > > -- > > Albert SHIH > > Observatoire de Paris Meudon > > SIO batiment 15 > > Heure local/Local time: > > Lun 26 nov 2007 12:46:06 CET > > 6 seconds seem to be an awful lot. What kind of query are you running on > what kind of database / contents? > I don't really known it's some scientifical data. But the problem is on a basic linux pc (with SATA disk) the time is 0.6 sec with same request and same data. And it's for web applications. At 6 sec for one request it's become very long for the visitor because the application make many requests. Regards -- Albert SHIH Observatoire de Paris Meudon SIO batiment 15 Heure local/Local time: Lun 26 nov 2007 13:00:32 CET
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20071126120319.GA70494>