- This topic has 15 replies, 3 voices, and was last updated 13 years ago by
.
-
Posts
-
I am having a problem on my site with getting the events page to come up. When I try to access, I’m getting a “502 bad gateway” error. The individual categories are coming up by not the main events/ page.
Not working: http://spokanekids.wpengine.com/events/
Working: http://spokanekids.wpengine.com/events/category/top-spokane-event-picks-for-kids/It is indeed a tad slow. How many events are currently in the system? Though I note you tried a few troubleshooting steps could I ask you to run through all of these steps in the first instance:
- Please ensure that your Modern Tribe plugins are up-to-date and in-synch … for instance if you are using The Events Calendar 2.0.11 you must also use Events Calendar PRO 2.0.11
- Deactivate all other plugins and change your theme to a default, unmodified one such as Twenty Eleven or Twenty Twelve
- Now test to see if the problem still exists
- If the problem has been solved by these steps, start reactivating everything one-at-a-time, testing at each point to see if the issue has returned
- If the issue does return, take note of whichever plugin (or theme) you reactivated immediately before it started again – it’s likely there is a conflict with this item
It may also be helpful to know what your permalink structure (you can find this in Settings > Permalinks) is set to.
Thanks!
It looks like this is related to the database. What tables should we remove to completely remove Tri.be from the db so we can reinstall?
The Events Calendar doesn’t create any new tables, it uses the existing WordPress schema. For example: events, venues and organizers all live in the posts table and typically there are associated entries in the postmeta table, too.
Generally speaking most entries can be identified in the posts table via the post_type column – if it belongs to our plugin(s) that entry will have a tribe_ prefix.
Is there a way to get a list of all of the tables the tribe plugin touches so we can write some delete statements to remove the data properly?
The options, posts, post meta, terms, term relationships and the term taxonomy tables will all potentially carry data relating to The Events Calendar.
If you are using add-ons such as Eventbrite Tickets then the user meta table may also contain data relating to that plugin.
Here is what my hosting company said. This is WPEngine.com, which is excellent hosting.
Hello Nicole,
We’ve narrowed down the issue regarding the database and the 502 errors you’ve been receiving per our conversation. The mysql is running a query that examined 925,574 rows of data in one time and 830,718 rows a second time all being presented for each click to the events section of your site. This is not including the normal functionalities of the theme and other plugins along with the additional selections from the user to the same events section. The slow query is listed below;
User@Host: spokanekids[spokanekids] @ localhost [127.0.0.1]
Thread_id: 1003388 Schema: wp_spokanekids Last_errno: 1292 Killed: 0
Query_time: 5.677365 Lock_time: 0.000176 Rows_sent: 10 Rows_examined: 925574 Rows_affected: 0 Rows_read: 10 SELECT SQL_CALC_FOUND_ROWS wp_posts., eventStart.meta_value as EventStartDate, IFNULL(DATE_ADD(CAST(eventStart.meta_value AS DATETIME), INTERVAL eventDuration.meta_value SECOND), eventEnd.meta_value) as EventEndDate FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) LEFT JOIN wp_postmeta as hideUpcoming ON( wp_posts.ID = hideUpcoming.post_id AND hideUpcoming.meta_key = ‘_EventHideFromUpcoming’) LEFT JOIN wp_postmeta as eventStart ON( wp_posts.ID = eventStart.post_id AND eventStart.meta_key = ‘_EventStartDate’) LEFT JOIN wp_postmeta as eventDuration ON( wp_posts.ID = eventDuration.post_id AND eventDuration.meta_key = ‘_EventDuration’) LEFT JOIN wp_postmeta as eventEnd ON( wp_posts.ID = eventEnd.post_id AND eventEnd.meta_key = ‘_EventEndDate’) WHERE 1=1 AND ( wp_term_relationships.term_taxonomy_id IN (35) ) AND wp_posts.post_type = ‘tribe_events’ AND (wp_posts.post_status = ‘publish’) AND (eventStart.meta_value > ‘2013-04-09 00:00:00’ OR (eventStart.meta_value = ‘2013-04-09 00:00:00’ )) AND (hideUpcoming.meta_value != ‘yes’ OR hideUpcoming.meta_value IS null) GROUP BY wp_posts.ID, eventStart.meta_value ORDER BY DATE(eventStart.meta_value) ASC, TIME(eventStart.meta_value) ASC LIMIT 0, 10 / From [spokanekids.wpengine.com/events/category/free/] in [/nas/wp/www/cluster-1271/spokanekids/index.php:17] */;
User@Host: spokanekids[spokanekids] @ localhost [127.0.0.1]
Thread_id: 1005398 Schema: wp_spokanekids Last_errno: 1292 Killed: 0
Query_time: 3.984592 Lock_time: 0.000221 Rows_sent: 10 Rows_examined: 830718 Rows_affected: 0 Rows_read: 10 use wp_spokanekids; SELECT SQL_CALC_FOUND_ROWS wp_posts., eventStart.meta_value as EventStartDate, IFNULL(DATE_ADD(CAST(eventStart.meta_value AS DATETIME), INTERVAL eventDuration.meta_value SECOND), eventEnd.meta_value) as EventEndDate FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) LEFT JOIN wp_postmeta as hideUpcoming ON( wp_posts.ID = hideUpcoming.post_id AND hideUpcoming.meta_key = ‘_EventHideFromUpcoming’) LEFT JOIN wp_postmeta as eventStart ON( wp_posts.ID = eventStart.post_id AND eventStart.meta_key = ‘_EventStartDate’) LEFT JOIN wp_postmeta as eventDuration ON( wp_posts.ID = eventDuration.post_id AND eventDuration.meta_key = ‘_EventDuration’) LEFT JOIN wp_postmeta as eventEnd ON( wp_posts.ID = eventEnd.post_id AND eventEnd.meta_key = ‘_EventEndDate’) WHERE 1=1 AND ( wp_term_relationships.term_taxonomy_id IN (75) ) AND wp_posts.post_type = ‘tribe_events’ AND (wp_posts.post_status = ‘publish’) AND (eventStart.meta_value > ‘2013-04-09 00:00:00’ OR (eventStart.meta_value = ‘2013-04-09 00:00:00’ )) AND (hideUpcoming.meta_value != ‘yes’ OR hideUpcoming.meta_value IS null) GROUP BY wp_posts.ID, eventStart.meta_value ORDER BY DATE(eventStart.meta_value) ASC, TIME(eventStart.meta_value) ASC LIMIT 0, 10 / From [spokanekids.wpengine.com/events/category/top-spokane-event-picks-for-kids/] in [/nas/wp/www/cluster-1271/spokanekids/index.php:17] */;
There is also an issue with the way the theme serves content on our platform. The Varnish Cache and Nginx process is being bypassed and not cached in the upper side on our server. The request are being served from Apache, which is considered the back end of the server, which is slower and appears to be another concern as to why the site is slow and the staging replicated the same issue as the live site.
At this time, the timeouts in the database are caused by the large request, if there is a way the plugin can be coded to optimize the query you will be in better shape. On our platform, there is no real way to improve this since we only support WordPress functionality and not custom plugins.
Hope this helps,
Tony Gilharry | WP Support Ninja
WPEngine – Finely Tuned WordPress
Twitter: @tonefoxIt looks like the reason the main calendar isn’t loading is the almost 1 million query requests on the server. Can you provide updated code that will work?
I’m also interested in finding a solution with the performance issue. I just installed the calendar over the weekend and am in the process of imputing events. I’ve noticed a slow in performance almost immediately after adding a handful of events. As of now I have less than 100 events, but will easily have 3-5k each year. I really want to transfer over to using EC instead of a google calendar, but am concerned about performance.
Yeah, if I were you, I’d wait to transfer things over unless this is addressed. I have thousands of events in there as I’ve been using the calendar since June 2012. The performance issue with queries seems to be an issue across the board for users. I didn’t notice it on my old host because I have a virtual private server but now moving to a performance server, this is a HUGE issue.
My understanding is that some performance improvements will be introduced in the next major release (3.0 – the stable release of which is hopefully not going to be much further away than 2 months).
If it helps we may be able to provide a copy of the 3.0 beta code for you to evaluate before that time. Although it isn’t production ready quite yet it might be useful as a means of confirming that the situation will improve in the near future. If that sounds like an option then please do email my colleague Rob (email address: rob at tri dot be), linking to this thread and he’ll take things from there.
Right now though I’m not sure there is a great deal we can do. There is probably room for improvement on our side (and, as above, that is in the works) but you do also need suitable hosting if you are handling a large number of events and the site is in demand.
Danielle: as per my above reply to Nicole it’s difficult to provide a great deal of advice here. I’m surprised to hear that you are experiencing performance issues with only 100 or so events, however.
Can you share any information about your web hosting package/if you have enabled any sort of caching to help with this?
Barry,
Thanks! I to was surprised to see a performance issue right off the bat, especially since so many other seem to be using it just fine. My hosting is through GoDaddy. I have not enabled any caching, not sure how to do that. Should I be enabling caching?I’d be interested in getting a copy of the Beta version of the 3.0 release of the calendar.
- The topic ‘SUPER SLOW LOADING’ is closed to new replies.