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?
