Middle Fork GIS wrote:
[...] at random intervals, Apache stops serving pages.
HTTP request sent, awaiting response...
And there it sits until the server is started; likewise from a remote browser, the page is never delivered. Nothing appears in Apache's log, even when set to the most verbose 'INFO' level.
The log is only written once the page has been served, so that isn't surprising.I'd take a look at your database. If one query locks all the important tables, then runs for minutes and minutes, every other query will block waiting for it. This will quickly fill up your Apache connection limit with people waiting for their response to be delivered. Eventually, the bad query times out and everything goes back to normal.
Apache is NOT pegging the CPU: CPU usage will show close to 0% and the load average will show close to zero as well. Apache is not hogging the memory, very little memory usage is shown.
On MySQL, this would be diagnosed with a quick "SHOW PROCESSLIST", I'm not sure about PostgreSQL though.
Cheers,
Nicholas Sherlock
---------------------------------------------------------------------
The official User-To-User support forum of the Apache HTTP Server Project.
See <URL:http://httpd.apache.org/userslist.html> for more info.
To unsubscribe, e-mail: users-unsubscribe@xxxxxxxxxxxxxxxx
" from the digest: users-digest-unsubscribe@xxxxxxxxxxxxxxxx
For additional commands, e-mail: users-help@xxxxxxxxxxxxxxxx
|