Mysql Hogging all system resources

[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? 

-----Original Message-----
From: Dan Nelson [mailto:dnelson at allantgroup.com] 
Sent: Friday, April 13, 2007 2:57 PM
To: Don O'Neil
Cc: freebsd-questions at freebsd.org; mysql at 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 at 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