Run `iostat -c10` or something like that and confirm that you're near the IO limit of the disk subsystem.  You'll also want to run `free` and see what's going on regarding memory usage.  You may not be using all of your memory if your InnoDB settings aren't setup to use it.

Anyway, the first thing is to get onto the latest and greatest Ubuntu/Debian/CentOS or whatever OS you're running and make sure you're on the latest and greatest MySQL from your OS vendor.  You should definitely be on 5.5 and ideally 5.6.

Then, checkout this whole section:

http://dev.mysql.com/doc/refman/5.6/en/optimizing-innodb.html

I wonder if it's an Innodb issue though - more likely it's bad queries and indexes - which you may or may not be able to change.

To see the hotspots, install New Relic (http://newrelic.com/).

-Adam


--
Kili - Cloud for Africa: kili.io
More Musings: varud.com

On Mon, Nov 17, 2014 at 10:52 AM, geoffrey gitagia via skunkworks <skunkworks@lists.my.co.ke> wrote:

Hi all
    Wanted to know how to improve my io performance on innodb , the situation is like this ,32 bit mysql ,virtualized with hyper-v , the db is on a 200gb vhd and space is not an issue, please note nothing can be changed in the environment unless you suggest putting log files to a different partition, but no changing of the sql server.

Regards
GG


_______________________________________________
skunkworks mailing list
skunkworks@lists.my.co.ke
------------
List info, subscribe/unsubscribe
http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks
------------

Skunkworks Rules
http://my.co.ke/phpbb/viewtopic.php?f=24&t=94
------------
Other services @ http://my.co.ke