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]
