• Resolved techguysa

    (@techguysa)


    HI there passed week or so noticed

    Maximum simultaneous queues already in progress (2 queues). No additional queues will begin processing until the current queues are complete.

    For example now i have this snippet cause the ques piled up on past due like crazy.

    add_filter( ‘action_scheduler_queue_runner_concurrent_batches’, ‘tg_custom_concurrent_queues’ );
    function tg_custom_concurrent_queues( $concurrent_batches ) {
    return 2; // Bumps max simultaneous queues from 2 to 4
    }

    add_filter( ‘action_scheduler_queue_runner_batch_size’, ‘tg_custom_as_batch_size’ );
    function tg_custom_as_batch_size( $batch_size ) {
    return 100; // Increases items processed per batch from 100 to 150
    }

    to help speed things up but even if its not on the stuff piles up as much as 2 days (if not more) its mostly gla jobs

    also got this in my functions

    add_filter( ‘action_scheduler_retention_period’, ‘t*****custom_as_retention’ );

    function t****_custom_as_retention( $period ) {
    return 3 * DAY_IN_SECONDS;
    }

    i asterixed it out her but this to clear old logs etc

    I had to go to terminal in cpanel and run

    php wp-cli.phar action-scheduler run –batches=5 –force (i change the 5 to 50 or 100 depending on the servers performance)

    everything is updated on teh site my sql database starts eating RAM when this piles up. (Slowly) *sql tables are about 7million i have a ton of stuff
    now originally had the advanced scheduler as recommened by one of your teams but seems to do nothing to help (so i purged it google gemini advised it can cause issues cause it starts looping).

    and trust me optimised SQL to death.

    Since i got past due up to date to 186 at 2am and now being 08:30 am its on 2552 and pending is on 3456
    I find no suspiciouos bots attacking the site etc again its mostly gla/jobs/update_products/process_item (in past due its 1352) and woocommerce_run_product_attribute_lookup_update_callback (in past due its 1153)

    Yes stock updates every few hours this issue cuase that stock updates to slow down to a point it takes close to an hour to run the updated even on 3000 skus and its just QTY updates if i do regular_price manually its fine but i know if its via real cron takes about an hour when these things piles up.

    IF this helps (For security i changed the tables names to REDACTED NAME for here

    WordPress Environment<br><br>WordPress address (URL): https://www.techguysa.co.za<br>Site address (URL): https://www.techguysa.co.za<br>WC Version: 10.8.1<br>Legacy REST API Package Version: ✔ 1.0.5<br>Action Scheduler Version: ✔ 3.9.3<br>Log Directory Writable: ✔<br>WP Version: 7.0<br>WP Multisite: –<br>WP Memory Limit: 4 GB<br>WP Debug Mode: –<br>WP Cron: –<br>WP Environment Type: production<br>Language: en_US<br>External object cache: ✔ Server Environment<br><br>Server Info: LiteSpeed<br>Server Architecture: Linux 5.14.0-611.16.1.el9_7.x86_64 x86_64<br>PHP Version: 8.3.31<br>PHP Post Max Size: 512 MB<br>PHP Time Limit: 2400<br>PHP Max Input Vars: 100000<br>cURL Version: 8.19.0<br>OpenSSL/3.5.1<br><br>SUHOSIN Installed: –<br>MySQL Version: 11.4.12-MariaDB<br>Max Upload Size: 512 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<br><br>WC Database Version: 10.8.1<br>WC Database Prefix: Redacted NAME_<br>Total Database Size: 1978.31MB<br>Database Data Size: 994.19MB<br>Database Index Size: 984.12MB<br>Redacted NAME_woocommerce_sessions: Data: 1.52MB + Index: 2.11MB + Engine InnoDB<br>Redacted NAME_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>Redacted NAME_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>Redacted NAME_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.08MB + Engine InnoDB<br>Redacted NAME_woocommerce_order_items: Data: 2.52MB + Index: 1.52MB + Engine InnoDB<br>Redacted NAME_woocommerce_order_itemmeta: Data: 26.58MB + Index: 32.67MB + Engine InnoDB<br>Redacted NAME_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>Redacted NAME_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>Redacted NAME_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>Redacted NAME_woocommerce_shipping_zone_locations: Data: 0.23MB + Index: 0.33MB + Engine InnoDB<br>Redacted NAME_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>Redacted NAME_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>Redacted NAME_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>Redacted NAME_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>Redacted NAME_actionscheduler_actions: Data: 6.25MB + Index: 20.69MB + Engine InnoDB<br>Redacted NAME_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>Redacted NAME_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>Redacted NAME_actionscheduler_logs: Data: 3.52MB + Index: 3.03MB + Engine InnoDB<br>Redacted NAME_clarity_collect_events: Data: 0.09MB + Index: 0.00MB + Engine InnoDB<br>Redacted NAME_commentmeta: Data: 0.33MB + Index: 0.69MB + Engine InnoDB<br>Redacted NAME_comments: Data: 32.56MB + Index: 44.70MB + Engine InnoDB<br>Redacted NAME_frm_fields: Data: 0.13MB + Index: 0.05MB + Engine InnoDB<br>Redacted NAME_frm_forms: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>Redacted NAME_frm_items: Data: 0.47MB + Index: 0.34MB + Engine InnoDB<br>Redacted NAME_frm_item_metas: Data: 1.52MB + Index: 0.72MB + Engine InnoDB<br>Redacted NAME_gla_attribute_mapping_rules: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>Redacted NAME_gla_budget_recommendations: Data: 0.19MB + Index: 0.11MB + Engine InnoDB<br>Redacted NAME_gla_merchant_issues: Data: 4.52MB + Index: 0.00MB + Engine InnoDB<br>Redacted NAME_gla_merchant_price_benchmarks: Data: 0.16MB + Index: 0.09MB + Engine InnoDB<br>Redacted NAME_gla_shipping_rates: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>Redacted NAME_gla_shipping_times: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>Redacted NAME_ht_activity: Data: 0.06MB + Index: 0.02MB + Engine InnoDB<br>Redacted NAME_ht_ip_list: Data: 0.38MB + Index: 0.11MB + Engine InnoDB<br>Redacted NAME_indexnow_failed_submissions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>Redacted NAME_indexnow_passed_submissions: Data: 0.28MB + Index: 0.00MB + Engine InnoDB<br>Redacted NAME_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>Redacted NAME_litespeed_avatar: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>Redacted NAME_litespeed_crawler: Data: 6.52MB + Index: 6.06MB + Engine InnoDB<br>Redacted NAME_litespeed_crawler_blacklist: Data: 1.52MB + Index: 0.59MB + Engine InnoDB<br>Redacted NAME_litespeed_url: Data: 0.34MB + Index: 0.50MB + Engine InnoDB<br>Redacted NAME_litespeed_url_file: Data: 1.52MB + Index: 1.67MB + Engine InnoDB<br>Redacted NAME_nm_personalized: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>Redacted NAME_options: Data: 6.50MB + Index: 0.39MB + Engine InnoDB<br>Redacted NAME_parcelpanel_courier: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>Redacted NAME_parcelpanel_location: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>Redacted NAME_parcelpanel_tracking: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>Redacted NAME_parcelpanel_tracking_items: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>Redacted NAME_postmeta: Data: 334.98MB + Index: 427.84MB + Engine InnoDB<br>Redacted NAME_posts: Data: 137.59MB + Index: 25.09MB + Engine InnoDB<br>Redacted NAME_relevanssi: Data: 153.84MB + Index: 173.95MB + Engine InnoDB<br>Redacted NAME_relevanssi_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>Redacted NAME_relevanssi_stopwords: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>Redacted NAME_revslider_css: Data: 0.13MB + Index: 0.02MB + Engine InnoDB<br>Redacted NAME_revslider_css_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>Redacted NAME_revslider_layer_animations: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>Redacted NAME_revslider_layer_animations_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>Redacted NAME_revslider_navigations: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>Redacted NAME_revslider_navigations_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>Redacted NAME_revslider_sliders: Data: 2.52MB + Index: 0.02MB + Engine InnoDB<br>Redacted NAME_revslider_sliders7: Data: 0.22MB + Index: 0.02MB + Engine InnoDB<br>Redacted NAME_revslider_sliders_bkp: Data: 1.52MB + Index: 0.00MB + Engine InnoDB<br>Redacted NAME_revslider_slides: Data: 1.52MB + Index: 0.02MB + Engine InnoDB<br>Redacted NAME_revslider_slides7: Data: 1.52MB + Index: 0.02MB + Engine InnoDB<br>Redacted NAME_revslider_slides_bkp: Data: 1.52MB + Index: 0.00MB + Engine InnoDB<br>Redacted NAME_revslider_static_slides: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>Redacted NAME_revslider_static_slides_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>Redacted NAME_sa_captured_wc_fields: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>Redacted NAME_sfa_abandoned_carts: Data: 17.52MB + Index: 0.00MB + Engine InnoDB<br>Redacted NAME_smsalert_booking_reminder: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>Redacted NAME_smsalert_renewal_reminders: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>Redacted NAME_termmeta: Data: 22.61MB + Index: 51.73MB + Engine InnoDB<br>Redacted NAME_terms: Data: 8.52MB + Index: 7.03MB + Engine InnoDB<br>Redacted NAME_term_relationships: Data: 21.55MB + Index: 23.03MB + Engine InnoDB<br>Redacted NAME_term_taxonomy: Data: 9.52MB + Index: 8.03MB + Engine InnoDB<br>Redacted NAME_usermeta: Data: 31.58MB + Index: 40.67MB + Engine InnoDB<br>Redacted NAME_users: Data: 2.52MB + Index: 0.97MB + Engine InnoDB<br>Redacted NAME_vi_woo_orders_tracking_track_info: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>Redacted NAME_wcpdf_invoice_number: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>Redacted NAME_wc_admin_notes: Data: 0.16MB + Index: 0.00MB + Engine InnoDB<br>Redacted NAME_wc_admin_note_actions: Data: 0.09MB + Index: 0.02MB + Engine InnoDB<br>Redacted NAME_wc_category_lookup: Data: 0.13MB + Index: 0.00MB + Engine InnoDB<br>Redacted NAME_wc_customer_lookup: Data: 1.52MB + Index: 0.64MB + Engine InnoDB<br>Redacted NAME_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>Redacted NAME_wc_orders: Data: 3.52MB + Index: 1.72MB + Engine InnoDB<br>Redacted NAME_wc_orders_meta: Data: 18.58MB + Index: 22.11MB + Engine InnoDB<br>Redacted NAME_wc_order_addresses: Data: 2.52MB + Index: 1.63MB + Engine InnoDB<br>Redacted NAME_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>Redacted NAME_wc_order_operational_data: Data: 1.52MB + Index: 0.48MB + Engine InnoDB<br>Redacted NAME_wc_order_product_lookup: Data: 1.52MB + Index: 1.61MB + Engine InnoDB<br>Redacted NAME_wc_order_stats: Data: 1.52MB + Index: 0.88MB + Engine InnoDB<br>Redacted NAME_wc_order_tax_lookup: Data: 0.48MB + Index: 0.38MB + Engine InnoDB<br>Redacted NAME_wc_product_attributes_lookup: Data: 3.52MB + Index: 5.03MB + Engine InnoDB<br>Redacted NAME_wc_product_download_directories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>Redacted NAME_wc_product_meta_lookup: Data: 9.52MB + Index: 17.13MB + Engine InnoDB<br>Redacted NAME_wc_rate_limits: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>Redacted NAME_wc_reserved_stock: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>Redacted NAME_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>Redacted NAME_wc_webhooks: Data: 0.34MB + Index: 0.11MB + Engine InnoDB<br>Redacted NAME_wfauditevents: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>Redacted NAME_wfblockediplog: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>Redacted NAME_wfblocks7: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>Redacted NAME_wfconfig: Data: 1.52MB + Index: 0.00MB + Engine InnoDB<br>Redacted NAME_wfcrawlers: Data: 0.05MB + Index: 0.00MB + Engine InnoDB<br>Redacted NAME_wffilechanges: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>Redacted NAME_wffilemods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>Redacted NAME_wfhits: Data: 1.02MB + Index: 0.08MB + Engine InnoDB<br>Redacted NAME_wfhoover: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>Redacted NAME_wfissues: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>Redacted NAME_wfknownfilelist: Data: 23.55MB + Index: 0.00MB + Engine InnoDB<br>Redacted NAME_wflivetraffichuman: Data: 0.05MB + Index: 0.05MB + Engine InnoDB<br>Redacted NAME_wflocs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>Redacted NAME_wflogins: Data: 0.13MB + Index: 0.03MB + Engine InnoDB<br>Redacted NAME_wfls_2fa_secrets: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>Redacted NAME_wfls_role_counts: Data: 0.00MB + Index: 0.00MB + Engine MEMORY<br>Redacted NAME_wfls_settings: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>Redacted NAME_wfnotifications: Data: 0.05MB + Index: 0.00MB + Engine InnoDB<br>Redacted NAME_wfpendingissues: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>Redacted NAME_wfpklist_template_data: Data: 0.09MB + Index: 0.00MB + Engine InnoDB<br>Redacted NAME_wfreversecache: Data: 1.52MB + Index: 0.00MB + Engine InnoDB<br>Redacted NAME_wfsecurityevents: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>Redacted NAME_wfsnipcache: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>Redacted NAME_wfstatus: Data: 0.09MB + Index: 0.09MB + Engine InnoDB<br>Redacted NAME_wftrafficrates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>Redacted NAME_wfwaffailures: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>Redacted NAME_woodmart_unsubscribed_emails: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>Redacted NAME_woodmart_waitlists: Data: 0.05MB + Index: 0.03MB + Engine InnoDB<br>Redacted NAME_woodmart_wishlists: Data: 0.36MB + Index: 0.00MB + Engine InnoDB<br>Redacted NAME_woodmart_wishlist_products: Data: 0.06MB + Index: 0.05MB + Engine InnoDB<br>Redacted NAME_woo_wallet_referrals: Data: 0.02MB + Index: 0.09MB + Engine InnoDB<br>Redacted NAME_woo_wallet_transactions: Data: 0.20MB + Index: 0.28MB + Engine InnoDB<br>Redacted NAME_woo_wallet_transaction_meta: Data: 0.09MB + Index: 0.09MB + Engine InnoDB<br>Redacted NAME_wotv_woo_track_info: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>Redacted NAME_wrc_caches: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>Redacted NAME_wrc_relations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>Redacted NAME_wt_iew_action_history: Data: 2.50MB + Index: 0.00MB + Engine InnoDB<br>Redacted NAME_wt_iew_cron: Data: 1.52MB + Index: 0.00MB + Engine InnoDB<br>Redacted NAME_wt_iew_email_template: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>Redacted NAME_wt_iew_ftp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>Redacted NAME_wt_iew_mapping_template: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>Redacted NAME_yith_wcaf_affiliates: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>Redacted NAME_yith_wcaf_clicks: Data: 0.42MB + Index: 0.17MB + Engine InnoDB<br>Redacted NAME_yith_wcaf_commissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>Redacted NAME_yith_wcaf_commission_notes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>Redacted NAME_yith_wcaf_payments: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>Redacted NAME_yith_wcaf_payment_commission: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>Redacted NAME_yith_wcaf_payment_notes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>Redacted NAME_yith_wcaf_rate_rulemeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>Redacted NAME_yith_wcaf_rate_rules: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>Redacted NAME_yith_wcwl: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>Redacted NAME_yith_wcwl_lists: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>Redacted NAME_yoast_expiring_store: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>Redacted NAME_yoast_indexable: Data: 51.59MB + Index: 37.13MB + Engine InnoDB<br>Redacted NAME_yoast_indexable_hierarchy: Data: 8.52MB + Index: 10.55MB + Engine InnoDB<br>Redacted NAME_yoast_migrations: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>Redacted NAME_yoast_primary_term: Data: 1.52MB + Index: 0.45MB + Engine InnoDB<br>Redacted NAME_yoast_seo_links: Data: 5.52MB + Index: 7.00MB + Engine InnoDB<br>Redacted NAME_yoast_seo_meta: Data: 0.34MB + Index: 0.00MB + Engine InnoDB<br>Redacted NAME_yoco_order_errors: Data: 0.02MB + Index: 0.00MB + Engine InnoDB Post Type Counts<br><br>attachment: 45276<br>cms_block: 26<br>cookielawinfo: 6<br>custom_css: 4<br>customize_changeset: 2<br>elementor_library: 1<br>frm_form_actions: 13<br>frm_styles: 1<br>jp_img_sitemap: 6<br>jp_img_sitemap_index: 1<br>jp_sitemap: 1<br>jp_sitemap_master: 1<br>jp_vid_sitemap: 1<br>nav_menu_item: 166<br>oembed_cache: 577<br>page: 63<br>pi_cefw_custom_group: 2<br>pi_fees_rule: 4<br>post: 116<br>product: 60427<br>product_variation: 31<br>shop_coupon: 405<br>shop_order: 7472<br>shop_order_refund: 263<br>shortcoder: 1<br>testimonial: 62<br>vtprd-rule: 1<br>wc_conditional_fee: 1<br>wcssc-cart: 28<br>wd_abandoned_cart: 32<br>wd_product_tabs: 4<br>wd_woo_discounts: 1<br>whatsapp-accounts: 1<br>woo_pb_share_link: 11<br>woo_product_builder: 1<br>woodmart_layout: 2<br>woodmart_sidebar: 1<br>woodmart_size_guide: 1<br>woodmart_slide: 1<br>woodmart_woo_fbt: 6<br>woosasc_cart: 34<br>wp_block: 1<br>wp_global_styles: 86<br>wp_navigation: 1<br>wp_template: 2<br>wpcode: 2<br>yaymail_template: 14 Security<br><br>Secure connection (HTTPS): ✔<br>Hide errors from visitors: ✔ Active Plugins (49)<br><br>Action Scheduler: by Automattic – 3.9.3<br>Advanced Database Cleaner: by SigmaPlugin – 4.1.1<br>Payment Gateway Based Fees and Discounts for WooCommerce: by Tyche Softwares – 3.1.0<br>Classic Editor: by WordPress Contributors – 1.7.0<br>Classic Widgets: by WordPress Contributors – 0.3<br>Conditional extra fees for WooCommerce PRO: by PI Websolution – 1.0.31.4<br>Custom Order Numbers for WooCommerce: by Tyche Softwares – 1.13.0<br>Desku: by Desku Inc – 2.1.1<br>EU/UK VAT Validation Manager for WooCommerce: by WPFactory – 4.6.1<br>Flexible Shipping PRO: by Octolize – 4.0.1<br>Flexible Shipping: by Octolize – 6.8.0<br>Formidable Forms: by Strategy11 Form Builder Team – 6.31<br>Google for WooCommerce: by WooCommerce – 3.7.1<br>Happy Ads: by Happy Pay – 1.0.0<br>Happy Pay Payment Gateway: by Happy Pay - Mark Geary – 6.2.3<br>Honeypot Toolkit: by Jeff Sterup – 5.0.4<br>Index WP MySQL For Speed: by Oliver Jones<br>Rick James – 1.5.7<br><br>IndexNow: by Microsoft Bing – 1.0.3<br>WPBakery Page Builder: by WPBakery – 8.7.3<br>LiteSpeed Cache: by LiteSpeed Technologies – 7.8.1<br>Shipping Cost on Product Page: by Octolize – 1.5.19<br>Payflex Payment Gateway: by Payflex – 2.7.0<br>WebToffee WooCommerce PDF Invoices, Packing Slips, Delivery Notes and Shipping Labels: by WebToffee – 4.9.6<br>Product Import Export for WooCommerce: by WebToffee – 2.6.4<br>Relevanssi: by Mikko Saari – 4.27.0<br>Slider Revolution: by ThemePunch – 6.7.56<br>Safe SVG: by 10up – 2.4.0<br>SMSAlert - WooCommerce: by Cozy Vision Technologies Pvt. Ltd. – 3.9.5<br>Tawk.to Live Chat: by Tawkto – 0.9.3<br>Checkout Field Editor for WooCommerce: by ThemeHigh – 2.1.9<br>Orders Tracking for WooCommerce: by VillaTheme – 1.2.17<br>TeraWallet: by StandaloneTech – 1.6.3<br>WooCommerce Legacy REST API: by WooCommerce – 1.0.5<br>WooCommerce Payfast Gateway: by WooCommerce – 1.7.6<br>PPOM for WooCommerce: by Themeisle – 34.0.2<br>Woocommerce Product Builder Premium: by VillaTheme – 2.3.8<br>WooCommerce Quote Gateway: by Marc Cognet – 1.0.0<br>WooCommerce: by Automattic – 10.8.1<br>Woodmart Core: by – 1.1.7<br>Wordfence Security: by Wordfence – 8.2.2<br>Yoast SEO: by Team Yoast – 27.8<br>WP Crontrol: by John Blackbourn – 1.21.0<br>WP Chat App: by NinjaTeam – 3.8.2<br>WPS Hide Login: by WPServeur<br>NicolasKulka<br>wpformation – 1.9.18<br><br>Product Import Export for WooCommerce Add-on: by WebToffee – 1.2.9<br>Import Export for WooCommerce Wrapper: by WebToffee – 1.3.2<br>YayMail - WooCommerce Email Customizer: by YayCommerce – 4.4.1<br>Yoco Payments: by Yoco – 3.9.4<br>Zapper Payments for WooCommerce: by Zapper Development – 2.1.13 Inactive Plugins (2)<br><br>Delete product images for WooCommerce: by Eduard V. Doloc – 3.0<br>Microsoft Clarity: by Microsoft – 0.10.24 Dropin Plugins ()<br><br>maintenance.php: maintenance.php<br>object-cache.php: LiteSpeed Cache - Object Cache (Drop-in) Must Use Plugins (1)<br><br>Index WP MySQL For Speed Upgrade Filter for mu-plugins.: by – 1.5.3 Settings<br><br>Legacy API Enabled: ✔<br>Force SSL: –<br>Currency: ZAR (R)<br>Currency Position: left<br>Thousand Separator: ,<br>Decimal Separator: .<br>Number of Decimals: 0<br>Taxonomies: Product Types: composite (composite)<br>external (external)<br>grouped (grouped)<br>simple (simple)<br>simple (simple-2)<br>simple (simple-3)<br>variable (variable)<br>woosb (woosb)<br><br>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)<br><br>Connected to WooCommerce.com: –<br>Enforce Approved Product Download Directories: –<br>HPOS feature enabled: –<br>Order datastore: WC_Order_Data_Store_CPT<br>HPOS data sync enabled: ✔<br>Enabled Features: analytics<br>marketplace<br>order_attribution<br>site_visibility_badge<br>remote_logging<br>email_improvements Logging<br><br>Enabled: ✔<br>Handler: Automattic\WooCommerce\Internal\Admin\Logging\LogHandlerFileV2<br>Retention period: 3 days<br>Level threshold: –<br>Log directory size: 19 MB WC Pages<br><br>Shop base: #11 - /shop/<br>Cart: #12 - /cart/ - Contains the &#091;woocommerce_cart] shortcode<br>Checkout: #13 - /checkout/ - Contains the &#091;woocommerce_checkout] shortcode<br>My account: #14 - /my-account/ - Contains the &#091;woocommerce_my_account] shortcode<br>Terms and conditions: #3205 - /terms-and-condition/ Theme<br><br>Name: Woodmart Child<br>Version: 1.0.0<br>Author URL: http://xtemos.com<br>Child Theme: ✔<br>Parent Theme Name: Woodmart<br>Parent Theme Version: 8.5.1 – 8.5.2 is available<br>Parent Theme Author URL: http://themeforest.net/user/xtemos<br>Theme type: Classic theme<br>WooCommerce Support: ✔ Templates<br><br>Override: wp-content/themes/woodmart/woocommerce/archive-product.php<br>Override: wp-content/themes/woodmart/woocommerce/cart/cart-item-data.php<br>Override: wp-content/themes/woodmart/woocommerce/cart/cart.php<br>Override: wp-content/themes/woodmart/woocommerce/cart/cross-sells.php<br>Override: wp-content/themes/woodmart/woocommerce/cart/mini-cart.php<br>Override: wp-content/themes/woodmart/woocommerce/checkout/form-checkout.php<br>Override: wp-content/themes/woodmart/woocommerce/checkout/thankyou.php<br>Override: wp-content/themes/woodmart/woocommerce/content-product-cat.php<br>Override: wp-content/themes/woodmart/woocommerce/content-product.php<br>Override: wp-content/themes/woodmart/woocommerce/content-single-product.php<br>Override: wp-content/themes/woodmart/woocommerce/content-widget-product.php<br>Override: wp-content/themes/woodmart/woocommerce/global/breadcrumb.php<br>Override: wp-content/themes/woodmart/woocommerce/global/form-login.php<br>Override: wp-content/themes/woodmart/woocommerce/global/quantity-input.php<br>Override: wp-content/themes/woodmart/woocommerce/loop/add-to-cart.php<br>Override: wp-content/themes/woodmart/woocommerce/loop/loop-end.php<br>Override: wp-content/themes/woodmart/woocommerce/loop/loop-start.php<br>Override: wp-content/themes/woodmart/woocommerce/loop/no-products-found.php<br>Override: wp-content/themes/woodmart/woocommerce/loop/orderby.php<br>Override: wp-content/themes/woodmart/woocommerce/loop/pagination.php<br>Override: wp-content/themes/woodmart/woocommerce/loop/sale-flash.php<br>Override: wp-content/themes/woodmart/woocommerce/myaccount/form-login.php<br>Override: wp-content/themes/woodmart/woocommerce/myaccount/my-account.php<br>Override: wp-content/themes/woodmart/woocommerce/product-searchform.php<br>Override: wp-content/themes/woodmart/woocommerce/single-product/add-to-cart/grouped.php<br>Override: wp-content/themes/woodmart/woocommerce/single-product/add-to-cart/variable.php<br>Override: wp-content/themes/woodmart/woocommerce/single-product/meta.php<br>Override: wp-content/themes/woodmart/woocommerce/single-product/product-attributes.php<br>Override: wp-content/themes/woodmart/woocommerce/single-product/product-image.php<br>Override: wp-content/themes/woodmart/woocommerce/single-product/product-thumbnails.php<br>Override: wp-content/themes/woodmart/woocommerce/single-product/rating.php<br>Override: wp-content/themes/woodmart/woocommerce/single-product/related.php<br>Override: wp-content/themes/woodmart/woocommerce/single-product/sale-flash.php<br>Override: wp-content/themes/woodmart/woocommerce/single-product/tabs/description.php<br>Override: wp-content/themes/woodmart/woocommerce/single-product/tabs/tabs.php<br>Override: wp-content/themes/woodmart/woocommerce/single-product/title.php<br>Override: wp-content/themes/woodmart/woocommerce/single-product/up-sells.php<br>Override: wp-content/themes/woodmart/woocommerce/single-product-reviews.php<br>Override: wp-content/themes/woodmart/woocommerce/single-product.php<br>Override: wp-content/themes/woodmart/woocommerce/content-product-cat.php Admin<br><br>Enabled Features: activity-panels<br>analytics<br>analytics-scheduled-import<br>product-block-editor<br>experimental-iapi-mini-cart<br>coupons<br>core-profiler<br>customize-store<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>onboarding<br>onboarding-tasks<br>pattern-toolkit-full-composability<br>product-custom-fields<br>remote-inbox-notifications<br>remote-free-extensions<br>payment-gateway-suggestions<br>printful<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<br>launch-your-store<br><br>Disabled Features: product-data-views<br>experimental-blocks<br>experimental-iapi-runtime<br>coming-soon-newsletter-template<br>minified-js<br>product-pre-publish-modal<br>products-catalog-api<br>settings<br>async-product-editor-category-field<br>product-editor-template-system<br>use-wp-horizon<br>rest-api-v4<br><br>Daily Cron: ✔ Next scheduled: 2026-06-12 19:35:05 +02:00<br>Options: ✔<br>Notes: 213<br>Onboarding: completed Action Scheduler<br><br>Complete: 14,797<br>Oldest: 2026-06-11 23:15:11 +0000<br>Newest: 2026-06-12 06:31:55 +0000<br><br>Failed: 81<br>Oldest: 2026-06-11 21:46:19 +0000<br>Newest: 2026-06-12 06:10:55 +0000<br><br>In-progress: 1<br>Oldest: –<br>Newest: –<br><br>Pending: 3,396<br>Oldest: 2026-06-12 04:59:46 +0000<br>Newest: 2026-06-30 21:59:59 +0000 Status report information<br><br>Generated at: 2026-06-12 08:32:50 +02:00<br>

    Also currently TOP via terminal the system has 8 cores 16gb ram (of which 4Gb for cpanel / wordpress and 1.5GB for Reddis and the rest for the OS and MariaDB currently its fine since i cleared everything at 2am i restarted the server to clear any caching on the OS since i dont have sudo/root rights on this one.

    CPU wise i have 2 lsphp workers. the other 6 cores for everything else generally wordpress itself takes about 250-400mb Ram the rest is SQL / Caching.

    top – 08:36:09 up 5:53, 0 users, load average: 1.88, 1.59, 1.50
    Tasks: 6 total, 3 running, 3 sleeping, 0 stopped, 0 zombie
    %Cpu(s): 9.8 us, 4.1 sy, 0.3 ni, 85.7 id, 0.1 wa, 0.0 hi, 0.1 si, 0.0 st
    MiB Mem : 15729.8 total, 1045.1 free, 6911.2 used, 8120.7 buff/cache
    MiB Swap: 0.0 total, 0.0 free, 0.0 used. 8818.6 avail Mem

    PID USER      PR  NI    VIRT    RES    SHR S  %CPU  %MEM     TIME+ COMMAND

    99284 vapeand+ 20 0 616792 296504 147860 R 38.2 1.8 0:03.80 lsphp
    99298 vapeand+ 20 0 583836 266092 148692 R 36.2 1.7 0:02.86 lsphp
    2731 vapeand+ 20 0 1431184 857132 17184 S 3.3 5.3 11:47.50 redis-server
    45397 vapeand+ 20 0 327568 52468 40840 S 0.0 0.3 0:10.80 lsphp
    92919 vapeand+ 20 0 5352 4284 3356 S 0.0 0.0 0:00.02 bash
    92980 vapeand+ 20 0 7980 3900 3300 R 0.0 0.0 0:00.59 top

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

    (@andyr94)

    Hey there,

    Thanks for sharing all that detail, the environment info, the server specs, and the code snippets. That makes it much easier to pinpoint what is happening here.

    The root cause: WP-Cron is disabled

    From the environment details you shared in your post, we can see that WP Cron is disabled on your site. This is a critical detail because Action Scheduler relies on WP-Cron to automatically trigger its queue runner every minute. With WP-Cron disabled and no server-side cron replacement firing wp-cron.php on a schedule, Action Scheduler has no way to automatically process the queue. That explains why actions pile up so fast overnight and between your manual WP-CLI runs.

    The fix: automate your WP-CLI command via a cPanel cron job

    You are already doing exactly the right thing by running wp action-scheduler run through your cPanel terminal. The issue is that you are doing it manually. Since you have cPanel access, you can automate this by setting up a cron job through cPanel’s Cron Jobs interface to run that same command every minute or every two minutes. This way, the queue will be continuously drained without you having to intervene.

    You can use the --batch-size and --batches flags to control how much work each run does, and the --group flag to prioritize specific action groups if needed. The full set of options is documented on the Action Scheduler WP-CLI page. For background on why WP-CLI processing is the recommended approach for high-volume stores like yours, take a look at the Action Scheduler Background Processing at Scale guide.

    Additionally, even with WP-Cron disabled, it is good practice to still have a server-side cron job triggering wp-cron.php so that other WordPress scheduled events continue to work normally. The WooCommerce guide on replacing WP-Cron with a real cron job walks through how to set that up in cPanel.

    A quick note on your code snippets

    The comments in your concurrent batches filter say “Bumps from 2 to 4” while the function returns 2. Similarly, the batch size comment says “Increases from 100 to 150” while it returns 100. The actual values sent to Action Scheduler are whatever the function returns, so the comments and the code are out of sync. That said, once you have a cron-driven WP-CLI runner in place, these web-based queue tuning filters become much less important since WP-CLI bypasses those limits entirely when using the --force flag.

    With 60,000+ products and Google for WooCommerce syncing each one individually through Action Scheduler, a cron-automated WP-CLI setup is really the way to go for a store at your scale. It will keep the queue moving around the clock without relying on site traffic or manual intervention.

    Thread Starter techguysa

    (@techguysa)

    HI yes cron disabled for real cron in wp-config

    define( ‘DISABLE_WP_CRON’, true );
    This is in $table_prefix =DATABASE NAME

    and in cpanel cron jobs to run every 5 mins
    cd /home/foldername/public_html && /usr/local/bin/php wp-cron.php >/dev/null 2>&1


    now after i made this post i did add this in cron jobs in cpanel

    which works

    set for every 1 min

    cd /home/folder name goes here/public_html && /usr/local/bin/php wp-cli.phar action-scheduler run >/dev/null 2>&1

    i did have the batch sizes changed before all that with 2 ques and batch of 100 then 150 (no real change on resources) the reason for the 2 is cause 8 cores on the server but its got 2 light speed workers.

    i have had to use this in terminal to clear majority of it

    after CD in its php wp-cli.phar action-scheduler run –batches=10 –force

    the 10 was cause last time i used it was about 2000 jobs behind after that i implemented the cron for every 1 min its been behaving since i normally see it at 900 with only 180 past due which is weird cause those 180 are future jobs (i.e sales falls away after x date)

    Plugin Support Andy – a11n

    (@andyr94)

    Thanks for the follow-up and for sharing the details of your cron configuration. It sounds like things are in much better shape now.

    To clarify, your original server cron running wp-cron.php every 5 minutes was already handling standard WordPress scheduled events correctly. The piece that was missing was a dedicated cron for Action Scheduler’s WP-CLI queue runner, and adding that at a one minute interval is the right approach for a store of your size. With 60,000+ products and Google for WooCommerce syncing each one through the queue, having a WP-CLI runner continuously draining actions is exactly how high volume stores are meant to operate. The Action Scheduler guide on Background Processing at Scale goes into more detail on why WP-CLI is the recommended approach once a store outgrows the default WP-Cron runner.

    About the ~180 past due actions you mentioned, that count is completely normal. Some of those are actions that become due between cron runs, since there is always a small window between each execution. Others, as you noted, are tied to scheduled WooCommerce events like sale end dates that have not reached their trigger time yet. The Action Scheduler FAQ confirms that having some past due actions is expected behavior. A count of 180 on a store with your volume is healthy.

    One thing worth keeping in mind for ongoing maintenance is the wp action-scheduler clean command. Running it periodically will prune old completed and cancelled actions from the database, keeping the actionscheduler_actions table lean over time. That should help with the database size and RAM concerns you mentioned earlier. The full set of options for the clean command is documented on the Action Scheduler WP-CLI page.

    We are glad we could help get this sorted out. If you have a moment, we would really appreciate it if you could leave a review on the Action Scheduler reviews page.

    Thread Starter techguysa

    (@techguysa)

    its just weird that it couldnt keep up with everything seems via wordpress there are some restrictions but the method i got now seems to be better servers ram is holding steady as well without it would hang / freeze and ram would build up close to OOM if not OOM on MariaDB (cause everything is waiting in que)

    unless im pushing the limits here

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

You must be logged in to reply to this topic.