I have a v6.9 system running on a 4 core server with 8GB of memory. 2 active file cabinets of about 250K rows each running MySQL. For the last 5 or 6 days the processors have been spiked at 100% or high 90's, according to the resource monitor, memory used is 4GB or less. 60% or more of the CPU is going to Content Server.
Anybody have any suggestions are what might be the cause of this apparent overload? Or advice on how to approach the issue? This is happening only recently and unexpectedly.
Thanks,