Virtualization in a high io environment like a database is never a good idea.

Google I/O blender effect.

Date: Tue, 18 Nov 2014 05:29:31 +0300
To: ggitagia@gmail.com; skunkworks@lists.my.co.ke
Subject: Re: [Skunkworks] Inno db io optimization
From: skunkworks@lists.my.co.ke

Geoffrey, there is this freeware, Spotlight on MySQL, which I have found very useful for continuous visualisation of that MySQL is upto, in real time.

http://software.dell.com/products/spotlight-on-mysql/

On Mon, Nov 17, 2014 at 2:08 PM, geoffrey gitagia via skunkworks <skunkworks@lists.my.co.ke> wrote:

Thanks Adam
I am running on a windows environment so I have 5.5 on it , I noticed is writes alot of temp files and at times converts to isam tables ,meaning that my io is going to be high ,from me resource monitor I can see lots of disk activities, it even at times freezes the server for a few seconds, another problem is that the tables have many columns of which the dev uses select * statements, impacting on cache.

_______________________________________________
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

Regards,
Peter Karunyu
-------------------

_______________________________________________ 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