- This topic has 11 replies, 2 voices, and was last updated 11 years, 9 months ago by
.
-
Posts
-
Since last night the events calendar has been sending 100s of the queries below which is crashing mysql server and bringing with it down all my blogs and websites. anyone know what might be causing it? I just disabled the pro plugin to see if that helps.
| 342484 | bucket248am | localhost | wordpress_wp | Query | 5313 | Removing duplicates | SELECT SQL_CALC_FOUND_ROWS DISTINCT wp_posts.*, IF (wp_posts.post_type = ‘tribe_events’, wp_postmeta.meta_value, wp_posts.post_date) AS post_date, tribe_event_end_date.meta_value as EventEndDate FROM wp_posts LEFT JOIN wp_postmeta as wp_postmeta on wp_posts.ID = wp_postmeta.post_id AND wp_postmeta.meta_key = ‘_EventStartDate’ LEFT JOIN wp_postmeta as tribe_event_end_date ON ( wp_posts.ID = tribe_event_end_date.post_id AND tribe_event_end_date.meta_key = ‘_EventEndDate’ ) WHERE 1=1 AND (((wp_posts.post_title LIKE ‘%a?%’) OR (wp_posts.post_content LIKE ‘%a?%’))) AND (wp_posts.post_password = ”) AND wp_posts.post_type IN (‘post’, ‘page’, ‘attachment’, ‘tribe_events’, ‘tribe_venue’) AND (wp_posts.post_status = ‘publish’) GROUP BY IF( wp_posts.post_parent = 0, wp_posts.ID, wp_posts.post_parent ) ORDER BY wp_posts.post_title LIKE ‘%a?%’ DESC, post_date DESC LIMIT 5040, 10
Hi: sorry to hear you are hitting problems.
Did this coincide with anything like a recent update to our plugins/which versions are you currently using?
I’m on the latest version of Events Calendar and Events Calendar Pro. I think I updated them both a few days ago but mysql just started crashing last night because of all the queries. I disabled Events Calendar Pro earlier today and rebooted my server and haven’t faced a single issue since. I’ve been checking my database processes and not of the crash causing queries were coming up so I’ve come to the conclusion something in the last update of Events Calendar Pro is causing these queries.
Hmm – and to confirm, this happens even if no other plugins besides The Events Calendar/Events Calendar PRO are active (and with just a default theme in place)? Are there any particular operations such as searches you are conducting that seem to lead to it?
No I can’t confirm that since there is no way I can disable all my plugins and change my theme to the default one since I runny a pretty busy and active blog. What I can confirm is nothing new was done and just randomly it started sending these queries. By disabling the pro version of the plugin the problem stopped.
btw, my theory is it has something to do with reoccurring events has to do with this issue. Sorry I shouldnt have said nothing new was done in my previous response. two new things were done:
1) a few days before the plugin upgrade i added one reoccurring event
2) i updted the plugin to the latest version once it was releasedOK, that’s unfortunate. We are actively looking at ways to improve performance (including the performance of database queries) and we hope that you will see these improvements develop with each successive release.
Right now I don’t think there’s actually a lot we can do here in the short term: is it possible instead for you to speak to your hosting provider and look at moving to a plan that offers more power/greater resources?
Well I don’t think it’s related to my power/resources. I’ve got a server with Rackspace and 8GB of RAM and the fact of the matter is everything was working fine before and the amount of queries the plugin was sending I’m guessing is beyond normal. The only thing I can guess is that maybe it has to do with the fact i’m using php 5.2. Not sure if that makes a difference but can’t think of any other reason.
OK: did you find any connection between these incidents and certain activities/operations? For instance, did you find this only occurred when you/someone else entered the admin environment, or was it upon sorting the list of events, or anything of that order? If we could get a handle on what is triggering this that would be awesome.
i’m traveling tomorrow for a few days, once i get back what i will do is activate the pro plugin again and try and see what might have caused the issue. Hopefully I will figure it out and let you know.
- The topic ‘Events Calendar overloading mysql server since last night’ is closed to new replies.