This may be important for the Indian DHIS2 installations which all run on MySql
Knut ---------- Forwarded message ---------- From: Saptarshi Purkayastha <sun...@gmail.com> Date: Thu, Aug 18, 2011 at 1:21 AM Subject: Re: [OPENMRS-IMPLEMENTERS] MySQL InnoDB plugin for performance enhancement To: openmrs-implemen...@listserv.iupui.edu Hi Jeremy, I completely agree that InnoDB-plugin does perform better than plain InnoDB tables. That's why Innobase (now Oracle) has been silently providing services to improving MySQL performance for years. Also with InnoDB-plugin you can intelligently set the KEY_BLOCK_SIZE and get more data in-memory in ur buffer_pool_size But from what u'll see I've mentioned earlier that if you are performing IO intensive tasks, XtraDB (another drop-in replacement for InnoDB) provides even better performance, with the same reliability. --- Regards, Saptarshi PURKAYASTHA My Tech Blog: http://sunnytalkstech.blogspot.com You Live by CHOICE, Not by CHANCE On 17 August 2011 23:11, Jeremy Keiper <jer...@openmrs.org> wrote: > Has anyone used the MySQL InnoDB plugin [0] for performance enhancement > (faster indexing, etc)? > > I just tried it out in our dev environment for upgrading the AMPATH dataset > from version 1.6.2 to 1.8.2. Our original upgrade was stuck on adding an > index to the obs table for 4+ days. After installing the plugin, the same > statement completed in 24 minutes. I would like to continue using it, but > need to know if anyone else has experienced problems with it. I will post a > blog entry with my findings. Thanks! > > [0]: http://dev.mysql.com/doc/innodb-plugin/1.0/en/index.html > > Jeremy Keiper > OpenMRS Core Developer > AMPATH / IU-Kenya Support > ------------------------------ > Click here to > unsubscribe<lists...@listserv.iupui.edu?body=SIGNOFF%20openmrs-implement-l>from > OpenMRS Implementers' mailing list ------------------------------ Click here to unsubscribe<lists...@listserv.iupui.edu?body=SIGNOFF%20openmrs-implement-l>from OpenMRS Implementers' mailing list -- Cheers, Knut Staring
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
