Daniel, According to the documentation<http://dev.mysql.com/doc/innodb-plugin/1.0/en/innodb-plugin-installation-configuration.html>it simply requires the following conf file change:
[mysqld] > ignore_builtin_innodb Jeremy Keiper OpenMRS Core Developer AMPATH / IU-Kenya Support On Wed, Apr 4, 2012 at 9:08 AM, Daniel Kayiwa <[email protected]>wrote: > > 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. > > ------------------------------ > 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]
