From owner-freebsd-questions@FreeBSD.ORG Thu Apr 12 23:19:02 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 D9E7216A402 for ; Thu, 12 Apr 2007 23:19:01 +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 C670F13C459 for ; Thu, 12 Apr 2007 23:19:01 +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 ) id 1Hc8ZB-0004qe-45; Thu, 12 Apr 2007 16:19:01 -0700 From: "Don O'Neil" To: "'Bill Moran'" References: <001301c77d3f$aa57f050$0300020a@mickey> <20070412163155.61ec8b40.wmoran@potentialtech.com> Date: Thu, 12 Apr 2007 16:18:50 -0700 Message-ID: <005801c77d58$ee387560$0300020a@mickey> MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Mailer: Microsoft Office Outlook 11 thread-index: Acd9QbstewJnwIe3Rr2/CzhqPrfI8AAFufIQ X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3028 In-Reply-To: <20070412163155.61ec8b40.wmoran@potentialtech.com> 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 List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Thu, 12 Apr 2007 23:19:02 -0000 This isn't exactly what I want to do. According to the FreeBSD Handbook, by defining a CPU limit it will just kill any process that uses more than the limit. What I want to do is effectively throttle the process so it doesn't use up more than a certain % CPU, but still lives, esentially taking longer to process than if it had unlimited resources. That way the process still runs and the system isn't taken to it's knees. -----Original Message----- From: owner-freebsd-questions@freebsd.org [mailto:owner-freebsd-questions@freebsd.org] On Behalf Of Bill Moran Sent: Thursday, April 12, 2007 1:32 PM To: Don O'Neil Cc: freebsd-questions@freebsd.org Subject: Re: Mysql Hogging all system resources In response to "Don O'Neil" : > 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 _______________________________________________ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "freebsd-questions-unsubscribe@freebsd.org"