From owner-freebsd-isp Thu Oct 11 5:20:39 2001 Delivered-To: freebsd-isp@freebsd.org Received: from mout0.freenet.de (mout0.freenet.de [194.97.50.131]) by hub.freebsd.org (Postfix) with ESMTP id A1BCB37B403 for ; Thu, 11 Oct 2001 05:20:35 -0700 (PDT) Received: from [194.97.50.136] (helo=mx3.freenet.de) by mout0.freenet.de with esmtp (Exim 3.33 #1) id 15repF-0002s1-00; Thu, 11 Oct 2001 14:20:33 +0200 Received: from b8273.pppool.de ([213.7.130.115] helo=Magelan.Leidinger.net) by mx3.freenet.de with esmtp (Exim 3.33 #3) id 15repE-0003E7-00; Thu, 11 Oct 2001 14:20:33 +0200 Received: from Leidinger.net (netchild@localhost [127.0.0.1]) by Magelan.Leidinger.net (8.11.6/8.11.6) with ESMTP id f9BBmek04003; Thu, 11 Oct 2001 13:48:41 +0200 (CEST) (envelope-from netchild@Leidinger.net) Message-Id: <200110111148.f9BBmek04003@Magelan.Leidinger.net> Date: Thu, 11 Oct 2001 13:48:39 +0200 (CEST) From: Alexander Leidinger Subject: Re: PostgreSQL & shared memory To: marcel-lists@virtua.ch Cc: sopel@freebsd.hbz.pl, john@goodleaf.net, freebsd-isp@FreeBSD.ORG In-Reply-To: <006b01c1522b$7f9ad750$8d01a8c0@gastroleader.com> MIME-Version: 1.0 Content-Type: TEXT/plain; charset=iso-8859-1 Sender: owner-freebsd-isp@FreeBSD.ORG Precedence: bulk List-ID: List-Archive: (Web Archive) List-Help: (List Instructions) List-Subscribe: List-Unsubscribe: X-Loop: FreeBSD.org On 11 Okt, Marcel Prisi wrote: > On the other hand, I have been impressed by FreeBSD as even when the load > was incredibly high (I saw up to 35.4 load average !!), I could always have > an ssh console and the machine stood up. This is the first FreeBSD machine > we have in such a load (we were linux-oriented up to now) and I must say > that I doubt linux would have handled such a load that way). > > What seems interested is the kind of "deadlock" in which the machine seem to > have been : we had so many requests that the machine started swapping (it > has 1Gb swap) and more and more zombie processes arrived. I had to restart > both apache & postgresql as the machine was unable to answer any http > request. It started again everytime the machine started swapping again. In > order to keep the machine in the ~2.0 - 3.0 load average, I had to stop > apache from using keepalive and stop php from using persistent postgresql > connections. Do you have the http accept filter enabled (man accf_http)? If you didn't use SSL, have you tried the SGI apache accelerating patches (http://oss.sgi.com/, there are bug reports for an SSL enabled apache with SGI patches, so you better didn't use it on a SSL enabled server)? This didn't solves your problems with pgsql, but it may give you a little bit more headroom. Perhaps you may also want to look at the links at "http://www.leidinger.net/cgi-bin/search.pl?q=apache&num=10" for some more apache tuning tips. > We'll set-up a second machine in the next days, so we'll separate db from > http server, we'll see if it helps (I am sure it will help a bit, but not > that much). I now have to see with our development department in order to > optimize their code, as there are way too many sql requests, and I am sure > this will be a much better solutions. Perhaps using more than one db-server may help. Bye, Alexander. -- It's not a bug, it's tradition! http://www.Leidinger.net Alexander @ Leidinger.net GPG fingerprint = C518 BC70 E67F 143F BE91 3365 79E2 9C60 B006 3FE7 To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-isp" in the body of the message