From owner-freebsd-questions@FreeBSD.ORG Sat Apr 14 03:44:46 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 A0B0516A402 for ; Sat, 14 Apr 2007 03:44:46 +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 8D88013C45D for ; Sat, 14 Apr 2007 03:44:46 +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 1HcZBl-0005jI-J6; Fri, 13 Apr 2007 20:44:37 -0700 From: "Don O'Neil" To: "'Dan Nelson'" References: <001301c77d3f$aa57f050$0300020a@mickey> <1BB47BFC-181B-4CED-B0C0-870D8816A004@mac.com> <025201c77e14$5cd35d30$0300020a@mickey> <026f01c77e14$fcf77530$0300020a@mickey> <20070413215726.GD11092@dan.emsphone.com> Date: Fri, 13 Apr 2007 20:44:35 -0700 Message-ID: <031f01c77e47$38a8c1b0$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: <20070413215726.GD11092@dan.emsphone.com> X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3028 Thread-Index: Acd+Fta2FeV+sEHsTma4utuqx5FzuQAMBayw 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 03:44:46 -0000 I did this: In my login.conf file (assuming that all you have to do is change whatever you don't want to be the default): nice:\ :priority=5: In the user entry I put 'nice' in field 5. When I rebuilt the login.conf db, nothing seems to have changed for th user... A 'top' still shows his processes (old and new) with a nice of 0. Is there something else I'm missing? -----Original Message----- From: Dan Nelson [mailto:dnelson@allantgroup.com] Sent: Friday, April 13, 2007 2:57 PM To: Don O'Neil Cc: freebsd-questions@freebsd.org; mysql@lists.mysql.com Subject: Re: Mysql Hogging all system resources 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=lists@lizardhill.com