CPU load issues sometimes bringing down the server.

[Christian Bishop]

We are running into some CPU load issues that seam to be caused by the events calendar.

We are running New Relic on the server and it seams to be always indicating that the events calendar is causing the load and delays just before the server becomes become unavailable. Please see attached.

~3500 events in the system.

We have tried reducing recurrence creation months but it doesn’t seam to be solving the issue. We have also tried turning of the lazy cron in favour of running wp-cron with crontab.

On the database end it seams that the slowest repeat queries are also coming from the events calendar. They look like this:
SELECT SQL_CALC_FOUND_ROWS * FROM (SELECT DISTINCT wp_posts.*, wp_postmeta.meta_value AS EventStartDate, tribe_event_end_date.meta_value AS EventEndDate FROM wp_posts LEFT JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) LEFT JOIN wp_postmeta AS mt? ON ( wp_posts.ID = mt?.post_id ) LEFT JOIN wp_postmeta AS mt? ON (wp_posts.ID = mt?.post_id AND mt?.meta_key = ? ) LEFT JOIN wp_postmeta AS tribe_event_end_date ON ( wp_posts.ID = tribe_event_end_date.post_id AND tribe ……..

Is there currently any know issues with the plugin and CPU load?
Is there any thing else we can change in the settings to prevent this high cpu load issue?
Can we defer the recurrence creation to a set time of day?

[Andras]

Hello Christian,

Thanks for using our plugins and welcome to the forums!

I’m sorry to hear about the CPU load issues you are having. Let me try to help you with that.

When are you experiencing the heavy CPU loads, at what action? Is it when visitors browse events or when you are doing something on the admin side?

Maybe some of these you are familiar with, nonetheless I’d recommend the following readings that are performance related:

• Caching Basics – https://theeventscalendar.com/knowledgebase/caching-basics/
• Caching Month View Transients – https://theeventscalendar.com/knowledgebase/caching-month-view-transients/
• The Events Calendar Performance Considerations – https://theeventscalendar.com/the-events-calendar-performance-considerations/

Could you also share 1-2 full queries that seem to be causing the slowness? That will give us something to start with.

Thanks and cheers,
Andras

[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