Improve database backup performance

Problem/Motivation

On a server I manage running a backup causes a major resource spike and it ultimately times out on the node_revisions__body table. This is rather dissatisfactory.

Proposed resolution

Look at ways to improve backup performance.

Remaining tasks

Work out how to improve backup performance.

User interface changes

TBD

API changes

TBD

Data model changes

TBD