Re: Mysql Hogging all system resources

2007-04-14 Thread Bill Moran
sses? I expect the priority is applied at login time and isn't going to be re-evaluated on a continual basis. > > -Original Message- > From: Dan Nelson [mailto:[EMAIL PROTECTED] > Sent: Friday, April 13, 2007 2:57 PM > To: Don O'Neil > Cc: [EMAIL PROTECTED

Re: Mysql Hogging all system resources

2007-04-14 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 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 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

Re: Mysql Hogging all system resources

2007-04-12 Thread Chuck Swiger
On Apr 12, 2007, at 4:18 PM, Don O'Neil wrote: This isn't exactly what I want to do. According to the FreeBSD Handbook, by defining a CPU limit it will just kill any process that uses more than the limit. What I want to do is effectively throttle the process so it doesn't use up more than a

RE: Mysql Hogging all system resources

2007-04-12 Thread Don O'Neil
on O'Neil Cc: [EMAIL PROTECTED] Subject: Re: Mysql Hogging all system resources In response to "Don O'Neil" <[EMAIL PROTECTED]>: > I have a customer that loaded up a HUGE table and was doing all sorts > of fancy stuff in it, and not waiting for the process to finish before

Re: Mysql Hogging all system resources

2007-04-12 Thread Bill Moran
In response to "Don O'Neil" <[EMAIL PROTECTED]>: > I have a customer that loaded up a HUGE table and was doing all sorts of > fancy stuff in it, and not waiting for the process to finish before sending > the same query, and eventually loading up the server to the point where the > only thing I cou