From owner-freebsd-questions@FreeBSD.ORG  Thu Apr 12 20:31:57 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 3079316A407
	for <freebsd-questions@freebsd.org>;
	Thu, 12 Apr 2007 20:31:57 +0000 (UTC)
	(envelope-from wmoran@potentialtech.com)
Received: from mail.potentialtech.com (internet.potentialtech.com
	[66.167.251.6])
	by mx1.freebsd.org (Postfix) with ESMTP id 03DBB13C44B
	for <freebsd-questions@freebsd.org>;
	Thu, 12 Apr 2007 20:31:56 +0000 (UTC)
	(envelope-from wmoran@potentialtech.com)
Received: from vanquish.pgh.priv.collaborativefusion.com
	(pr40.pitbpa0.pub.collaborativefusion.com [206.210.89.202])
	(using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits))
	(No client certificate requested)
	by mail.potentialtech.com (Postfix) with ESMTP id 11ED6EBC7B;
	Thu, 12 Apr 2007 16:31:56 -0400 (EDT)
Date: Thu, 12 Apr 2007 16:31:55 -0400
From: Bill Moran <wmoran@potentialtech.com>
To: "Don O'Neil" <lists@lizardhill.com>
Message-Id: <20070412163155.61ec8b40.wmoran@potentialtech.com>
In-Reply-To: <001301c77d3f$aa57f050$0300020a@mickey>
References: <001301c77d3f$aa57f050$0300020a@mickey>
X-Mailer: Sylpheed 2.3.1 (GTK+ 2.10.11; i386-portbld-freebsd6.1)
Mime-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit
Cc: 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: Thu, 12 Apr 2007 20:31:57 -0000

In response to "Don O'Neil" <lists@lizardhill.com>:

> I have a customer that loaded up a HUGE table and was doing all sorts of
> fancy stuff in it, and not waiting for the process to finish before sending
> the same query, and eventually loading up the server to the point where the
> only thing I could do was unplug it.
> 
> 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.

man login.conf should tell you all you need to know.

-- 
Bill Moran
http://www.potentialtech.com