2 messages in com.mysql.lists.javaRe: CLOSE_WAIT| From | Sent On | Attachments |
|---|---|---|
| John Rayburn | 02 Oct 2002 03:48 | |
| Mark Matthews | 02 Oct 2002 07:17 |
| Subject: | Re: CLOSE_WAIT |
|---|---|
| From: | Mark Matthews (ma...@mysql.com) |
| Date: | 10/02/2002 07:17:40 AM |
| List: | com.mysql.lists.java |
John Rayburn wrote:
We are using the MySQL JDBC Driver (org.gjt.mm.mysql.Driver) with MySQL 3.* (not MAX) on a RedHat linux box.
I've noticed that at any particular time when the server is quiet, there are upwards of 30-50 TCP connections in the CLOSE_WAIT status to the mysql server. I would think this would have some sort of adverse effect and I was wondering if this is normal, or if it might be an application (Java) or db (MySQL) config/code problem.
Any thoughts?
_________________________________________________________________ Join the world’s largest e-mail service with MSN Hotmail. http://www.hotmail.com
--------------------------------------------------------------------- Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before posting. To request this thread, e-mail java...@lists.mysql.com
To unsubscribe, send a message to the address shown in the List-Unsubscribe header of this message. If you cannot see it, e-mail java...@lists.mysql.com instead.
Which version of the driver are you using? Some very old versions had a bug with not always closing the sockets to the server.
You should try and use the latest stable or beta drivers. See http://www.mysql.com/products/connector-j/
-Mark
-- For technical support contracts, visit https://order.mysql.com/?ref=mmma
__ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Mark Matthews <ma...@mysql.com> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer - JDBC/Java /_/ /_/\_, /___/\___\_\___/ Flossmoor (Chicago), IL USA <___/ www.mysql.com