Dave

Thanks Kiran. That seems to have done the trick, thank you!

You can see attached graph, the difference since you did the updates.

Is it safe to upgrade to the latest version of GD and still keep the changes you’ve made?

Thanks,
Dave

If you change the encryption to “use explicit FTP over TLS if available” I think that should work

I’ll ask them now. But I think last time, used used a VPN. That could be quicker?

Thanks,
Dave

Ok I guess that makes sense. The event calendar widget is loaded on every page as it’s in the main menu at the top.

I’ve installed WP phpMyAdmin plugin now. You can login to my wp admin panel (details further up this thread) and go to settings and it should let you in.

Thank you for your help.
Dave

Hi Kiran,

The site speed initially improved a few weeks ago but it’s happening again unfortunately.

I increased the max execution time again but nothing improved. I’ve now got the site in maintenance mode and because of the coronavirus outbreak, we have virtually no traffic to our site. So it’s a good opportunity to understand what’s causing spikes on our server CPU.

I asked the support team at my hosting provider (Guru), and they explained the following:

“I can see that this is still being limited by MySQL governor due to excessive resource usage.

Based on the command line tool for this, I can see your database queries alone appeared to be using 2 CPU cores at one stage.

At the time this resource consumption was taking place, I found the following query running which I believe is the same as the query mentioned previously by my colleague Mike.

==================================
SELECT ( SELECT GROUP_CONCAT( DISTINCT CONCAT( DATE_FORMAT( wp_geodir_event_schedule.start_date, ‘%d%m%y’ ), ”, DATE_FORMAT( wp_geodir_event_schedule.end_date, ‘%d%m%y’ ) ) ) FROM wp_geodir_event_schedule WHERE ( ( ( ‘2020-03-01’ BETWEEN start_date AND end_date ) OR (start_date BETWEEN ‘2020-03-01’ AND end_date ) ) AND ( ( ‘2020-03-31’ BETWEEN start_date AND end_date ) OR ( end_date BETWEEN start_date AND ‘2020-03-31’ ) ) ) AND wp_geodir_event_schedule.event_id = wp_posts.ID ) AS schedules FROM wp_posts LEFT JOIN wp_geodir_gd_event_detail ON wp_geodir_gd_event_detail.post_id = wp_posts.ID LEFT JOIN wp_geodir_event_schedule ON wp_geodir_event_schedule.event_id = wp_posts.ID WHERE 1=1 AND wp_posts.post_type = ‘gd_event’ AND ((wp_posts.post_status = ‘publish’)) AND wp_geodir_gd_event_detail.post_id > 0 AND ( ( ( ‘2020-03-01’ BETWEEN start_date AND end_date ) OR ( start_date BETWEEN ‘2020-03-01’ AND end_date ) ) AND ( ( ‘2020-03-31’ BETWEEN start_date AND end_date ) OR ( end_date BETWEEN start_date AND ‘2020-03-31’ ) ) ) ORDER BY wp_posts.post_date DESC
==================================

Given that the site is in maintenance mode, it may be possible that the cron is triggering this query in some way.”

Do you know why the above command line might be causing these spikes? And if so, what can be done to fix it?

I’m guessing that those PHP undefined variables you mentioned before, won’t be causing this now, seen as the site is in maintenance mode and no traffic.

Please can you help?

Dave

I see. Thanks Alex.

I’ve seen that it’s possible to exclude certain categories on certain packages. So is it possible to set a default category in the settings somewhere? Then I can just exclude it on the lower packages.

Thanks,
Dave