Mysql Hogging all system resources
lists at lizardhill.com
Fri Apr 13 21:40:43 UTC 2007
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
nice: Badly formed number.
I ran a man page on it, and this is the right format, but its not working.
From: Chuck Swiger [mailto:cswiger at mac.com]
Sent: Friday, April 13, 2007 11:38 AM
To: Don O'Neil
Cc: freebsd-questions at freebsd.org; mysql at lists.mysql.com
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?
> never done that before, so I'm not sure if it's the right approach or
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....
More information about the freebsd-questions