Massive Increase in CPU usage and slow queries caused by Events Ca lander plugin

[Mike]

We have most recent versions of Events calander and Events Calander Pro installed, same for WP version.
We are getting slammed with a large number of slow queries.
We use a managed WordPress hosting provider. They have warned us about a large number of slow queries being logged due to The Events Calander plugin.
We used New Relic site monitoring and find The Events Calander (free part) is taking 3 times as long as the nearest resource. Then The Events calander Pro plugin adds even more usage.
We have used this plugin since 2013, and I would hate to delete it.
Any idea on how to bring down usage. Any way to disable features that cause the load.
This issue likely related to discussion, https://theeventscalendar.com/support/forums/topic/high-cron-usage/

The queries are likely driven by crons that happen every 15 and 30 minutes.

+——————————————-+———————+———————–+————+
| hook | next_run_gmt | next_run_relative | recurrence |
+——————————————-+———————+———————–+————+
| tribe_events_pro_process_recurring_events | 2018-08-16 21:14:46 | 6 minutes 54 seconds | 30 minutes |
| tribe_aggregator_process_insert_records | 2018-08-16 21:16:39 | 8 minutes 47 seconds | 15 minutes |
+——————————————-+———————+———————–+————+

$ wp cron event list
+——————————————-+———————+———————–+————+
| hook | next_run_gmt | next_run_relative | recurrence |
+——————————————-+———————+———————–+————+
| tribe_events_pro_process_recurring_events | 2018-08-16 21:14:46 | 6 minutes 54 seconds | 30 minutes |
| tribe_aggregator_process_insert_records | 2018-08-16 21:16:39 | 8 minutes 47 seconds | 15 minutes |

[Victor]

Hi Mike!

Thanks for getting in touch with us!

We apologize for a bit of delay in getting back to you. We are dealing with a high volume of threads at the moment and we are slowly getting back to normal response times.

I’m sorry to hear you are having performance issues. Let me try to help you with that.

We are getting slammed with a large number of slow queries.

Could you please provide more information about these slow queries you are getting? Are they happening on a specific page view of your site?

How many events, venues and organizers do you currently have? Can you also specify how many recurring events you have?

It seems your system information did not go through correctly, could you please copy and paste your latest system information in a private reply? We’ll see if there is anything strange that would indicate an error from there.

As a reference, we have a great article that will get you started on Performance Considerations you should know about. After that, if you decide to implement a caching system then you can move to these articles: Caching: What, when and how and Caching month view HTML in transients

There is a good article George put up here that groups a set of developer plugins. It’s a bit more technical than the others but will definitely be of help if you are into development.

Please let us know about that.

Thanks,
Victor

[Support Droid]

Hey there! This thread has been pretty quiet for the last three weeks, so we’re going to go ahead and close it to avoid confusion with other topics. If you’re still looking for help with this, please do open a new thread, reference this one and we’d be more than happy to continue the conversation over there.

Thanks so much!
The Events Calendar Support Team

[Author]

Posts