Long Running Queries Crashing My SQL Database

[pseybold]

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).

Here is the log file they sent… Can you help me troubleshoot what’s going on??

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

Top table row reads:
DB_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

Top WAIT (IO) TIME:
DB_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

pseybold 75727 10.0 0.1 343316 53948 ? SN 11:03 0:01 /opt/php54/bin/php-cgi /home2/pseybold/public_html/index.php
pseybold 76317 11.0 0.0 310456 20484 ? SN 11:03 0:00 /opt/php54/bin/php-cgi /home2/pseybold/public_html/index.php

Wed Nov 16 11:03:22 CST 2016
Running Processes:
pseybold 75727 10.0 0.1 343316 53948 ? SN 11:03 0:01 /opt/php54/bin/php-cgi /home2/pseybold/public_html/index.php
pseybold 76317 14.0 0.0 316708 26616 ? RN 11:03 0:00 /opt/php54/bin/php-cgi /home2/pseybold/public_html/index.php

Running Queries:
*************************** 1. row ***************************
USER: pseybold_bbmeusa
DB: pseybold_boothbay
STATE: Sending data
TIME: 0
COMMAND: Query
INFO: SELECT option_name, option_value FROM bbr_options WHERE autoload = ‘yes’
*************************** 2. row ***************************
USER: pseybold_bbmeusa
DB: pseybold_boothbay
STATE: Copying to tmp table
TIME: 0
COMMAND: Query
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 (
bbr_postmeta.meta_key = ‘_EventStartDate’
) 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

[Cliff]

Yikes! Sorry you’re experiencing this.

This isn’t currently a known issue so I’d suggest following these recommended troubleshooting steps for your own site:

There might be some new updates available. Could you please make sure all your Modern Tribe plugins (and WordPress core) are at their latest versions?

• Downloads / Version Numbers
• License Keys
• TEC Automatic Updates
• or TEC Manual Updates
• WordPress core updates

Once you verify you’re on the latest versions, please test to see if the issue is still happening for you.

If it is, please follow our Testing for Conflicts Guide (basically switch to Twenty Sixteen theme and deactivate all plugins and custom code other than Modern Tribe plugins) and see if that helps narrow down the cause of this.

If it doesn’t, please enable WP_DEBUG and WP_DEBUG_LOG and share any debug messages you see while changing tickets quantity, navigating your site’s home page, events page, single-event pages, and any other of your site’s pages relevant to this ticket.

Then, please share your System Information (while in Testing for Conflicts Mode). That will give me a lot of extra information to help diagnose the problem.

You might also see if you can spot any console errors at your site. (If needed, you may reference our KB article Using Google Chrome Developer Tools.)

Let us know what you find out.

Thanks.

[pseybold]

My host gave me access to my site again. I have updated the Standard Events Calendar to the 4.3.3 and the Events Pro PlugIn is 4.3.1.1 Everything seems to be working but I don’t know how to check to see whether a bot is running queries against my database.

[Cliff]

That’s good news.

4.3.3 is the latest for both the core plugin and the PRO add-on plugin. You should update PRO to its latest version. You should also make sure you’re running the latest version of WordPress.

• Downloads / Version Numbers
• TEC Automatic Updates
• or TEC Manual Updates
• WordPress core updates

It’s hard to tell if this is your issue or not, but, once you verify you’re on the latest versions, please do strongly consider trying the fix for runaway recurring events (a bug introduced in version 4.2.2 and fixed within a few days via version 4.2.2.1).

You can reference these code snippets to help determine if this is your problem and how to go about resolving it in your database:

• tribe-extension-recurring-cleanup.zip (Recurring Events fixer plugin wp-admin page preview) (make a database backup first)

Please let me know how it goes for you.

[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