[elementalhealing]

Hi Brendan,

Thankfully it was something simple…the plugin was deactivated, although
we can’t figure out how it happened and it occurred right after you did an
update.

Thanks for checking in with me!
Robyn

Robyn Albaum
Business Development & Marketing Manager

Contact me via text, email or phone:
(text and email preferred, then schedule a call):

*ON-SITE Hours: (appt. required)*

[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

[elementalhealing]

Barry, all is well, thank you! I found what was conflicting in my theme. Thank you for your help!

[elementalhealing]

Thank you, Barry! That did work, however, now the calendar won’t load the next month. Any idea why that would be?

[Author]

Posts