There is a MySQL InnoDB plugin that comes packaged with MySQL 5.1+. Here's a link:
http://dev.mysql.com/doc/innodb-plugin/1.0/en/index.html The primary benefit for us is fast index creation. Tuwei, I tested this in our Indy dev server and it worked well. I believe I just enabled the plugin with a few lines in a conf file in /etc/mysqld/conf.d/ for it to start working. Implementing this plugin can let you do some things that "normal" InnoDB cannot do, which is a good thing unless you need to revert some time. Because of that, I never tried any other fancy InnoDB plugin enhancements. Jeremy Keiper OpenMRS Core Developer AMPATH / IU-Kenya Support On Wed, Apr 4, 2012 at 8:14 AM, Ben Wolfe <[email protected]> wrote: > Mysql unnecessarily complicates the "alter" statements. It copies the > entire table and rebuilds it. > > Jeremy found a workaround that involves setting a new engine to mysql. > Once choosing that engine, the alter statement is super fast. I can't find > where he talked about or documented that right now though. > > Ben > > > On Wed, Apr 4, 2012 at 4:26 AM, Tuwei Gilbert <[email protected]>wrote: > >> Hi all >> We are having problem upgrading to 1.9 this is due to the fact that we >> have more than 125 million observation. Executing this statement 'ALTER >> TABLE obs DROP COLUMN 'date_started' during the upgrade process is taking >> forever.Has any body upgraded to 1.9 and has more than 100 Million obs? >> We are using tomcat 6.0 and mysql 5.1. >> >> Regards >> >> -- >> Tuwei Gilbert >> OpenMRS Core Implementer >> USAID/AMPATH-Eldoret Kenya >> ------------------------------ >> 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]
