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. Thanks! -----Original Message----- From: Don O'Neil [mailto:[EMAIL PROTECTED] Sent: Friday, April 13, 2007 2:41 PM To: 'Chuck Swiger' Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: Mysql Hogging all system resources Is there a way to set a 'nice' priority for a particular user? Also, when I run this: nice -n 5 /usr/bin/spamd -d -c -m 5 I get: nice: Badly formed number. I ran a man page on it, and this is the right format, but its not working. -----Original Message----- From: Chuck Swiger [mailto:[EMAIL PROTECTED] Sent: Friday, April 13, 2007 11:38 AM To: Don O'Neil Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: Mysql Hogging all system resources On Apr 12, 2007, at 1:17 PM, Don O'Neil wrote: [ ... ] > Is there a way to prioritize or set the amount of resources that MySQL > is allowed to have? Do I need to set it up as a jailed process maybe? > I've > never done that before, so I'm not sure if it's the right approach or > not. Um, didn't you ask this question yesterday? Use nice/renice to change the process priority of the MySQL server so that you don't starve other processes of CPU.... -- -Chuck -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] _______________________________________________ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]"