From owner-freebsd-questions@FreeBSD.ORG Tue Mar 17 04:45:18 2015 Return-Path: Delivered-To: questions@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:1900:2254:206a::19:1]) (using TLSv1.2 with cipher AECDH-AES256-SHA (256/256 bits)) (No client certificate requested) by hub.freebsd.org (Postfix) with ESMTPS id A20C8425 for ; Tue, 17 Mar 2015 04:45:18 +0000 (UTC) Received: from mail.parts-unknown.org (mail.parts-unknown.org [50.250.218.162]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (Client did not present a certificate) by mx1.freebsd.org (Postfix) with ESMTPS id 7B5C5C76 for ; Tue, 17 Mar 2015 04:45:18 +0000 (UTC) Received: by mail.parts-unknown.org (Postfix, from userid 1001) id 0A66A5B3BD22; Mon, 16 Mar 2015 21:45:17 -0700 (PDT) Date: Mon, 16 Mar 2015 21:45:17 -0700 From: David Benfell To: Charles Swiger Subject: Re: sonewconn: pcb 0xfffff801efdd1000: Listen queue overflow: 31 already in queue awaiting acceptance Message-ID: <20150317044517.GA6069@home.parts-unknown.org> References: <20150316213018.GA97580@home.parts-unknown.org> <22987F08-3543-43BE-A06A-78E76437ADD2@mac.com> <20150316234857.GA3587@home.parts-unknown.org> <457B9A78-1A87-4CE9-BBD0-5813BDA352CE@mac.com> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="RnlQjJ0d97Da+TV1" Content-Disposition: inline In-Reply-To: <457B9A78-1A87-4CE9-BBD0-5813BDA352CE@mac.com> User-Agent: Mutt/1.5.23 (2014-03-12) Cc: questions@freebsd.org X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.18-1 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Tue, 17 Mar 2015 04:45:18 -0000 --RnlQjJ0d97Da+TV1 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Mon, Mar 16, 2015 at 05:01:45PM -0700, Charles Swiger wrote: >=20 > There's an apc.php script which will look at your APC stats. >=20 It appears not to be compatible with php 5.5, which I guess raises the question of why I'm needing to adjust this value at all. In any event, I raised it to 2048M and *this* time didn't see a recurrance. We shall see. > >> The listen queue overflow means that your system is failing to process > >> incoming requests fast enough to keep up. The bottleneck could be > >> on a resource like CPU or memory, or serialization against a database > >> table, or something else. (You'll want to identify the bottleneck.) I found this article: http://www.softwareprojects.com/resources/programming/t-optimizing-nginx-an= d-php-fpm-for-high-traffic-sites-2081.html It suggests a number of changes to sysctl oids (including a couple of, I guess, obsolete ones). I've imported these. I don't think my sites are really high traffic (I should be rich and famous if they were, right?) but the box seems able to handle it. > >=20 > > Interesting. htop says I've got plenty of memory and CPU--it's a new > > server and I went big. That would seem to suggest mysql may not be > > performing well, which is a very strong possibility. Until relatively > > recently, I was trying to run on a VPS and then a rather small hosted > > server; I don't think I've revisited the mysql configuration since. > >=20 > > Thank you very much. All this helps. >=20 > mysql is a likely candidate, particularly if it was an old setup and has > not been tuned for the workload. For example, MyISAM is adequate for > read-mostly stuff, but table-level locking tends to become a real problem > if you have more than a single admin instance doing writes. >=20 > http://dev.mysql.com/doc/refman/5.7/en/table-locking.html Looking at that, I'm not sure I dare mess with it. None of this is code I'm writing myself and the one thing left on that page that I could do would change the order of updates, which, intuitively more than anything else, sounds unwise. But I've installed mysqltuner and so I guess I'll be increasing some variables until (assuming it ever can be) it is happy. Thanks! --=20 David Benfell See https://parts-unknown.org/node/2 if you don't understand the attachment. --RnlQjJ0d97Da+TV1 Content-Type: application/pgp-signature -----BEGIN PGP SIGNATURE----- Version: GnuPG v1 iQIcBAEBCgAGBQJVB7FcAAoJEBV64x4SNmArdvQP/1i73by0vFE9OdVgyaccftop l32zgtzmRNJEmBWKHj5ebdVTFhbFZIvBdS60FLbXiZFQ5x61AtOwgmuGRn9FCKSo vaQ1LHMrqLqEOMK6sMH6UdBjeQK/BuxMIwBMKup6bHtuDzhefbQdhww28Vcla2s6 CSm2zmNfITQveM8jbTTtKJJnfxWJzPD5QSpYIF8aBuqxeWmK59huE85H8quNHlKt HMJtcUo3t8ic62it3B1juFZPaTwYCcVRTJq4uviHYbUD1plfyhT2QuiS1TUbe4Nb ePZ8TRRzwVElqTNik5FYDeHZsEzUv8hcs13br1+Iypv5wbkJxWMviVOahaV7SjR7 FBQzAsAPgldJ4EZY6GAyzE69T6RyeHuuGIMBhu6B2/Amj328DI4+Y0aKpM+6Kfkd LjP4DalWQnNvwmmJpWRuY456D0FAGgyIdB2+GY9wteBjQTHJxUQlsdVsd9GAn7xy fKRtEzsugES0bEWcA0SIi6/u674vJTBUJ87xGHaH/dcfieLuCNYBxeZXXLJhFFqS 1XjUlogBUxddnEQV9g9/tFCLRcyeV2nJNSI9YTMZWMYry25k/VhNt05YhgUxQ8z8 RAVYTYzWPDCRzhwKeE9pDHMPxYpyqLJTouM4kigJDbYM7h2za7sVobC0OV9bQPUA kj1ACvR1gr7rAbLL1mCp =Y0Sj -----END PGP SIGNATURE----- --RnlQjJ0d97Da+TV1--