InnoDB Plugin 1.0 for MySQL 5.1 User's Guide  /  Upgrading the InnoDB Plugin  /  Converting Compressed Tables Created Before Version 1.0.2

10.3. Converting Compressed Tables Created Before Version 1.0.2

The InnoDB Plugin version 1.0.2 introduces an incompatible change to the format of compressed tables. This means that some compressed tables that were created with an earlier version of the InnoDB Plugin may need to be rebuilt with a bigger KEY_BLOCK_SIZE before they can be used.

If you must keep your existing database when you upgrade to InnoDB Plugin 1.0.2 or newer, you will need to perform a slow shutdown of MySQL running the previous version of the InnoDB Plugin. Following such a shutdown, and using the newer release of the InnoDB Plugin, you will need to determine which compressed tables need conversion and then follow a procedure to upgrade these tables. Because most users will not have tables where this process is required, this manual does not detail the procedures required. If you have created compressed tables with the InnoDB Plugin prior to release 1.0.2, you may want to contact MySQL support.

User Comments
Sign Up Login You must be logged in to post a comment.