Serious iowait issues
Hi,I am running a number of large databases on my Linux box, and am running into performance problems.
Memory usage: low
CPU usage: low
iowait: very high, nearing 100%
That above is reported by "top".
What are my choices?
--change my box to something with very fast disk - raid, scsi?
--buy a lot of ram, and use that as mysql cache
appreciate your advice.