New release slow?

Ok, if your hosting platform is Ok this seems to put the prob back to your site.

Presumably your old site i.e pre-upgrade to 0.9.6.2 didn’t exhibit this behavior, in which case its beginning to sound like something in the upgrade maybe.

I still think you should tell the site admins about the forbidden access to /home error, it shouldn’t really do this whether its pertinent to the fault or not.

You could try putting the timing marks out on a test page, i.e this syntax from the MODx template :-



This will tell you roughly where the time is being spent, MYSQL or page serving. Bring this page up when the fault occurs.

Other than that you’ve only really got the logs to help you at the mo.

By the way whats an ’rc2’ that you mention above?

modx-0.9.6.2-rc2 http://modxcms.com/beta.html

I am using this version on my other sites.

I’ll put that SQL code in my site to see what the results are. I will do some testing on the front end. Thanks

Ok one page showed these results

MySQL: 1.3188 s, 42 request(s), PHP: 6.0210 s, total: 7.3398 s, document retrieved from database
MySQL: 21.8213 s, 44 request(s), PHP: 0.9134 s, total: 22.7347 s, document retrieved from database


It done nothing special apart from change page. There’s nothing special to the page as such.

OK, spending nearly 22 seconds in MYSQL doesn’t sound right to me but I think you need to do a comparison if you can, can you put the timing code into one of your working sites and see what that comes up with? Obviously it’ll need to be a site that basically does what the problem one does, on a similar hosting platform.

Thinking about it spending 6 seconds in PHP seems a bit OTT as well but I’ve got no real feel for this as my site is hosted on my own server and I get timings in the region of 0.05 seconds per page load.

Maybe you could ask a general question on the forums on what other people think a ’good’ MYSQL timing might be for a similar site.

OK, I see the rc2 thing now, it may be worth looking at whats changed between rc2 and the actual 0.9.6.2 release, is there a changelog published with releases i wonder. I’ll have quick look at this later.

Hi rossco, just remembered, I’ve got a utility on my server called ’mytop’, its a perl program that performs a similar function to ’top’ but on the MYSQL server. It shows queries per sec, load averages etc. Its got a man page for usage info. I rolled my own RPM for my centos5 server but being perl its a noarch package so it should be OK on other platforms, it will almost certainly be OK on RHEL 5.

If you think its MYSQL the utility is an RPM file here http://bitez.hobby-site.com/assets/site/software/misc/mytop-1.6-2.noarch.rpm
or look in the ’misc’ directory of my software download page.

You can of course go to the mytop site if you dont want to install the RPM.

I’m not that well versed on server settings so I’m limited with what to do.

Could you search through the areas and see if you get any slow down? The site is not complete as yet so excuse the poor look. I have put the status bar at just under the logo, I’m sure you’ll see it.

If need be, I’ll do a fresh install of modx but what would be the best to easily put everything back to normal? Would a bad upgrade cause slow down? Surely if it was a bad upgrade there would be more issues than just speed?


www.rossco-designs.com

Thanks.

Appears snappy enough to me; no slow pages, everything moved right along, mostly under .2 seconds; although the "extras" page did hiccup for .7 seconds once.

OK just looked at the site, mainly the timings look much more like it but I noticed the following :-

1. On one page request PHP timing shot up to 7 seconds for some reason.
2, I clicked on ’web-sites’ link and got a ’forbidden error’ ’cannot access /289 on this site’ only once, did it several times and it was OK.
3. A large purple box opens the closes in the top right of the site on page refresh, something to do with the info tab I think.

I don’t think this is the upgrade at fault nor 0.9.6.2, it looks more like a jumpy server to me.

I didn’t see anything like the MYSQL timings you posted above, this looks OK here.

I think all you can do is monitor the situation and try and get some timings when the slowness occurs.

The occasional ’forbidden’ errors that I’ve just seen and that you reported earlier are a little worrying, this shouldn’t happen at all, I cant see this being MODx personally.

If you see the large purple box... I assume you are using Linux as Linux doesn’t display transparency in flash correctly at all. It’s just a java/flash corner effect.

I will email the host again and ask them to double check everything cos it’s annoying the hell out of me waiting 20 seconds for a page update!

Thanks to you all.

Ok rossco, yes I’m using linux, show you’re admins the MYSQL timings you posted earlier, 22 seconds is way to long for me.

Good luck with it, if you get it fixed could you post the outcome here, be interesting if nothing else.