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