From owner-freebsd-questions@FreeBSD.ORG Fri May 11 08:07:48 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 C8C4F16A405 for ; Fri, 11 May 2007 08:07:48 +0000 (UTC) (envelope-from almarrie@gmail.com) Received: from an-out-0708.google.com (an-out-0708.google.com [209.85.132.240]) by mx1.freebsd.org (Postfix) with ESMTP id 8B8F713C45E for ; Fri, 11 May 2007 08:07:48 +0000 (UTC) (envelope-from almarrie@gmail.com) Received: by an-out-0708.google.com with SMTP id d23so207887and for ; Fri, 11 May 2007 01:07:48 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:mime-version:content-type:content-transfer-encoding:content-disposition; b=d5N/e/tVsvBcsLOK1G589pwwXISw7etfq1KXFF0iWPXd/ZuJoL5B+rDB5FwQZFspYXsPq7FivgCDGqOpwfC772ak6GaM2l5JdtsODdXBYWhaKX9vJWvi7OKvkjUng4TiikXarSCaixsHbx4V44QuQ7vigUbGBcgTVb9o+jQfkiY= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:cc:mime-version:content-type:content-transfer-encoding:content-disposition; b=Mo2A3fqNDmVa8OKwWc9fPD7TVswzifJCBbPQ2NOD4bKm2UpZMH5elRo9n7vvJuzkLB9YQXRgTTA2UjIENQY/dn+eKRgdW6VZ5xD79aeCbyd2PZthvpW/9M2sgu0EZxXVYMK2aYJThtotbfu2z6PbChAGEi2WUsj8ThxN9ztlciI= Received: by 10.100.136.8 with SMTP id j8mr2026469and.1178870867469; Fri, 11 May 2007 01:07:47 -0700 (PDT) Received: by 10.100.9.14 with HTTP; Fri, 11 May 2007 01:07:47 -0700 (PDT) Message-ID: <499c70c0705110107u77f96543le8e2017cda71b67a@mail.gmail.com> Date: Fri, 11 May 2007 11:07:47 +0300 From: "Abdullah Ibn Hamad Al-Marri" To: "FreeBSD Questions" MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline Cc: freebsd-current@freebsd.org Subject: 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 08:07:48 -0000 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/