There can be a few seconds that would lock your database - to prevent this, you should enable to option to 'skip locking tables'.
Otherwise, there can be CPU/RAM spikes, but we use Ottomatik to back up Ottomatik's databases every hour and there are no noticeable effects.
Does the frequent backup affect the performance of the DB hourly?
Written by Brent Sanders. Updated over a week ago
Did this answer your question?