I have found th eproblem of my slow server. It seems my Average Disk Queue Length peaks at 37! Apparently it should be no more than 2!
All that is on that disk is the MySql datafile.
What I have done is made a copt of a 500MB MyIsam table and converted it to Innodb, which is now about 1 Gig.
When I run my site against the innodb table, I get very high Disk I/O to the datafile.
I have plenty of physical memory left and the cpu is not overloaded, its just the disk access thats killing my server.
I have tried changing all the parameters but cant seem to get the disk accees down.
Any Ideas what I should be changing?
Im only running less than 100 connections.