From owner-freebsd-stable@FreeBSD.ORG Mon May 23 17:26:46 2005 Return-Path: X-Original-To: stable@FreeBSD.ORG Delivered-To: freebsd-stable@FreeBSD.ORG Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 3419B16A41C for ; Mon, 23 May 2005 17:26:46 +0000 (GMT) (envelope-from petefrench@ticketswitch.com) Received: from mail.ticketswitch.com (mail.ticketswitch.com [194.200.93.188]) by mx1.FreeBSD.org (Postfix) with ESMTP id E767843D1F for ; Mon, 23 May 2005 17:26:45 +0000 (GMT) (envelope-from petefrench@ticketswitch.com) Received: from [172.16.1.6] (helo=dilbert.firstcallgroup.co.uk) by mail.ticketswitch.com with esmtp (Exim 4.50 (FreeBSD)) id 1DaGhO-000Gdg-6X for stable@FreeBSD.ORG; Mon, 23 May 2005 18:26:42 +0100 Received: from petefrench by dilbert.firstcallgroup.co.uk with local (Exim 4.50 (FreeBSD)) id 1DaGhN-000Ono-QZ for stable@FreeBSD.ORG; Mon, 23 May 2005 18:26:41 +0100 To: stable@FreeBSD.ORG Message-Id: From: Pete French Date: Mon, 23 May 2005 18:26:41 +0100 Cc: Subject: mysql loosing connections on 5.4 X-BeenThere: freebsd-stable@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Production branch of FreeBSD source code List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Mon, 23 May 2005 17:26:46 -0000 When port randomisation was added to 4.x I noticed that under heavy loading my webservers starting dropping their connections to the the mysql database. This was fixed by disabling port randomisation and everything ran very happily. When I upgraded to 5.4 I left port randomisation on, and everything was fine until we started to get a very heavy load on the servers over the last two days. So I disabled it, and the problem went away to a large degree, but is still there occasionaly (i.e. I still see a few connections). It's odd behavioour, but what makes it odder is that all these connections are too a local mysql process, using a socket in /tmp! So quite how port randomsiation should affect it I dont know. Anybody else seen this ? I remember a few people had the same issue under 4.x, but I havent heard much about it since then. -pcf.