Home › Forums › Calendar Products › Events Calendar PRO › Update multi-site install now brings server down with high SQL load
- This topic has 10 replies, 6 voices, and was last updated 6 years ago by Support Droid.
-
AuthorPosts
-
November 8, 2017 at 7:02 am #1377900ellsworthamericanParticipant
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
MAX(coords
.lat
) ASmax_lat
,
MAX(coords
.lng
) ASmax_lng
,
MIN( `coo | 0 | 54971622 | 54971622 |
| 151158 | eareachm_zig | localhost | eareachm_wpmulti | Query | 1751 | Sending data | SELECT
MAX(coords
.lat
) ASmax_lat
,
MAX(coords
.lng
) ASmax_lng
,
MIN( `coo | 0 | 54893804 | 54893804 |
| 151191 | eareachm_zig | localhost | eareachm_wpmulti | Query | 1744 | Sending data | SELECT
MAX(coords
.lat
) ASmax_lat
,
MAX(coords
.lng
) ASmax_lng
,
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) FROMea_12_posts
WHERE 1 group by post_type
——————
“attachment”,”5453″
“nav_menu_item”,”29″
“page”,”5″
“post”,”4″
“revision”,”7621″
“sidebar”,”2″
“template”,”2″
“tribe_events”,”14282″
“tribe_filters”,”1″
“tribe_organizer”,”2037″
“tribe_venue”,”5865″
“wp_router_page”,”1″the post_meta table has 50435 entries.
Not sure what else you might need. The PRO plugin is current disabledhelp.
November 9, 2017 at 8:04 am #1379018BarryMemberHi Alan,
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).
“tribe_events”,”14282″
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)?
November 14, 2017 at 6:48 am #1382420ellsworthamericanParticipantThis reply is private.
November 14, 2017 at 7:24 am #1382453BarryMemberThanks Linda.
It turns out that a number of other users have also highlighted similar problems relating to the same query (again, following an update to 4.4.19).
We have a bug report filed and I’ll attach this topic so we can provide an update once a fix has been created.
December 6, 2017 at 8:35 am #1399484Support DroidKeymasterHey 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 TeamJanuary 26, 2018 at 7:53 am #1437016NicoMemberHi there,
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,
Best,
NicoJanuary 31, 2018 at 2:09 pm #1441104ellsworthamericanParticipantHello Nico,
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.
currently have:
Wordpress 4.9.2
The Events Calendar: 4.6.10.1
The Events Calendar: Community Events: 4.5.8
The Events Calendar PRO: Version 4.4.22Again, 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.
Thanks,
LindaFebruary 5, 2018 at 7:58 am #1444175BarryMemberHi Linda,
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.
March 8, 2018 at 1:46 pm #1473924VictorKeymasterHi Linda!
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
Find out more about this release → https://theeventscalendar.com/maintenance-release-week-5-march-2018/
Please update the plugins and let us know if the fix works for your site.
Best,
VictorMarch 30, 2018 at 9:35 am #1492911Support DroidKeymasterHey 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 -
AuthorPosts
- The topic ‘Update multi-site install now brings server down with high SQL load’ is closed to new replies.