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 class
.
-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: Mysql Hogging all system resources
In the last episode (Apr 13), Don O'Neil said:
Nevermind on the badly
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
:[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 that MySQL
is allowed
]
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/spamd -d -c -m 5
I get:
nice: Badly formed
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
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: 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 sending
the same query, and eventually loading up the server to the point where the
only thing I could do
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
sending the same query, and eventually loading up
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
10 matches
Mail list logo