Upgrade to 1.9

classic Classic list List threaded Threaded
5 messages Options
Tuwei Gilbert Tuwei Gilbert
Reply | Threaded
Open this post in threaded view
|

Upgrade to 1.9

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

[hidden email] from OpenMRS Implementers' mailing list
Ben Wolfe (openmrs) Ben Wolfe (openmrs)
Reply | Threaded
Open this post in threaded view
|

Re: Upgrade to 1.9

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 <[hidden email]> 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

[hidden email] from OpenMRS Implementers' mailing list


[hidden email] from OpenMRS Implementers' mailing list
Jeremy Keiper-3 Jeremy Keiper-3
Reply | Threaded
Open this post in threaded view
|

Re: Upgrade to 1.9

There is a MySQL InnoDB plugin that comes packaged with MySQL 5.1+.  Here's a link:


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 <[hidden email]> 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 <[hidden email]> 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

[hidden email] from OpenMRS Implementers' mailing list



[hidden email] from OpenMRS Implementers' mailing list
Daniel Kayiwa Daniel Kayiwa
Reply | Threaded
Open this post in threaded view
|

Re: Upgrade to 1.9


Jeremy,

Do you remember what you exactly did to configure this plugin?

On Wed, Apr 4, 2012 at 3:34 PM, Jeremy Keiper <[hidden email]> wrote:
There is a MySQL InnoDB plugin that comes packaged with MySQL 5.1+.  Here's a link:


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 <[hidden email]> 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 <[hidden email]> 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

[hidden email] from OpenMRS Implementers' mailing list



[hidden email] 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.

[hidden email] from OpenMRS Implementers' mailing list
Jeremy Keiper-3 Jeremy Keiper-3
Reply | Threaded
Open this post in threaded view
|

Re: Upgrade to 1.9

Daniel, 

According to the documentation 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 <[hidden email]> wrote:

Jeremy,

Do you remember what you exactly did to configure this plugin?


On Wed, Apr 4, 2012 at 3:34 PM, Jeremy Keiper <[hidden email]> wrote:
There is a MySQL InnoDB plugin that comes packaged with MySQL 5.1+.  Here's a link:


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 <[hidden email]> 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 <[hidden email]> 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

[hidden email] from OpenMRS Implementers' mailing list



[hidden email] 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.


[hidden email] from OpenMRS Implementers' mailing list


[hidden email] from OpenMRS Implementers' mailing list