Hadn't heard of this before but it looks pretty awesome. Note this specific comment: Because the ability to create and drop indexes does not require use of a new on-disk file format, it is possible to temporarily use the InnoDB Plugin to create or drop an index, and then fall back to using the standard built-in InnoDB in MySQL for normal operations if you wish. See Chapter 11, *Downgrading from the InnoDB Plugin*<http://dev.mysql.com/doc/innodb-plugin/1.0/en/innodb-downgrading.html> for more information.
So if you're worried about this plugin, but you still want faster DB upgrades, you might enable it selectively. -Darius On Wed, Aug 17, 2011 at 10:41 AM, Jeremy Keiper <[email protected]> wrote: > Has anyone used the MySQL InnoDB plugin [0] for performance enhancement > (faster indexing, etc)? > > I just tried it out in our dev environment for upgrading the AMPATH dataset > from version 1.6.2 to 1.8.2. Our original upgrade was stuck on adding an > index to the obs table for 4+ days. After installing the plugin, the same > statement completed in 24 minutes. I would like to continue using it, but > need to know if anyone else has experienced problems with it. I will post a > blog entry with my findings. Thanks! > > [0]: http://dev.mysql.com/doc/innodb-plugin/1.0/en/index.html > > Jeremy Keiper > OpenMRS Core Developer > AMPATH / IU-Kenya Support > ------------------------------ > Click here to > unsubscribe<[email protected]?body=SIGNOFF%20openmrs-implement-l>from > OpenMRS Implementers' mailing list _________________________________________ To unsubscribe from OpenMRS Implementers' mailing list, send an e-mail to [email protected] with "SIGNOFF openmrs-implement-l" in the body (not the subject) of your e-mail. [mailto:[email protected]?body=SIGNOFF%20openmrs-implement-l]
