Jetpack Sync running 800s+ SQL queries

  • Resolved rocketsportsnetwork

    (@rocketsportsnetwork)


    9 months, 1 week ago

    I noticed some 800+ second queries in my MySQL slow log monitoring, and tracked them down to a couple classes/functions in the Automattic\Jetpack\Sync\Replicastore namespace.

    I believe it’s the Table_Checksum::build_checksum_query() function causing what I’m seeing, but it may also be Table_Checksum_Users::build_checksum_query(). The function runs a query that starts “SELECT SUM( CRC32( CONCAT_WS(” and this is what’s sometimes taking over 800 seconds to run.

    I don’t know what “Jetpack Sync” is, or why it’s enabled by default, or why it thinks it’s a good idea to try and checksum entire tables like this, or why there’s no control to disable it in the settings, but if it’s nothing to do with stats collection (which is all we use/need Jetpack for) then I’d very much appreciate if you could let me know how I can disable it, please.

    The page I need help with: [log in to see the link]

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Support Erina (a11n)

    (@eri32s98)

    Hi @rocketsportsnetwork, Jetpack Sync is a tool that keeps your site’s data in sync with WordPress.com for features like Stats, related content, and others.

    I notice that the site is using an outdated version of Jetpack, could you first update it to the latest version 13.1.3?

    If there are still issues after the update, then try the following:

    • Turn off any Jetpack feature modules that you don’t need (see guide)
    • Start a manual sync under the WordPress.com dashboard, Settings → Manage your connection → Data synchronization, then click on “initiate a sync manually”.
    Plugin Support Tamirat B. (a11n)

    (@tamirat22)

    Hello @rocketsportsnetwork,

    Do you have any updates? We usually close inactive threads after one week of no activity, but we want to make sure we’re all set before marking it as solved. Thanks!

    Thread Starter rocketsportsnetwork

    (@rocketsportsnetwork)

    Sorry, I’ve had a lot on and haven’t had chance to dive back in to this yet, but do still intend to.

    Plugin Support Tamirat B. (a11n)

    (@tamirat22)

    Hi there again!

    It’s been more than a week since this topic was last updated. I’m going to mark this thread as solved. If you have any further questions or need more help, you’re welcome to open another thread here. Cheers!

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Jetpack Sync running 800s+ SQL queries’ is closed to new replies.