Greg Larkin wrote:
> Steve Bertrand wrote:

>> I'll have to play around a bit. Looking closer, it does appear to be a
>> disk I/O issue, but I figured that if I tried to prioritize the job, it
>> might ease-up on all system aspects.

> I had the same situation here, and nice(1) wasn't cutting it for me.  I
> finally switched to idprio(1):
> http://www.freebsd.org/cgi/man.cgi?query=idprio&sourceid=opensearch
> 
> idprio 31 mysqldump .....
> 
> will run only when other processes are idle.  That should prevent any
> further self-incurred DOS symptoms for you.

Ok that looks promising.

I will give that a try and see how it goes.

Before I ask how mysqldump works, I'll have to do some research on
when/how/if/how long it holds the db tables unreadable/unwritable during
it's process, if it does it at all.

Steve

Attachment: smime.p7s
Description: S/MIME Cryptographic Signature

Reply via email to