JILI888 app.Enjoy Free 888+200 Daily Legal Bonus

Resolved mindtakerminis
(@mindtakerminis)

1 year, 1 month ago
This is similar to another support topic, but mine does not seem to be clearing in the same way.

I’m getting a ton of errors similar to this

KILLED QUERY (20988 characters long generated in /nas/content/live/mindtaker/wp-content/plugins/jetpack/jetpack_vendor/automattic/jetpack-sync/src/sync-queue/class-queue-storage-options.php:129): SELECT option_name AS id, option_value AS value#012#011#011#011#011FROM wpyk_options#012#011#011#011#011WHERE option_name IN ( 'jpsq_sync-1696013296.501679-782389-99', 'jpsq_sync-1696013296.509450-782389-100', 'jpsq_sync-1696013296.586735-782389-101', 'jpsq_sync-1696013296.603349-782389-102', 'jpsq_sync-1696013296.610944-782389-103', 'jpsq_sync-1696013298.492661-782389-104', 'jpsq_sync-1696013298.592808-782389-105', 'jpsq_sync-1696013300.303438-782389-106', 'jpsq_sync-1696013300.310412-782389-107', 'jpsq_sync-1696013300.716941-782389-108', 'jpsq_sync-1696013300.790270-782389-109', 'jpsq_sync-1696013300.801083-782389-110', 'jpsq_sync-1696013301.700914-782389-111', 'jpsq_sync-1696013302.000363-782389-112', 'jpsq_sync-1696013302.007388-782389-113', 'jpsq_sync-1696013302.090711-782389-114', 'jpsq_sync-1696013302.100773-782389-115', 'jpsq_sync-1696013302.110346-782389-116', 'jpsq_sync-1696013302.116791-782389-117', 'jpsq_sync-1696013302.123589-782389-118', 'jpsq_sync-1696013302.192139-782389-119', 'jpsq_sync-1696013302.199513-782389-120', 'jpsq_sync-169601330

and it seems to be filling up the wpyk_options table pretty rapidly.

I’m at newest version of WP and Jetpack.

Status Report below

