From owner-freebsd-questions@FreeBSD.ORG Sat Apr 14 12:01:44 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 0D48416A401 for ; Sat, 14 Apr 2007 12:01:44 +0000 (UTC) (envelope-from wmoran@potentialtech.com) Received: from mail.potentialtech.com (internet.potentialtech.com [66.167.251.6]) by mx1.freebsd.org (Postfix) with ESMTP id D26D213C448 for ; Sat, 14 Apr 2007 12:01:43 +0000 (UTC) (envelope-from wmoran@potentialtech.com) Received: from vanquish.pgh.priv.collaborativefusion.com (pr40.pitbpa0.pub.collaborativefusion.com [206.210.89.202]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by mail.potentialtech.com (Postfix) with ESMTP id C0696EBC78; Sat, 14 Apr 2007 08:01:42 -0400 (EDT) Date: Sat, 14 Apr 2007 08:01:41 -0400 From: Bill Moran To: "Don O'Neil" Message-Id: <20070414080141.8893405a.wmoran@potentialtech.com> In-Reply-To: <031f01c77e47$38a8c1b0$0300020a@mickey> 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> <031f01c77e47$38a8c1b0$0300020a@mickey> X-Mailer: Sylpheed 2.3.1 (GTK+ 2.10.11; i386-portbld-freebsd6.1) Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit Cc: mysql@lists.mysql.com, 'Dan Nelson' , 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 12:01:44 -0000 In response to "Don O'Neil" : > 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? Did you log the user out/restart all his processes? I expect the priority is applied at login time and isn't going to be re-evaluated on a continual basis. > > -----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 > > > _______________________________________________ > 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" -- Bill Moran http://www.potentialtech.com