Connections not closing

This is a discussion on Connections not closing within the MySQL Database forums, part of the Database Forums category; Hi all. It's the first time I write on this newsgroup, I hope you could help me. I noticed ...


Go Back   Usenet Forums > Database Forums > MySQL Database

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 12-15-2006
Elvandar
 
Posts: n/a
Default Connections not closing

Hi all. It's the first time I write on this newsgroup, I hope you could
help me. I noticed a strange behaviour on MySQL 3.23 under Win 2000
Server. Even if both wait_timeout and interactive_timeout system
variables are set to 28800 seconds (the default) after this time
sleeping connections aren't closed. A similar thing happens if I try to
kill a connection using WinMySqlAdministrator...it says the connection
has been killed, but it remains in the list of active connections (also
after many days...).
Using MySQL 5.0 all works correctly, connections are closed after
wait_timeout and if I kill a connection it is closed in a few seconds.
I tried opening connections with my app (java through jdbc driver),
with sqlyog and with a c++ app. On MySQL 3.23 I've always the same
problem, while on MySQL 5.0 is all ok.
I know on MySQL 3.23 there was a bug closing connections on Solaris
OS...is there a bug also on Windows OS? Unfortunately I can't install
MySQL 5.0 on the server where the app is installed, so I should know if
it's a bug in order to solve it in other ways.
Thanks for any answer!

Elvandar


Reply With Quote
  #2 (permalink)  
Old 12-19-2006
Jared
 
Posts: n/a
Default Re: Connections not closing

just scanning your post quickly try one of following

set session variable wait_timeout = 1000000 on every connection

-or-

verify connection open after every single command execute (my favourite :))


Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are Off
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 05:54 PM.


Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Content Relevant URLs by vBSEO 3.0.0