From owner-freebsd-current@FreeBSD.ORG Tue Feb 3 13:18:57 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 CD91916A4CE; Tue, 3 Feb 2004 13:18:57 -0800 (PST) Received: from mail.pcnet.com (mail.pcnet.com [204.213.232.4]) by mx1.FreeBSD.org (Postfix) with ESMTP id A67B343D48; Tue, 3 Feb 2004 13:18:56 -0800 (PST) (envelope-from eischen@vigrid.com) Received: from mail.pcnet.com (mail.pcnet.com [204.213.232.4]) by mail.pcnet.com (8.12.10/8.12.1) with ESMTP id i13LImiw022365; Tue, 3 Feb 2004 16:18:48 -0500 (EST) Date: Tue, 3 Feb 2004 16:18:48 -0500 (EST) From: Daniel Eischen X-Sender: eischen@pcnet5.pcnet.com To: Kris Gale In-Reply-To: <54647.68.3.131.72.1075836867.squirrel@mail.asn.net> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII cc: threads@freebsd.org cc: freebsd-current@freebsd.org cc: Julian Elischer Subject: Re: 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 21:18:57 -0000 On Tue, 3 Feb 2004, Kris Gale wrote: > 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? It would help if you could give us some way to reproduce this. How you configure/install MySQL, what scripts to run to generate the queries, etc. I've not really used MySQL too much, so don't assume I know anything ;-) Also, you may have to increase kern.threads.max_threads_per_proc if you have a lot of threads stuck in the kernel. -- Dan Eischen