Backup MySQL Database MySQL provides mysqldump utility to let us dump SQL statements that can recreate the whole database. We can output the SQL statements… Read More »Mysqldump Compress on the Fly
Two steps to make your table compressed. Set the server INNODB_FILE_FORMAT to Barracuda. mysql> SET GLOBAL INNODB_FILE_FORMAT=Barracuda; Alter table to compressed with 8KB key block… Read More »2 Steps to Compress MySQL Tables