From owner-freebsd-threads@FreeBSD.ORG Tue Feb 10 13:49:26 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 4890916A4CE for ; Tue, 10 Feb 2004 13:49:26 -0800 (PST) Received: from mail.asn.net (mail.asn.net [66.235.231.4]) by mx1.FreeBSD.org (Postfix) with SMTP id 1619243D2F for ; Tue, 10 Feb 2004 13:49:26 -0800 (PST) (envelope-from kris-fbsd@asn.net) Received: (qmail 98313 invoked by uid 80); 10 Feb 2004 21:49:25 -0000 Received: from 68.3.131.72 (SquirrelMail authenticated user kgale) by mail.asn.net with HTTP; Tue, 10 Feb 2004 14:49:25 -0700 (MST) Message-ID: <53224.68.3.131.72.1076449765.squirrel@mail.asn.net> In-Reply-To: <20040210193240.GA47392@crodrigues.org> References: <1076398781.b793f9a0dkt@digitalme.com> <51993.68.3.131.72.1076432061.squirrel@mail.asn.net> <20040210193240.GA47392@crodrigues.org> Date: Tue, 10 Feb 2004 14:49:25 -0700 (MST) From: "Kris Gale" To: "Craig Rodrigues" 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 cc: freebsd-threads@freebsd.org Subject: Re: Question about threads [beaver challenge] 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, 10 Feb 2004 21:49:26 -0000 > On Tue, Feb 10, 2004 at 09:54:21AM -0700, Kris Gale wrote: >> > 1a) Is it stable to use KSE with mySQL? >> >> Not in my experience. >> http://lists.freebsd.org/pipermail/freebsd-threads/2004-February/001568.html > > How did you compile and configure MySQL with KSE? > > Did you build it from ports? If so, what version? > What configuration did you use? MySQL 4.0.17 from ports. KSE entries in libmap.conf. I tried it with and without BUILD_OPTIMIZED. I did not BUILD_STATIC, as I normally do. The DB_DIR was reconfigured. > How big were the tables that you used? The database powers a complicated web application. There are about 150 tables. Some have a few rows, some have hundreds of thousands of rows. > How many queries did you hit the database with? ---[ From previous thread]--- 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. ------ I wasn't able to see the total number of queries because the database became unresponsive, but a quick estimate using the query rates and uptimes above would be several million. 300 qps * 60 seconds * 60 minutes * 3 hours = 3.24 million 600 qps * 60 seconds * 30 minutes = 1.08 million Kris