Calendar is Timing Out and Overloading the Server

[elementalhealing]

From my website developer:

We’ve been exploring the report from host gator and within your hosting account and it looks like the Events Calendar plugin is having a timeout issue so it’s loading the server.

Can you tell me how to resolve this issue?

Thanks,
Robyn

[Barry]

Hi Robyn,

I’m sorry to hear that 🙁

Are there any other specifics that Hostgator’s support team might have shared with your developer that you can forward to us?

Often, hosts are able to pinpoint specific database queries that are causing problems, for instance, which is really helpful on our end.

Beyond that, can you give me an approximate idea of how many events you currently have?

Thanks!

[elementalhealing]

I tried to respond with the link provided in the email and it says “Address not Found.” Here is my email…

Hi Barry,

We have TONS of ongoing events from the time we started using Events Calendar Pro plugin around Dec. 2013. And, we have grown since then. I really have no way to count them all, but if you take a peek at our calendar on our website you will get a better feel; http://www.ElementalHealingCharlotte.com. I have always felt it took while to move from one month to the next, but this is different and is a much bigger problem.

I am pasting the email (from Nov. 29th) with all the data from Host Gator below which does show the calendar issue. Am I forced to upgrade to a dedicated server because of the server bloat?

Please let me know asap!

Thank you.
Robyn (for Margaret Wyche)

Hello,

Unfortunately, we have been forced to temporarily restrict access to MySQL for ralbaum on gator3070.hostgator.com. Please take a moment to review this email in full as it contains important information and resources to assist you in resolving this issue. Please note that while this restriction is temporary, you should take actions to resolve the issue(s) which may have caused it in order to avoid further down-time/permanent restrictions.

– How can you resolve the issue?
We have two solutions available. Moving the account to a dedicated server, which will allow far greater hardware resources or you may try following the basic recommendations for optimizing your database. If you feel your database has already been optimized, it may simply be time to consider the hardware upgrade. http://support.hostgator.com/articles/specialized-help/technical/optimize-mysql-resource-usage

– Why did this happen?
Per our terms of service (http://www.hostgator.com/tos) a single hosting account may use no more than 25% of the entire server’s resources. Accounts are typically not actively restricted until they exceed those resource limitations exceptionally. Unfortunately, in this instance, we were forced to place a temporary restriction on your user to prevent service issues with the server’s over-all system performance. For more information about resource usage limitations, please see:https://support.hostgator.com/articles/pre-sales-policies/rules-terms-of-service/account-limits-summary

Please reply to this email once you have determined a resolution to this issue.

CPU_TIME:1137 table_rows_read:43115682 SELECTS:9743 ROWS_UPDATED:0 ROWS_FETCHED:149311 BUSY_TIME:1200 ONNECTED_TIME:1368 BYTES_SENT:33101190 BYTES_RECEIVED:2017641 WAIT_TIME:63

Top table row reads:
DB_USER: ralbaum_wrdp1 — TOTAL_CONNECTIONS: 118 — CONNECTED_TIME: 1368 — CPU_TIME: 1137 — TABLE_ROW_READS: 43115682 — SELECT_COMMANDS: 9745 — UPDATE_COMMANDS: — BUSY_TIME: 1200 — BYTES_SENT: 33101190 — BYTES_RECEIVED: 2017809 — WAIT_TIME (IO): 63

Top WAIT (IO) TIME:
DB_USER: ralbaum_wrdp1 — TOTAL_CONNECTIONS: 118 — CONNECTED_TIME: 1368 — CPU_TIME: 1137 — TABLE_ROW_READS: 43115682 — SELECT_COMMANDS: 9745 — UPDATE_COMMANDS: — BUSY_TIME: 1200 — BYTES_SENT: 33101190 — BYTES_RECEIVED: 2017809 — WAIT_TIME (IO): 63

ralbaum 175052 10.8 0.1 343452 64916 ? SN 10:48 0:01 /opt/php54/bin/php-cgi /home3/ralbaum/public_html/index.php
ralbaum 175386 17.1 0.1 343516 65000 ? SN 10:48 0:01 /opt/php54/bin/php-cgi /home3/ralbaum/public_html/index.php
ralbaum 175615 27.0 0.1 343524 64760 ? SN 10:48 0:01 /opt/php54/bin/php-cgi /home3/ralbaum/public_html/index.php
ralbaum 175699 47.5 0.1 343332 64744 ? SN 10:48 0:00 /opt/php54/bin/php-cgi /home3/ralbaum/public_html/index.php
ralbaum 175771 62.0 0.1 329032 50068 ? RN 10:48 0:00 /opt/php54/bin/php-cgi /home3/ralbaum/public_html/index.php

Wed Nov 29 10:49:00 CST 2017
Running Processes:
ralbaum 175052 10.8 0.1 343452 64916 ? SN 10:48 0:01 /opt/php54/bin/php-cgi /home3/ralbaum/public_html/index.php
ralbaum 175386 17.1 0.1 343516 65000 ? SN 10:48 0:01 /opt/php54/bin/php-cgi /home3/ralbaum/public_html/index.php
ralbaum 175615 27.0 0.1 343524 64760 ? SN 10:48 0:01 /opt/php54/bin/php-cgi /home3/ralbaum/public_html/index.php
ralbaum 175699 47.5 0.1 343332 64744 ? SN 10:48 0:00 /opt/php54/bin/php-cgi /home3/ralbaum/public_html/index.php
ralbaum 175771 77.0 0.1 336920 57732 ? RN 10:48 0:00 /opt/php54/bin/php-cgi /home3/ralbaum/public_html/index.php

Running Queries:
*************************** 1. row ***************************
USER: ralbaum_wrdp1
DB: ralbaum_wrdp1
STATE:
TIME: 0
COMMAND: Sleep
INFO: NULL
*************************** 2. row ***************************
USER: ralbaum_wrdp1
DB: ralbaum_wrdp1
STATE: Copying to tmp table
TIME: 1
COMMAND: Query
INFO: SELECT SQL_CALC_FOUND_ROWS DISTINCT wp_posts.*, MIN(wp_postmeta.meta_value) as EventStartDate, MIN(tribe_event_end_date.meta_value) as EventEndDate FROM wp_posts LEFT JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) LEFT JOIN wp_postmeta AS mt1 ON ( wp_posts.ID = mt1.post_id ) LEFT JOIN wp_postmeta AS mt2 ON (wp_posts.ID = mt2.post_id AND mt2.meta_key = ‘_EventHideFromUpcoming’ ) 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.ID NOT IN (4521) AND (
wp_postmeta.meta_key = ‘_EventStartDate’
AND
(
( mt1.meta_key = ‘_EventStartDate’ AND CAST(mt1.meta_value AS DATETIME) < ‘2015-09-17 19:00:00’ )
OR (
( mt1.meta_key = ‘_EventStartDate’ AND CAST(mt1.meta_value AS DATETIME) = ‘2015-09-17 19:00:00’ )
AND mt1.post_id < 4521
)
)
AND
mt2.post_id IS NULL
) AND wp_posts.post_type = ‘tribe_events’ AND (wp_posts.post_status = ‘publish’ OR wp_posts.post_status = ‘tribe-ea-success’ OR wp_posts.post_status = ‘tribe-ea-failed’ OR wp_posts.post_status = ‘tribe-ea-schedule’ OR wp_posts.post_status = ‘tribe-ea-pending’ OR wp_posts.post_status = ‘tribe-ea-draft’) GROUP BY wp_posts.ID ORDER BY EventStartDate DESC, wp_posts.ID DESC LIMIT 0, 1
*************************** 3. row ***************************
USER: ralbaum_wrdp1
DB: ralbaum_wrdp1
STATE: Copying to tmp table
TIME: 2
COMMAND: Query
INFO: SELECT SQL_CALC_FOUND_ROWS DISTINCT wp_posts.*, MIN(wp_postmeta.meta_value) as EventStartDate, MIN(tribe_event_end_date.meta_value) as EventEndDate FROM wp_posts LEFT JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) LEFT JOIN wp_postmeta AS mt1 ON ( wp_posts.ID = mt1.post_id ) LEFT JOIN wp_postmeta AS mt2 ON (wp_posts.ID = mt2.post_id AND mt2.meta_key = ‘_EventHideFromUpcoming’ ) 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.ID NOT IN (4933) AND (
wp_postmeta.meta_key = ‘_EventStartDate’
AND
(
( mt1.meta_key = ‘_EventStartDate’ AND CAST(mt1.meta_value AS DATETIME) < ‘2016-03-05 09:00:00’ )
OR (
( mt1.meta_key = ‘_EventStartDate’ AND CAST(mt1.meta_value AS DATETIME) = ‘2016-03-05 09:00:00’ )
AND mt1.post_id < 4933
)
)
AND
mt2.post_id IS NULL
) AND wp_posts.post_type = ‘tribe_events’ AND (wp_posts.post_status = ‘publish’ OR wp_posts.post_status = ‘tribe-ea-success’ OR wp_posts.post_status = ‘tribe-ea-failed’ OR wp_posts.post_status = ‘tribe-ea-schedule’ OR wp_posts.post_status = ‘tribe-ea-pending’ OR wp_posts.post_status = ‘tribe-ea-draft’) GROUP BY wp_posts.ID ORDER BY EventStartDate DESC, wp_posts.ID DESC LIMIT 0, 1
*************************** 4. row ***************************
USER: ralbaum_wrdp1
DB: ralbaum_wrdp1
STATE: Copying to tmp table
TIME: 0
COMMAND: Query
INFO: SELECT SQL_CALC_FOUND_ROWS DISTINCT wp_posts.*, MIN(wp_postmeta.meta_value) as EventStartDate, MIN(tribe_event_end_date.meta_value) as EventEndDate FROM wp_posts LEFT JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) LEFT JOIN wp_postmeta AS mt1 ON ( wp_posts.ID = mt1.post_id ) LEFT JOIN wp_postmeta AS mt2 ON (wp_posts.ID = mt2.post_id AND mt2.meta_key = ‘_EventHideFromUpcoming’ ) 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.ID NOT IN (6335) AND (
wp_postmeta.meta_key = ‘_EventStartDate’
AND
(
( mt1.meta_key = ‘_EventStartDate’ AND CAST(mt1.meta_value AS DATETIME) < ‘2016-09-14 18:00:00’ )
OR (
( mt1.meta_key = ‘_EventStartDate’ AND CAST(mt1.meta_value AS DATETIME) = ‘2016-09-14 18:00:00’ )
AND mt1.post_id < 6335
)
)
AND
mt2.post_id IS NULL
) AND wp_posts.post_type = ‘tribe_events’ AND (wp_posts.post_status = ‘publish’ OR wp_posts.post_status = ‘tribe-ea-success’ OR wp_posts.post_status = ‘tribe-ea-failed’ OR wp_posts.post_status = ‘tribe-ea-schedule’ OR wp_posts.post_status = ‘tribe-ea-pending’ OR wp_posts.post_status = ‘tribe-ea-draft’) GROUP BY wp_posts.ID ORDER BY EventStartDate DESC, wp_posts.ID DESC LIMIT 0, 1
*************************** 5. row ***************************
USER: ralbaum_wrdp1
DB: ralbaum_wrdp1
STATE: Copying to tmp table
TIME: 2
COMMAND: Query
INFO: SELECT SQL_CALC_FOUND_ROWS DISTINCT wp_posts.*, MIN(wp_postmeta.meta_value) as EventStartDate, MIN(tribe_event_end_date.meta_value) as EventEndDate FROM wp_posts LEFT JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) LEFT JOIN wp_postmeta AS mt1 ON ( wp_posts.ID = mt1.post_id ) LEFT JOIN wp_postmeta AS mt2 ON (wp_posts.ID = mt2.post_id AND mt2.meta_key = ‘_EventHideFromUpcoming’ ) 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.ID NOT IN (7323) AND (
wp_postmeta.meta_key = ‘_EventStartDate’
AND
(
( mt1.meta_key = ‘_EventStartDate’ AND CAST(mt1.meta_value AS DATETIME) > ‘2017-01-12 18:45:00’ )
OR (
( mt1.meta_key = ‘_EventStartDate’ AND CAST(mt1.meta_value AS DATETIME) = ‘2017-01-12 18:45:00’ )
AND mt1.post_id > 7323
)
)
AND
mt2.post_id IS NULL
) AND wp_posts.post_type = ‘tribe_events’ AND (wp_posts.post_status = ‘publish’ OR wp_posts.post_status = ‘tribe-ea-success’ OR wp_posts.post_status = ‘tribe-ea-failed’ OR wp_posts.post_status = ‘tribe-ea-schedule’ OR wp_posts.post_status = ‘tribe-ea-pending’ OR wp_posts.post_status = ‘tribe-ea-draft’) GROUP BY wp_posts.ID ORDER BY EventStartDate ASC, wp_posts.ID ASC LIMIT 0, 1

