the problem is not on the MySQL side.. the problem is in the connection management of your Java application... Are you using connection pooling? Nothing on the server is going to close those connections for you (although they will go stal eventually), that is up to your client application.
- michael On 3/15/07, balaraju mandala <[EMAIL PROTECTED]> wrote:
Hi All, I have some doudts in db connections. Please clarify if u know. I am using MySQL 5 version, while my program(Java Program with threads) is running, some times i won't get DB connection with in expected time. When ever i type "show processlist" on mysql prompt, it is showing 180+ connections estableshed but almost all are in sleep stage only. Is these many opened connections are delaying a new connection? if yes is there any process to close these sleeping connections?
-- - michael dykman - [EMAIL PROTECTED] - All models are wrong. Some models are useful. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
