Archive: 08/06/2018

Greetings!  Unfortunately due to the mountains of spam I am getting in the comments and contact form, I am temporarily disabling comments.  Once I can get the Captcha plugin working correctly, I will re enable commenting and the contact form.  I apologize to those whose questions and comments I unintentionally deleted while cleaning out the spam!


 

Gzip vz XZ for mysqldump

gzip vz xzThere are numerous compression tools available to Linux and Database administrators including gzip, xz, bzip2, and pigz and others.  Gzip has been the classic go to for compression, however there has been a move to xz over gzip due to improvements in compression.  This quick guide will show the differences in compression and time to complete specifically when dealing with mysqldump.  When dumping databases, it is often a balance between total achieved compression and time it take to complete, to keep lock time to a minimal.

Read more about 'Gzip vz XZ for mysqldump'...