Date: Mon, 26 Nov 2007 13:29:35 +0100 From: Ivan Voras <ivoras@freebsd.org> To: freebsd-questions@freebsd.org Subject: Re: Help for very bad perf for MySQL Message-ID: <fiedup$bv7$1@ger.gmane.org> In-Reply-To: <20071126115022.GA70340@pcjas.obspm.fr> References: <20071126115022.GA70340@pcjas.obspm.fr>
next in thread | previous in thread | raw e-mail | index | archive | help
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.
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?fiedup$bv7$1>