List:General Discussion« Previous MessageNext Message »
From:Don O'Neil Date:April 13 2007 9:45pm
Subject:RE: Mysql Hogging all system resources
View as plain text  
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:lists@stripped] 
Sent: Friday, April 13, 2007 2:41 PM
To: 'Chuck Swiger'
Cc: freebsd-questions@stripped; mysql@stripped
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:cswiger@stripped]
Sent: Friday, April 13, 2007 11:38 AM
To: Don O'Neil
Cc: freebsd-questions@stripped; mysql@stripped
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/mysql?unsub=1


Thread
Mysql Hogging all system resourcesDon O'Neil12 Apr
  • Re: Mysql Hogging all system resourcesChuck Swiger13 Apr
    • RE: Mysql Hogging all system resourcesDon O'Neil13 Apr
      • RE: Mysql Hogging all system resourcesDon O'Neil13 Apr
        • Re: Mysql Hogging all system resourcesDan Nelson13 Apr
          • RE: Mysql Hogging all system resourcesDon O'Neil14 Apr
      • Re: Mysql Hogging all system resourcesChuck Swiger13 Apr
        • RE: Mysql Hogging all system resourcesAndrey Dmitriev13 Apr