Hello Support,<\/p>\n
The server is reporting too many system resources being used. I have tweaked the calendar using the suggestions from other posts including caching, reducing the amount of posts being displayed. Tried a different view other than month view (week looks terrible!) so anything else is unacceptable. These tweaks have helped, but not quite there yet.<\/p>\n
We’ve been running this calendar for at least 3 years now. Is it possible that there are too many old entries that is causing the database to be slow and use too many resources? Is there a way to clean the database to get rid of past years events?<\/p>\n
Maybe the error log will point as to what exactly is slowing things down? Additional pointers in the right direction would be appreciated.<\/p>\n
Here is what the server spit out:
\nCPU_TIME:991 table_rows_read:70749375 SELECTS:10614 ROWS_UPDATED:9 ROWS_FETCHED:82667 BUSY_TIME:1180 ONNECTED_TIME:1284 BYTES_SENT:11366112 BYTES_RECEIVED:2136277 WAIT_TIME:189<\/p>\n
Top table row reads:
\nDB_USER: csvac_wrdp1 — TOTAL_CONNECTIONS: 110 — CONNECTED_TIME: 1284 — CPU_TIME: 991 — TABLE_ROW_READS: 70749376 — SELECT_COMMANDS: 10615 — UPDATE_COMMANDS: — BUSY_TIME: 1180 — BYTES_SENT: 11366112 — BYTES_RECEIVED: 2136329 — WAIT_TIME (IO): 189<\/p>\n
Top WAIT (IO) TIME:
\nDB_USER: csvac_wrdp1 — TOTAL_CONNECTIONS: 110 — CONNECTED_TIME: 1284 — CPU_TIME: 991 — TABLE_ROW_READS: 70749376 — SELECT_COMMANDS: 10615 — UPDATE_COMMANDS: — BUSY_TIME: 1180 — BYTES_SENT: 11366112 — BYTES_RECEIVED: 2136329 — WAIT_TIME (IO): 189<\/p>\n
csvac 706823 10.0 0.2 292920 44940 ? SN 21:59 0:01 \/opt\/php71\/bin\/php-cgi \/home\/csvac\/public_html\/index.php
\ncsvac 706912 9.1 0.2 292920 44932 ? SN 21:59 0:00 \/opt\/php71\/bin\/php-cgi \/home\/csvac\/public_html\/index.php
\ncsvac 706920 10.1 0.2 292532 44188 ? SN 21:59 0:00 \/opt\/php71\/bin\/php-cgi \/home\/csvac\/public_html\/index.php<\/p>\n
Tue Nov 28 21:59:36 CST 2017
\nRunning Processes:
\ncsvac 706823 10.0 0.2 292920 44940 ? SN 21:59 0:01 \/opt\/php71\/bin\/php-cgi \/home\/csvac\/public_html\/index.php
\ncsvac 706912 9.1 0.2 292920 44932 ? SN 21:59 0:00 \/opt\/php71\/bin\/php-cgi \/home\/csvac\/public_html\/index.php
\ncsvac 706920 10.1 0.2 292532 44188 ? SN 21:59 0:00 \/opt\/php71\/bin\/php-cgi \/home\/csvac\/public_html\/index.php<\/p>\n
Running Queries:
\n*************************** 1. row ***************************
\n USER: csvac_wrdp1
\n DB: csvac_wrdp1
\n STATE: Copying to tmp table
\n TIME: 2
\nCOMMAND: Query
\n INFO: SELECT
\n SQL_CALC_FOUND_ROWS *
\n FROM (
\n SELECT DISTINCT wp_posts.*, wp_postmeta.meta_value as EventStartDate, 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 (11116) AND (
\n wp_postmeta.meta_key = ‘_EventStartDate’
\n AND
\n (
\n ( mt1.meta_key = ‘_EventStartDate’ AND CAST(mt1.meta_value AS DATETIME) > ‘2016-11-30 09:30:00’ )
\n OR (
\n ( mt1.meta_key = ‘_EventStartDate’ AND CAST(mt1.meta_value AS DATETIME) = ‘2016-11-30 09:30:00’ )
\n AND mt1.post_id > 11116
\n )
\n )
\n AND
\n mt2.post_id IS NULL
\n) 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’) ORDER BY EventStartDate ASC, wp_posts.ID ASC
\n ) a
\n GROUP BY IF( post_parent = 0, ID, post_parent )
\n ORDER BY EventStartDate ASC
\n LIMIT 0, 1
\n*************************** 2. row ***************************
\n USER: csvac_wrdp1
\n DB: csvac_wrdp1
\n STATE: Sending data
\n TIME: 1
\nCOMMAND: Query
\n INFO: SELECT meta_value
\n FROM wp_postmeta m
\n INNER JOIN wp_posts p ON p.ID=m.post_id
\n AND ( p.post_parent=10482 OR p.ID=10482 )<\/p>\n
WHERE meta_key = ‘_EventStartDate’
\n AND post_type = ‘tribe_events’
\n AND post_status NOT IN ( ‘inherit’, ‘auto-draft’, ‘trash’ )<\/p>\n
ORDER BY meta_value ASC
\n*************************** 3. row ***************************
\n USER: csvac_wrdp1
\n DB: csvac_wrdp1
\n STATE: Copying to tmp table
\n TIME: 2
\nCOMMAND: Query
\n INFO: SELECT
\n SQL_CALC_FOUND_ROWS *
\n FROM (
\n SELECT DISTINCT wp_posts.*, wp_postmeta.meta_value as EventStartDate, 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 (12386) AND (
\n wp_postmeta.meta_key = ‘_EventStartDate’
\n AND
\n (
\n ( mt1.meta_key = ‘_EventStartDate’ AND CAST(mt1.meta_value AS DATETIME) > ‘2017-06-24 13:00:00’ )
\n OR (
\n ( mt1.meta_key = ‘_EventStartDate’ AND CAST(mt1.meta_value AS DATETIME) = ‘2017-06-24 13:00:00’ )
\n AND mt1.post_id > 12386
\n )
\n )
\n AND
\n mt2.post_id IS NULL
\n) 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’) ORDER BY EventStartDate ASC, wp_posts.ID ASC
\n ) a
\n GROUP BY IF( post_parent = 0, ID, post_parent )
\n ORDER BY EventStartDate ASC
\n LIMIT 0, 1<\/p>\n
Open connections<\/p>\n
Current Site Requests:<\/p>\n","protected":false},"template":"","class_list":["post-1397019","topic","type-topic","status-closed","hentry"],"yoast_head":"\n