From owner-freebsd-questions@FreeBSD.ORG  Fri Apr 13 18:38:16 2007
Return-Path: <owner-freebsd-questions@FreeBSD.ORG>
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 5CD6616A401
	for <freebsd-questions@freebsd.org>;
	Fri, 13 Apr 2007 18:38:16 +0000 (UTC) (envelope-from cswiger@mac.com)
Received: from mail-out3.apple.com (mail-out3.apple.com [17.254.13.22])
	by mx1.freebsd.org (Postfix) with ESMTP id 4467413C45E
	for <freebsd-questions@freebsd.org>;
	Fri, 13 Apr 2007 18:38:16 +0000 (UTC) (envelope-from cswiger@mac.com)
Received: from relay5.apple.com (a17-128-113-35.apple.com [17.128.113.35])
	by mail-out3.apple.com (8.13.8/8.13.8) with ESMTP id l3DIcGHq015528;
	Fri, 13 Apr 2007 11:38:16 -0700 (PDT)
Received: from relay5.apple.com (unknown [127.0.0.1])
	by relay5.apple.com (Symantec Mail Security) with ESMTP id 19D3229C003; 
	Fri, 13 Apr 2007 11:38:16 -0700 (PDT)
X-AuditID: 11807123-a03eabb000000b42-bc-461fce175b7a 
Received: from [17.214.13.96] (cswiger1.apple.com [17.214.13.96])
	(using TLSv1 with cipher AES128-SHA (128/128 bits))
	(No client certificate requested)
	by relay5.apple.com (Apple SCV relay) with ESMTP id CF62430400D;
	Fri, 13 Apr 2007 11:38:15 -0700 (PDT)
In-Reply-To: <001301c77d3f$aa57f050$0300020a@mickey>
References: <001301c77d3f$aa57f050$0300020a@mickey>
Mime-Version: 1.0 (Apple Message framework v752.2)
Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed
Message-Id: <1BB47BFC-181B-4CED-B0C0-870D8816A004@mac.com>
Content-Transfer-Encoding: 7bit
From: Chuck Swiger <cswiger@mac.com>
Date: Fri, 13 Apr 2007 11:38:14 -0700
To: "Don O'Neil" <lists@lizardhill.com>
X-Mailer: Apple Mail (2.752.2)
X-Brightmail-Tracker: AAAAAA==
Cc: mysql@lists.mysql.com, freebsd-questions@freebsd.org
Subject: Re: Mysql Hogging all system resources
X-BeenThere: freebsd-questions@freebsd.org
X-Mailman-Version: 2.1.5
Precedence: list
List-Id: User questions <freebsd-questions.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>, 
	<mailto:freebsd-questions-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-questions>
List-Post: <mailto:freebsd-questions@freebsd.org>
List-Help: <mailto:freebsd-questions-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>, 
	<mailto:freebsd-questions-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Fri, 13 Apr 2007 18:38:16 -0000

On Apr 12, 2007, at 1:17 PM, Don O'Neil wrote:
[ ... ]
> Is there a way to prioritize or set the amount of resources that  
> MySQL is
> allowed to have? Do I need to set it up as a jailed process maybe?  
> I've
> never done that before, so I'm not sure if it's the right approach  
> or not.

Um, didn't you ask this question yesterday?  Use nice/renice to  
change the process priority of the MySQL server so that you don't  
starve other processes of CPU....

-- 
-Chuck