From owner-freebsd-stable@FreeBSD.ORG Mon May 23 18:45:37 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 76F6B16A41C for ; Mon, 23 May 2005 18:45:37 +0000 (GMT) (envelope-from killing@multiplay.co.uk) Received: from multiplay.co.uk (www1.multiplay.co.uk [212.42.16.7]) by mx1.FreeBSD.org (Postfix) with ESMTP id F26BB43D1D for ; Mon, 23 May 2005 18:45:36 +0000 (GMT) (envelope-from killing@multiplay.co.uk) Received: from vader ([212.135.219.179]) by multiplay.co.uk (multiplay.co.uk [212.42.16.7]) (MDaemon.PRO.v8.0.2.R) with ESMTP id md50001431345.msg for ; Mon, 23 May 2005 19:40:33 +0100 Message-ID: <004d01c55fc7$7d0afd50$b3db87d4@multiplay.co.uk> From: "Steven Hartland" To: , "Pete French" References: Date: Mon, 23 May 2005 19:44:41 +0100 MIME-Version: 1.0 Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=original Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2900.2527 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2527 X-Spam-Processed: multiplay.co.uk, Mon, 23 May 2005 19:40:33 +0100 (not processed: message from valid local sender) X-MDRemoteIP: 212.135.219.179 X-Return-Path: killing@multiplay.co.uk X-MDaemon-Deliver-To: stable@FreeBSD.ORG X-MDAV-Processed: multiplay.co.uk, Mon, 23 May 2005 19:40:35 +0100 Cc: Subject: Re: 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 18:45:37 -0000 Do you get a particular error and which version of mysql are you running: We have to use 4.0 due to this bug: http://bugs.mysql.com/?id=7209&edit=2 Steve ----- Original Message ----- From: "Pete French" To: Sent: Monday, May 23, 2005 6:26 PM Subject: mysql loosing connections on 5.4 > 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. ================================================ This e.mail is private and confidential between Multiplay (UK) Ltd. and the person or entity to whom it is addressed. In the event of misdirection, the recipient is prohibited from using, copying, printing or otherwise disseminating it or any information contained in it. In the event of misdirection, illegible or incomplete transmission please telephone (023) 8024 3137 or return the E.mail to postmaster@multiplay.co.uk.