From owner-freebsd-questions@FreeBSD.ORG Tue Mar 17 00:01:52 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 2ADB0493 for ; Tue, 17 Mar 2015 00:01:52 +0000 (UTC) Received: from mail-in2.apple.com (mail-out2.apple.com [17.151.62.25]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (Client did not present a certificate) by mx1.freebsd.org (Postfix) with ESMTPS id F0A25CE8 for ; Tue, 17 Mar 2015 00:01:51 +0000 (UTC) Received: from relay8.apple.com (relay8.apple.com [17.128.113.102]) by mail-in2.apple.com (Apple Secure Mail Relay) with SMTP id 19.EA.09031.9EE67055; Mon, 16 Mar 2015 17:01:45 -0700 (PDT) X-AuditID: 11973e11-f79f86d000002347-f9-55076ee9ad44 Received: from [17.149.230.73] (Unknown_Domain [17.149.230.73]) (using TLS with cipher DHE-RSA-AES256-SHA (256/256 bits)) (Client did not present a certificate) by relay8.apple.com (Apple SCV relay) with SMTP id A0.90.06911.EEE67055; Mon, 16 Mar 2015 17:01:50 -0700 (PDT) Content-Type: text/plain; charset=us-ascii Mime-Version: 1.0 (Mac OS X Mail 8.2 \(2070.6\)) Subject: Re: sonewconn: pcb 0xfffff801efdd1000: Listen queue overflow: 31 already in queue awaiting acceptance From: Charles Swiger In-Reply-To: <20150316234857.GA3587@home.parts-unknown.org> Date: Mon, 16 Mar 2015 17:01:45 -0700 Content-Transfer-Encoding: quoted-printable Message-Id: <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> To: David Benfell X-Mailer: Apple Mail (2.2070.6) X-Brightmail-Tracker: H4sIAAAAAAAAA+NgFlrPLMWRmVeSWpSXmKPExsUi2FCYpvsyjz3UoGOevkXrrL8sFt0nu5kd mDxmfJrP4nG9awpTAFMUl01Kak5mWWqRvl0CV8aESx1sBVd4Kv5/2szewDiVq4uRk0NCwETi /ZNeRghbTOLCvfVsXYxcHEIC+xgl5p/Zxw5T1L13OVRiKpPEhEdfmUASzAJaEjf+vQSzeQUM JOae+gJmCwvkSRy7DTKVg4NNQE1iwkQekDCngLXErnNHWEBsFgFViW3vH7NBjJGUWPh+HQuE rS2xbOFrZoiRVhIPrsxngdg7k1Hiz6fdYAkRAV2JLasOsYPMlxCQl+jZlA5SIyHwkVXi3Lo/ bBMYhWYhOW8WkvNmIdmxgJF5FaNQbmJmjm5mnpFeYkFBTqpecn7uJkZQCE+3E9zBeHyV1SFG AQ5GJR7eAAm2UCHWxLLiytxDjNIcLErivI19/0OEBNITS1KzU1MLUovii0pzUosPMTJxcEo1 MG62Mdr3YmeNEJdJx/vsN7z59q8f/ntquiNOJfyIH3e64bLVxipVT4ITImPvxX/5tlhnjdp/ OVPjkzsrZq1RZllhbnrpRo/+oRb+Kf3HdyvOKa3tEXfY/LTdbHWolFLm8i95D9c+nmqkJia/ 2/zz18RXuQa/2fe/4A6TfMA2M2HBM4MQV5X9vUosxRmJhlrMRcWJAKlDZdJCAgAA X-Brightmail-Tracker: H4sIAAAAAAAAA+NgFlrELMWRmVeSWpSXmKPExsUiOPWZp+67PPZQgw9PjCxaZ/1lseg+2c3s wOQx49N8Fo/rXVOYApiiuGxSUnMyy1KL9O0SuDImXOpgK7jCU/H/02b2BsapXF2MnBwSAiYS 3XuXs0HYYhIX7q0Hsrk4hASmMklMePSVCSTBLKAlcePfSzCbV8BAYu6pL2C2sECexLHbvYxd jBwcbAJqEhMm8oCEOQWsJXadO8ICYrMIqEpse/+YDWKMpMTC9+tYIGxtiWULXzNDjLSSeHBl PgvE3pmMEn8+7QZLiAjoSmxZdYgdZL6EgLxEz6b0CYz8s5BcNAvJRbOQjF3AyLyKUaAoNSex 0kIvsaAgJ1UvOT93EyMo5BoK03YwNi23OsQowMGoxMMbIMEWKsSaWFZcmXuIUYKDWUmE95sS e6gQb0piZVVqUX58UWlOavEhRmkOFiVxXnlOoJRAemJJanZqakFqEUyWiYNTqoHRdPqTrnlh K7jDL+6/yV5qlrbYMdo/Juy+vtrVPz+VfuZOfd6fGv0vvlYiVK161f3KVwUtBdrvn2UeXjI1 meHDpnDRX/nXo7fvdVphc896QmyBwq/ns5QNYtMOBJnOCL08OfnaHL6NFXpf3I9fDklhvGo+ c4ekgQzPm1Mh+xpNl9S8jN6W2delxFKckWioxVxUnAgA9GKQJjUCAAA= 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 00:01:52 -0000 On Mar 16, 2015, at 4:48 PM, David Benfell = wrote: > On Mon, Mar 16, 2015 at 03:38:51PM -0700, Charles Swiger wrote: >>=20 >> They aren't directly related. You generally need to increase = apc.shm_size >> suitable for however many PHP processes you're running-- generally = via mod_php >> in Apache or fastcgi for nginx and the like. >=20 > I *am* running a bunch of php-fpm processes. Is there a formula for > calculating this? There's an apc.php script which will look at your APC stats. >> 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.) >=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. 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. http://dev.mysql.com/doc/refman/5.7/en/table-locking.html Regards, --=20 -Chuck