On Thu, Aug 14, 2003 at 11:35:18AM -0700, Jennifer Goodie wrote:
> > Setting skip-name-resolve will avoid this code path and the bug. It
> > looks like some DNS funkyness...
> >
>
> I've implented this and so far I can't get the box to hang in authentication
> no matter how mean I am to it. I fe
On Thursday, Aug 7, 2003, at 13:41 America/Los_Angeles, Jennifer Goodie
wrote:
I have a stand alone database server. It is a RAID5 running mySQL
3.23.55
on FreeBSD 4.1
In addition to Jeremy's suggestion of setting skip-name-resolve (and
changing host names in the "mysql" database to IP address
On Fri, Aug 08, 2003 at 04:18:51PM -0700, Jeremy Zawodny wrote:
> On Thu, Aug 07, 2003 at 09:07:41PM -0500, Dan Nelson wrote:
> > In the last episode (Aug 07), Jeremy Zawodny said:
> > > > I've been on the box at the mysql prompt quite a few times when it
> > > > has happened and there was always a
> > A crash was recreated by running a specific query.
>
> Oh.
>
> You didn't mention crashes in your first note. That changes
> everything.
Sorry, I'm a dork. Buy crash I mean "all new connections getting stuck in
authentication mode." As the day wears on my Jennifer Vernacular -> English
tran
In the last episode (Aug 07), Jeremy Zawodny said:
> > I've been on the box at the mysql prompt quite a few times when it
> > has happened and there was always a large amount of threads waiting
> > for a lock to clear, and as soon as they went through nothing could
> > connect, but this doesn't hap
> > One of my coworkers insists that this is due to corrupt indexes, stating
> > that if an index points to a location outside of the record set
> mysql gets
> > confused and hangs.
>
> Does he have any evidence whatsoever for that? I'm 99% sure he's
> wrong--at least in *our* cases. :-)
A crash
> Setting skip-name-resolve will avoid this code path and the bug. It
> looks like some DNS funkyness...
>
I've implented this and so far I can't get the box to hang in authentication
no matter how mean I am to it. I feel so dumb, for not thinking of this
before, I swore I had already done it ab
On Thu, Aug 07, 2003 at 03:58:37PM -0700, Jennifer Goodie wrote:
> > > One of my coworkers insists that this is due to corrupt indexes, stating
> > > that if an index points to a location outside of the record set
> > mysql gets
> > > confused and hangs.
> >
> > Does he have any evidence whatsoever
On Thu, Aug 07, 2003 at 09:07:41PM -0500, Dan Nelson wrote:
> In the last episode (Aug 07), Jeremy Zawodny said:
> > > I've been on the box at the mysql prompt quite a few times when it
> > > has happened and there was always a large amount of threads waiting
> > > for a lock to clear, and as soon
On Thu, Aug 07, 2003 at 01:41:57PM -0700, Jennifer Goodie wrote:
> I have a stand alone database server. It is a RAID5 running mySQL 3.23.55
> on FreeBSD 4.1 and has 768MB of RAM, I'm not sure on the processor speed,
> but I think it's a P3 1GHz. It has several tables with 20-40 million rows
> an
Jennifer Goodie wrote:
I have a stand alone database server. It is a RAID5 running mySQL 3.23.55
on FreeBSD 4.1 and has 768MB of RAM, I'm not sure on the processor speed,
but I think it's a P3 1GHz. It has several tables with 20-40 million rows
and a ton of smaller tables with less than 1 millio
11 matches
Mail list logo
