From owner-freebsd-current@FreeBSD.ORG Sun Mar 21 20:53:42 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 6738716A4CE for ; Sun, 21 Mar 2004 20:53:42 -0800 (PST) Received: from mta08-svc.ntlworld.com (mta08-svc.ntlworld.com [62.253.162.48]) by mx1.FreeBSD.org (Postfix) with ESMTP id B2B6643D1D for ; Sun, 21 Mar 2004 20:53:41 -0800 (PST) (envelope-from tom.hurst@clara.net) Received: from voi.aagh.net ([81.104.55.176]) by mta08-svc.ntlworld.com (InterMail vM.4.01.03.37 201-229-121-137-20020806) with ESMTP id <20040322045342.QJOD5004.mta08-svc.ntlworld.com@voi.aagh.net> for ; Mon, 22 Mar 2004 04:53:42 +0000 Received: from freaky by voi.aagh.net with local (Exim 4.30; FreeBSD) id 1B5HRU-000BUx-1c for current@freebsd.org; Mon, 22 Mar 2004 04:53:40 +0000 Date: Mon, 22 Mar 2004 04:53:40 +0000 From: Thomas Hurst To: current@freebsd.org Message-ID: <20040322045339.GA43881@voi.aagh.net> Mail-Followup-To: current@freebsd.org Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Organization: Not much. User-Agent: Mutt/1.5.6i Sender: Thomas Hurst Subject: Loaded MySQL 4.0.18 w/ KSE running nicely 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: Mon, 22 Mar 2004 04:53:42 -0000 Just thought I'd make a little note to let people know that we're successfully running MySQL 4.0.18 on 5.2.1-RELEASE-p3 dated Mar 18 using libkse, after having raised thread limits to 500 per proc/150 per group: Uptime: 233816 Threads: 45 Questions: 33388272 Slow queries: 597 Opens: 2725 Flush tables: 1 Open tables: 429 Queries per second avg: 142.797 This is running on 2*1266MHz Pentium III's with 4GB of memory, although MySQL is "only" using about 1GB of it. Main issue we've noticed is top shows the main process as using 0.00% CPU; ps does too, but setting it to display threads works as expected. We did try -CURRENT dated around the same time, but we were plagued with MySQL lockups and such even using linuxthreads, which we've ran for over a year fine on 4-STABLE, MySQL bugs notwithstanding. We're open to suggestions for improving performance and happy to test things (within reason.. this is a production server ;) fwiw imho omfg wp gg np gtg k pls tnx lol! Ahem. -- Thomas 'Freaky' Hurst - newzBin Developer & Admin - freaky@newzbin.com