We are hosting a large site (10-12,000 visitors per day) which is database driven on a Linux box (RedHat 6.something), 750 proc and 256 RAM.
mySQL is eating up the system resources like wildfire - which seems very strange and has baffled everyone I've spoken to. RAM is fine - almost 100 free, no use of a swap file.
The largest table is about 20,000 records - nothing to sneeze at, but not huge. A few pages query the database several times, up to 10 on a given page, to get all the information needed.
At a loss as to what to do - any suggestions are much appreciated!!
Cheers..
Drew
mySQL is eating up the system resources like wildfire - which seems very strange and has baffled everyone I've spoken to. RAM is fine - almost 100 free, no use of a swap file.
The largest table is about 20,000 records - nothing to sneeze at, but not huge. A few pages query the database several times, up to 10 on a given page, to get all the information needed.
At a loss as to what to do - any suggestions are much appreciated!!
Cheers..
Drew