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.