Date: Sat, 14 Apr 2007 08:01:41 -0400 From: Bill Moran <wmoran@potentialtech.com> To: "Don O'Neil" <lists@lizardhill.com> Cc: mysql@lists.mysql.com, 'Dan Nelson' <dnelson@allantgroup.com>, freebsd-questions@freebsd.org Subject: Re: Mysql Hogging all system resources 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>
next in thread | previous in thread | raw e-mail | index | archive | help
In response to "Don O'Neil" <lists@lizardhill.com>: > 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
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20070414080141.8893405a.wmoran>