On Mon, 2009-03-09 at 22:17 +0000, Adam Bower wrote:
Not knowing what the hardware above is doing could be a clue, what's the virtualisation method? and is the box itself being hammered by other virtual machines? That would effectively make them similar to a virus or trojan in some respects ;)
Adam
Also if you are still running virtual and you are using a virtual disk image rather than a dedicated partition (I'd hope not if you care about the performance) then look into using the noop scheduler rather than the default CFQ one as the optimisation of the latter doesn't make sense when you are running from an image.
If you are running on a dedicated volume then what is it running on..RAID 5 will murder write speeds on MySQL
Also if they are not important to you the you should consider mounting volumes with noatime or if they are important but you don't want the same level of write overhead on reads and you have a kernel >= to 2.6.20 then relatime.
Either of those optimisations can result in a 20% or so performance boost in specific circumstances and more in special cases.
Consider if you need the binary log, if not and your access is write heavy then disable it. (although in reality the performance cost doesn't seem to be that heavy and it can come in handy)