Open connections

Current Site Requests:
157.55.39.130 elementalhealingcharlotte.com /event/ec-sessions-wmarcela-john-mcbride/2015-03-26/
157.55.39.130 elementalhealingcharlotte.com /event/exploring-eden-energy-techniques-weva-gourley-2016-0
157.55.39.130 elementalhealingcharlotte.com /event/exploring-eden-energy-techniques-weva-gourley/2016-0
157.55.39.130 elementalhealingcharlotte.com /event/family-addiction-small-group-wward-blanchard-3-2015-
157.55.39.130 elementalhealingcharlotte.com /event/tai-chi-beginners-wnigel-barnes/2016-08-04/
157.55.39.130 elementalhealingcharlotte.com /event/tai-chi-wmaster-nigel-barnes/2017-01-03/
157.55.39.255 elementalhealingcharlotte.com /event/family-addiction-small-group-wward-blanchard-4/2016-
157.55.39.255 elementalhealingcharlotte.com /event/family-addiction-workshop-wward-christina-blanchard-
157.55.39.255 elementalhealingcharlotte.com /event/fear-friend-foe-wmakeda-pennycooke/
157.55.39.255 elementalhealingcharlotte.com /event/internal-family-services-training-wthe-center-for-se
157.55.39.255 elementalhealingcharlotte.com /event/laughter-yoga-whoward-carver-2/2015-10-22/
157.55.39.255 elementalhealingcharlotte.com /event/massage-therapy-continuing-ed-waimee-taylor/2016-03-
157.55.39.255 elementalhealingcharlotte.com /event/meditation-101-wcarol-baccile-2/
157.55.39.255 elementalhealingcharlotte.com /event/messages-heaven-2hr-medium-demonstration-show-wtamar
157.55.39.255 elementalhealingcharlotte.com /event/messages-heaven-2hr-medium-demonstration-show-wtamar
157.55.39.255 elementalhealingcharlotte.com /event/qigong-wyadi-alamin-2016-11-06/2017-10-29/
157.55.39.255 elementalhealingcharlotte.com /event/tai-chi-beginners-wnigel-barnes/2017-09-14/
157.55.39.255 elementalhealingcharlotte.com /event/taoist-qigong-meetup-wyadi-alamin-2-2015-02-06-2017-
157.55.39.45 elementalhealingcharlotte.com /event/community-pranic-healing-meditation-wpranic-healing-
157.55.39.45 elementalhealingcharlotte.com /event/empowerment-group-wkristen-oliver-2/2017-01-12/
157.55.39.45 elementalhealingcharlotte.com /event/tai-chi-beginners-wnigel-barnes-2017-05-11/2017-08-1
157.55.39.45 elementalhealingcharlotte.com /event/tai-chi-wmaster-nigel-barnes/2017-05-02/
157.55.39.45 elementalhealingcharlotte.com /event/tai-chi-wmaster-nigel-barnes/2017-12-07/
157.55.39.45 elementalhealingcharlotte.com /event/take-your-heart-to-work-peer-support-specialist-trai
207.46.13.164 elementalhealingcharlotte.com /event/empath-course-empowering-light-within-wed-carlton/20
207.46.13.164 elementalhealingcharlotte.com /event/empath-course-empowering-light-within-wed-carlton/20
207.46.13.164 elementalhealingcharlotte.com /event/private-event-wmargaret-wyche-2/2017-01-02/
207.46.13.164 elementalhealingcharlotte.com /event/tai-chi-wmaster-nigel-barnes/2017-04-13/
207.46.13.164 elementalhealingcharlotte.com /event/tai-chi-wmaster-nigel-barnes/2017-06-27/
207.46.13.164 elementalhealingcharlotte.com /event/taoist-qigong-meetup-wyadi-alamin-2-2015-02-06/2017-
207.46.13.164 elementalhealingcharlotte.com /event/taoist-qigong-meetup-wyadi-alamin-2-2015-02-06/2017-

