Perhaps a better solution is to determine why mysql is 'hogging'
resources in the first place.
There is a tuning section in MySQL manual.
From: Chuck Swiger [mailto:cswiger@stripped]
Sent: Friday, April 13, 2007 5:46 PM
To: Don O'Neil
Cc: freebsd-questions@stripped; mysql@stripped
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
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
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql