[Sonny Parlin]

You sir, are a steely-eyed missile man.

[Sonny Parlin]

This appears to have resolved the issue, or at least gave us some relief. Thanks!

[Sonny Parlin]

I’ve made the changes, I guess it’s wait and see time. Thanks for your help! I’m going to keep the issue open so I can post updates.

[Sonny Parlin]

Here is are the numbers:

View post on imgur.com

I’m not sure why we have so many drafts, but these are the numbers. Maybe have that query exclude drafts?

[Sonny Parlin]

I figured out what the problem was. I had made some changes to the mini calendar in a previous version by creating tribe-events/widgets/mini-calendar-widget.php in my theme’s directory. I forgot all about it, and when I upgraded, that problem came about.

[Sonny Parlin]

Okay I’ve narrowed it down to having something to do with my theme… not sure what yet, but I set up my development environment and disabled all the plugins and the problem was still there. However using it with 2012, the plugin widget works. So I’m currently trying to sort through my functions.php file to see what could be causing the issue. ANy suggestions of specific things to look for would be great. For instance, what was causing this bug on your end before you guys fixed it? That might help me as I wade through 2k+ lines of code in our functions.php file.

[Sonny Parlin]

I left a comment with my system info, but it didn’t show up here… It will be VERY difficult for me to disable our plugins and try a default theme. Is it possible for you to look into this witout me doing that?

[Sonny Parlin]

