I have been running into server performance issues....
I am running just mysql and apache thoughts on how to identify the problem?
I have ran top and even when nothing is using alot of CPU or Memory I still run into performance issues when querying SQL. The weird thing is I can query the same item and sometimes its a fraction of a second and other times 5-6 seconds return time.
Is there anyway to ensure enough resources for my frontend applications?