Networker

Re: [Networker] Mysql

2009-03-14 00:00:33
Subject: Re: [Networker] Mysql
From: David Magda <dmagda AT EE.RYERSON DOT CA>
To: NETWORKER AT LISTSERV.TEMPLE DOT EDU
Date: Fri, 13 Mar 2009 23:48:37 -0400
On Mar 13, 2009, at 18:26, Yaron Zabary wrote:

mysqldump --add-drop-table --all-databases -uroot -ppass | gzip -9 > /var/mysqlbackup/backup.$D.gz

Depending on how many spares CPUs / cores you have, you may want to look at a version of gzip that's made more parallel:

        http://www.zlib.net/pigz/

7zip is also designed for more parallel machines, as are other utilities:

http://www.codinghorror.com/blog/archives/001231.html

http://blogs.sun.com/timc/entry/tamp_a_lightweight_multi_threaded
http://blogs.reucon.com/srt/2008/02/18/compression_gzip_vs_bzip2_vs_7_zip.html

To sign off this list, send email to listserv AT listserv.temple DOT edu and type 
"signoff networker" in the body of the email. Please write to networker-request 
AT listserv.temple DOT edu if you have any problems with this list. You can access the 
archives at http://listserv.temple.edu/archives/networker.html or
via RSS at http://listserv.temple.edu/cgi-bin/wa?RSS&L=NETWORKER

<Prev in Thread] Current Thread [Next in Thread>