Re: Help for very bad perf for MySQL

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.2, I'm

Re: Help for very bad perf for MySQL

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 it's take 0.6

Re: Help for very bad perf for MySQL

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

Re: Help for very bad perf for MySQL

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.X on this

Re: Help for very bad perf for MySQL

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 Linux it's

RE: Help for very bad perf for MySQL

-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-0800, Ted Mittelstaedt a écrit Sorry

Re: Help for very bad perf for MySQL

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

-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 very bad perf for MySQL

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

RE: Help for very bad perf for MySQL

-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 send a message. But I don't receive any answer

Re: Help for very bad perf for MySQL

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 on this server

Re: Help for very bad perf for MySQL

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

Re: Help for very bad perf for MySQL

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

RE: Help for very bad perf for MySQL

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 kind of query

RE: Help for very bad perf for MySQL

-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 send a message. But I don't receive any answer