Update multi-site install now brings server down with high SQL load
I updated the events calendar plugin, community events and calendar PRO. but when I active the PRO on the /calendar site, the whole server comes crashing down. This happened three times when I tried to activate the Events Calendar PRO plugin after update.
We only run the calendar on one site within the multisite and I checked the knowlege base (https://theeventscalendar.com/knowledgebase/multisite-license/) and it said that the personal license is sufficient if you are willing to do manual updates.
Updated PRO from 4.3.3 to 4.4.19
Hosting company has the issue was ….” caused by high load on server from queries like…..
| 151146 | eareachm_zig | localhost | eareachm_wpmulti | Query | 1754 | Sending data | SELECT
MIN( `coo | 0 | 54971622 | 54971622 |
| 151158 | eareachm_zig | localhost | eareachm_wpmulti | Query | 1751 | Sending data | SELECT
MIN( `coo | 0 | 54893804 | 54893804 |
| 151191 | eareachm_zig | localhost | eareachm_wpmulti | Query | 1744 | Sending data | SELECT
MIN( `coo | 0 | 53784322 | 53784322 |
| 151416 | eareachm_zig | localhost | eareachm_wpmulti | Query | 1709 | Sending data | SELECT
The are 35302 entries in the posts table.
Ran this query and got all the posttypes:
SELECT post_type, count(post_type) FROM
WHERE 1 group by post_type
the post_meta table has 50435 entries.
Not sure what else you might need. The PRO plugin is current disabled
I’m sorry (and surprised!) to hear that.
The fragment you shared points a finger at our geolocation query, which is used to figure out the appropriate ‘bounding box’ for map view (so that the map is zoomed in to the relevant part of the world).
This should only run within map view – so your note that it takes down your site as soon as Events Calendar PRO is activated is rather alarming. Did you mean that quite literally – ie, the very instant you activate it things crash?
Who is your host and what sort of hosting package are you currently using (if you prefer not to disclose this publicly, please make use of our private reply facility).
That is not a small number of events … are there any that you could potentially delete (old events that are no longer relevant to your users, for instance)?
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
Just wanted to share with you that a new maintenance release (for the Week of 7th January 2018) is out, including a fix for this issue :slightly_smiling_face:
Find out more about this release → https://theeventscalendar.com/maintenance-release-week-7-january-2018/
Please update the plugins and let us know if the fix works for your site,
Thank you for letting me know about the recent update.
I installed the latest version of the calendar pro and am still experiencing performance issue when I activate the calendar events PRO.
The Events Calendar: 18.104.22.168
The Events Calendar: Community Events: 4.5.8
The Events Calendar PRO: Version 4.4.22
Again, not right away, but access to the site slows over a 2-3 minutes and then become unresponsive.
I have been deleteing past events. we are not at 7,700 events.
Can you tell me if this is only an issue with the multi-site installs?
If there is anything else I can provide to help resolve this, please let me know.
What we found when we investigated this was that the query you referenced was running far more frequently than necessary. The change we made was to restrict this so that it would run less often, reducing the net impact.
However, the query itself remains essentially the same and it may be that this still presents a problem in some hosting environments, even if it does run only infrequently.
I’ve re-opened a bug ticket about this so we can take another look.
Just wanted to share with you that a new maintenance release (for the Week of 5 March 2018) is out, including a fix for this issue
Please update the plugins and let us know if the fix works for your site.