My host has taken my site down because of too much My SQL activity. I think someone (or the updated plug in) is running a bunch of queries against my event calendar. I can’t access the site to fix it at the moment. But if they give me permission again, what do I look for or do? (Not a Techie). <\/p>\n
Here is the log file they sent… Can you help me troubleshoot what’s going on??<\/p>\n
CPU_TIME:456 table_rows_read:29111888 SELECTS:9343 ROWS_UPDATED:0 ROWS_FETCHED:349729 BUSY_TIME:479 ONNECTED_TIME:619 BYTES_SENT:67330790 BYTES_RECEIVED:1619016 WAIT_TIME:23<\/p>\n
Top table row reads:
\nDB_USER: pseybold_bbmeusa — TOTAL_CONNECTIONS: 67 — CONNECTED_TIME: 619 — CPU_TIME: 456 — TABLE_ROW_READS: 29111888 — SELECT_COMMANDS: 9344 — UPDATE_COMMANDS: — BUSY_TIME: 479 — BYTES_SENT: 67330790 — BYTES_RECEIVED: 1619121 — WAIT_TIME (IO): 23<\/p>\n
Top WAIT (IO) TIME:
\nDB_USER: pseybold_bbmeusa — TOTAL_CONNECTIONS: 67 — CONNECTED_TIME: 619 — CPU_TIME: 456 — TABLE_ROW_READS: 29111888 — SELECT_COMMANDS: 9344 — UPDATE_COMMANDS: — BUSY_TIME: 479 — BYTES_SENT: 67330790 — BYTES_RECEIVED: 1619121 — WAIT_TIME (IO): 23<\/p>\n
pseybold 75727 10.0 0.1 343316 53948 ? SN 11:03 0:01 \/opt\/php54\/bin\/php-cgi \/home2\/pseybold\/public_html\/index.php
\npseybold 76317 11.0 0.0 310456 20484 ? SN 11:03 0:00 \/opt\/php54\/bin\/php-cgi \/home2\/pseybold\/public_html\/index.php<\/p>\n
Wed Nov 16 11:03:22 CST 2016
\nRunning Processes:
\npseybold 75727 10.0 0.1 343316 53948 ? SN 11:03 0:01 \/opt\/php54\/bin\/php-cgi \/home2\/pseybold\/public_html\/index.php
\npseybold 76317 14.0 0.0 316708 26616 ? RN 11:03 0:00 \/opt\/php54\/bin\/php-cgi \/home2\/pseybold\/public_html\/index.php<\/p>\n
Running Queries:
\n*************************** 1. row ***************************
\n USER: pseybold_bbmeusa
\n DB: pseybold_boothbay
\n STATE: Sending data
\n TIME: 0
\nCOMMAND: Query
\n INFO: SELECT option_name, option_value FROM bbr_options WHERE autoload = ‘yes’
\n*************************** 2. row ***************************
\n USER: pseybold_bbmeusa
\n DB: pseybold_boothbay
\n STATE: Copying to tmp table
\n TIME: 0
\nCOMMAND: Query
\n INFO: SELECT SQL_CALC_FOUND_ROWS DISTINCT bbr_posts.*, MIN(bbr_postmeta.meta_value) as EventStartDate, MIN(tribe_event_end_date.meta_value) as EventEndDate FROM bbr_posts INNER JOIN bbr_postmeta ON ( bbr_posts.ID = bbr_postmeta.post_id ) LEFT JOIN bbr_postmeta as tribe_event_end_date ON ( bbr_posts.ID = tribe_event_end_date.post_id AND tribe_event_end_date.meta_key = ‘_EventEndDate’ ) WHERE 1=1 AND (
\n bbr_postmeta.meta_key = ‘_EventStartDate’
\n) AND bbr_posts.post_type = ‘tribe_events’ AND (bbr_posts.post_status = ‘publish’ OR bbr_posts.post_status = ‘tribe-ea-success’ OR bbr_posts.post_status = ‘tribe-ea-failed’ OR bbr_posts.post_status = ‘tribe-ea-schedule’ OR bbr_posts.post_status = ‘tribe-ea-pending’ OR bbr_posts.post_status = ‘tribe-ea-draft’) AND (bbr_postmeta.meta_value >= ‘2016-11-16 17:03:22’ OR (bbr_postmeta.meta_value <= ‘2016-11-16 17:03:22’ AND tribe_event_end_date.meta_value >= ‘2016-11-16 17:03:22’ )) GROUP BY bbr_posts.ID ORDER BY EventStartDate ASC, bbr_posts.post_date ASC LIMIT 0, 7<\/p>\n","protected":false},"template":"","class_list":["post-1193305","topic","type-topic","status-closed","hentry"],"yoast_head":"\n