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
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.keGeoffrey, there is this freeware, Spotlight on MySQL, which I have found very useful for continuous visualisation of that MySQL is upto, in real time.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