From owner-freebsd-questions@FreeBSD.ORG Fri May 11 09:36:59 2007 Return-Path: X-Original-To: freebsd-questions@freebsd.org Delivered-To: freebsd-questions@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [69.147.83.52]) by hub.freebsd.org (Postfix) with ESMTP id D13ED16A402 for ; Fri, 11 May 2007 09:36:59 +0000 (UTC) (envelope-from mb@imp.ch) Received: from pop.imp.ch (mx2.imp.ch [157.161.9.17]) by mx1.freebsd.org (Postfix) with ESMTP id 6D82913C4B8 for ; Fri, 11 May 2007 09:36:59 +0000 (UTC) (envelope-from mb@imp.ch) Received: from godot (godot.imp.ch [157.161.4.8]) by pop.imp.ch (8.13.8/8.13.8/Submit_imp) with ESMTP id l4B8wXp4053277; Fri, 11 May 2007 10:58:34 +0200 (CEST) (envelope-from mb@imp.ch) Date: Fri, 11 May 2007 10:58:33 +0200 (CEST) From: Martin Blapp X-X-Sender: mb@godot To: Abdullah Ibn Hamad Al-Marri In-Reply-To: <499c70c0705110107u77f96543le8e2017cda71b67a@mail.gmail.com> Message-ID: <20070511105652.S2786@godot> References: <499c70c0705110107u77f96543le8e2017cda71b67a@mail.gmail.com> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed Cc: FreeBSD Questions Subject: Re: MySQL slowness in SMP X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Fri, 11 May 2007 09:36:59 -0000 Hi, It depends on the threading library you use. Can you please show us the output of ldd /usr/local/libexec/mysqld ? You should use libthr instead of libpthread or libc_r in /etc/libmap.conf for mysqld. -- Martin Martin Blapp, ------------------------------------------------------------------ ImproWare AG, UNIXSP & ISP, Zurlindenstrasse 29, 4133 Pratteln, CH Phone: +41 61 826 93 00 Fax: +41 61 826 93 01 PGP: PGP Fingerprint: B434 53FC C87C FE7B 0A18 B84C 8686 EF22 D300 551E ------------------------------------------------------------------ On Fri, 11 May 2007, Abdullah Ibn Hamad Al-Marri wrote: > Hello, > > I have dual xeon server with 2 GB of ram. > > FreeBSD 6.2-STABLE #0: Tue Apr 24 11:32:50 GMT 2007 > arabian@noc:/usr/obj/usr/src/sys/NOC i386 > > Which runs heavily MySQL with MyISAM, the problem I have it maxes out > one cpu, and doesn't use the other one. > > Could someone tell me what shall I do to make MySQL runs faster? it > already uses libthr, cache beside MySQL optimized, I would like to use > the power of both cpus. > > > last pid: 79040; load averages: 1.00, 1.01, 1.00 > up 16+16:54:20 08:04:55 > 39 processes: 2 running, 37 sleeping > CPU states: 26.9% user, 0.0% nice, 23.3% system, 0.0% interrupt, 49.8% idle > Mem: 556M Active, 1154M Inact, 198M Wired, 93M Cache, 112M Buf, 3072K Free > Swap: 5120M Total, 16K Used, 5120M Free > > PID USERNAME THR PRI NICE SIZE RES STATE C TIME WCPU COMMAND > 90293 mysql 19 100 0 434M 187M ucond 1 176.6H 95.95% mysqld > > Is upgrading to FreeBSD 7.0 current and using ULE would make MySQL > runs in this dual xeon box? > > -- > Regards, > > -Abdullah Ibn Hamad Al-Marri > Arab Portal > http://www.WeArab.Net/ > _______________________________________________ > freebsd-current@freebsd.org mailing list > http://lists.freebsd.org/mailman/listinfo/freebsd-current > To unsubscribe, send any mail to "freebsd-current-unsubscribe@freebsd.org" >