From owner-freebsd-database@FreeBSD.ORG Sat May 3 05:39:52 2003 Return-Path: Delivered-To: freebsd-database@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id EA91937B401 for ; Sat, 3 May 2003 05:39:52 -0700 (PDT) Received: from libra.i-cable.com (libra.i-cable.com [203.83.111.73]) by mx1.FreeBSD.org (Postfix) with SMTP id 77F1B43F75 for ; Sat, 3 May 2003 05:39:51 -0700 (PDT) (envelope-from jeremy@inframatrix.com) Received: (qmail 19741 invoked by uid 706); 3 May 2003 12:39:49 -0000 Received: from cm61-10-38-73.hkcable.com.hk (HELO L5) (61.10.38.73) by 0 with SMTP; 3 May 2003 12:39:46 -0000 Message-ID: <06be01c31171$120dd960$0402a8c0@L5> From: "[IFMX] Jeremy" To: Date: Sat, 3 May 2003 20:39:41 +0800 MIME-Version: 1.0 Content-Type: text/plain; charset="big5" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1106 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 Subject: Problems with MySQL X-BeenThere: freebsd-database@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: Database use and development under FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Sat, 03 May 2003 12:39:53 -0000 Hi, I run a small hosting service and I have serious problems with MySQL. I installed version 3.23.53 using the ports defaults and did not add any optimizations except tuning the back_log, max_connections and connection_timeout variables. My clients experience occation connection drops, either resulting in "cannot connect to database" or "no database selected". I have absolutely no idea of what's happening, nothing is wrong in the logs and the problem happens randomly. Any idea? Thanks in advance - Jeremy From owner-freebsd-database@FreeBSD.ORG Sat May 3 11:20:47 2003 Return-Path: Delivered-To: freebsd-database@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 1563537B401 for ; Sat, 3 May 2003 11:20:47 -0700 (PDT) Received: from search.sparks.net (search.sparks.net [207.5.180.136]) by mx1.FreeBSD.org (Postfix) with ESMTP id 9093943FBD for ; Sat, 3 May 2003 11:20:46 -0700 (PDT) (envelope-from dmiller@sparks.net) Received: by search.sparks.net (Postfix, from userid 100) id 0DCA3A903; Sat, 3 May 2003 14:20:46 -0400 (EDT) Received: from localhost (localhost [127.0.0.1]) by search.sparks.net (Postfix) with ESMTP id 0BADCA902; Sat, 3 May 2003 14:20:46 -0400 (EDT) Date: Sat, 3 May 2003 14:20:46 -0400 (EDT) From: David Miller X-Sender: dmiller@search.sparks.net To: "[IFMX] Jeremy" In-Reply-To: <06be01c31171$120dd960$0402a8c0@L5> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Sender: dmiller@sparks.net cc: freebsd-database@freebsd.org Subject: Re: Problems with MySQL X-BeenThere: freebsd-database@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: Database use and development under FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Sat, 03 May 2003 18:20:47 -0000 On Sat, 3 May 2003, [IFMX] Jeremy wrote: > Hi, > > I run a small hosting service and I have serious problems with MySQL. I > installed version 3.23.53 using the ports defaults and did not add any > optimizations except tuning the back_log, max_connections and > connection_timeout variables. My clients experience occation connection > drops, either resulting in "cannot connect to database" or "no database > selected". I have absolutely no idea of what's happening, nothing is wrong > in the logs and the problem happens randomly. Any idea? Thanks in advance Sounds like you might be running out of file descriptors or something similar - too many processes or something. Check the first with sysctl. --- David