Site Slows to Crawl Since Upgrade(s)

[Andy]

Since enabling/updating 3.12+ and including 4.0 we’re experience extreme site performance issues with the plugin installed.

How can we troubleshoot this with your actual team? We’ve experienced this on a number of sites and we have to stop pushing the plugin to our clients with then performance problems.

Perhaps there’s some form of direct clean up you recommend for MySQL? I’m at a loss and think we need direct support here – ideally to find the issue and correct it now and anytime we run into it in the future.

[Cliff]

This reply is private.

[Andy]

This reply is private.

[Brook]

Howdy Andy,

Thanks you very much for detailing everything in the video.

When you say you are updating to 3.12+, what version are you coming from? There are some known slow downs in Month view since around version 3.9. Most of them have been rectified since then in 3.10+. However, we still have a couple of optimizations we are investigating. The reason the slowdowns happened in the first place is because our old code was hard to maintain and bug prone. So we made a conscious choice to improve stability even if it cost some speed, but have been working to improve speed also so that hopefully the tradeoff becomes moot.

Calendars, especially ones running atop WP_Query as WP Custom Post Types, have extremely complex queries. There is no getting around this. However, we have spent countless hundreds of hours optimizing our plugin to be as fast as possible. We spent nearly the entirety of 2014 improving speed. And so I want to set your expectation early on that there is probably no silver bullet to your speed problem. You might just need a faster server, typically just a faster database server. The more events and posts on your site, the faster the server needed.

As you have no doubt gathered we take performance very seriously. And I am not saying we are perfect, on occassion we still find areas for optimization and we tackle those when they come up.

I see you have the debug bar enabled. Does this mean you have SAVEQUERIES set to true? If so, can you try disabling that? As notied in that link savequeries has a fair performance impact on your site, and actually might whats slowing you down here. Can you also try temporarily disabling any other performance monitoring configs or plugins you have? Most of them tend to slow things down a fair bit. Does that help?

If not, does your webhost offer you access to any sort of MySQL profiling? If so, can you share the logs with us?

Cheers!

– Brook

[Andy]

This reply is private.

[Cliff]

Hi Andy.

Thanks for the additional details. I relayed this thread to our developers and they asked for additional information before they take a deeper look into it:

How many events do you have on this site?

How many recurring events do you have (approximate if you don’t have exact)?

Please grab your system information and paste it here. Make sure to use the “Set as private reply” checkbox to protect your private information from the public.

You can find the system info by going to WP Admin > Events > Settings, clicking on the “Help” tab, and scrolling down to the “System Information” box. (Or by going to [yoursite]/wp-admin/edit.php?post_type=tribe_events&page=tribe-events-calendar&tab=help)

That will give me a lot of extra information to help diagnose the problem.

Thank you.

[Andy]

This reply is private.

[Cliff]

1)

With so many events and many of them being recurring, I looked for recurrenceMaxMonthsBefore and recurrenceMaxMonthsAfter from the sysinfo report. It seems your sysinfo report didn’t include all the information at wp-admin > Events > Settings > Help tab > System Information section. Maybe you could try re-sending it — or, at the least, specify what “Clean up recurring events after” and “Create recurring events in advance for” are set to?

Ideally, we’d like the entire sysinfo report if possible.

2)

Have you noticed the performance issue with all views (e.g. Month vs Day)?

3)

Have you noticed the performance issue in all time frames (e.g. current month, +1 month, -3 months, etc)?

I’m looking forward to hearing back from you.

[Andy]

This reply is private.

[Cliff]

This reply is private.

[Andy]

The Events Calendar is at 4.0.4
The Events Calendar Pro is at 4.0.3
WordPress is 4.4.1

That is the correct URL but we toggle the plugin off because it takes the entire site down and we have tons of marketing/campaigns running, not to mention the site helps power a lot of in-club displays.

I have updated the settings to 1 month for keeping events; creating events is set to 2 months. Hopefully this will clean A LOT up.

Let me know if saving the settings will purge the old events or if there is another method of purging?

[Andy]

As another note, I will leave the plugin on as long as I can today (3pm EST latest) to see if the site performance is ok now.

[Andy]

This reply is private.

[Cliff]

I’m glad a shorter timeframe will work for you. I expect that’ll clean things up significantly if your site’s been posting events for a while.

As far as purging, it will eventually happen. It relies on WP cron — so it should happen within 24 hours.

Obviously, that’s not going to fly for your needs. Maybe you could edit the cronjob (e.g. via https://wordpress.org/plugins/wp-crontrol/) to make it run more quickly. Please know this hasn’t been tested. If it does work for you, you might want to disable the crontrol plugin and then deactivate/reactivate all the Modern Tribe plugins in order to try to get the cronjobs back at regular intervals and overall fresh start.

Of course, restorable backups are recommended before proceeding. 😉

I hope this gets resolved quickly for you!

[krystalknapp]

My site also has slowed to a crawl. Disabling the calendar plugin is the only way to stop it. WPEngine error log shows errors from calendar. I will post a separate post on this, but here is just a snippet: [Fri Jan 08 03:44:05.291518 2016] [:error] [pid 6525] [client 24.165.16.203:59968] KILLED QUERY (35128 characters long generated in /nas/content/live/princeplanet/wp-content/plugins/the-events-calendar/src/Tribe/Query.php:980): SELECT SQL_CALC_FOUND_ROWS DISTINCT wp_posts.*, MIN(wp_postmeta.meta_value) as EventStartDate, MIN(tribe_event_end_date.meta_value) as EventEndDate FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) LEFT JOIN wp_postmeta as tribe_event_end_date ON ( wp_posts.ID = tribe_event_end_date.post_id AND tribe_event_end_date.meta_key = ‘_EventEndDate’ ) WHERE 1=1 AND wp_posts.ID IN (21279,22210,22211,22213,22214,22215,22316,22482,22601,22679,22691,22711,22713,22714,22715,22718,22720,22724,22728,22753,22802,22835,22850,22864,22936,22938,22939,22940,22941,22942,22943,22944,22945,22946,22947,22948,22949,22993,23012,23024,23034,23038,23070,23071,23072,23073,23074,23075,23076,23077,230

[Author]

Posts