` WordPress Environment WordPress address (URL): https://www.mindtaker.org Site address (URL): https://www.mindtaker.org WC Version: 8.1.1 REST API Version: ? 8.1.1 WC Blocks Version: ? 10.9.3 Action Scheduler Version: ? 3.6.3 Log Directory Writable: ? WP Version: 6.3.1 WP Multisite: – WP Memory Limit: 512 MB WP Debug Mode: – WP Cron: ? Language: en_US External object cache: – Server Environment Server Info: nginx PHP Version: 8.0.30 PHP Post Max Size: 100 MB PHP Time Limit: 7200 PHP Max Input Vars: 10000 cURL Version: 7.81.0 OpenSSL/3.0.2 SUHOSIN Installed: – MySQL Version: 8.0.33-25 Max Upload Size: 50 MB Default Timezone is UTC: ? fsockopen/cURL: ? SoapClient: ? DOMDocument: ? GZip: ? Multibyte String: ? Remote Post: ? Remote Get: ? Database WC Database Version: 8.1.1 WC Database Prefix: wpyk_ Total Database Size: 3315.67MB Database Data Size: 2521.33MB Database Index Size: 794.34MB wpyk_woocommerce_sessions: Data: 20.02MB + Index: 0.13MB + Engine InnoDB wpyk_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wpyk_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wpyk_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB wpyk_woocommerce_order_items: Data: 12.52MB + Index: 3.52MB + Engine InnoDB wpyk_woocommerce_order_itemmeta: Data: 81.61MB + Index: 63.14MB + Engine InnoDB wpyk_woocommerce_tax_rates: Data: 0.05MB + Index: 0.06MB + Engine InnoDB wpyk_woocommerce_tax_rate_locations: Data: 0.05MB + Index: 0.03MB + Engine InnoDB wpyk_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpyk_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wpyk_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpyk_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wpyk_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wpyk_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_comments: Data: 0.02MB + Index: 0.08MB + Engine InnoDB wp_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_options: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_postmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_posts: Data: 0.02MB + Index: 0.06MB + Engine InnoDB wp_term_relationships: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_term_taxonomy: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_termmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_terms: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_usermeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_users: Data: 0.02MB + Index: 0.05MB + Engine InnoDB wpyk_actionscheduler_actions: Data: 23.05MB + Index: 25.14MB + Engine InnoDB wpyk_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wpyk_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wpyk_actionscheduler_logs: Data: 19.05MB + Index: 14.03MB + Engine InnoDB wpyk_adtribes_my_conversions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wpyk_atum_order_itemmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wpyk_atum_order_items: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wpyk_atum_product_data: Data: 3.52MB + Index: 1.25MB + Engine InnoDB wpyk_commentmeta: Data: 2.52MB + Index: 3.03MB + Engine InnoDB wpyk_comments: Data: 641.98MB + Index: 251.48MB + Engine InnoDB wpyk_e_events: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wpyk_e_notes: Data: 0.02MB + Index: 0.17MB + Engine InnoDB wpyk_e_notes_users_relations: Data: 0.02MB + Index: 0.05MB + Engine InnoDB wpyk_e_submissions: Data: 0.02MB + Index: 0.27MB + Engine InnoDB wpyk_e_submissions_actions_log: Data: 0.02MB + Index: 0.11MB + Engine InnoDB wpyk_e_submissions_values: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wpyk_ebay_accounts: Data: 0.05MB + Index: 0.00MB + Engine InnoDB wpyk_ebay_auctions: Data: 644.81MB + Index: 27.70MB + Engine InnoDB wpyk_ebay_categories: Data: 4.52MB + Index: 0.84MB + Engine InnoDB wpyk_ebay_jobs: Data: 2.02MB + Index: 0.00MB + Engine InnoDB wpyk_ebay_log: Data: 1.02MB + Index: 0.20MB + Engine InnoDB wpyk_ebay_messages: Data: 1.52MB + Index: 0.00MB + Engine InnoDB wpyk_ebay_orders: Data: 43.02MB + Index: 0.16MB + Engine InnoDB wpyk_ebay_payment: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpyk_ebay_profiles: Data: 0.19MB + Index: 0.00MB + Engine InnoDB wpyk_ebay_shipping: Data: 0.05MB + Index: 0.00MB + Engine InnoDB wpyk_ebay_sites: Data: 0.03MB + Index: 0.00MB + Engine InnoDB wpyk_ebay_stocks_log: Data: 18.05MB + Index: 0.00MB + Engine InnoDB wpyk_ebay_store_categories: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wpyk_ebay_transactions: Data: 40.02MB + Index: 0.28MB + Engine InnoDB wpyk_gf_draft_submissions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wpyk_gf_entry: Data: 1.52MB + Index: 0.14MB + Engine InnoDB wpyk_gf_entry_meta: Data: 6.52MB + Index: 4.48MB + Engine InnoDB wpyk_gf_entry_notes: Data: 0.41MB + Index: 0.11MB + Engine InnoDB wpyk_gf_form: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpyk_gf_form_meta: Data: 0.06MB + Index: 0.00MB + Engine InnoDB wpyk_gf_form_revisions: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wpyk_gf_form_view: Data: 0.11MB + Index: 0.09MB + Engine InnoDB wpyk_gf_rest_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wpyk_gla_budget_recommendations: Data: 0.20MB + Index: 0.11MB + Engine InnoDB wpyk_gla_merchant_issues: Data: 0.48MB + Index: 0.11MB + Engine InnoDB wpyk_gla_shipping_rates: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wpyk_gla_shipping_times: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wpyk_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wpyk_mailchimp_carts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpyk_mailchimp_jobs: Data: 10.52MB + Index: 0.00MB + Engine InnoDB wpyk_options: Data: 305.25MB + Index: 12.11MB + Engine InnoDB wpyk_pos_warehouse: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpyk_postmeta: Data: 503.98MB + Index: 303.80MB + Engine InnoDB wpyk_posts: Data: 55.56MB + Index: 24.97MB + Engine InnoDB wpyk_rank_math_404_logs: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wpyk_rank_math_analytics_gsc: Data: 0.02MB + Index: 0.06MB + Engine InnoDB wpyk_rank_math_analytics_objects: Data: 6.52MB + Index: 1.52MB + Engine InnoDB wpyk_rank_math_internal_links: Data: 3.52MB + Index: 1.52MB + Engine InnoDB wpyk_rank_math_internal_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpyk_rank_math_redirections: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wpyk_rank_math_redirections_cache: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wpyk_tec_events: Data: 0.06MB + Index: 0.02MB + Engine InnoDB wpyk_tec_occurrences: Data: 0.06MB + Index: 0.03MB + Engine InnoDB wpyk_tec_series_relationships: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wpyk_term_relationships: Data: 11.47MB + Index: 7.45MB + Engine InnoDB wpyk_term_taxonomy: Data: 1.52MB + Index: 0.53MB + Engine InnoDB wpyk_termmeta: Data: 1.48MB + Index: 0.73MB + Engine InnoDB wpyk_terms: Data: 0.50MB + Index: 0.67MB + Engine InnoDB wpyk_tm_taskmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wpyk_tm_tasks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wpyk_usermeta: Data: 9.52MB + Index: 6.03MB + Engine InnoDB wpyk_users: Data: 0.45MB + Index: 0.31MB + Engine InnoDB wpyk_wc_admin_note_actions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wpyk_wc_admin_notes: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpyk_wc_category_lookup: Data: 0.09MB + Index: 0.00MB + Engine InnoDB wpyk_wc_customer_lookup: Data: 2.52MB + Index: 1.92MB + Engine InnoDB wpyk_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wpyk_wc_order_addresses: Data: 0.02MB + Index: 0.06MB + Engine InnoDB wpyk_wc_order_coupon_lookup: Data: 0.11MB + Index: 0.17MB + Engine InnoDB wpyk_wc_order_operational_data: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wpyk_wc_order_product_lookup: Data: 11.52MB + Index: 10.06MB + Engine InnoDB wpyk_wc_order_stats: Data: 6.52MB + Index: 6.53MB + Engine InnoDB wpyk_wc_order_tax_lookup: Data: 1.52MB + Index: 0.52MB + Engine InnoDB wpyk_wc_orders: Data: 0.02MB + Index: 0.11MB + Engine InnoDB wpyk_wc_orders_meta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wpyk_wc_product_attributes_lookup: Data: 2.52MB + Index: 1.52MB + Engine InnoDB wpyk_wc_product_download_directories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wpyk_wc_product_meta_lookup: Data: 7.52MB + Index: 15.55MB + Engine InnoDB wpyk_wc_rate_limits: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wpyk_wc_reserved_stock: Data: 0.05MB + Index: 0.00MB + Engine InnoDB wpyk_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wpyk_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wpyk_wcpv_commissions: Data: 3.52MB + Index: 0.00MB + Engine InnoDB wpyk_wcpv_per_product_shipping_rules: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpyk_woocommerce_square_customers: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpyk_wpfb_badges: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wpyk_wpfb_floats: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wpyk_wpfb_forms: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wpyk_wpfb_getapps_forms: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wpyk_wpfb_gettwitter_forms: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wpyk_wpfb_nofitifcation_forms: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wpyk_wpfb_post_templates: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wpyk_wpfb_reviewfunnel: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wpyk_wpfb_reviews: Data: 0.23MB + Index: 0.02MB + Engine InnoDB wpyk_wpfb_total_averages: Data: 0.05MB + Index: 0.02MB + Engine InnoDB wpyk_wt_iew_action_history: Data: 3.02MB + Index: 0.00MB + Engine InnoDB wpyk_wt_iew_cron: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpyk_wt_iew_ftp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpyk_wt_iew_mapping_template: Data: 1.28MB + Index: 0.00MB + Engine InnoDB Post Type Counts attachment: 56492 atum_purchase_order: 1 atum_supplier: 3 custom_css: 2 customize_changeset: 1 elementor_library: 12 fandom_mail: 1 gift_card: 683 is_search_form: 4 izettle_purchase: 305 jp_img_sitemap: 10 jp_img_sitemap_index: 1 jp_sitemap: 1 jp_sitemap_master: 1 jp_vid_sitemap: 1 jupiterx-codes: 1 mymodal_pro: 1 nav_menu_item: 100 nf_sub: 1225 oembed_cache: 27 page: 38 pos-station: 2 post: 5 product: 38692 product_variation: 95 revision: 51 schema: 2 shop_coupon: 197 shop_order: 48035 shop_order_refund: 1363 store: 9 tec_tc_attendee: 62 tec_tc_order: 58 tec_tc_ticket: 12 ticket-meta-fieldset: 2 tribe_event_series: 9 tribe_events: 160 tribe_organizer: 11 tribe_rsvp_attendees: 60 tribe_rsvp_tickets: 27 tribe_venue: 8 tribe_wooticket: 536 tribe-ea-record: 182 watermark: 1 wp_global_styles: 1 Security Secure connection (HTTPS): ? Hide errors from visitors: ? Active Plugins (33) Query Monitor: by John Blackbourn – 3.13.1 Gravity Forms: by Gravity Forms – 2.7.14 A City Ranked Suite: by City Ranked Media – 2023.05.15 Advanced Custom Fields: by WP Engine – 6.2.1 FiboSearch – AJAX Search for WooCommerce: by FiboSearch Team – 1.25.0 Easy Watermark: by BracketSpace – 1.0.11 Elementor Pro: by Elementor.com – 3.16.2 Elementor: by Elementor.com – 3.16.4 Event Tickets Plus: by The Events Calendar – 5.7.5 Event Tickets: by The Events Calendar – 5.6.5 The Events Calendar Pro: by The Events Calendar – 6.2.1 Facebook Chat Plugin – Live Chat Plugin for WordPress: by Meta – 2.5 JetWooBuilder For Elementor: by Crocoblock – 2.1.6.1 Jetpack: by Automattic – 12.6.2 Jupiter X Core: by Artbees – 3.5.6 Mailchimp for WooCommerce: by Mailchimp – 3.2 Rank Math SEO: by Rank Math – 1.0.202 The Events Calendar: by The Events Calendar – 6.2.2 Product Feed PRO for WooCommerce: by AdTribes.io – 12.9.5 Print Invoice & Delivery Notes for WooCommerce: by Tyche Softwares – 4.7.3 WooCommerce Google Analytics Integration: by WooCommerce – 1.8.5 Advanced Order Export For WooCommerce (Pro): by AlgolPlus – 3.4.2 WooCommerce PayPal Payments: by WooCommerce – 2.1.0 (update to version 2.3.1 is available) WooCommerce Product Vendors: by WooCommerce – 2.2.1 WooCommerce Shipping & Tax: by WooCommerce – 2.3.5 WooCommerce USPS Shipping: by WooCommerce – 4.7.4 WooCommerce: by Automattic – 8.1.1 WP-Lister Pro for eBay: by WP Lab – 3.5.1 WP Review Slider Pro (Premium): by LJ Apps – 11.7.5 WPS Hide Login: by WPServeur NicolasKulka wpformation – 1.9.9 Product Import Export for WooCommerce Add-on: by WebToffee – 1.1.7 Import Export for WooCommerce Wrapper: by WebToffee – 1.2.0 YITH WooCommerce Gift Cards: by YITH – 4.4.0 Inactive Plugins (3) Akismet Anti-spam: Spam Protection: by Automattic – Anti-spam Team – 5.3 Media Cleaner (Pro): by Jordy Meow – 6.5.6 WP-Optimize – Clean, Compress, Cache: by David Anderson Ruhani Rabin Team Updraft – 3.2.19 Dropin Plugins (1) advanced-cache.php: advanced-cache.php Must Use Plugins (6) Elementor Safe Mode: by Elementor.com – 1.0.0 Force Strong Passwords – WPE Edition: by Jason Cosper – 1.8.0 WP Engine Cache Plugin: by WP Engine – 1.1.4 WP Engine Seamless Login Plugin: by WP Engine – 1.6.1 WP Engine Security Auditor: by wpengine – 1.1.0 WP Engine System: by WP Engine – 5.0.1 Settings API Enabled: ? Force SSL: – Currency: USD ($) Currency Position: left Thousand Separator: , Decimal Separator: . Number of Decimals: 2 Taxonomies: Product Types: external (external) gift-card (gift-card) grouped (grouped) simple (simple) variable (variable) Taxonomies: Product Visibility: exclude-from-catalog (exclude-from-catalog) exclude-from-search (exclude-from-search) featured (featured) outofstock (outofstock) rated-1 (rated-1) rated-2 (rated-2) rated-3 (rated-3) rated-4 (rated-4) rated-5 (rated-5) Connected to WooCommerce.com: ? Enforce Approved Product Download Directories: – HPOS feature screen enabled: – HPOS feature enabled: – Order datastore: WC_Order_Data_Store_CPT HPOS data sync enabled: – WC Pages Shop base: #7 – /shop/ Cart: #8 – /cart/ Checkout: #9 – /checkout/ My account: #10 – /my-account/ Terms and conditions: #43 – /policies/ Theme Name: JupiterX Child Version: 1.0.0 Author URL: https://jupiterx.com Child Theme: ? Parent Theme Name: JupiterX Parent Theme Version: 3.4.3 Parent Theme Author URL: https://artbees.net/ WooCommerce Support: ? Templates Overrides: jupiterx/lib/templates/woocommerce/cart/cart.php jupiterx/lib/templates/woocommerce/checkout/thankyou.php version 3.7.0 is out of date. The core version is 8.1.0 jupiterx/lib/templates/woocommerce/content-product.php jupiterx/lib/templates/woocommerce/loop/rating.php jupiterx/lib/templates/woocommerce/order/order-details-item.php jupiterx/lib/templates/woocommerce/single-product/add-to-cart/grouped.php jupiterx/lib/templates/woocommerce/single-product/add-to-cart/simple.php jupiterx/lib/templates/woocommerce/single-product/add-to-cart/variable.php jupiterx/lib/templates/woocommerce/single-product/add-to-cart/variation-add-to-cart-button.php jupiterx/lib/templates/woocommerce/single-product/meta.php Outdated Templates: ? <pre class=”wp-block-code”><code> Learn how to update</code></pre> WooCommerce PayPal Payments Onboarded: ? Shop country code: US WooCommerce currency supported: ? Advanced Card Processing available in country: ? Pay Later messaging available in country: ? Webhook status: ? Vault enabled: – Logging enabled: – Reference Transactions: – Used PayPal Checkout plugin: ? Tracking enabled: – Admin Enabled Features: activity-panels analytics product-block-editor coupons core-profiler customer-effort-score-tracks import-products-task experimental-fashion-sample-products shipping-smart-defaults shipping-setting-tour homescreen marketing mobile-app-banner navigation onboarding onboarding-tasks remote-inbox-notifications remote-free-extensions payment-gateway-suggestions shipping-label-banner subscriptions store-alerts transient-notices woo-mobile-welcome wc-pay-promotion wc-pay-welcome-page Disabled Features: customize-store minified-js new-product-management-experience product-variation-management settings async-product-editor-category-field Daily Cron: ? Next scheduled: 2023-09-29 21:30:41 -07:00 Options: ? Notes: 10 Onboarding: completed Action Scheduler Canceled: 961 Oldest: 2023-08-30 19:41:30 -0700 Newest: 2023-09-29 11:01:09 -0700 Complete: 62,503 Oldest: 2023-08-29 17:05:11 -0700 Newest: 2023-09-29 12:25:47 -0700 Failed: 8,709 Oldest: 2023-08-29 18:07:20 -0700 Newest: 2023-09-29 11:41:05 -0700 In-progress: 1 Oldest: – Newest: – Pending: 12 Oldest: 2023-09-29 12:25:48 -0700 Newest: 2023-09-29 18:08:52 -0700 Status report information Generated at: 2023-09-29 12:25:51 -07:00 `
- This topic was modified 1 year, 1 month ago by mindtakerminis.

