Re: [PERFORM] cpu throttling

2007-08-03 Thread Decibel!
On Thu, Aug 02, 2007 at 09:14:37AM -0700, Alan Hodgson wrote: > On Thursday 02 August 2007 09:02, "Bryan Murphy" <[EMAIL PROTECTED]> > wrote: > > My question: Is there a way I can decrease the priority of a specific > > query, or determine the PID of the process it is running in? I'd like > > to

Re: [PERFORM] cpu throttling

2007-08-02 Thread Bryan Murphy
It's a 4 processor Intel xeon machine with more than enough ram. The entire database can fit in memory, and while the CPU is pegged, nothing is chewing up I/O bandwidth, and nothing is getting swapped out of RAM. I'm running Debian stable with only a few tweaks to the kernel's memory settings. A

Re: [PERFORM] cpu throttling

2007-08-02 Thread Alan Hodgson
On Thursday 02 August 2007 09:02, "Bryan Murphy" <[EMAIL PROTECTED]> wrote: > My question: Is there a way I can decrease the priority of a specific > query, or determine the PID of the process it is running in? I'd like > to throw together a quick shell script if at all possible, as right > now