Thanks to all yee skunks, I am now getting a clear picture of what's going on , now as a solution I want to buy an ssd and then attach it to my systems vm such that I avoid the blender effect ,in your opinion will this 'cure' my system? Or will I still face a io bottle neck? Regard Geoffrey On Nov 18, 2014 8:14 AM, "john doe" <kuwasiliana@hotmail.com> wrote:
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