Showing posts with label mysql compression. Show all posts
Showing posts with label mysql compression. Show all posts

Upgrading MySQL to 5.5.32 and compressed tables

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!