Hi everybody,
I'm devolping .NET web applications usign mySQL database for Windows.
Searching the web I found this article:
http://bugs.mysql.com/bug.php?id=397
that reads:
In fact, if I run the SHOW FULL PROCESSLIST query I can see many opened connections, one for each user connected to my application. The solution for this is to launch mySQL with the default value of NOT USING PERSISTANT CONNECTIONS.MySQL uses a blocking read for each connection. This means that a connection will not be disconnected automatically after 8 hours (default value for the wait_timeout global variable), as happens with the Unix version of MySQL. If a connection hangs, it's impossible to break it without killing MySQL.
How do I accomplish this? By commandline? By modifying the my.cnf file? Can you give me some advice?
thanks in advance
![]()




Reply With Quote