Date: Tue, 27 Nov 2007 14:02:27 +0100 From: Albert Shih <Albert.Shih@obspm.fr> To: Ivan Voras <ivoras@freebsd.org> Cc: freebsd-questions@freebsd.org Subject: Re: Help for very bad perf for MySQL Message-ID: <20071127130227.GC81551@pcjas.obspm.fr> In-Reply-To: <fiedup$bv7$1@ger.gmane.org> References: <20071126115022.GA70340@pcjas.obspm.fr> <fiedup$bv7$1@ger.gmane.org>
next in thread | previous in thread | raw e-mail | index | archive | help
Le 26/11/2007 à 13:29:35+0100, Ivan Voras a écrit > Albert Shih wrote: > > 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. > > > > For starts, if you didn't do it already, copy > /usr/local/share/mysql/my-huge.cnf to /etc/my.cnf and try again. These > are just some general settings, they might or might not help you. It's change nothing but thanks for you answer Regards. JAS -- Albert SHIH Observatoire de Paris Meudon SIO batiment 15 Heure local/Local time: Mar 27 nov 2007 14:02:06 CET
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20071127130227.GC81551>