[Nss-mysql-devel] [ 101353 ] Lots of sleeping threads

[nobody]

Support Request #101353, was updated on 2002-Oct-04 18:55
You can respond by visiting: 
http://savannah.nongnu.org/support/?func=detailsupport&support_id=101353&group_id=443

Category: None
Status: Open
Priority: 5
Summary: Lots of sleeping threads

By: gmorin
Date: 2002-Oct-05 12:22
Logged In: YES 
user_id=230
Browser: Mozilla/5.0 (X11; U; Linux ppc; fr-FR; rv:1.1) Gecko/20020915 
Debian/1.1-1

Hi,

>From which version were you updating ? Was that 0.42 or
earlier ?

Guillaume.

----------------------------------------------------------------------

By: jody
Date: 2002-Oct-04 18:55
Logged In: NO 
Browser: Mozilla/5.0 (Macintosh; U; PPC Mac OS X; en-US; rv:1.0.1) 
Gecko/20020923

Hi,

Since updating to 0.43 nss_mysql seems to create a lot
of mysql sleeping threads; it seems to be creating a
persistent connection to the mysql server, but then not
actually use that thread for future connections, so we
have the situation where within 10 minutes nss_mysql
has flooded our mysql server with over 200 connections
and we have to restart mysql.

we have temporarily solved the problem by limiting the
sleeping thread time to 10 seconds (instead of the
default 28800!!) but is there a bug in nss_mysql somewhere?
 

----------------------------------------------------------------------
You can respond by visiting: 
http://savannah.nongnu.org/support/?func=detailsupport&support_id=101353&group_id=443