Primarily the database serves the web server so it is always the same host.
The database may vary, but some more than others. I feel confident that
some path through an ASP either crashes or the connection close command is
never reached or does not exist. However, I would think that the timeout
would still kill those.... they are sleeping... for days.
BTW, I am running 2.23.32 on Win2K.
I have been trying to come up with an easy way to know which ASP has the
error in it. Only thing I can think of is to create dozens of usernames and
use a different one in each file.... ick... that will take some time.
[EMAIL PROTECTED]
----- Original Message -----
From: "Jeremy D. Zawodny" <[EMAIL PROTECTED]>
To: "Meyer, Patrick" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Thursday, February 01, 2001 2:48 AM
Subject: Re: wait_timeout?
> On Tue, Jan 30, 2001 at 12:26:34PM -0600, Meyer, Patrick wrote:
> >
> > I am slowly gaining connections to the database that just sleep. I
> > know these can arise from not closing the database. I am accessing
> > it via MyODBC from Active Server Pages. However, I set wait_timeout
> > to 3600... I have some that have been there for days... just
> > sleeping. Why doesn't MySQL disconnect them from the timeout?
> > Maybe I just don't understand wait_timeout.
>
> That's odd.
>
> I haven't had the need to use wait_timeout, so I can't say what you
> should expect. But I'd expect that it should work as documented.
>
> Do they appear to have anything particular in common? Same
> host/user/db?
>
> Jeremy
> --
> Jeremy D. Zawodny, <[EMAIL PROTECTED]>
> Technical Yahoo - Yahoo Finance
> Desk: (408) 328-7878 Fax: (408) 530-5454
> Cell: (408) 439-9951
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
