From owner-freebsd-questions@FreeBSD.ORG  Thu Apr 12 20:18:21 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 95CE516A402
	for <freebsd-questions@freebsd.org>;
	Thu, 12 Apr 2007 20:18:21 +0000 (UTC)
	(envelope-from lists@lizardhill.com)
Received: from kermit.lizardhill.com (kermit.lizardhill.com [64.69.41.217])
	by mx1.freebsd.org (Postfix) with ESMTP id 836A813C459
	for <freebsd-questions@freebsd.org>;
	Thu, 12 Apr 2007 20:18:21 +0000 (UTC)
	(envelope-from lists@lizardhill.com)
Received: from ip72-193-85-114.lv.lv.cox.net ([72.193.85.114] helo=mickey)
	by kermit.lizardhill.com with esmtpa (Exim 4.66)
	(envelope-from <lists@lizardhill.com>)
	id 1Hc5k9-0003Ys-Se; Thu, 12 Apr 2007 13:18:18 -0700
From: "Don O'Neil" <lists@lizardhill.com>
To: <freebsd-questions@freebsd.org>,
	<mysql@lists.mysql.com>
Date: Thu, 12 Apr 2007 13:17:59 -0700
Message-ID: <001301c77d3f$aa57f050$0300020a@mickey>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: 7bit
X-Mailer: Microsoft Office Outlook 11
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3028
Thread-Index: Acd9P6n7y34k+6LQRqmPcmQEvswAsQ==
Cc: 
Subject: 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:18:21 -0000

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.

I'm running FreeBSD 6.1.