Date: Fri, 13 Apr 2007 20:44:35 -0700 From: "Don O'Neil" <lists@lizardhill.com> To: "'Dan Nelson'" <dnelson@allantgroup.com> Cc: mysql@lists.mysql.com, freebsd-questions@freebsd.org Subject: RE: Mysql Hogging all system resources Message-ID: <031f01c77e47$38a8c1b0$0300020a@mickey> In-Reply-To: <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> <20070413215726.GD11092@dan.emsphone.com>
next in thread | previous in thread | raw e-mail | index | archive | help
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
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?031f01c77e47$38a8c1b0$0300020a>