Forum Replies Created
-
Posts
-
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.
It 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?
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: @tonefoxIs 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?
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?
A PayPal addon for those of us monetizing our calendars would be great. Also, “copy” a current event so if we have a multi-day event that the recurrence function won’t let us do, we can just copy that event and change the date(s). This is especially helpful if an event runs 2 days, then skips a day, runs 2 days again, etc.
Do you have any plans for PayPal integration on community events? I have one category that people need to pay for but currently need custom coding to achieve this.
I haven’t actually seen this functionality for an event calendar anywhere, you would be the first. However, for those of us running large sites with local events, it would be SUPER amazing to have. Then we wouldn’t have to mess with entering everything in by hand. I’ve seen this function on database importing but not using a calendar.
