Mysql Hogging all system resources
lists at lizardhill.com
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?
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
dnelson at allantgroup.com
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://firstname.lastname@example.org
More information about the freebsd-questions