Alexandre Benson Smith wrote:

>> It looks like you're using SuperServer. Switch to Classic and things
>> should improve a lot. If you still want more control, with Classic each
>> connection is a separate process, so you can use the system 'renice'
>> command to change the priority.
>
> IIRC Ann said that renice the process is not a good thing, some locks
> will be low priority and the other process that waits for those locks
> will wait more than necessary, I can't remember exactly, but I have
> something on that line on my mind.

It makes sense. A 'reniced' long-running process would have lower
priority and when it acquires the lock it would take a long time for it
to release it (as it is low priority, it wouldn't get much chance). I
don't know if it actually works that way in practice, but it is quite
possible that 'renice' would have an effect of slowing down the entire
server.

Thanks for pointing that out.

--
Milan Babuskov
http://www.flamerobin.org