Date: Mon, 16 Mar 2015 21:45:17 -0700 From: David Benfell <benfell@parts-unknown.org> To: Charles Swiger <cswiger@mac.com> Cc: questions@freebsd.org Subject: Re: sonewconn: pcb 0xfffff801efdd1000: Listen queue overflow: 31 already in queue awaiting acceptance Message-ID: <20150317044517.GA6069@home.parts-unknown.org> In-Reply-To: <457B9A78-1A87-4CE9-BBD0-5813BDA352CE@mac.com> 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>
next in thread | previous in thread | raw e-mail | index | archive | help
--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 <benfell@parts-unknown.org> 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--
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20150317044517.GA6069>