From owner-freebsd-questions@FreeBSD.ORG Fri May 11 11:59:18 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 EE62E16A400; Fri, 11 May 2007 11:59:18 +0000 (UTC) (envelope-from gmicsko@gmail.com) Received: from mail00a.mail.t-online.hu (mail00a.mail.t-online.hu [84.2.40.5]) by mx1.freebsd.org (Postfix) with ESMTP id B30E613C45A; Fri, 11 May 2007 11:59:18 +0000 (UTC) (envelope-from gmicsko@gmail.com) Received: from [82.150.62.62] (int-62.int-air.net [82.150.62.62]) by mail00a.mail.t-online.hu (Postfix) with ESMTP id 05897ACC40; Fri, 11 May 2007 13:41:13 +0200 (CEST) From: Gabor MICSKO To: Abdullah Ibn Hamad Al-Marri In-Reply-To: <499c70c0705110107u77f96543le8e2017cda71b67a@mail.gmail.com> References: <499c70c0705110107u77f96543le8e2017cda71b67a@mail.gmail.com> Content-Type: text/plain; charset=UTF-8 Date: Fri, 11 May 2007 13:41:11 +0200 Message-Id: <1178883671.6053.10.camel@localhost.localdomain> Mime-Version: 1.0 X-Mailer: Evolution 2.10.1 Content-Transfer-Encoding: 8bit Cc: freebsd-current@freebsd.org, 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 11:59:19 -0000 On Fri, 2007-05-11 at 11:07 +0300, Abdullah Ibn Hamad Al-Marri wrote: > Hello, Hi! I had the same problem, but i found this blog entry from Jeremy Zawodny: http://jeremy.zawodny.com/blog/archives/000173.html After i adjusted the wait_timeout and thread_cache_size, the problem is gone. CPU utilization dropped significantly. HTH > 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 -- Micskó Gábor HP APS, AIS, ASE Szintézis Zrt. H-9023 Győr, Tihanyi Á. u. 2. Tel: +36 96 502 216 Fax: +36 96 318 658 E-mail: gmicsko@szintezis.hu