On Fri, 29 May 2009, Fabrix wrote:
> In this application is not closing the connection, the development team
> is makeing the change for close the connection after getting the job
> done. So most connections are in idle state. How much would this help?
> Does this could be the real problem?
Ah, now you're getting somewhere. This is actually another subtle problem
with making max_connections really high. It lets developers get away with
being sloppy in ways that waste large amount of server resources.
Fix that problem, re-test, and then think about changing other things.
There's no need to go through kernel changes and the lot if you can nail
the problem at its true source and get acceptable performance.
--
* Greg Smith gsmith@gregsmith.com http://www.gregsmith.com Baltimore, MD