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
-------------------