From owner-freebsd-questions@FreeBSD.ORG Fri Apr 13 21:45:11 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 861DC16A402 for ; Fri, 13 Apr 2007 21:45:11 +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 6FEF013C46E for ; Fri, 13 Apr 2007 21:45:11 +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 1HcTZp-000MMK-Dg; Fri, 13 Apr 2007 14:45:05 -0700 From: "Don O'Neil" To: , References: <001301c77d3f$aa57f050$0300020a@mickey> <1BB47BFC-181B-4CED-B0C0-870D8816A004@mac.com> <025201c77e14$5cd35d30$0300020a@mickey> Date: Fri, 13 Apr 2007 14:45:00 -0700 Message-ID: <026f01c77e14$fcf77530$0300020a@mickey> MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Mailer: Microsoft Office Outlook 11 In-Reply-To: <025201c77e14$5cd35d30$0300020a@mickey> X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3028 Thread-Index: Acd9+uYn2DW9K+pWQRiRmaHHm8IbwgAF5lLwAACWOJA= Cc: 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: Fri, 13 Apr 2007 21:45:11 -0000 Nevermind on the "badly formatted number"... I specified the full path /usr/bin/nice and it worked ok this time :-) However, I still want to know if there is a way to specify a nice level for an entire users processes. Thanks! -----Original Message----- From: Don O'Neil [mailto:lists@lizardhill.com] Sent: Friday, April 13, 2007 2:41 PM To: 'Chuck Swiger' Cc: freebsd-questions@freebsd.org; mysql@lists.mysql.com Subject: RE: Mysql Hogging all system resources Is there a way to set a 'nice' priority for a particular user? Also, when I run this: nice -n 5 /usr/bin/spamd -d -c -m 5 I get: nice: Badly formed number. I ran a man page on it, and this is the right format, but its not working. -----Original Message----- From: Chuck Swiger [mailto:cswiger@mac.com] Sent: Friday, April 13, 2007 11:38 AM To: Don O'Neil Cc: freebsd-questions@freebsd.org; mysql@lists.mysql.com Subject: Re: Mysql Hogging all system resources 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=lists@lizardhill.com