Recently I was tasked with upgrade some MySQL instances from 5.5.16 to 5.5.32. The task seemed easy enough but when I started the process on one of the larger databases on the server (just under 1TB), it is made up of a lot smaller tables and most over 90% are 'myisam'. I ran into issues when I ran mysql_upgrade.
error : Table upgrade required. Please do "REPAIR TABLE `<name>`" or
dump/reload to fix it!
Showing posts with label compression. Show all posts
Showing posts with label compression. Show all posts
MySQL Enterprise Backup (MEB) Compress Option
I have used compression tools before and was interested to understand a little more about MEB's use of compression. Jumping straight in, here are a couple of points to consider:
- the backup compression feature only applies to InnoDB tables.
- when InnoDB tablespace files are compressed during backup, they receive the extension .ibz rather than the usual .ibd extension.
- you can only use the --compress option for full backups, not for incremental backups.
Subscribe to:
Posts (Atom)