(please forgive my ignorance, I am new to this whole hosting thing. Just an old UNIX hack from before the internet days)
I had previously posted about SQL query perforamnce but that was an assumption on my part. Here are the raw observations. Any advice would be greatly appreciated.
We are trying to debug intermittent very sluggish response times for our users.
Debug started with Chrome>Developer Tools>Network trace attached. This shows that the delay is happening upon the initial click waiting for the page to be "built" by the host. See slow_response.png
I then SSH'd into the host and ran top and kept clicking until another slow event occured. I have been able to correlate the sluggish response to a large number concurrent of "php-cgi" processes on the host. They are all tyring to run at the same time and only getting a fraction of the CPU utilization. See summary of process log trace attached process_debug.jpg It gets much worse (more php-cgi processes) but that log file is at home and I'm at work.
By monitoring the "top" output over SSH with a very fast refresh rate (0.3sec), I can see that the php-cgi processes are direct results if click events on the web site. Thus, I suspect we are just seeing a large number of users simultaneously clicking.
Is this likely the result of simply too many simultaneous clicks?
Is it possible these are add-ons running causing this?
Cron jobs running too often or possibly all at once?
Mucho thanks for any advice/questions/help anyone can give!
Frank and Sean