Skip site navigation (1)Skip section navigation (2)
Date:      Wed, 3 Jun 2009 11:36:09 +0200
From:      Mel Flynn <mel.flynn+fbsd.questions@mailing.thruhere.net>
To:        freebsd-questions@freebsd.org
Cc:        Steve Bertrand <steve@ibctech.ca>
Subject:   Re: Set task priority
Message-ID:  <200906031136.10054.mel.flynn%2Bfbsd.questions@mailing.thruhere.net>
In-Reply-To: <4A25B029.1030608@ibctech.ca>
References:  <4A25B029.1030608@ibctech.ca>

next in thread | previous in thread | raw e-mail | index | archive | help
On Wednesday 03 June 2009 01:05:13 Steve Bertrand wrote:

> What is the best way to set priority on my task in order to ensure it
> completes as quickly as possible, but does not cause a situation where
> other programs and their children can't respond?

You may want to consider the fact that priority has nothing to do with the 
outage symptom.
If your other services use MySQL, they will time out because mysqldump will 
exclusively lock the tables your services are trying to query and/or update.
The best way to do this if you need the feature more then once is to setup a 
slave replicator that isn't queried by the services at all and then you do 
your dumps on that machine. Replication will catch up after the dump. If you 
have enough hard disk space, can even do this on your laptop.
-- 
Mel



Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?200906031136.10054.mel.flynn%2Bfbsd.questions>