From owner-freebsd-performance@FreeBSD.ORG Mon May 28 08:50:33 2007 Return-Path: X-Original-To: freebsd-performance@freebsd.org Delivered-To: freebsd-performance@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [69.147.83.52]) by hub.freebsd.org (Postfix) with ESMTP id 6E1A416A519 for ; Mon, 28 May 2007 08:50:33 +0000 (UTC) (envelope-from almarrie@gmail.com) Received: from an-out-0708.google.com (an-out-0708.google.com [209.85.132.250]) by mx1.freebsd.org (Postfix) with ESMTP id 2D98F13C4B0 for ; Mon, 28 May 2007 08:50:33 +0000 (UTC) (envelope-from almarrie@gmail.com) Received: by an-out-0708.google.com with SMTP id c14so451304anc for ; Mon, 28 May 2007 01:50:32 -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:mime-version:content-type:content-transfer-encoding:content-disposition; b=dcY7qocGXv7Wb7qDPpFIBgxEkuJhhL3/cLLu8kEQiJHfSztgYWoila+v2yHDEQ5T/cC2kRVXgFKtJGV1lgXfzDVPy5Sz5E1DNEh8vOgXv3USSDtrf2rWmUOloay+RDHrGRNQDKkprDAkkiCRXQKWIKt25zSZIdrbicJIiY33Y4c= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition; b=jWjJGJvRH5B00Ky+YDkWy/kFcEsvxJ7zsawH+I9ECSvxRqa2umfoxqnR7EnCKczoAEVDxVwsa5VN1rJVi97HiUWDG5kqhfajClvH0qQoBUJKHYgZX3cg2Ow/9vOiY+zEq+Y5mQfUa1yn9nALsp7fAvono7X2Mm/ZL96I8vIrnCo= Received: by 10.100.202.13 with SMTP id z13mr4403945anf.1180340760687; Mon, 28 May 2007 01:26:00 -0700 (PDT) Received: by 10.100.9.14 with HTTP; Mon, 28 May 2007 01:26:00 -0700 (PDT) Message-ID: <499c70c0705280126o252d505q99ca5476bf4b6d62@mail.gmail.com> Date: Mon, 28 May 2007 11:26:00 +0300 From: "Abdullah Ibn Hamad Al-Marri" To: freebsd-performance@freebsd.org MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline Subject: Tweaks tips for MySQL in FreeBSD 7.0-CURRENT SMP X-BeenThere: freebsd-performance@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Performance/tuning List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Mon, 28 May 2007 08:50:33 -0000 Hello Guys, I was able to use this command in 6.x Now when I tried it it doesn't work in 7.0 sysctl kern.threads.max_groups_per_proc=40000 What do you recommend for tweaking MySQL server 5.0.41 with MyISAM db in Dual Xeon 2.8 GHz server with 2 GB of ram and 10k rpm wcd raptor HD? -- -- Regards, -Abdullah Ibn Hamad Al-Marri Arab Portal http://www.WeArab.Net/