Solution: FreeBSD and MySQL - mysqld eats CPU alive

2004-08-02 Thread Martin Blapp
Hi all, We have many Mysql's running here, and just to tell you, there are fixes/workarounds for the behaviour you see: FreeBSD 4.8 / 4.9 / 4.10 : -- Compile port with WITH_LINUXTHREADS=YES or remove tcpwrappers support manually from the build if it hangs with libc_r.

Re: Solution: FreeBSD and MySQL - mysqld eats CPU alive

2004-08-02 Thread Daniel Eischen
On Mon, 2 Aug 2004, Martin Blapp wrote: Hi all, We have many Mysql's running here, and just to tell you, there are fixes/workarounds for the behaviour you see: FreeBSD 4.8 / 4.9 / 4.10 : -- Compile port with WITH_LINUXTHREADS=YES or remove tcpwrappers

Re: FreeBSD and MySQL - mysqld eats CPU alive

2004-08-02 Thread somethrowawayaddy
On Sat, 31 Jul 2004, adp wrote: I recently posted the following message to MySQL discussion list. The response there, and the one I keep finding on Google, is that this is a long-standing issue betweeen FreeBSD and MySQL. For me this has been happening since FreeBSD 4.4. I had that problem a

Re: FreeBSD and MySQL - mysqld eats CPU alive

2004-08-01 Thread Alasdair Lumsden
On Sun, 2004-08-01 at 04:08, adp wrote: FreeBSD 4.4, 4.7, 4.9, 4.10 MySQL 3.x and 4.x Typical load: 50 qps With and without replication enabled. Some sites are SELECT heavy, some are INSERT heavy. For one site I think we will be moving from FreeBSD to Linux for the MySQL servers since

Re: FreeBSD and MySQL - mysqld eats CPU alive

2004-08-01 Thread Brandon D. Valentine
On Sat, Jul 31, 2004 at 10:08:32PM -0500, adp wrote: Any help on this? Googling shows a long history of people having these problems but no solutions. Please don't give me a URL to a Google showing others having this problem--I've seen that and more. I want to know if there is a solution. Any

Re: FreeBSD and MySQL - mysqld eats CPU alive

2004-08-01 Thread John Nielsen
On Saturday 31 July 2004 21:08, adp wrote: I recently posted the following message to MySQL discussion list. The response there, and the one I keep finding on Google, is that this is a long-standing issue betweeen FreeBSD and MySQL. For me this has been happening since FreeBSD 4.4. I don't

Re: FreeBSD and MySQL - mysqld eats CPU alive

2004-08-01 Thread Jeremy Zawodny
On Sat, Jul 31, 2004 at 10:08:32PM -0500, adp wrote: I recently posted the following message to MySQL discussion list. The response there, and the one I keep finding on Google, is that this is a long-standing issue betweeen FreeBSD and MySQL. For me this has been happening since FreeBSD 4.4.

FreeBSD and MySQL - mysqld eats CPU alive

2004-07-31 Thread adp
I recently posted the following message to MySQL discussion list. The response there, and the one I keep finding on Google, is that this is a long-standing issue betweeen FreeBSD and MySQL. For me this has been happening since FreeBSD 4.4. I have one site where we are going to have to move to

Re: FreeBSD and MySQL - mysqld eats CPU alive

2004-07-31 Thread Kevin D. Kinsey, DaleCo, S.P.
removed hackers@, database@ Before the rest of the message ... I think it'd be best not to shotgun your mails like this... adp wrote: I recently posted the following message to MySQL discussion list. The response there, and the one I keep finding on Google, is that this is a long-standing issue

Re: FreeBSD and MySQL - mysqld eats CPU alive

2004-07-31 Thread dap99
removed hackers@, database@ Before the rest of the message ... I think it'd be best not to shotgun your mails like this... Hello. I would disagree with this. This is obviously both database@ and questions@ appropriate. I also feel that it is hackers@ appropriate as it deals with an old,