Viewing 7 replies - 1 through 7 (of 7 total)

Plugin Support Bruce (a11n)
(@bruceallen)

Happiness Engineer

1 year, 1 month ago

Hi @mindtakerminis

I believe this is an issue with WP Engine, as they limits long queries (longer than 1024 characters) for performance reasons.

You may want to contact them for a solution, I’ve seen elsewhere that adding this to your wp-config file can fix this, but I would check with them first:

define( 'WPE_GOVERNOR', false );

tplomari
(@tplomari)

1 year, 1 month ago

Yes, WP Engine is killing the query – but it’s killing the query because there are SO many rows of these jpsq_sync options. I’ve had a nearly identical problem to the OP. The problem isn’t WP Engine…it’s that there are 1000’s (or in my case 174,000 across our multisite) of rows of data being added to our options table by Jetpack. Overriding WPE’s “Governor” doesn’t fix the actual problem…

Thread Starter mindtakerminis
(@mindtakerminis)

1 year, 1 month ago

@bruceallen @tplomari is correct, I believe. The problem is not that queries are being killed it is that so much data is being created in the first place that any reasonable query will fail. When I first twigged to the error, I have about 60-80k lines that it was trying to get through.

Plugin Support Bruce (a11n)
(@bruceallen)

Happiness Engineer

1 year, 1 month ago

Hi @mindtakerminis

I see this is still an issue. The largest table which is having the sync issue is woocommerce_order_items had you added or imported a large number of products recently?

As mentioned in a previous thread, have you tried removing and reinstalling Jetpack?

Thread Starter mindtakerminis
(@mindtakerminis)

1 year, 1 month ago

Bruce, we add about 500 items a week to the store. I have turned off and turned it back on. I have not completely removed jetpack though.

Thread Starter mindtakerminis
(@mindtakerminis)

1 year, 1 month ago

That being said, it is not currently popping off, but I don’t think that the issue is fixed just that it is not currently exploding. I’m only seeing one jp sync in the options table currently.

Daniel
(@ihenetudan)

1 year, 1 month ago

@mindtakerminis

We can look deeper into this if you’d like. If you would like us to do that, kindly contact us via this contact form.

Please include a link to this thread if you choose to reach out via that channel. Thank you.

Viewing 7 replies - 1 through 7 (of 7 total)

The topic ‘Killed Query and Filling up wpyk_options’ is closed to new replies.