tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Christopher Schultz <ch...@christopherschultz.net>
Subject Re: R: How to close idle connections
Date Mon, 28 Apr 2008 18:38:15 GMT
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

David,

David Smith wrote:
| I'll bet money the added, idle postgres connections are just sleeping
| while they wait for work.  Given idle connections contribute virtually
| no additional load, don't see his argument that idle connections
| contribute to a database overload.  If the minor increase in overhead
| due to sleeping threads actually overloads the database, you need to let
| your boss know the server hardware is way too frail for production use
| and needs to be upgraded.

It could be a memory issue, and perhaps with lots of connections from
different machines (maybe a clustered application and a single database
instance)... lots of connections == lots of memory allocated on the
server, even when the connections are idle.

- -chris

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.9 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iEYEARECAAYFAkgWGZcACgkQ9CaO5/Lv0PCVVgCgiQHs4I8xJfbupkGXUHEBLgci
qmQAn3yNwIsnO4jzF/GobTZyzXp8fe17
=ma/c
-----END PGP SIGNATURE-----

---------------------------------------------------------------------
To start a new topic, e-mail: users@tomcat.apache.org
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org


Mime
View raw message