Submission Form Maxing out CPU

Thanks Kiran, that’s been a big help. I’ve changed the max execution time to 45 seconds now instead and the site seems to be running much better.

As for those PHP notices, I’m not sure what they mean. Do undefined variables have an impact? And should I just go to Listimia theme about them and also AdRotate plugin?

Thanks,
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

Thanks Kiran. Is that what is causing the issue… the event calendar?

If I install the phpmyadmin plugin to wordpress, will that give you the access that you need?

Thanks,
Dave