Archive for December, 2012

Rsync out of memory

Posted: 18/12/2012 in Shell tips

Do you have any problems when you use rsync to create incremental backups of your files?
Rsync uses a considerable amount of memory because of the recursive algorithm. The recursive algorithm that is used is an incremental scan that begins the file transfer after the scanning of the first few directories have been completed. If you use a VERY low memory vps for your backups you might have problems.
Incremental recursion can be disabled using the

--no-inc-recursive

option or its shorter

--no-i-r

You also have to read these:
https://rsync.samba.org/FAQ.html#4
https://rsync.samba.org/FAQ.html#5

An easy and very useful command to automatically check, repair and optimize all tables in all mysql databases

mysqlcheck -u root -p --auto-repair --check --optimize --all-databases