My current VPS (5 node tmdhosting VPS) is very slow on disk IO throughput; a simple insert mysql query can take more than 10 seconds ( yes, more than 10 seconds!!) to complete. I've checked already, my VPS is underutilized, and I strongly suspect that other VPSes that cohabitate with mine on the same physical server is doing a lot of disk IO operation at the expense of mine.
Not only that, the performance of mysql write query can be quite inconsistent; on a day it is fast, and on another day it is slow. This is also reinforcing my above suspicion.
I am thinking about switching to cloud hosting. But I afraid that cloud hosting may have the same problem ( ie: IO throughput is shared among all of the visualization), am I right in this?
Is there any kind of hosting package that I can use to get a consistent IO throughput? I understand that dedicated server is the ultimate answer, but I don't want to use a dedicated server just yet.