Re: FreeBSD and MySQL - mysqld eats CPU alive

2004-08-04 Thread Peter Schuller
> I've experienced this exact problem, all the way from 4.4-STABLE as well. > The time period where the issue starts happening is very erradic, but I'm > having the exact issue on one of my servers at this very moment. I thought > it was just an issue with my box, and not anyone elses. I've seen t

Re: FreeBSD and MySQL - mysqld eats CPU alive

2004-08-03 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 proble

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 tcpwrapper

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. Us

Re: FreeBSD and MySQL - mysqld eats CPU alive

2004-08-02 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

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 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. A

Re: FreeBSD and MySQL - mysqld eats CPU alive

2004-08-01 Thread Peter Kieser
: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Saturday, July 31, 2004 8:08 PM Subject: FreeBSD and MySQL - mysqld eats CPU alive > > Anyone experienced this problem? Is it mysqld or FreeBSD? I can't pinpoint > the exact issue. > ___

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 s

FreeBSD and MySQL - mysqld eats CPU alive

2004-08-01 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 Linu