Frequently "edit content" and "edit news" pages show up blank

[g5todd]

I'm running CMSMS 1.2.3.

The main page works fine but when I try to edit the content or news I wind up waiting for about a minute, then the connection get closed. 0 bytes were transferred. The custom headers don't even get set.

No error message gets sent.

The editing worked just fine on my previous host, and my current host when I had the site closed off to the public. It wasn't until I opened it to the public that I started getting these intermittent (read: inside 8am-8pm) issues.

Here's a header dump from firebug where it doesn't work (note the lack of Response headers):
Request Headers
Host    (snip)
User-Agent      Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9b4)
Gecko/2008030714 Firefox/3.0b4
Accept  text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
Accept-Language en-us,en;q=0.5
Accept-Encoding gzip,deflate
Accept-Charset  ISO-8859-1,utf-8;q=0.7,*;q=0.7
Keep-Alive      300
Connection      keep-alive
Referer http://(snip)/admin/
Cookie  (snip)

And here's a dump from firebug where it works:

Response Headers
Date Fri, 21 Mar 2008 19:09:22 GMT
Server Apache/1.3.37 (Unix) PHP/4.4.4
X-Powered-By PHP/4.4.4
Expires Mon, 26 Jul 1997 05:00:00 GMT
Cache-Control no-store, no-cache, must-revalidate, post-check=0, pre-check=0
Pragma no-cache
Last-Modified Fri, 21 Mar 2008 19:09:27 GMT
Keep-Alive timeout=5, max=50
Connection Keep-Alive
Transfer-Encoding chunked
Content-Type text/html; charset=utf-8

Request Headers
Host (snip)
User-Agent Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9b4) Gecko/2008030714 Firefox/3.0b4
Accept text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
Accept-Language en-us,en;q=0.5
Accept-Encoding gzip,deflate
Accept-Charset ISO-8859-1,utf-8;q=0.7,*;q=0.7
Keep-Alive 300
Connection keep-alive
Referer http://(snip)/admin/moduleinterface.php?module=News
Cookie (snip)

[Nullig]

When you look at the page source of your site, how long does it take to generate the pages?
It could be an overloaded MySQL server that's the problem.

What about your PHP environment? What are the memory limit, max execution time, etc.?

Nullig

[g5todd]

It seems to only happen with the administrative pages which doesn't have the generated time in the source.

Max execution time is a good call. I don't know that so I've put in a ticket to ask. They do claim I can customize my php.ini so I might need to increase that.

As for page generation times of content pages, those can get pretty heavy.






I don't like that variance.

[Nullig]

Looks like an overloaded MySQL server. I have sites with 1000+ pages in the db that rarely take longer than 1 second.

Nullig

[g5todd]

Hmm. Now I'm getting ~2 second generation times on the front page, but I'm still getting issues on the admin side. My next guess is overload on the apache server.






Is 500 hits/hour asking too much of a $7/month webhost?