I would guess that your scripting library is not closing your connections for you as your variables go out of scope. Each database access library (PHP, DBI, ADO, etc) has its own command to manually close a connection. I suggest you review your code and make sure that you manually close each connection as soon as you no longer need it. This is a cross-platform issue and not related to any language in particular.
Eventually, the garbage collection routine in your language will find your abandoned connections and reclaim them but that could take quite a while depending on how much heap space you have and the aggressiveness of your language's collector. It's always best to manually close your connection and dereference it before allowing the variables to go out of scope. Yours, Shawn Green Database Administrator Unimin Corporation - Spruce Pine "Linda" <[EMAIL PROTECTED]> wrote on 08/16/2004 09:38:43 AM: > Hi, > > I found my MySQL's connections are keeping increasing recently. I > setted the timeout as below: > | interactive_timeout | 14400 | > | wait_timeout | 14400 | > > When I run processlist, I found there are a lot of connections over > 14400 but the connections are still sleeping. That's why my > connections are keep inceasing. > > 61534 admin 192.168.1.10 abc 40099 Sleep > 60027 admin 192.168.1.10 abc 40090 Sleep > 61554 admin 192.168.1.10 abc 40041 Sleep > 61732 admin 192.168.1.10 abc 39825 Sleep > > > > Could anyone tell how to fix it? I am using MySQL-4.0.20 with Max onRedHat 9. > > > Thanks > > > Linda
