Jeremy, Do you remember what you exactly did to configure this plugin?
On Wed, Apr 4, 2012 at 3:34 PM, Jeremy Keiper <[email protected]> wrote: > 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 >> >> >> > ------------------------------ > Click here to > unsubscribe<[email protected]?body=SIGNOFF%20openmrs-implement-l>from > OpenMRS Implementers' mailing list > -- If we keep uppermost in our minds the unkind and unjust acts of others, we shall find it impossible to love them as Christ has loved us; but if our thoughts dwell upon the wondrous love and pity of Christ for us, the same spirit will flow out to others. _________________________________________ 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]
