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
smime.p7s
Description: S/MIME Cryptographic Signature