dhis2-devs team mailing list archive

[Knut Staring <knutst@xxxxxxxxx>]

This may be important for the Indian DHIS2 installations which all run on
MySql

Knut

---------- Forwarded message ----------
From: Saptarshi Purkayastha <sunbiz@xxxxxxxxx>
Date: Thu, Aug 18, 2011 at 1:21 AM
Subject: Re: [OPENMRS-IMPLEMENTERS] MySQL InnoDB plugin for performance
enhancement
To: openmrs-implement-l@xxxxxxxxxxxxxxxxxx


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 <jeremy@xxxxxxxxxxx> 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<LISTSERV@xxxxxxxxxxxxxxxxxx?body=SIGNOFF%20openmrs-implement-l>from OpenMRS Implementers' mailing list


------------------------------
Click here to unsubscribe<LISTSERV@xxxxxxxxxxxxxxxxxx?body=SIGNOFF%20openmrs-implement-l>from
OpenMRS Implementers' mailing list



-- 
Cheers,
Knut Staring