From owner-freebsd-current@FreeBSD.ORG Tue Feb 3 11:34:29 2004 Return-Path: Delivered-To: freebsd-current@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 2038D16A4CE for ; Tue, 3 Feb 2004 11:34:29 -0800 (PST) Received: from mail.asn.net (mail.asn.net [66.235.231.4]) by mx1.FreeBSD.org (Postfix) with SMTP id 8BF4C43D45 for ; Tue, 3 Feb 2004 11:34:27 -0800 (PST) (envelope-from kris-fbsdcur@asn.net) Received: (qmail 62464 invoked by uid 80); 3 Feb 2004 19:34:27 -0000 Received: from 68.3.131.72 (SquirrelMail authenticated user kgale) by mail.asn.net with HTTP; Tue, 3 Feb 2004 12:34:27 -0700 (MST) Message-ID: <54647.68.3.131.72.1075836867.squirrel@mail.asn.net> Date: Tue, 3 Feb 2004 12:34:27 -0700 (MST) From: "Kris Gale" To: freebsd-current@freebsd.org User-Agent: SquirrelMail/1.4.2 MIME-Version: 1.0 Content-Type: text/plain;charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Priority: 3 Importance: Normal Subject: MySQL with KSE -- Unstable? X-BeenThere: freebsd-current@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: Discussions about the use of FreeBSD-current List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Tue, 03 Feb 2004 19:34:29 -0000 I've given MySQL on KSE a couple of tries in production, and I've run into a problem where threads seem to build up after an hour or so, depending on load. The first time I tried it, we were maintaining a load of about 600 threads and 300 queries/second and lasted about three hours before the thread count went through the roof and MySQL became unresponsive. The second time, we were sustaining a load of 1300 threads and 600 queries/second. This only lasted about 30 minutes. Each time, upon attempting to restart MySQL without first shutting down the web cluster that was using it, the server rebooted. I'm not sure if this was because MySQL got flooded with reconnect requests, and the machine crashed trying to start up threads that quickly. Any ideas? Has anyone else had success with MySQL on 5.2 with KSE in high-load environments? Kris Gale