From owner-freebsd-questions@FreeBSD.ORG Sat Apr 14 08:35:13 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 2D6F016A400 for ; Sat, 14 Apr 2007 08:35:13 +0000 (UTC) (envelope-from dan@dan.emsphone.com) Received: from dan.emsphone.com (dan.emsphone.com [199.67.51.101]) by mx1.freebsd.org (Postfix) with ESMTP id EA30113C45A for ; Sat, 14 Apr 2007 08:35:02 +0000 (UTC) (envelope-from dan@dan.emsphone.com) Received: from dan.emsphone.com (smmsp@localhost [127.0.0.1]) by dan.emsphone.com (8.14.0/8.13.8) with ESMTP id l3E8YtUt086849 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO) for ; Sat, 14 Apr 2007 03:34:56 -0500 (CDT) (envelope-from dan@dan.emsphone.com) Received: (from dan@localhost) by dan.emsphone.com (8.14.1/8.14.0/Submit) id l3DLvQhb043627; Fri, 13 Apr 2007 16:57:26 -0500 (CDT) (envelope-from dan) Date: Fri, 13 Apr 2007 16:57:26 -0500 From: Dan Nelson To: "Don O'Neil" Message-ID: <20070413215726.GD11092@dan.emsphone.com> References: <001301c77d3f$aa57f050$0300020a@mickey> <1BB47BFC-181B-4CED-B0C0-870D8816A004@mac.com> <025201c77e14$5cd35d30$0300020a@mickey> <026f01c77e14$fcf77530$0300020a@mickey> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <026f01c77e14$fcf77530$0300020a@mickey> X-OS: FreeBSD 6.2-STABLE User-Agent: Mutt/1.5.15 (2007-04-06) 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: Sat, 14 Apr 2007 08:35:13 -0000 In the last episode (Apr 13), Don O'Neil said: > 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. If you create a login class in /etc/login.conf and set the priority capability, then assign a user to that class in /etc/master.passwd (the class field is the 5th one, it's usually empty), then their priority (aka niceness) should get set then they log in. Remember to use the 'vipw' command to edit the passwd file, and to run 'cap_mkdb /etc/login.conf' to rebuild login.conf.db. -- Dan Nelson dnelson@allantgroup.com