Date: Mon, 26 Nov 2007 13:01:47 +0100 From: "Jan Catrysse" <j.catrysse@proximedia.be> To: <freebsd-questions@freebsd.org> Subject: RE: Help for very bad perf for MySQL Message-ID: <20071126115816.DB21928C76@smtp.proximedia.com> In-Reply-To: <20071126115022.GA70340@pcjas.obspm.fr>
next in thread | previous in thread | raw e-mail | index | archive | help
> -----Original Message----- > From: owner-freebsd-questions@freebsd.org > [mailto:owner-freebsd-questions@freebsd.org] On Behalf Of Albert Shih > Sent: Monday, November 26, 2007 12:50 PM > To: freebsd-questions@freebsd.org > Subject: Help for very bad perf for MySQL > > Hi all > > 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? Regs, Jan
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20071126115816.DB21928C76>