URL
http://www.wggb.com
INSTALL KEYS
events-calendar-pro = 04cc4f657968be0c5b1951826b25e75a9dc7e609
WORDPRESS VERSION
3.8
PHP VERSION
5.3.2-1ubuntu4.22
PLUGINS
Add Link to Facebook version 1.195 by Marcel Bokhorst(http://blog.bokhorst.biz/about/)
Admin Author Filter version 1.0.1 by Don Kukral(http://yourdomain.com)
Akismet version 2.5.9 by Automattic(http://automattic.com/wordpress-plugins/)
Better Excerpt version 0.2.1 by Sue Bailey(http://blogmum.com)
CloudFlare version 1.3.11 by Ian Pye, Jerome Chen, James Greene (CloudFlare Team)
Comment Filter version 1.0.0 by William Long, Whoo(http://www.williamlong.info)
Configure SMTP version 3.1 by Scott Reilly(http://coffee2code.com)
Custom sidebars version 1.3.1 by WPMUDEV(http://premium.wpmudev.org/)
EmbedIt Pro by SuperThemes version 1.11(http://www.superthemes.org)
The Events Calendar PRO version 3.3 by Modern Tribe, Inc.(http://m.tri.be/20)
Formidable version 1.07.02 by Strategy11(http://strategy11.com)
Frontend Uploader version 0.6 by Rinat Khaziev, Daniel Bachhuber(http://digitallyconscious.com)
Google Analytics Popular Posts version 1.1.8 by koichiyaima(http://yaima.sakuraweb.com/)
Google XML Sitemaps v3 for qTranslate version 3.2.9 by DSmidgy, NeoEGM, Arne Brachhold(http://blog.slo-host.com/)
Image Widget version 4.0.8 by Modern Tribe, Inc.(http://m.tri.be/26)
Jetpack by WordPress.com version 2.7 by Automattic(http://jetpack.me)
JSON API version 1.1.1 by Dan Phiffer(http://phiffer.org/)
Mobile Gallery version 1.0.2 by Raygun(http://madebyraygun.com)
Official StatCounter Plugin version 1.6.5 by Aodhan Cullen(http://statcounter.com/)
Page Peel version 0.3 by Nemanja Avramovic(http://www.avramovic.info/)
Post Editor Buttons Fork version 2.3 by Kailey Lampert(http://kaileylampert.com)
Post Expirator version 2.1.1 by Aaron Axelsen(http://postexpirator.tuxdocs.net/)
Really Simple Twitter Feed Widget version 2.4.9 by WhileTrue(http://www.whiletrue.it/)
Related Posts by Category version 0.9.1 by Sergej Müller(http://www.wpSEO.org)
Safe Report Comments version 0.3.2 by Thorsten Ott, Daniel Bachhuber, Automattic(http://automattic.com)
SoundCloud Shortcode version 2.3 by SoundCloud Inc.(http://soundcloud.com)
Speedy Page Redirect version 0.4.1 by Geert De Deckere(http://geertdedeckere.be/)
Subscribe to Comments Reloaded version 2.0.6 by camu, Reedyseth and andreasbo
The Events Calendar version 3.3 by Modern Tribe, Inc.(http://m.tri.be/1x)
TimThumb Vulnerability Scanner version 1.53 by Peter Butler(http://codegarage.com/)
Twitter Widget Pro version 2.6.0 by Aaron D. Campbell(http://ran.ge/)
Urban Push version 1.0.3 by Sonny Parlin(http://sonnyparlin.com)
URL Shortener version 4.0.2 by Gerald Yeo(http://www.fusedthought.com)
User Photo version 0.9.5.2 by Weston Ruter
User Spam Remover version 0.9.1 by Joel Hardi(http://lyncd.com/)
ManageWP – Worker version 3.9.28 by ManageWP(http://managewp.com)
WP Content Filter version 2.33 by David Gwyer(http://www.presscoders.com)
WP-EMail version 2.61 by Lester ‘GaMerZ’ Chan(http://lesterchan.net)
WP-Optimize version 1.5.6 by Ruhani Rabin(http://www.ruhanirabin.com)
WP to Twitter version 2.7.7 by Joseph Dolson(http://www.joedolson.com/)
WPeMatico version 1.1.8 by etruel (http://www.netmdp.com)
NETWORK PLUGINS
–
MU PLUGINS
–
THEME
WGGB
MULTISITE
–
SETTINGS
disable_metabox_custom_fields = hide
previous_ecp_versions =
Array
(
[0] => 0
[1] => 2.0.11
[2] => 2.0.11
[3] => 3.0
[4] => 3.0.1
[5] => 3.0.2
[6] => 3.0.3
)
latest_ecp_version = 3.3
welcome_notice = 1
displayedPressTrendsDialogue = 1
donate-link =
viewOption = month
eventsSlug = community-calendar
singleEventSlug = community-calendar
postsPerPage = 15
showComments =
multiDayCutoff = 12:00
embedGoogleMaps = 1
embedGoogleMapsHeight = 350
embedGoogleMapsWidth = 100%
embedGoogleMapsZoom = 10
sendPressTrendsData = 1
debugEvents =
tribeEventsTemplate = fullpage.php
tribeEventsBeforeHTML = POST YOUR EVENT
tribeEventsAfterHTML =
defaultValueReplace = 1
eventsDefaultOrganizerID = 0
eventsDefaultVenueID = 0
eventsDefaultAddress =
eventsDefaultCity =
eventsDefaultState = MA
eventsDefaultProvince =
eventsDefaultZip =
defaultCountry =
eventsDefaultPhone =
tribeEventsCountries =
recurring_events_are_hidden = exposed
liveFiltersUpdate = 1
hideSubsequentRecurrencesDefault =
userToggleSubsequentRecurrences =
showEventsInMainLoop =
defaultCurrencySymbol = $
geoloc_default_geofence = 25
geoloc_default_unit = miles
organizer_venue_amalgamation = 1

[Sonny Parlin]

Like everything, I have to run this by the powers that be, but hopefully I’ll get to set this up and I’ll get back to you. The site as a whole handles the traffic fine, notwithstanding large spikes in traffic (i.e. the boston marathon bombings) but even then we didn’t go down. I think as the calendar entries grow the queries are getting larger and are taking longer. Perhaps we could work together to figure out how to make the queries work better for larger scale sites. But doing so will certainly be easier once the calendar is isolated…

[Sonny Parlin]

Okay here’s what I’m thinking… I’m thinking about possibly setting up another web server (we have two right now and one database server). This new server could host the events calendar and it could be isolated with it’s own database. The only hardship I could see would be moving the existing calendar events (for which we have many) from our current server to the new one. This would free me up to try your suggestions and would also isolate the calendar so if a problem like this gets caused it won’t take down the entire site (which is what has been happening). Also, we likely won’t need many of the plugins we have installed now to just host the calendar. Any thoughts on moving the existing events?

I think doing this would be a better option for us because even if I were to set up a staging environment, it wouldn’t be under nearly the same load as the production server, which in my opinion would be taking away one of the major factors associated with the issue. The average on any given day is roughly 25k visitors and 73k pageviews.

[Sonny Parlin]

I can’t really try that on this site as it’s a large production site for a local news station in Mass. I’m not sure what changing the theme would have to do with the query being generated. Do you know where this particular query comes from?

[Sonny Parlin]

Boom, that worked! Thanks so much!

[Author]

Posts