Make sure the script or application querying the database is closing connections when it has finished with them. Theres an awful lot of badly coded scripts out there, especially php scripts, which keep the connections to the server open and eating away at server resources long after they could have released the thread back to the server.
On Mon, 2008-11-10 at 18:39 +0100, Uwe Kiewel wrote: > -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1 > > This mailing list has a stupid configuration. Pressing the answer > button, the message goes to the sender not to the list :-( > > - -------- Original-Nachricht -------- > Betreff: Re: Is it a bug or my mistake in server configuration? > Datum: Mon, 10 Nov 2008 18:36:34 +0100 > Von: Uwe Kiewel <[EMAIL PROTECTED]> > An: Alexey Vlasov <[EMAIL PROTECTED]> > Referenzen: <[EMAIL PROTECTED]> > > Alexey Vlasov schrieb: > > open files (-n) 1024 > > > just a shot to the blue: > > can you count your open files with lsof? > > HTH, > Uwe > -----BEGIN PGP SIGNATURE----- > Version: GnuPG v1.4.9 (MingW32) > Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org > > iQIcBAEBAgAGBQJJGHG8AAoJEEJXG7BUuynnycwP/1SB9O7u8toxRYcRbctfwbdV > EnycPRk9k2meEEWEFNCqr/lQr3qzZL9BEj8HrMUnSqOSgkKKFS/XeqkIsUK+BZzp > 2lV6zjD+wAtlM++O5BYYlQZ1JRgtk6rEkf+qWYQvRqbGOuQsSZ9UBqb7trUhbumF > 7GsygytsUhT9aDmOlHoanlQ0VDQl+QvxKMVgtyu78s3CR7tMihSVxGdfC0A5Ws02 > mlGdhxs/BgQsKuuSjLFar8Ok+Ad8g+lYhz5a2Tf8JTidYOBx1SAJoXC4R5MpRipp > AUwfcMe3w7VaNZ47L+Sh20hYyQpYDCNiyBX371uMWE7Yizbm6ddDd1JZ3jkv8NdL > N/9uLLLu14OIkYbC5TYJT84F9WlmvDtQiLTIl71LYjlPQdlEHsPs65+I5Pdmvt5V > 0MfC2Weob0JUmzNBV/x03XfSUbEvXaScTdJa+DEV5+QNEnxxlRP45QVow+kfLMkQ > gB7jvFfIkpjhUsfkaofH83f8wBGXT1AD257blb8X/M1lkLpWjh81xsBFDmfKacXt > xu4St/VW59GESPbQaIkU5lcm/d/e93wY3xNIYtxnPsZ50pGv6PCszdI8N7Uu5UHQ > KrYXO8G8Bi4unI9i1bfPSJUyfFErWGesiqYopydt5idvyfPJA9E2aKtqTXqHfDc9 > m0XjbWeBv2JXC8R04byE > =vQC5 > -----END PGP SIGNATURE----- >
