Super Slow Queries in 3.12

[Ameet]

Hey Folks,
We were cruising for a while on 3.9 and after this update and enabling community-event-tickets, our site has slowed down by more than 50%.

SInce we added the plugins 6 days ago we’ve racked up almost 4000 slow queries similar to this:

| 2015-10-23 05:07:12 | x_root_nginx[xl_root_nginx] @  [xxx.xxx.xx.xxx] | 00:00:19   | 00:00:00  |         6 |        104741 | wp_xlr8r_nginx |              0 |         0 | 1171086832 | 
SELECT SQL_CALC_FOUND_ROWS  wp_posts.ID FROM wp_posts  WHERE 1=1  AND (((wp_posts.post_title LIKE '%TTC%') OR
(wp_posts.post_content LIKE '%TTC%')) AND ((wp_posts.post_title LIKE '%TE%') OR (wp_posts.post_content LIKE '%TE%')))  
AND (wp_posts.post_password = '')  AND wp_posts.post_type IN ('post', 'page', 'attachment', 'product', 'tribe_events', 
'tribe_venue') AND ((wp_posts.post_status = 'publish'))  ORDER BY wp_posts.post_date DESC LIMIT 0, 6

View post on imgur.com

View post on imgur.com

http://imgur.com/GFzPcRd (after we upgraded to 3.12 Oct 19)

View post on imgur.com

We have:
28,800 Posts
1250 Events
—–

I’ve looked all over your forums and have worked with some of your team members to get a beta ticketing our the door, but they have specifically mentioned that something has been identified on the core event-calendar plugin or pro and told me to hit you guys here for a solution. If there is something we can hack out until you get a proper patch, that would be super helpful.

We have disabled recurring events.
Deleting old events are not an option as we have promoters who want a record of all those past events.

Please advise, we’ve been looking for solutions for the past 5 days doing tests, but seems like there is some query that is triggering all these issues.

• This topic was modified 10 years, 5 months ago by Ameet.
• This topic was modified 10 years, 5 months ago by Ameet.
• This topic was modified 10 years, 5 months ago by Ameet.
• This topic was modified 10 years, 5 months ago by Geoff.

[Barry]

Hi Ameet,

Thanks for hitting us up here on the support forums and for your patience so far.

Unfortunately, I’m not actually sure what the source of the query you cited is. I do also realize you’ve been in communication with other team members, but having chatted to them about this I think there’s a possibility that some wires were crossed and this query/your performance issues may not have their origins in the same problem they were referring to.

Given the number of posts in your database I’ve no doubt those queries with their LIKE statements could be causing something of a burden and what I’d like to try and zero in on is the trigger and source of those queries:

• You specifically note enabling Community Tickets (a beta build) – do you find this problem vanishes if you deactivate it?
• Sometimes we find problematic queries are triggered only on certain pages or in response to certain requests … have you been able to identify any such patterns (is this query only executed in relation to event views, for instance, or does it run on every page load?)
• As an extension of the above, have you been able to run through our standard troubleshooting steps (on a staging/test site, perhaps)?
• I’d like to get a better picture of your site and its environment – the system information you provided when you created this topic is definitely useful (thanks for sharing!) but typically what we are interested in is the data described here … would it be possible for you to share this in a private reply?

Knowing you’ve already been discussing issues out of the forums I realize you will be especially keen to reach a speedy resolution – if we can run through the above steps and questions in the first instance we’ll hopefully be better placed to facilitate that 🙂

Thanks!

[Ameet]

This reply is private.

[Barry]

Hi Ameet,

Thanks for those extra details.

I do appreciate that the guys indicated the query was a known problem, but I’d again emphasize that there may have been a misunderstanding and this may not be the same query/problem they were thinking of.

With that in mind I feel it’s important we don’t neglect other possible causes — so working through the remainder of the questions I asked previously could definitely prove useful:

• Sometimes we find problematic queries are triggered only on certain pages or in response to certain requests … have you been able to identify any such patterns (is this query only executed in relation to event views, for instance, or does it run on every page load?)
• As an extension of the above, have you been able to run through our standard troubleshooting steps (on a staging/test site, perhaps)?

Would you be able to give those a shot and let me know how you get on?

[Barry]

Hi Ameet,

Just checking in here — did you have a chance to perform any further troubleshooting or were you able to notice patterns between the occurrence of the queries you highlighted and specific views or user actions?

Let me know if we can help further 🙂

[Ameet]

Hey Barry,
Thanks for checking back in. I’ve been on contact with Zach and know you finally release Community Events Tickets from out of beta, so I’ll be trying it out shortly.

I did do the steps to revert to 2013 theme and still saw some issues, but I’m now feeling it has to do something with woocommerce and memecached but also potentially Recurring events.

I’m still doing a bit of testing and research on my end and hoping that the new updates will rectify some of the issues we’ve been seeing.

Cheers,
ameet

[Barry]

Sounds good: I’ll leave this open and if any other information comes to light as you do further testing please do let us know and we’ll take things from there 🙂

[Support Droid]

This topic has not been active for quite some time and will now be closed.

If you still need assistance please simply open a new topic (linking to this one if necessary)
and one of the team will be only too happy to help.

[Author]

Posts