RE: Help for very bad perf for MySQL

2007-11-27 Thread Michael K. Smith - Adhost
> -Original Message- > From: [EMAIL PROTECTED] [mailto:owner-freebsd- > [EMAIL PROTECTED] On Behalf Of Josh Carroll > Sent: Tuesday, November 27, 2007 8:12 AM > To: Ted Mittelstaedt > Cc: [EMAIL PROTECTED]; freebsd-questions@freebsd.org > Subject: Re: Help for ve

Re: Help for very bad perf for MySQL

2007-11-27 Thread Josh Carroll
> Is Hyperthreading enabled (by default it is not under > FreeBSD) mysql is heavily dependent on threading, if it is not > built and linked into the freebsd threads package you will get > poor performance. Some folks have installed the linux compat libs > and linked mysql into the linux threads

RE: Help for very bad perf for MySQL

2007-11-27 Thread Ted Mittelstaedt
> -Original Message- > From: Albert Shih [mailto:[EMAIL PROTECTED] > Sent: Tuesday, November 27, 2007 5:00 AM > To: Ted Mittelstaedt > Cc: freebsd-questions@freebsd.org > Subject: Re: Help for very bad perf for MySQL > > > Le 26/11/2007 à 22:34:34-080

Re: Help for very bad perf for MySQL

2007-11-27 Thread cpghost
On Mon, 26 Nov 2007 13:03:19 +0100 Albert Shih <[EMAIL PROTECTED]> wrote: > > > 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 L

Re: Help for very bad perf for MySQL

2007-11-27 Thread Albert Shih
Le 26/11/2007 à 07:20:43-0500, Philip M. Gollucci 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

Re: Help for very bad perf for MySQL

2007-11-27 Thread Albert Shih
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 t

Re: Help for very bad perf for MySQL

2007-11-27 Thread Albert Shih
Le 26/11/2007 à 13:31:12+0100, Jan Catrysse a écrit > > > > 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 > > > >

Re: Help for very bad perf for MySQL

2007-11-27 Thread Albert Shih
Le 26/11/2007 à 22:34:34-0800, Ted Mittelstaedt a écrit > > Sorry yeasterday I don't have time to answer you. > > > > 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.

RE: Help for very bad perf for MySQL

2007-11-26 Thread Ted Mittelstaedt
> -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of Albert Shih > Sent: Monday, November 26, 2007 3:50 AM > To: freebsd-questions@freebsd.org > Subject: Help for very bad perf for MySQL > > > Hi all > > I've already s

RE: Help for very bad perf for MySQL

2007-11-26 Thread Jan Catrysse
> > > 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). > > 6 seconds seem to be an awful lot. What

Re: Help for very bad perf for MySQL

2007-11-26 Thread Ivan Voras
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 > com

Re: Help for very bad perf for MySQL

2007-11-26 Thread Philip M. Gollucci
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 > comp

Re: Help for very bad perf for MySQL

2007-11-26 Thread Albert Shih
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 o

RE: Help for very bad perf for MySQL

2007-11-26 Thread Jan Catrysse
> -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] 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

Help for very bad perf for MySQL

2007-11-26 Thread Albert Shih
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 (o