RE: Mysql Hogging all system resources

2007-04-13 Thread Don O'Neil
x27;top' still shows his processes (old and new) with a nice of 0. Is there something else I'm missing? -Original Message- From: Dan Nelson [mailto:[EMAIL PROTECTED] Sent: Friday, April 13, 2007 2:57 PM To: Don O'Neil Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: Mys

Re: Mysql Hogging all system resources

2007-04-13 Thread Dan Nelson
In the last episode (Apr 13), Don O'Neil said: > 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. If you create a login

RE: Mysql Hogging all system resources

2007-04-13 Thread Andrey Dmitriev
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 adjus

Re: Mysql Hogging all system resources

2007-04-13 Thread Chuck Swiger
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

RE: Mysql Hogging all system resources

2007-04-13 Thread 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/sp

RE: Mysql Hogging all system resources

2007-04-13 Thread Don O'Neil
er [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 t

Re: Mysql Hogging all system resources

2007-04-13 Thread Chuck Swiger
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