I ussually use bzip2, but compressing some db backups seemed to be taking to long (and stomping the box), so I did a quick test:
Started with a 512MB chunk of a MySQL table file
zip: 1:52, 288MB, system load around 80-90%
gzip: 1:40, 288MB, system load around 80-90%
bzip2: 5:01, 234MB, system load around 95-98%
Ouch.
Just switched the script over to gzip ... we'll see how it does.
FWIW, test machine is a 3.2GHz P4, 1GB RAM, 7200RPM IDE, Red Hat Enterprise 3.0
Started with a 512MB chunk of a MySQL table file
zip: 1:52, 288MB, system load around 80-90%
gzip: 1:40, 288MB, system load around 80-90%
bzip2: 5:01, 234MB, system load around 95-98%
Ouch.
Just switched the script over to gzip ... we'll see how it does.
FWIW, test machine is a 3.2GHz P4, 1GB RAM, 7200RPM IDE, Red Hat Enterprise 3.0