Re: mysqld too busy to check its grant tables?

2004-05-05 Thread Jeremy Zawodny
On Wednesday, May 5, 2004, at 11:48 US/Pacific, Atle wrote: What versions are you seeing this on? We've seen it exclusively on 3.23.58, with or without LinuxThreads enabled. Various versions of 4.0.xx. We don't run 3.23.xx much of anywhere anymore. Jeremy -- MySQL General Mailing List For list

RE: mysqld too busy to check its grant tables?

2004-05-05 Thread Atle
e also seen the problem on linux a while back; we haven't had the > problem lately though. > > Donny > > > -Original Message- > > From: Jeremy Zawodny [mailto:[EMAIL PROTECTED] > > Sent: Monday, April 26, 2004 3:36 PM > > To: MySQL > > Cc: [EMAI

Re: mysqld too busy to check its grant tables?

2004-05-02 Thread Atle
We just had another machine that this weird bug introduced itself onto. However, I just noticed something interesting; they're both running mysql-3.23.58. Most of our production servers are 3.23.57 or below. Also, there was a specific change to 3.23.58 dealing with password handling: "Fixed buffe

RE: mysqld too busy to check its grant tables?

2004-04-26 Thread Donny Simonton
Sent: Monday, April 26, 2004 4:21 PM > To: Donny Simonton > Cc: [EMAIL PROTECTED]; 'MySQL' > Subject: Re: mysqld too busy to check its grant tables? > > On Mon, Apr 26, 2004 at 04:11:37PM -0500, Donny Simonton wrote: > > We have tried the same thing, flush hosts and

Re: mysqld too busy to check its grant tables?

2004-04-26 Thread Jeremy Zawodny
On Mon, Apr 26, 2004 at 04:11:37PM -0500, Donny Simonton wrote: > We have tried the same thing, flush hosts and flush privileges did nothing. > Refresh reload did nothing. Once the load went down the problem normally > went away. We have tried shutting down mysql and starting it back up, that > h

RE: mysqld too busy to check its grant tables?

2004-04-26 Thread Donny Simonton
age- > From: Jeremy Zawodny [mailto:[EMAIL PROTECTED] > Sent: Monday, April 26, 2004 3:49 PM > To: Donny Simonton > Cc: [EMAIL PROTECTED]; 'MySQL' > Subject: Re: mysqld too busy to check its grant tables? > > On Mon, Apr 26, 2004 at 03:44:03PM -0500, Donny Simonton wrote

Re: mysqld too busy to check its grant tables?

2004-04-26 Thread Jeremy Zawodny
On Mon, Apr 26, 2004 at 01:56:22PM -0700, Atle wrote: > > On Mon, 26 Apr 2004, Jeremy Zawodny wrote: > > > On Mon, Apr 26, 2004 at 03:44:03PM -0500, Donny Simonton wrote: > > > Jeremy, > > > > > > We have also seen the problem on linux a while back; we haven't had the > > > problem lately though.

Re: mysqld too busy to check its grant tables?

2004-04-26 Thread Atle
On Mon, 26 Apr 2004, Jeremy Zawodny wrote: > On Mon, Apr 26, 2004 at 03:44:03PM -0500, Donny Simonton wrote: > > Jeremy, > > > > We have also seen the problem on linux a while back; we haven't had the > > problem lately though. > > In our case, we've found that neither FLUSH HOSTS or FLUSH PRIVIE

Re: mysqld too busy to check its grant tables?

2004-04-26 Thread Jeremy Zawodny
On Mon, Apr 26, 2004 at 03:44:03PM -0500, Donny Simonton wrote: > Jeremy, > > We have also seen the problem on linux a while back; we haven't had the > problem lately though. In our case, we've found that neither FLUSH HOSTS or FLUSH PRIVIELGES have any effect. Was that the case for you folks as

RE: mysqld too busy to check its grant tables?

2004-04-26 Thread Donny Simonton
Jeremy, We have also seen the problem on linux a while back; we haven't had the problem lately though. Donny > -Original Message- > From: Jeremy Zawodny [mailto:[EMAIL PROTECTED] > Sent: Monday, April 26, 2004 3:36 PM > To: MySQL > Cc: [EMAIL PROTECTED] > Subject:

Re: mysqld too busy to check its grant tables?

2004-04-26 Thread Jeremy Zawodny
On Mon, Apr 26, 2004 at 01:27:08PM -0700, MySQL wrote: > > On Mon, 26 Apr 2004, Jeremy Zawodny wrote: > > > > > Yeah, we've been seeing this bug a bit too. I'm trying to isolate it > > > > and figure out if it's a FreeBSD related problem or something more > > > > MySQL specific. > > > > > > > >

Re: mysqld too busy to check its grant tables?

2004-04-26 Thread MySQL
On Mon, 26 Apr 2004, Jeremy Zawodny wrote: > > > Yeah, we've been seeing this bug a bit too. I'm trying to isolate it > > > and figure out if it's a FreeBSD related problem or something more > > > MySQL specific. > > > > > > Are you using FreeBSD's native threads or LinuxThreads? > > > > FreeBSD

Re: mysqld too busy to check its grant tables?

2004-04-26 Thread Jeremy Zawodny
On Mon, Apr 26, 2004 at 12:21:47PM -0700, MySQL wrote: > > On Mon, 26 Apr 2004, Jeremy Zawodny wrote: > > > On Mon, Apr 26, 2004 at 11:27:46AM -0700, MySQL wrote: > > > > > > Hi, I have a FreeBSD 4.9-R server running 3.23.58-log and lately it's been > > > a daily occurrence that mysqld gets so bu

Re: mysqld too busy to check its grant tables?

2004-04-26 Thread MySQL
On Mon, 26 Apr 2004, Jeremy Zawodny wrote: > On Mon, Apr 26, 2004 at 11:27:46AM -0700, MySQL wrote: > > > > Hi, I have a FreeBSD 4.9-R server running 3.23.58-log and lately it's been > > a daily occurrence that mysqld gets so busy that it's unable to authorize > > connections properly. Our monito

Re: mysqld too busy to check its grant tables?

2004-04-26 Thread Jeremy Zawodny
On Mon, Apr 26, 2004 at 11:27:46AM -0700, MySQL wrote: > > Hi, I have a FreeBSD 4.9-R server running 3.23.58-log and lately it's been > a daily occurrence that mysqld gets so busy that it's unable to authorize > connections properly. Our monitoring system will report something like > this: "Access