Doesn't cause any load on my VPS, but then, I've got just under 220k posts and 5k members, do it's not that big.
I run the mysqldump with single transaction option so it doesn't lock any tables, but 4am there is hardly anyone using the forum anyway.
Suppose you could set the niceness on the mysqldump to use less CPU is that would be an issue?