Mysql Hogging all system resources

Don O'Neil lists at
Sat Apr 14 03:44:46 UTC 2007

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):


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] 
Sent: Friday, April 13, 2007 2:57 PM
To: Don O'Neil
Cc: freebsd-questions at; mysql at
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

MySQL General Mailing List
For list archives:
To unsubscribe:

More information about the freebsd-questions mailing list