Slow Queries

[Jimmy]

Seeing just a massive amount of Slow Queries with this plugin… See from my mySQL slow-query logs below:

# Time: 151021 18:01:29
# Query_time: 10.045758  Lock_time: 0.000102 Rows_sent: 3  Rows_examined: 1697540
SET timestamp=1445464889;
SELECT  DISTINCT wp__posts.*, IF (wp__posts.post_type = 'tribe_events', wp__postmeta.meta_value, wp__posts.post_date) AS post_date FROM wp__posts  INNER JOIN wp__term_relationships ON (wp__posts.ID = wp__term_relationships.object_id) LEFT JOIN wp__postmeta as wp__postmeta on wp__posts.ID = wp__postmeta.post_id AND wp__postmeta.meta_key = '_EventStartDate' WHERE 1=1   AND wp__posts.ID NOT IN (48386) AND ( 
  wp__term_relationships.term_taxonomy_id IN (2,8,200,255,787,1316,3125,10434)
) AND wp__posts.post_type IN ('post', 'tribe_events') AND (wp__posts.post_status = 'publish') AND wp__posts.post_status != 'private'  GROUP BY wp__posts.ID ORDER BY post_date DESC LIMIT 0, 3;

I’ve changed my prefix to protect the innocent etc… These are just over and over again (every minute or every 5 minutes). It is (sometimes) a high-traffic site, but obviously there’s a bottleneck where it comes to this plugin.

We’re running 8 Cores and 8 GB of RAM on a Centos VPS, php 5.5, nginx… The site/server is geared towards handling a lot of traffic. All my slow queries has tribe_events… Any suggestions?

[Brian]

Hi,

Thanks for using our plugins. I can help out here.

Is this coming from loading the Community Events Pages itself or the other views such as month view?

Have you enabled the Month View cache here:

Events > Settings > Display Tab > “Enable the Month View Cache”

If not does enabling that help?

And how large is your post table? How many entries are in it?

Let me know and we can go from here.

Thanks

[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