High SQL Usage

[Brad Mitchell]

My host will no longer allow to me use The Events Calendar due to high SQL usage. See their message below. What can be done to resolve this so I can continue to use your plugin?

The query they mention is very expensive and is run on probably hundreds of posts at once. The query is getting lat and long coordinates. Maps only appear on single event pages. If this expensive query must exist, it should only be run on single event page for one post only.

---

Here is your MySQL usage for the past few hours: http://take.ms/Q3Rgn
So far, this peak has lasted for over 4 hours.

On average a regular account with WP websites use around 0.01~0.02 where your account usage is 1.66 which means you are much over the average. Your MySQL usage with this plugin disabled is less than 0.01.

We will also attach the currently SQL query (as a txt file) which is running non stop while the usage is extremely high.

We cannot allow this to continue any further.

We have disabled your plugin for the last time.

Here is another screenshot of the MySQL usage for the past hour after we have disabled the plugin: http://take.ms/Tb8BM

[Barry]

Hi Brad,

I’m sorry this has caused you problems.

We can’t restrict it quite in the way you suggested, because the query doesn’t relate to the single event view maps (rather it is used to calculate the initial bounding box used in map view).

You’re right, though, it’s running far more frequently than it should and that’s a problem. We have a high priority bug ticket logged for this however and will get a fix out as quickly as we can.

I appreciate your support and patience in the meantime… while I realize this is less than ideal if you were to temporarily deactivate Events Calendar PRO that would mitigate this problem and you could continue to run The Events Calendar itself.

[Brad Mitchell]

I upgraded to the latest version of the pro plugin that was released yesterday. I compared queries using the Query Monitor plugin before and after upgrading. I no longer see the expensive query previously mentioned, so this appears to have been resolved. Please confirm.

[Barry]

Hi Brad,

The query you referenced hasn’t gone — but yes we did some work in relation to this and it will run much less frequently. From our changelog:

* Tweak - Made the caching of Map View's geofence data more consistent 
  in terms of when it invalidates; this should improve performance (props 
  to many users reporting details of this issue in the forums!) [93177]

Let me know if you have any further questions on this 🙂

[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