Reference: ui
Server: gator3070.hostgator.com
Brand: hostgator
Srv. Type: cpanel
Created: Wed Sep 4 18:50:41 2013
Acct Type: Shared
Plan: Hatchling
User: ralbaum
U. Domain: elementalhealingcharlotte.com
Email: [email protected]
IP: 198.57.241.130 (shared)

Doc Root: /home3/ralbaum/public_html
Shell: /usr/local/cpanel/bin/jailshell

Malware: Most recent quarantined content: Mon Feb 27 05:45:23 2017
CPU Usage: 151.8% (warning)

Cpu Time hit 1137 > 450

Current load: 10:49:03 up 158 days, 10:19, 0 users, load average: 0.08, 0.02, 0.00

[Barry]

That’s certainly a pretty busy looking calendar.

I can’t access your system information – there seem to be problems with your WordPress installation not being able to connect to the database so I can only see the first page of month view which happens to have been cached already.

Assuming the lack of a database connection is temporary, here are some immediate steps you can look into:

• Login, visit Events ‣ Settings ‣ Display and enable month view caching —
  this is an additional layer of caching that would compliment the work your dedicated caching plugin is doing
• Delete as many events as you can! If you have lots of historic events and they aren’t important to the success of your site/generally go unseen by visitors, it could be worth purging them

Beyond that, it’s hard to do a thorough assessment because I can’t see just how many posts (that is, the total number of blog posts, pages, events and other post types) you have and don’t know what sort of traffic you are receiving … but it could be you’ve reached the point where you need to scale up in some way, perhaps to the next package your hosting provider offers that will give you more resources.

[Support Droid]

Hey there! This thread has been pretty quiet for the last three weeks, so we’re going to go ahead and close it to avoid confusion with other topics. If you’re still looking for help with this, please do open a new thread, reference this one and we’d be more than happy to continue the conversation over there.

Thanks so much!
The Events Calendar Support Team

[Author]

Posts