From owner-freebsd-threads@FreeBSD.ORG Tue Feb 10 14:57:41 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 9A02516A4CE for ; Tue, 10 Feb 2004 14:57:41 -0800 (PST) Received: from freefall.freebsd.org (freefall.freebsd.org [216.136.204.21]) by mx1.FreeBSD.org (Postfix) with ESMTP id 9333443D1F; Tue, 10 Feb 2004 14:57:41 -0800 (PST) (envelope-from davidxu@viatech.com.cn) Received: from viatech.com.cn (davidxu@localhost [127.0.0.1]) i1AMvbbv055214; Tue, 10 Feb 2004 14:57:40 -0800 (PST) (envelope-from davidxu@viatech.com.cn) Message-ID: <4029627F.4090602@viatech.com.cn> Date: Wed, 11 Feb 2004 07:00:15 +0800 From: David Xu User-Agent: Mozilla/5.0 (X11; U; FreeBSD i386; en-US; rv:1.5) Gecko/20031206 Thunderbird/0.3 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Kris Gale References: <1076398781.b793f9a0dkt@digitalme.com> <51993.68.3.131.72.1076432061.squirrel@mail.asn.net> <20040210193240.GA47392@crodrigues.org> <53224.68.3.131.72.1076449765.squirrel@mail.asn.net> In-Reply-To: <53224.68.3.131.72.1076449765.squirrel@mail.asn.net> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit 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 22:57:41 -0000 Kris Gale wrote: >>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 > > > What's the value of your sysctl kern.threads.max_threads_per_proc and kern.threads.max_groups_per_proc ? Mysql heavily uses system scope thread. David Xu