From owner-freebsd-questions@FreeBSD.ORG Fri Apr 13 21:40:43 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 7D42A16A404 for ; Fri, 13 Apr 2007 21:40:43 +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 6596213C448 for ; Fri, 13 Apr 2007 21:40:43 +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 1HcTVU-000LrU-PP; Fri, 13 Apr 2007 14:40:36 -0700 From: "Don O'Neil" To: "'Chuck Swiger'" References: <001301c77d3f$aa57f050$0300020a@mickey> <1BB47BFC-181B-4CED-B0C0-870D8816A004@mac.com> Date: Fri, 13 Apr 2007 14:40:31 -0700 Message-ID: <025201c77e14$5cd35d30$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: <1BB47BFC-181B-4CED-B0C0-870D8816A004@mac.com> X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3028 Thread-Index: Acd9+uYn2DW9K+pWQRiRmaHHm8IbwgAF5lLw 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 List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Fri, 13 Apr 2007 21:40:43 -0000 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