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. Petty good point. Did you adjust innodb_buffer_size to your system's memory profile. Also, make sure you are using innodb plugin NOT the build in innodb unless you are now on mysql 5.6 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. Doubt it will help. Even if he is using oracle, Ms sql, he would still have the same problem. He is saturating his i/o subsystem  A better filesystem may help marginally as ntfs has high overhead than case sensitive filesystem but his problem is deeper. If there is money, he could buy some SSD disk and put the 200gb on SSD. Using hardware to fix software lack of good design. William   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 Musings: twitter.com/varud <https://twitter.com/varud> More Musings: varud.com About Adam: www.linkedin.com/in/adamcnelson 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