Date: Mon, 26 Nov 2007 07:20:43 -0500 From: "Philip M. Gollucci" <pgollucci@riderway.com> To: "Albert.Shih@obspm.fr" <Albert.Shih@obspm.fr> Cc: "freebsd-questions@freebsd.org" <freebsd-questions@freebsd.org> Subject: Re: Help for very bad perf for MySQL Message-ID: <474ABA1B.9070808@riderway.com> 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. Well -- we'll need more information, but as your say, if its not threading related what makes you think its FreeBSD. You'd probably have better luck over on mysql@lists.mysql.com. A good start would be the query itself, and the output of EXPLAIN for that query. Also, your my.cnf is the next step. -- ------------------------------------------------------------------------ Philip M. Gollucci (philip@ridecharge.com) o:703.549.2050x206 Senior System Admin - Riderway, Inc. http://riderway.com / http://ridecharge.com 1024D/EC88A0BF 0DE5 C55C 6BF3 B235 2DAB B89E 1324 9B4F EC88 A0BF Work like you don't need the money, love like you'll never get hurt, and dance like nobody's watching.
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?474ABA1B.9070808>