On 11/5/2018 1:31 PM, Chris Nighswonger wrote:
Is there any wisdom available on optimization of dumporder?
This is personal experience only, but I find that in general, if all
your dumps run at about the same speed and you don't have to worry about
bandwidth, using something like the following generally gets reasonably
good behavior:
'ssSS'
In essence, it ensures that the smallest dumps complete fast, while
still making sure the big ones get started early.
Where I work, we've got a couple of slow systems, and I find that this
works a bit better under those circumstances:
'ssST'
Similar to the above, except it makes sure that the long backups get
started early too (I would use 'ssTT', except that we only run one DLE
at a time for any given host).
