{"id":320,"date":"2011-11-16T22:08:33","date_gmt":"2011-11-16T22:08:33","guid":{"rendered":"http:\/\/blog.trungson.com\/?p=320"},"modified":"2011-11-16T22:08:33","modified_gmt":"2011-11-16T22:08:33","slug":"benchmark-xtrabackup-streaming-option-tar-gz-vs-tar","status":"publish","type":"post","link":"http:\/\/blog.trungson.com\/?p=320","title":{"rendered":"Benchmark xtrabackup streaming option tar.gz vs. tar"},"content":{"rendered":"

time innobackupex –databases=”mydb” –stream=tar .\/ –slave-info > \/var\/lib\/mysql\/snapshot_mydb.tar<\/p>\n

time innobackupex –databases=”mydb” –stream=tar .\/ –slave-info | gzip – > \/var\/lib\/mysql\/snapshot_mydb.tar.gz<\/p>\n

Results:
\nTAR: filesize 5.4Gb
\nreal\t0m52.633s
\nuser\t0m0.900s
\nsys\t0m29.860s<\/p>\n

TAR.GZ: filesize 350Mb
\nreal\t2m26.606s
\nuser\t3m40.261s
\nsys\t0m28.829s<\/p>\n

And during the dump, tar.gz locks tables. Thus, for a big database, a better solution would be just tar, then compress before sending<\/p>\n","protected":false},"excerpt":{"rendered":"

time innobackupex –databases=”mydb” –stream=tar .\/ –slave-info > \/var\/lib\/mysql\/snapshot_mydb.tar time innobackupex –databases=”mydb” –stream=tar .\/ –slave-info | gzip – > \/var\/lib\/mysql\/snapshot_mydb.tar.gz Results: TAR: filesize 5.4Gb real 0m52.633s user 0m0.900s sys 0m29.860s TAR.GZ: filesize 350Mb real 2m26.606s user 3m40.261s sys 0m28.829s And during the dump, tar.gz locks tables. Thus, for a big database, a better solution would be […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"_links":{"self":[{"href":"http:\/\/blog.trungson.com\/index.php?rest_route=\/wp\/v2\/posts\/320"}],"collection":[{"href":"http:\/\/blog.trungson.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/blog.trungson.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/blog.trungson.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/blog.trungson.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=320"}],"version-history":[{"count":1,"href":"http:\/\/blog.trungson.com\/index.php?rest_route=\/wp\/v2\/posts\/320\/revisions"}],"predecessor-version":[{"id":321,"href":"http:\/\/blog.trungson.com\/index.php?rest_route=\/wp\/v2\/posts\/320\/revisions\/321"}],"wp:attachment":[{"href":"http:\/\/blog.trungson.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=320"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/blog.trungson.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=320"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/blog.trungson.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=320"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}