Perhaps a better solution is to determine why mysql is 'hogging' resources in the first place.
There is a tuning section in MySQL manual. -a -----Original Message----- From: Chuck Swiger [mailto:[EMAIL PROTECTED] Sent: Friday, April 13, 2007 5:46 PM To: Don O'Neil Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: Mysql Hogging all system resources On Apr 13, 2007, at 2:40 PM, Don O'Neil wrote: > Is there a way to set a 'nice' priority for a particular user? Why, yes-- see /etc/login.conf and the priority keyword. Some shells also let you adjust the priority levels for various users. > 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. Many shells offer nice as a built-in keyword, with syntax that may vary slightly from what /usr/bin/nice uses. Either try "/usr/bin/ nice -n 5 _command_", or use "nice 5 _command_" under csh/tcsh. sh/ ksh/zsh ought to understand the -n flag and be more similar to the external command under /usr/bin. -- -Chuck -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]