From owner-freebsd-threads@FreeBSD.ORG Tue Feb 3 15:24:29 2004 Return-Path: Delivered-To: freebsd-threads@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 906C216A4CE for ; Tue, 3 Feb 2004 15:24:29 -0800 (PST) Received: from mail.asn.net (mail.asn.net [66.235.231.4]) by mx1.FreeBSD.org (Postfix) with SMTP id 9B91043D39 for ; Tue, 3 Feb 2004 15:24:28 -0800 (PST) (envelope-from kris-fbsd@asn.net) Received: (qmail 69169 invoked by uid 80); 3 Feb 2004 23:24:28 -0000 Received: from 68.3.131.72 (SquirrelMail authenticated user kgale) by mail.asn.net with HTTP; Tue, 3 Feb 2004 16:24:28 -0700 (MST) Message-ID: <54817.68.3.131.72.1075850668.squirrel@mail.asn.net> Date: Tue, 3 Feb 2004 16:24:28 -0700 (MST) From: "Kris Gale" To: freebsd-threads@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-threads@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: Threading on FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Tue, 03 Feb 2004 23:24:29 -0000 --- I originally posted this to freebsd-current, but it was suggested I bring it up on this list, too. --- 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