• Resolved EndlessRange

    (@rhenium3)


    When I turn on HPOS and have the tables sync, we are experiencing major issues with CPU spikes once staff starts processing our orders. When I turn off HPOS and sync, I show orders that haven’t been synced yet (which is weird). We can try to replicate on staging site but I don’t see issues until staff starts processing orders and traffic picks up. This is what it looks like right after I turned off HPOS and compatibility mode (I expect it would be 0 not 18) https://snipboard.io/isoNX4.jpg



     WordPress Environment

    WordPress address (URL): https://fernvalleyfarms.com<br>Site address (URL): https://fernvalleyfarms.com<br>WC Version: 8.6.1<br>REST API Version: ? 8.6.1<br>WC Blocks Version: ? 11.8.0-dev<br>Action Scheduler Version: ? 3.7.1<br>Log Directory Writable: ?<br>WP Version: 6.4.3<br>WP Multisite: –<br>WP Memory Limit: 2 GB<br>WP Debug Mode: –<br>WP Cron: ?<br>Language: en_US<br>External object cache: ? Server Environment

    Server Info: Apache/2.4.58 (Debian)<br>PHP Version: 8.1.27<br>PHP Post Max Size: 499 MB<br>PHP Time Limit: 1000<br>PHP Max Input Vars: 10000<br>cURL Version: 7.64.0<br>OpenSSL/1.1.1n

    SUHOSIN Installed: –<br>MySQL Version: 10.4.20-MariaDB-1:10.4.20+maria~buster-log<br>Max Upload Size: 499 MB<br>Default Timezone is UTC: ?<br>fsockopen/cURL: ?<br>SoapClient: ?<br>DOMDocument: ?<br>GZip: ?<br>Multibyte String: ?<br>Remote Post: ?<br>Remote Get: ? Database

    WC Database Version: 8.6.1<br>WC Database Prefix: wp_gwcttgg19j_<br>Total Database Size: 3806.20MB<br>Database Data Size: 2045.04MB<br>Database Index Size: 1761.16MB<br>wp_gwcttgg19j_woocommerce_sessions: Data: 4.02MB + Index: 0.05MB + Engine InnoDB<br>wp_gwcttgg19j_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_gwcttgg19j_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_gwcttgg19j_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>wp_gwcttgg19j_woocommerce_order_items: Data: 20.55MB + Index: 7.52MB + Engine InnoDB<br>wp_gwcttgg19j_woocommerce_order_itemmeta: Data: 554.83MB + Index: 135.36MB + Engine InnoDB<br>wp_gwcttgg19j_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>wp_gwcttgg19j_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_gwcttgg19j_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_gwcttgg19j_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_gwcttgg19j_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_gwcttgg19j_woocommerce_payment_tokens: Data: 0.17MB + Index: 0.06MB + Engine InnoDB<br>wp_gwcttgg19j_woocommerce_payment_tokenmeta: Data: 2.27MB + Index: 0.80MB + Engine InnoDB<br>wp_gwcttgg19j_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_actionscheduler_actions: Data: 0.02MB + Index: 0.11MB + Engine InnoDB<br>wp_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_actionscheduler_logs: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_bv_fw_requests: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_bv_ip_store: Data: 0.28MB + Index: 0.31MB + Engine InnoDB<br>wp_bv_lp_requests: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_comments: Data: 0.02MB + Index: 0.08MB + Engine InnoDB<br>wp_gwcttgg19j_acfw_store_credits: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_gwcttgg19j_acfw_virtual_coupons: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_gwcttgg19j_actionscheduler_actions: Data: 73.59MB + Index: 98.95MB + Engine InnoDB<br>wp_gwcttgg19j_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_gwcttgg19j_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_gwcttgg19j_actionscheduler_logs: Data: 58.59MB + Index: 39.48MB + Engine InnoDB<br>wp_gwcttgg19j_berocket_termmeta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_gwcttgg19j_bv_fw_requests: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_gwcttgg19j_bv_ip_store: Data: 0.28MB + Index: 0.19MB + Engine InnoDB<br>wp_gwcttgg19j_bv_lp_requests: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_gwcttgg19j_cart_notices: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_gwcttgg19j_commentmeta: Data: 3.19MB + Index: 3.56MB + Engine InnoDB<br>wp_gwcttgg19j_comments: Data: 104.64MB + Index: 84.23MB + Engine InnoDB<br>wp_gwcttgg19j_cr_local_forms: Data: 9.52MB + Index: 1.52MB + Engine InnoDB<br>wp_gwcttgg19j_db7_forms: Data: 3.52MB + Index: 0.00MB + Engine InnoDB<br>wp_gwcttgg19j_dgwt_wcas_index: Data: 0.20MB + Index: 0.02MB + Engine InnoDB<br>wp_gwcttgg19j_dgwt_wcas_invindex_cache: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_gwcttgg19j_dgwt_wcas_invindex_doclist: Data: 4.47MB + Index: 5.80MB + Engine InnoDB<br>wp_gwcttgg19j_dgwt_wcas_invindex_wordlist: Data: 0.45MB + Index: 0.31MB + Engine InnoDB<br>wp_gwcttgg19j_dgwt_wcas_stats: Data: 1.02MB + Index: 0.00MB + Engine InnoDB<br>wp_gwcttgg19j_dgwt_wcas_tax_index: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>wp_gwcttgg19j_e_events: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_gwcttgg19j_hkdev_mm_access_keys: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_gwcttgg19j_hkdev_mm_unrestricted_ips: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_gwcttgg19j_hollerbox_stats: Data: 16.61MB + Index: 48.31MB + Engine InnoDB<br>wp_gwcttgg19j_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_gwcttgg19j_lws_webhooks_events: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_gwcttgg19j_lws_wr_achieved_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_gwcttgg19j_lws_wr_historic: Data: 10.52MB + Index: 4.03MB + Engine InnoDB<br>wp_gwcttgg19j_lws_wr_tinyurls: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_gwcttgg19j_lws_wr_userbadge: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_gwcttgg19j_ml_data: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_gwcttgg19j_ms_snippets: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_gwcttgg19j_omnisend_logs: Data: 1.52MB + Index: 0.00MB + Engine InnoDB<br>wp_gwcttgg19j_options: Data: 23.17MB + Index: 4.19MB + Engine InnoDB<br>wp_gwcttgg19j_pmxe_exports: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_gwcttgg19j_pmxe_google_cats: Data: 0.39MB + Index: 0.00MB + Engine InnoDB<br>wp_gwcttgg19j_pmxe_posts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_gwcttgg19j_pmxe_templates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_gwcttgg19j_postmeta: Data: 581.84MB + Index: 525.81MB + Engine InnoDB<br>wp_gwcttgg19j_posts: Data: 82.33MB + Index: 23.91MB + Engine InnoDB<br>wp_gwcttgg19j_reward_points_balances: Data: 0.20MB + Index: 0.00MB + Engine InnoDB<br>wp_gwcttgg19j_reward_points_config: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_gwcttgg19j_reward_points_transaction_history: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_gwcttgg19j_rtafar_rules: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_gwcttgg19j_smush_dir_images: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_gwcttgg19j_snippets: Data: 0.05MB + Index: 0.03MB + Engine InnoDB<br>wp_gwcttgg19j_termmeta: Data: 0.08MB + Index: 0.06MB + Engine InnoDB<br>wp_gwcttgg19j_terms: Data: 0.05MB + Index: 0.03MB + Engine InnoDB<br>wp_gwcttgg19j_term_relationships: Data: 1.44MB + Index: 0.45MB + Engine InnoDB<br>wp_gwcttgg19j_term_taxonomy: Data: 0.05MB + Index: 0.03MB + Engine InnoDB<br>wp_gwcttgg19j_usermeta: Data: 92.64MB + Index: 64.19MB + Engine InnoDB<br>wp_gwcttgg19j_users: Data: 3.52MB + Index: 4.55MB + Engine InnoDB<br>wp_gwcttgg19j_wcs_payment_retries: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_gwcttgg19j_wc_admin_notes: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_gwcttgg19j_wc_admin_note_actions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_gwcttgg19j_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_gwcttgg19j_wc_customer_lookup: Data: 4.52MB + Index: 4.02MB + Engine InnoDB<br>wp_gwcttgg19j_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_gwcttgg19j_wc_orders: Data: 27.56MB + Index: 29.50MB + Engine InnoDB<br>wp_gwcttgg19j_wc_orders_meta: Data: 238.80MB + Index: 571.98MB + Engine InnoDB<br>wp_gwcttgg19j_wc_order_addresses: Data: 23.56MB + Index: 28.06MB + Engine InnoDB<br>wp_gwcttgg19j_wc_order_coupon_lookup: Data: 3.48MB + Index: 2.91MB + Engine InnoDB<br>wp_gwcttgg19j_wc_order_operational_data: Data: 16.55MB + Index: 8.03MB + Engine InnoDB<br>wp_gwcttgg19j_wc_order_product_lookup: Data: 21.55MB + Index: 21.58MB + Engine InnoDB<br>wp_gwcttgg19j_wc_order_stats: Data: 17.55MB + Index: 10.30MB + Engine InnoDB<br>wp_gwcttgg19j_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_gwcttgg19j_wc_product_attributes_lookup: Data: 0.19MB + Index: 0.16MB + Engine InnoDB<br>wp_gwcttgg19j_wc_product_download_directories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_gwcttgg19j_wc_product_meta_lookup: Data: 0.41MB + Index: 0.70MB + Engine InnoDB<br>wp_gwcttgg19j_wc_rate_limits: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_gwcttgg19j_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_gwcttgg19j_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_gwcttgg19j_wc_webhooks: Data: 4.52MB + Index: 1.50MB + Engine InnoDB<br>wp_gwcttgg19j_wdp_orders: Data: 0.48MB + Index: 0.23MB + Engine InnoDB<br>wp_gwcttgg19j_wdp_order_items: Data: 0.38MB + Index: 0.38MB + Engine InnoDB<br>wp_gwcttgg19j_wdp_persistent_rules_cache: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_gwcttgg19j_wdp_product_collections: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_gwcttgg19j_wdp_rules: Data: 0.16MB + Index: 0.03MB + Engine InnoDB<br>wp_gwcttgg19j_wdr_order_discounts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_gwcttgg19j_wdr_order_item_discounts: Data: 2.52MB + Index: 1.23MB + Engine InnoDB<br>wp_gwcttgg19j_wdr_rules: Data: 0.11MB + Index: 0.00MB + Engine InnoDB<br>wp_gwcttgg19j_wfblockediplog: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_gwcttgg19j_wfblocks7: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>wp_gwcttgg19j_wfconfig: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_gwcttgg19j_wfcrawlers: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_gwcttgg19j_wffilechanges: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_gwcttgg19j_wffilemods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_gwcttgg19j_wfhits: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>wp_gwcttgg19j_wfhoover: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_gwcttgg19j_wfissues: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>wp_gwcttgg19j_wfknownfilelist: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_gwcttgg19j_wflivetraffichuman: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_gwcttgg19j_wflocs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_gwcttgg19j_wflogins: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_gwcttgg19j_wfls_2fa_secrets: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_gwcttgg19j_wfls_settings: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_gwcttgg19j_wfnotifications: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_gwcttgg19j_wfpendingissues: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>wp_gwcttgg19j_wfpklist_template_data: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_gwcttgg19j_wfreversecache: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_gwcttgg19j_wfsnipcache: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>wp_gwcttgg19j_wfstatus: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_gwcttgg19j_wftrafficrates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_gwcttgg19j_woocommerce_bis_activity: Data: 0.52MB + Index: 0.58MB + Engine InnoDB<br>wp_gwcttgg19j_woocommerce_bis_notifications: Data: 0.20MB + Index: 0.41MB + Engine InnoDB<br>wp_gwcttgg19j_woocommerce_bis_notificationsmeta: Data: 1.52MB + Index: 0.34MB + Engine InnoDB<br>wp_gwcttgg19j_woocommerce_square_customers: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_gwcttgg19j_wpfm_backup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_gwcttgg19j_wpr_rocket_cache: Data: 0.16MB + Index: 0.16MB + Engine InnoDB<br>wp_gwcttgg19j_wpr_rucss_used_css: Data: 0.02MB + Index: 0.09MB + Engine InnoDB<br>wp_gwcttgg19j_wsal_metadata: Data: 9.52MB + Index: 17.08MB + Engine InnoDB<br>wp_gwcttgg19j_wsal_occurrences: Data: 5.52MB + Index: 3.03MB + Engine InnoDB<br>wp_gwcttgg19j_wt_iew_action_history: Data: 2.52MB + Index: 0.00MB + Engine InnoDB<br>wp_gwcttgg19j_wt_iew_cron: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_gwcttgg19j_wt_iew_ftp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_gwcttgg19j_wt_iew_mapping_template: Data: 0.09MB + Index: 0.00MB + Engine InnoDB<br>wp_gwcttgg19j_yoast_indexable: Data: 1.42MB + Index: 0.23MB + Engine InnoDB<br>wp_gwcttgg19j_yoast_indexable_hierarchy: Data: 0.05MB + Index: 0.05MB + Engine InnoDB<br>wp_gwcttgg19j_yoast_migrations: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_gwcttgg19j_yoast_primary_term: Data: 0.05MB + Index: 0.03MB + Engine InnoDB<br>wp_gwcttgg19j_yoast_prominent_words: Data: 1.41MB + Index: 1.98MB + Engine InnoDB<br>wp_gwcttgg19j_yoast_seo_links: Data: 1.17MB + Index: 0.28MB + Engine InnoDB<br>wp_gwcttgg19j_yoast_seo_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_options: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_postmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_posts: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>wp_termmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_terms: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_term_relationships: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_term_taxonomy: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_usermeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_users: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>wp_wc_admin_notes: Data: 0.05MB + Index: 0.00MB + Engine InnoDB<br>wp_wc_admin_note_actions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wc_customer_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_wc_order_product_lookup: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>wp_wc_order_stats: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>wp_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_wc_product_attributes_lookup: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_wc_product_download_directories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_wc_product_meta_lookup: Data: 0.02MB + Index: 0.09MB + Engine InnoDB<br>wp_wc_rate_limits: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>wp_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_woocommerce_order_itemmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_woocommerce_order_items: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_woocommerce_sessions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>wp_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB Post Type Counts

    accm_messages: 14<br>attachment: 4064<br>blocked_user: 2<br>cbdaffs_track_event: 6<br>custom_css: 4<br>custom_order_status: 1<br>customize_changeset: 2<br>elementor_library: 1<br>fgf_master_log: 1135<br>fgf_rules: 8<br>gp_elements: 4<br>hollerbox: 27<br>lws-wre-event: 2<br>lws-wre-pool: 3<br>lws-wre-unlockable: 3<br>nab_experiment: 12<br>nav_menu_item: 218<br>ni-order-status: 1<br>oembed_cache: 22<br>order_form: 2<br>page: 64<br>post: 91<br>product: 354<br>product_variation: 2188<br>revision: 31<br>shop_coupon: 17991<br>shop_order: 88151<br>shop_order_refund: 689<br>shop_subscription: 89<br>wp_block: 3<br>wp_navigation: 1<br>wpcf7_contact_form: 4 Security

    Secure connection (HTTPS): ?<br>Hide errors from visitors: ? Active Plugins (53)

    Query Monitor: by John Blackbourn – 3.15.0<br>CBDAffs Advertiser Integration: by CBDAffs – 2.6.2<br>Restrict Products based on Geo: by Hilary Torn – 4.0.3<br>WooCommerce Google Analytics Integration By Advanced WC Analytics Pro: by Passionate Brains – 3.4.2<br>Advanced Coupons for WooCommerce Free: by Rymera Web Co – 4.5.9.2<br>Advanced Coupons for WooCommerce Premium: by Rymera Web Co – 3.5.8.1<br>FiboSearch - AJAX Search for WooCommerce (Pro): by FiboSearch Team – 1.27.1<br>PublishPress Capabilities: by PublishPress – 2.13.0<br>WooCommerce Clone Orders: by Vibe Agency – 1.5.8 (update to version 1.5.9 is available)<br>Contact Form 7 Captcha: by 247wd – 0.1.2<br>Contact Form 7: by Takayuki Miyoshi – 5.8.7<br>Contact Form CFDB7: by Arshid – 1.2.6.8<br>Customer Reviews for WooCommerce PRO: by CusRev – 1.6.0<br>Customer Reviews for WooCommerce: by CusRev – 5.41.0<br>Disable Comments: by WPDeveloper – 2.4.5<br>Dynamic Cart & Checkout Notices: by Addify – 1.2.0<br>Edit to functions file: by Hilary Torn – 9.8.2<br>UPS Live Rates and Access Points PRO: by Octolize – 2.2.1<br>GenerateBlocks: by Tom Usborne – 1.8.2<br>GP Premium: by Tom Usborne – 2.4.0<br>HollerBox: by Groundhogg Inc. – 2.3.5<br>HollerBox - Pro: by Groundhogg Inc. – 2.1<br>Loco Translate: by Tim Whitlock – 2.6.6<br>Metorik Helper: by Metorik – 1.7.1<br>Ni WooCommerce Custom Order Status: by anzia – 2.2.2<br>Omnisend for Woocommerce: by Omnisend – 1.14.1<br>reCaptcha for WooCommerce: by I Thirteen Web Solution – 2.50<br>Sezzle WooCommerce Payment: by Sezzle – 5.0.8<br>Stop User Enumeration: by Fullworks – 1.4.9<br>Password Strength Settings for WooCommerce: by Daniel Santoro – 3.0.1<br>WooCommerce Address Book: by CrossPeak – 2.6.2<br>Woo Discount Rules PRO 2.0: by Flycart – 2.6.1<br>Discount Rules Core: by Flycart – 2.6.3<br>WPC Smart Quick View for WooCommerce: by WPClever – 3.5.7<br>Woo All Products For Subscriptions: by Woo – 4.1.5<br>Woo Back In Stock Notifications: by Woo – 1.6.8<br>WooCommerce AeroPay Online Gateway: by AeroPay – 2.1.0<br>WooCommerce Authorize.Net Gateway: by SkyVerge – 3.10.1<br>WooCommerce Print Invoices/Packing Lists: by SkyVerge – 3.13.2 (update to version 3.13.3 is available)<br>Woo Subscriptions: by WooCommerce – 6.0.0<br>WooCommerce Wholesale Lead Capture: by Rymera Web Co – 1.17.8<br>WooCommerce Wholesale Order Form: by Rymera Web Co – 3.0.4<br>WooCommerce Wholesale Prices Premium: by Rymera Web Co – 1.30.5<br>WooCommerce Wholesale Prices: by Rymera Web Co – 2.1.12<br>WooCommerce: by Automattic – 8.6.1<br>MyRewards: by Long Watch Studio – 5.3.0<br>Yoast SEO Premium: by Team Yoast – 22.0<br>Yoast SEO: by Team Yoast – 22.1<br>WP NMI Gateway PCI for WooCommerce: by Pledged Plugins – 1.1.6<br>WP Rocket: by WP Media – 3.15.9<br>WP Activity Log: by Melapress – 4.6.4<br>Yoast SEO: WooCommerce: by Team Yoast – 16.0<br>XPS Ship Integration: by XPS Ship – 1.1.74 Inactive Plugins (2)

    Advanced Database Cleaner PRO: by Younes JFR. – 3.2.8<br>MalCare WordPress Security Plugin - Malware Scanner, Cleaner, Security Firewall: by MalCare Security – 5.47 Dropin Plugins (2)

    advanced-cache.php: advanced-cache.php<br>object-cache.php: Object Cache Pro (Drop-in) Must Use Plugins (1)

    Object Cache Pro (MU): by Rhubarb Group – 1.20.2 Settings

    API Enabled: –<br>Force SSL: –<br>Currency: USD ($)<br>Currency Position: left<br>Thousand Separator: ,<br>Decimal Separator: .<br>Number of Decimals: 2<br>Taxonomies: Product Types: external (external)<br>grouped (grouped)<br>simple (simple)<br>subscription (subscription)<br>variable (variable)<br>variable subscription (variable-subscription)

    Taxonomies: Product Visibility: exclude-from-catalog (exclude-from-catalog)<br>exclude-from-search (exclude-from-search)<br>featured (featured)<br>outofstock (outofstock)<br>rated-1 (rated-1)<br>rated-2 (rated-2)<br>rated-3 (rated-3)<br>rated-4 (rated-4)<br>rated-5 (rated-5)

    Connected to Woo.com: ?<br>Enforce Approved Product Download Directories: –<br>HPOS feature screen enabled: –<br>HPOS feature enabled: –<br>Order datastore: WC_Order_Data_Store_CPT<br>HPOS data sync enabled: – WC Pages

    Shop base: #8 - /shop/<br>Cart: #9 - /cart/<br>Checkout: #10 - /checkout/<br>My account: #11 - /my-account/<br>Terms and conditions: #8257 - /terms-conditions/ Theme

    Name: GeneratePress Child<br>Version: 0.1<br>Author URL: https://tomusborne.com<br>Child Theme: ?<br>Parent Theme Name: GeneratePress<br>Parent Theme Version: 3.3.1 – 3.4.0 is available<br>Parent Theme Author URL: https://tomusborne.com<br>WooCommerce Support: ? Templates

    Overrides: generatepress_child/woocommerce/checkout/form-pay.php<br>generatepress_child/woocommerce/myaccount/form-edit-account.php Subscriptions

    WCS_DEBUG: ? No<br>Subscriptions Mode: ? Live<br>Subscriptions Live URL: https://fernvalleyfarms.com<br>Subscriptions-core Library Version: 6.8.0<br>Subscription Statuses: wc-active: 46<br>wc-expired: 1<br>wc-pending-cancel: 5<br>wc-pending: 2<br>wc-on-hold: 10<br>wc-cancelled: 25

    WooCommerce Account Connected: ? Yes<br>Active Product Key: ? No<br>Custom Retry Rules: ? No<br>Custom Retry Rule Class: ? No<br>Custom Raw Retry Rule: ? No<br>Custom Retry Rule: ? No<br>Retries Migration Status: ? Completed<br>Report Cache Enabled: ? Yes<br>Cache Update Failures: ? 0 failure Store Setup

    Country / State: United States (US) — Oregon Subscriptions by Payment Gateway

    Authorize.Net Credit Card: wc-active: 46<br>wc-cancelled: 24<br>wc-expired: 1<br>wc-on-hold: 10<br>wc-pending-cancel: 5 Payment Gateway Support

    Authorize.Net Credit Card: products<br>card_types<br>payment_form<br>inline<br>lightbox<br>tokenization<br>token_editor<br>charge<br>charge-virtual<br>authorization<br>capture_charge<br>customer_decline_messages<br>refunds<br>voids<br>customer_id<br>add_payment_method<br>apple_pay<br>subscriptions<br>subscription_suspension<br>subscription_cancellation<br>subscription_reactivation<br>subscription_amount_changes<br>subscription_date_changes<br>multiple_subscriptions<br>subscription_payment_method_change_customer<br>subscription_payment_method_change_admin

    Sezzle: products<br>refunds Back In Stock

    Database Version: 1.6.8<br>Loopback Test: ? Authorize.Net Credit Card

    Environment: Production<br>Tokenization Enabled: ?<br>Debug Mode: Off<br>Webhooks Enabled: ?<br>No signature key configured Admin

    Enabled Features: activity-panels<br>analytics<br>product-block-editor<br>coupons<br>core-profiler<br>customer-effort-score-tracks<br>import-products-task<br>experimental-fashion-sample-products<br>shipping-smart-defaults<br>shipping-setting-tour<br>homescreen<br>marketing<br>mobile-app-banner<br>navigation<br>onboarding<br>onboarding-tasks<br>product-variation-management<br>product-virtual-downloadable<br>product-external-affiliate<br>product-grouped<br>product-linked<br>remote-inbox-notifications<br>remote-free-extensions<br>payment-gateway-suggestions<br>shipping-label-banner<br>subscriptions<br>store-alerts<br>transient-notices<br>woo-mobile-welcome<br>wc-pay-promotion<br>wc-pay-welcome-page

    Disabled Features: customize-store<br>minified-js<br>new-product-management-experience<br>product-pre-publish-modal<br>settings<br>async-product-editor-category-field

    Daily Cron: ? Next scheduled: 2024-03-01 18:37:27 -08:00<br>Options: ?<br>Notes: 26<br>Onboarding: completed All Products for Woo Subscriptions

    Template Overrides: – Action Scheduler

    Complete: 192,031<br>Oldest: 2024-01-26 01:22:10 -0800<br>Newest: 2024-02-29 23:03:35 -0800

    Failed: 4,732<br>Oldest: 2022-06-08 15:23:25 -0700<br>Newest: 2024-02-29 04:22:30 -0800

    Pending: 57<br>Oldest: 2024-03-01 04:15:00 -0800<br>Newest: 2024-03-31 17:06:30 -0700 Status report information

    Generated at: 2024-02-29 23:05:54 -08:00<br>

Viewing 2 replies - 1 through 2 (of 2 total)
  • Hi @rhenium3,

    Thanks for reaching out.

    It seems like the HPOS is causing CPU spikes when processing orders, particularly during high traffic periods.

    This could be an issue with the WP-Cron jobs not functioning correctly, as you are unable to replicate the issue on a staging site, this makes it quite challenging to troubleshoot.

    Nevertheless, you can try increasing your PHP Post Max Size from 499 MB to 2GB, but this would mean you can only observe any changes during the high traffic periods in your store.

    Let us know if you notice any changes in CPU spikes.

    Thanks.

    Plugin Support Feten L. a11n

    (@fetenlakhal)

    Greetings!


    Just noticed it’s been some time since we’ve been in touch. I’ll be setting this matter to ‘resolved’ for now. Feel free to reach out if you decide to pick things up again.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘HPOS causes major issues on website’ is closed to new replies.