Category: MySQL

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'...

MySQL Pager

MySQL LogoEver worked on a MySQL having table locking problems and when you run 'show full processlist' your screen is blasted with hundreds of lines of queries?  MySQL have a feature to help you parse this information easier with a feature known as a 'pager'

Read more about 'MySQL Pager'...

Linux Commands in MySQL

MySQL LogoRecently I can across the ability to run Linux commands in the MySQL shell without the need to drop out of the MySQL shell.  This can save quite some time in the long run when troubleshooting database performance issues as you do not need to switch shells to run commands.

Read more about 'Linux Commands in MySQL'...