From owner-freebsd-threads@FreeBSD.ORG Tue Feb 3 12:11:01 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 CF44E16A4CE for ; Tue, 3 Feb 2004 12:11:01 -0800 (PST) Received: from rwcrmhc12.comcast.net (rwcrmhc12.comcast.net [216.148.227.85]) by mx1.FreeBSD.org (Postfix) with ESMTP id 6CB2743D41 for ; Tue, 3 Feb 2004 12:10:40 -0800 (PST) (envelope-from julian@elischer.org) Received: from interjet.elischer.org ([24.7.73.28]) by comcast.net (rwcrmhc12) with ESMTP id <2004020320103901400addo7e>; Tue, 3 Feb 2004 20:10:39 +0000 Received: from localhost (localhost.elischer.org [127.0.0.1]) by InterJet.elischer.org (8.9.1a/8.9.1) with ESMTP id MAA88430 for ; Tue, 3 Feb 2004 12:10:39 -0800 (PST) X-Received: from mx2.freebsd.org (mx2.freebsd.org [216.136.204.119]) by InterJet.elischer.org (8.9.1a/8.9.1) with ESMTP id LAA87981 for ; Tue, 3 Feb 2004 11:34:52 -0800 (PST) X-Received: from hub.freebsd.org (hub.freebsd.org [216.136.204.18]) by mx2.freebsd.org (Postfix) with ESMTP id 73B85564AB for ; Tue, 3 Feb 2004 11:34:45 -0800 (PST) (envelope-from owner-freebsd-current@freebsd.org) X-Received: by hub.freebsd.org (Postfix) id C3B5016A4FB; Tue, 3 Feb 2004 11:34:43 -0800 (PST) Delivered-To: julian@freebsd.org X-Received: from hub.freebsd.org (localhost [127.0.0.1]) by hub.freebsd.org (Postfix) with ESMTP id B877316A4F9; Tue, 3 Feb 2004 11:34:43 -0800 (PST) Delivered-To: freebsd-current@freebsd.org X-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) X-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) X-Received: (qmail 62464 invoked by uid 80); 3 Feb 2004 19:34:27 -0000 X-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 X-BeenThere: freebsd-current@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list Sender: owner-freebsd-current@freebsd.org Errors-To: owner-freebsd-current@freebsd.org ReSent-Date: Tue, 3 Feb 2004 12:10:31 -0800 (PST) Resent-From: Julian Elischer Resent-To: threads@freebsd.org ReSent-Subject: MySQL with KSE -- Unstable? ReSent-Message-ID: Subject: MySQL with KSE -- Unstable? X-BeenThere: freebsd-threads@freebsd.org List-Id: Threading on FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Tue, 03 Feb 2004 20:11:02 -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 _______________________________________________ freebsd-current@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-current To unsubscribe, send any mail to "freebsd-current-unsubscribe@freebsd.org"