tonysab

Then it is pretty quick (as I guess you’d expect). 2 secs average, although occasionally 5 seconds.
GD have advised they have changed something on my hosting to try and fix the issue. I had not really noticed any difference, although with all plugins on and the 2015 theme it did seem quicker than it had done previously. Switching the Graphene theme back did seem to slow it down again.
However the more I clicked around, the faster it seemed to get (and I was clicking on different pages so don’t think it’s due to caching), suddenly I was getting 2 seconds response time with everything back on as it was. Not every single time but it does seem to have sped up a bit. Not sure how long it will last or if it’s just a temporary “go fast” but I’ll see.

OK I understand what you are saying.
But…I have activated the 2015 theme to try this, and am typically getting response times of around 18 seconds now, with 16 seconds being DB access. So it looks like the time has just been reduced by the terrible query time. The performance is still ridiculously slow.

As an example, with the 2015 theme it takes 3.7 seconds to run –

SELECT option_name, option_value
FROM wp_options
WHERE autoload = ‘yes’

Thanks for the feedback.
I don’t dispute the query is possibly terrible, and I will contact the theme author about it. However I think the slowness of the mysql in general by Godaddy just makes it stand out more.
In other words, I estimate that every query against the database is now taking 15 times longer than it did 3 weeks ago. So this “terrible” query, which previously took half a second, now takes 7.5 seconds etc. Likewise all the (previously very quick) queries that used to take a fifteenth of a second, now take a second, and so on.
So whilst I don’t dispute the query may be poor, I don’t think you can say the problem is with the theme. Prior to GD making these changes the site ran normally.

Hi James – thanks for your feedback. Yes you are correct, I have found that the initial query mentioned is indeed a theme specific query. However on other ‘old style’ GoDaddy accounts using the same theme, it runs in fractions of a second. This is true of most of the other queries, whereas on the slow site there are a several queries each taking for example 0.9 seconds each, these should be (and on the old style account are taking), like 0.03 seconds. So 10 of these = 9 seconds, so it’s the culmination of these, plus a couple of other slow ones that add up to the 20-30 seconds I am experiencing.
Can you advise how long it takes you to get to pages on radleyvillage.org.uk?

I still have an open incident with GoDaddy about this which I insisted on them opening, but I fear all they will continue to say is that this is how the new setup is. Which makes me think there surely must be other people experiencing the same issues?

After doing all this the site was fine. Now in the last 2-3 days it has re-occurred and I’m at a loss to explain why. Memory going through the roof, IO too. And yet nothing has changed on the site.
Log files showed some new crawlers – yandex. In desperation I have set my robots.txt to disallow all bots except google. Last night I disabled all plugins on the site, but resources were still hitting max. Raw log files now show virtually no traffic, and yet the site is constantly timing out/ error 500.
Godaddy have just advised it must be wp since https://www.radleyvillage.org.uk/home.html is fine.
But I don’t know what else to do, it’s absolutely ridiculous as the amount of traffic is so low and yet something is eating all the resources!
Any further advice gratefully received, thanks.

Some excellent advice Matt – many thanks. I have done what you said and found that for Feb – the past 3 days – out of 25,000 log file entries, just under 6,000 were attributable to https://www.majestic12.co.uk, a further 7700 to bingbot plus about 2.5K to https://www.opensiteexplorer.org/dotbot.

I shall look into some robots file entries I think to prevent these as they do seem to be killing the site.

I also had 51 entries for xmlrpc.php – which on the face of it doesn’t seem too many. I have read that blocking this can also speed things up. I think I’ll hold off doing that for now but certainly keep an eye on it.

I’ll make the robots entries and see how that goes. Thanks again for your help and advice.

Hi Angelo, yes as mentioned in my second posting, this is what I did and found the clashing plugin to be the Image Map Hot Spot. I have contacted the author of that too. I can’t quite fathom out what is causing it but definitely with that plugin enabled, it seems to lose formatting around the first couple of events on the event list, parts of them are wrapped in p tags which then seems have a knock on effect to the rest of the listing which is all over the place.

Thanks for that, very interesting, although I don’t think that applies in this case. The inspect element shows jquery 1.11.0 is being used.

I tried deactivating all plug-ins and re-activating one by one. It showed the culprit is the Image Map Hot Spot plugin. I will do some more digging.

Cheers, no this wasn’t on a Mac – TBH it’s not the end of the world – it’s sometimes best to have the core files not in the root I guess – I just wondered if it was normal for this to happen? Thanks.

Thanks for your advice. I think part of the problem is that I want to re-host the site to GoDaddy at the same time as I use the one click install of WordPress whereas their current host you have to install manually – I know its not a massive deal but I prefer to use GoDaddy and this is where I have my own site hosted.
So if I am looking to re-host a site and cutover to a newly developed one at the same time this is where it gets messy but like I say it must be a fairly common thing to do.

Thank you. What would have been the best way of approaching this if I had the time again? This must be a fairly common scenario I’d have thought, ie a new site is required but don’t want to affect the current site.

Hi sorry for the delay in replying, I have tried these without any success.
Link to a page with the categories link is –

https://tonystoyle.co.uk/radleyvillage/events/radley-parish-council-ordinary-meeting-2/

any further suggestions would be gratefully received, thanks.

Thanks – I should have mentioned that I have previously used a plugin for this – list category posts – but I would like to know how to do it myself, if possible. Thanks.

Blimey that looks good, although I don’t think it’s quite what I want. Using my example I want to display posts where the order is Lepidoptera and I want to display them in family sequence, so I would expect to see 2 posts, the one with a family value of CRAMBIDAE first, then followed by the one with NOCTUIDAE.
Thanks for your help though.