From owner-freebsd-threads@FreeBSD.ORG Tue Jun 15 15:10:37 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 3681E16A4CF; Tue, 15 Jun 2004 15:10:37 +0000 (GMT) Received: from mx1.imp.ch (mx1.imp.ch [157.161.9.16]) by mx1.FreeBSD.org (Postfix) with ESMTP id 3BE3843D64; Tue, 15 Jun 2004 15:10:35 +0000 (GMT) (envelope-from mb@imp.ch) Received: from mx2.imp.ch (mx2 [157.161.9.17]) by mx1.imp.ch (8.12.11/8.12.11) with ESMTP id i5FF9xDR011613; Tue, 15 Jun 2004 17:10:00 +0200 (CEST) (envelope-from mb@imp.ch) Received: from mx2.imp.ch (localhost [127.0.0.1]) by mx2.imp.ch (8.12.11/8.12.11/Submit) with ESMTP id i5FF9vpL053815; Tue, 15 Jun 2004 17:09:57 +0200 (CEST) (envelope-from mb@imp.ch) Received: (from clamav@localhost) by mx2.imp.ch (8.12.11/8.12.11/Submit) id i5FF9uvO053805; Tue, 15 Jun 2004 17:09:56 +0200 (CEST) (envelope-from mb@imp.ch) Received: from cvs.imp.ch (cvs.imp.ch [157.161.4.9]) by ns1.imp.ch (MIMEDefang) with ESMTP id i5FF9pCH031041; Tue, 15 Jun 2004 17:09:56 +0200 (CEST) Date: Tue, 15 Jun 2004 17:09:51 +0200 (CEST) From: Martin Blapp To: mike In-Reply-To: Message-ID: <20040615170316.T84297@cvs.imp.ch> References: <01c301c45239$940781f0$6401a8c0@animal> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Spam-Checksum: 3e629ff7caceec649e71d44aaed56da4 X-Virus-Status: No X-Spam-Status: No, hits=-4.899 required=4 tests=BAYES_00, UPPERCASE_25_50 X-Scanned-By: MIMEDefang 2.42 cc: freebsd-current@freebsd.org cc: freebsd-threads@freebsd.org Subject: Re: Possible Threading problem with -CURRENT / MySQL? 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, 15 Jun 2004 15:10:37 -0000 Hi all, Just to list our working setup: (I don't know if mysql is very fast, but since I rewrote all mysql queries to use LEFT/RIGHT JOIN and UNION and redesigned the databases, the mysql load is not significant anymore) Has someone a test database and e benchmark tool ? - We use SCHED_4BSD. - HTT is disabled in the BIOS - WITNESS and INVARIANTS are turned off (important) ! uptime 5:07PM up 35 days, 3:52, 9 users, load averages: 2.27, 1.70, 1.54 No hangs and crashes or lockups. 38073 idms 20 -15 55160K 17200K kserel 0 26:45 0.00% 0.00% mysqld my.cnf config: [mysqld] skip-innodb set-variable = max_connections=1000 set-variable = key_buffer_size=16M set-variable = table_cache=256 set-variable = record_buffer=1M set-variable = sort_buffer=16M CPU: Intel(R) Xeon(TM) CPU 3.06GHz (3059.98-MHz 686-class CPU) Origin = "GenuineIntel" Id = 0xf27 Stepping = 7 Features=0xbfebfbff real memory = 2147397632 (2047 MB) avail memory = 2095964160 (1998 MB) ACPI APIC Table: FreeBSD/SMP: Multiprocessor System Detected: 2 CPUs cpu0 (BSP): APIC ID: 0 cpu1 (AP): APIC ID: 6 Hope this helps anybody: Martin