Worrying Performance issue: Long Queries

[nilskau]

Hey there,
One of my clients sites has slowed down considerably – to the point that it is a problem. We noticed a lot of database queries & CPU being at 100% capacity…on a dedicated server with 2 cores and almost no traffic on the site.
After investigating, we found that these issues come from an Events Calendar issue:

Fri Oct 17 20:03:38 2014] [error] [client 66.162.212.19] LONG QUERY (1028 characters long generated in /nas/wp/www/cluster-2250/hipica/wp-content/plugins/the-events-calendar/lib/tribe-event-query.class.php:841):

That’s only one example – there are many more in the error log.

We also moved the site to WPengine, to test. They helped us again to investigate the problem, and also came to the conclusion that Events Calendar is the reason for queries and performance issues. The support technician further told me, that these performance issues of Events Calendar are well known at WPengine.

We do not have many events, maybe 60 & none re-occurring.

Please help

Thanks

Nils

P.s.: Otherwise, the plugin is fantastic & I really love it!!!

[Barry]

Hi there nilskau,

I’m stoked to hear you love the plugin, but naturally we’re a bit concerned about the problem you’ve reported.

Thanks also for including so much information straight away, particularly about the number of events on your site and the fact that you experienced this with almost no traffic.

Fri Oct 17 20:03:38 2014] [error] [client 66.162.212.19] LONG QUERY (1028 characters long generated in /nas/wp/www/cluster-2250/hipica/wp-content/plugins/the-events-calendar/lib/tribe-event-query.class.php:841):

That’s only one example – there are many more in the error log.

The first thing I am wondering is if all or most of the errors/warnings relate to the same LONG QUERY issue?

We also moved the site to WPengine, to test. They helped us again to investigate the problem, and also came to the conclusion that Events Calendar is the reason for queries and performance issues.

You’ve obviously spent some time troubleshooting and so may very well have done this, but I’d just like to be sure: did you find the same performance issues surfaced even with no other plugins and only a stock theme (such as Twenty Fourteen) running?

The reason I ask is that other plugins – and some themes – may modify queries which, on occasion, can have unintended consequences.

 

[Barry]

Hi there nilskau,

I just wanted to check in and see if you have had an opportunity to explore that last point (about the potential for a conflict with another plugin or with your theme)?

[Barry]

Hi! It’s been a while so I’m going to go ahead and close this thread. If we can help with anything else, though, please don’t hesitate to create new threads as needed. Thanks!

[Author]

Posts