• Resolved Krissieg

    (@krissieg)


    We’ve been doing some testing and find that our CPU usage on our website spikes whenever we’re editing products on our website. We’ve been working with our hosting provider, who has been looking at our site in general and it seems woocommerce is one of the issues for an increase in resource when working in the backend. Please can you help us resolve this as we don’t seem to be the only ones? Also, we’re a multi-vendor website and use YITH multi-vendor plugin. This means we can have backend usage with more than one admin at a time, so this spike issue definitely needs sorting for our site, otherwise we will not have many people wanting to use our site!
    Thanks

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

Viewing 11 replies - 1 through 11 (of 11 total)
  • Hi @krissieg

    Thanks for reaching out.

    Since the issue is about spike in resource usage, you may want to make sure that your hosting environment setup meets the WooCommerce Server Recommendations: https://woocommerce.com/document/server-requirements/

    Here are a few articles that have discussed ways to minimize CPU usage spike, which may be of help here:

    As you are using YITH multi-vendor plugin, the plugin’s team can help you with this the best. You can get in touch with their customer support team here: https://yithemes.com/contact-form/ . While we’re experts on our own products, third-party plugins are best supported by their own developers.

    Cheers

    Thread Starter Krissieg

    (@krissieg)

    Hey Margaret,
    Thanks for responding so quickly. 🙂
    I’ve been using Query Monitor on our site and it seems to be a Woocommerce issue:

    Notice (Suppressed)	Trying to get property 'ID' of non-object	2	
    wp-includes/class-wp-query.php:4121
    Plugin: woocommerce
    Notice (Suppressed)	Trying to get property 'post_title' of non-object	2	
    wp-includes/class-wp-query.php:4123
    Plugin: woocommerce
    Notice (Suppressed)	Trying to get property 'post_name' of non-object	2	
    wp-includes/class-wp-query.php:4125
    Plugin: woocommerce

    We’ve not got issues with the YITH plugin, it’s woocommerce that’s causing the spikes. We’ve not had such issues until recent updates of woocommerce. So any further help would be much appreciated. I’ve shared your comment above with our hosting to provider to check our settings on our server are correct.

    Thank you

    Hello,

    We’ve not had such issues until recent updates of woocommerce.

    We’ve been doing some testing and find that our CPU usage on our website spikes whenever we’re editing products on our website

    Can you provide the following information for us to take a closer look?

    Share a copy of your site’s System Status: You can find it via WooCommerce > Status. Select “Get system report” and then “Copy for support”.  Once you’ve done that, paste it here in your response.

    Error Log: Share a copy of any fatal error log found under WooCommerce > System Status > Logs (if any other error).

    Thank you.

    Thread Starter Krissieg

    (@krissieg)

    Sure, is is the status report:

    
    ### WordPress Environment ###
    
    WordPress address (URL): https://oyoo.earth
    Site address (URL): https://oyoo.earth
    WC Version: 6.4.1
    REST API Version: ✔ 6.4.1
    WC Blocks Version: ✔ 7.2.2
    Action Scheduler Version: ✔ 3.4.0
    WC Admin Version: ✔ 3.3.2
    Log Directory Writable: ✔
    WP Version: 5.9.3
    WP Multisite: –
    WP Memory Limit: 256 MB
    WP Debug Mode: –
    WP Cron: –
    Language: en_ZA
    External object cache: ✔
    
    ### Server Environment ###
    
    Server Info: LiteSpeed
    PHP Version: 7.4.28
    PHP Post Max Size: 256 MB
    PHP Time Limit: 600
    PHP Max Input Vars: 10000
    cURL Version: 7.71.0
    OpenSSL/1.1.1d
    
    SUHOSIN Installed: –
    MySQL Version: 5.5.5-10.1.48-MariaDB-cll-lve
    Max Upload Size: 128 MB
    Default Timezone is UTC: ✔
    fsockopen/cURL: ✔
    SoapClient: ✔
    DOMDocument: ✔
    GZip: ✔
    Multibyte String: ✔
    Remote Post: ✔
    Remote Get: ✔
    
    ### Database ###
    
    WC Database Version: 6.4.1
    WC Database Prefix: wppr_
    Total Database Size: 167.06MB
    Database Data Size: 139.63MB
    Database Index Size: 27.43MB
    wppr_woocommerce_sessions: Data: 27.56MB + Index: 1.52MB + Engine InnoDB
    wppr_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wppr_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wppr_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    wppr_woocommerce_order_items: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wppr_woocommerce_order_itemmeta: Data: 0.13MB + Index: 0.14MB + Engine InnoDB
    wppr_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    wppr_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wppr_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wppr_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wppr_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wppr_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wppr_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wppr_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wppr_actionscheduler_actions: Data: 2.52MB + Index: 1.30MB + Engine InnoDB
    wppr_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wppr_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wppr_actionscheduler_logs: Data: 1.52MB + Index: 0.63MB + Engine InnoDB
    wppr_aelia_dismissed_messages: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wppr_aepc_custom_audiences: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wppr_aepc_logs: Data: 0.39MB + Index: 0.00MB + Engine InnoDB
    wppr_ajaxsearchpro: Data: 0.05MB + Index: 0.00MB + Engine InnoDB
    wppr_ajaxsearchpro_priorities: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wppr_ajaxsearchpro_statistics: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wppr_asp_index: Data: 1.52MB + Index: 0.50MB + Engine InnoDB
    wppr_asp_synonyms: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wppr_commentmeta: Data: 0.06MB + Index: 0.03MB + Engine InnoDB
    wppr_comments: Data: 0.11MB + Index: 0.09MB + Engine InnoDB
    wppr_em_bookings: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wppr_em_events: Data: 0.02MB + Index: 0.14MB + Engine InnoDB
    wppr_em_locations: Data: 0.02MB + Index: 0.08MB + Engine InnoDB
    wppr_em_meta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wppr_em_tickets: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wppr_em_tickets_bookings: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wppr_fcm_notificaiton_logs: Data: 1.52MB + Index: 0.00MB + Engine InnoDB
    wppr_give_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wppr_give_comments: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wppr_give_donationmeta: Data: 0.08MB + Index: 0.06MB + Engine InnoDB
    wppr_give_donormeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wppr_give_donors: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wppr_give_formmeta: Data: 0.09MB + Index: 0.06MB + Engine InnoDB
    wppr_give_log: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wppr_give_migrations: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wppr_give_revenue: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wppr_give_sequential_ordering: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wppr_give_sessions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wppr_give_subscriptionmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wppr_give_subscriptions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    wppr_imbachat_hooks: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wppr_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wppr_litespeed_avatar: Data: 0.08MB + Index: 0.03MB + Engine InnoDB
    wppr_litespeed_crawler: Data: 0.09MB + Index: 0.08MB + Engine InnoDB
    wppr_litespeed_crawler_blacklist: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wppr_litespeed_img_optm: Data: 4.52MB + Index: 3.03MB + Engine InnoDB
    wppr_litespeed_img_optming: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wppr_litespeed_url: Data: 0.08MB + Index: 0.09MB + Engine InnoDB
    wppr_litespeed_url_file: Data: 0.02MB + Index: 0.08MB + Engine InnoDB
    wppr_mailchimp_carts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wppr_mailchimp_jobs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wppr_mailerlite_forms: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wppr_mailpoet_custom_fields: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wppr_mailpoet_forms: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wppr_mailpoet_log: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wppr_mailpoet_mapping_to_external_entities: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wppr_mailpoet_newsletters: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wppr_mailpoet_newsletter_links: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wppr_mailpoet_newsletter_option: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wppr_mailpoet_newsletter_option_fields: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wppr_mailpoet_newsletter_posts: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wppr_mailpoet_newsletter_segment: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wppr_mailpoet_newsletter_templates: Data: 2.52MB + Index: 0.00MB + Engine InnoDB
    wppr_mailpoet_scheduled_tasks: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wppr_mailpoet_scheduled_task_subscribers: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wppr_mailpoet_segments: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wppr_mailpoet_sending_queues: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wppr_mailpoet_settings: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wppr_mailpoet_statistics_clicks: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wppr_mailpoet_statistics_forms: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wppr_mailpoet_statistics_newsletters: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wppr_mailpoet_statistics_opens: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    wppr_mailpoet_statistics_unsubscribes: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wppr_mailpoet_statistics_woocommerce_purchases: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    wppr_mailpoet_stats_notifications: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wppr_mailpoet_subscribers: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    wppr_mailpoet_subscriber_custom_field: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wppr_mailpoet_subscriber_ips: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wppr_mailpoet_subscriber_segment: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wppr_mailpoet_user_flags: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wppr_ms_snippets: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wppr_myCRED_log: Data: 0.48MB + Index: 0.06MB + Engine InnoDB
    wppr_nf3_actions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wppr_nf3_action_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wppr_nf3_chunks: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wppr_nf3_fields: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wppr_nf3_field_meta: Data: 0.05MB + Index: 0.00MB + Engine InnoDB
    wppr_nf3_forms: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wppr_nf3_form_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wppr_nf3_objects: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wppr_nf3_object_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wppr_nf3_relationships: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wppr_nf3_upgrades: Data: 0.05MB + Index: 0.00MB + Engine InnoDB
    wppr_options: Data: 14.50MB + Index: 0.31MB + Engine InnoDB
    wppr_postmeta: Data: 44.58MB + Index: 7.03MB + Engine InnoDB
    wppr_posts: Data: 6.52MB + Index: 0.94MB + Engine InnoDB
    wppr_pwaforwp_analytics_data: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wppr_pwaforwp_analytics_overall: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wppr_redirection_404: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wppr_redirection_groups: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wppr_redirection_items: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
    wppr_redirection_logs: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wppr_revslider_css: Data: 0.14MB + Index: 0.00MB + Engine InnoDB
    wppr_revslider_css_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wppr_revslider_layer_animations: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wppr_revslider_layer_animations_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wppr_revslider_navigations: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wppr_revslider_navigations_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wppr_revslider_sliders: Data: 0.16MB + Index: 0.00MB + Engine InnoDB
    wppr_revslider_sliders_bkp: Data: 0.13MB + Index: 0.00MB + Engine InnoDB
    wppr_revslider_slides: Data: 1.52MB + Index: 0.00MB + Engine InnoDB
    wppr_revslider_slides_bkp: Data: 1.52MB + Index: 0.00MB + Engine InnoDB
    wppr_revslider_static_slides: Data: 0.14MB + Index: 0.00MB + Engine InnoDB
    wppr_revslider_static_slides_bkp: Data: 0.08MB + Index: 0.00MB + Engine InnoDB
    wppr_say_what_strings: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wppr_smush_dir_images: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wppr_snippets: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wppr_termmeta: Data: 0.19MB + Index: 0.11MB + Engine InnoDB
    wppr_terms: Data: 0.11MB + Index: 0.13MB + Engine InnoDB
    wppr_term_relationships: Data: 0.39MB + Index: 0.22MB + Engine InnoDB
    wppr_term_taxonomy: Data: 0.13MB + Index: 0.14MB + Engine InnoDB
    wppr_uap_action_log: Data: 0.02MB + Index: 0.08MB + Engine InnoDB
    wppr_uap_action_logs_view: Data: 0.00MB + Index: 0.00MB + Engine
    wppr_uap_action_log_meta: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    wppr_uap_closure_log: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    wppr_uap_closure_log_meta: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wppr_uap_recipe_log: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wppr_uap_recipe_logs_view: Data: 0.00MB + Index: 0.00MB + Engine
    wppr_uap_trigger_log: Data: 0.02MB + Index: 0.08MB + Engine InnoDB
    wppr_uap_trigger_logs_view: Data: 0.00MB + Index: 0.00MB + Engine
    wppr_uap_trigger_log_meta: Data: 0.02MB + Index: 0.08MB + Engine InnoDB
    wppr_um_conversations: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wppr_um_followers: Data: 0.05MB + Index: 0.00MB + Engine InnoDB
    wppr_um_friends: Data: 0.08MB + Index: 0.00MB + Engine InnoDB
    wppr_um_groups_members: Data: 0.06MB + Index: 0.00MB + Engine InnoDB
    wppr_um_messages: Data: 0.30MB + Index: 0.44MB + Engine InnoDB
    wppr_um_metadata: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wppr_um_notifications: Data: 2.52MB + Index: 0.00MB + Engine InnoDB
    wppr_upicrm_fields: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wppr_upicrm_fields_mapping: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wppr_upicrm_integrations: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wppr_upicrm_leads: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wppr_upicrm_leads_campaign: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wppr_upicrm_leads_integration: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wppr_upicrm_leads_route: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wppr_upicrm_leads_status: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wppr_upicrm_mails: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wppr_upicrm_options: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wppr_upicrm_users: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wppr_upicrm_webservice: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wppr_upicrm_webservice_parameters: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wppr_usermeta: Data: 3.52MB + Index: 3.03MB + Engine InnoDB
    wppr_users: Data: 0.09MB + Index: 0.05MB + Engine InnoDB
    wppr_wcpv_commissions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wppr_wcpv_per_product_shipping_rules: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wppr_wc_admin_notes: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wppr_wc_admin_note_actions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wppr_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wppr_wc_customer_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wppr_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wppr_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wppr_wc_order_product_lookup: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    wppr_wc_order_stats: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wppr_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wppr_wc_product_attributes_lookup: Data: 0.16MB + Index: 0.13MB + Engine InnoDB
    wppr_wc_product_meta_lookup: Data: 0.30MB + Index: 0.53MB + Engine InnoDB
    wppr_wc_rate_limits: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wppr_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wppr_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wppr_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wppr_webinarignition: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wppr_webinarignition_leads: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wppr_webinarignition_questions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wppr_webinarignition_users_online: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wppr_wi_logs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wppr_wpfm_backup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wppr_wpforms_entries: Data: 4.52MB + Index: 0.06MB + Engine InnoDB
    wppr_wpforms_entry_fields: Data: 1.52MB + Index: 1.02MB + Engine InnoDB
    wppr_wpforms_entry_meta: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wppr_wpforms_logs: Data: 5.52MB + Index: 0.00MB + Engine InnoDB
    wppr_wpforms_tasks_meta: Data: 0.08MB + Index: 0.00MB + Engine InnoDB
    wppr_wswebinars_chats: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wppr_wswebinars_email_queue: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wppr_wswebinars_notifications: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wppr_wswebinars_questions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wppr_wswebinars_subscribers: Data: 0.02MB + Index: 0.08MB + Engine InnoDB
    wppr_wswebinars_unsubscribe: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wppr_yith_vendors_commissions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wppr_yith_vendors_commissions_notes: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wppr_yith_vendors_payments: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wppr_yith_vendors_payments_relationship: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wppr_yith_wcan_filter_sessions: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wppr_yith_wcps_shippings: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wppr_yith_wcsc_commissions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wppr_yith_wcsc_receivers: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wppr_yoast_indexable: Data: 3.52MB + Index: 1.84MB + Engine InnoDB
    wppr_yoast_indexable_hierarchy: Data: 0.23MB + Index: 0.31MB + Engine InnoDB
    wppr_yoast_migrations: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wppr_yoast_primary_term: Data: 0.06MB + Index: 0.03MB + Engine InnoDB
    wppr_yoast_seo_links: Data: 0.20MB + Index: 0.16MB + Engine InnoDB
    wppr_yoast_seo_meta: Data: 0.27MB + Index: 0.00MB + Engine InnoDB
    wppr_yoco_order_errors: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    
    ### Post Type Counts ###
    
    agora_channel: 2
    attachment: 2893
    bnfw_notification: 1
    cp_recipe: 88
    cspm_post_type: 1
    cspmas: 1
    custom_css: 3
    customize_changeset: 4
    event: 1
    fmwp_forum: 2
    fmwp_reply: 3
    fmwp_topic: 2
    give_forms: 3
    give_payment: 15
    mailpoet_page: 1
    master-popups: 1
    mycred_badge: 6
    mycred_coupon: 1
    mycred_email_notice: 1
    nav_menu_item: 49
    notification: 1
    oembed_cache: 6
    page: 61
    portfolio: 9
    post: 92
    product: 140
    product_variation: 2340
    revision: 29
    shop_coupon: 15
    shop_order: 53
    shop_order_refund: 2
    um_activity: 909
    um_directory: 1
    um_form: 9
    um_groups: 2
    um_groups_discussion: 110
    um_mailchimp: 1
    um_notice: 5
    um_private_content: 257
    um_profile_tabs: 8
    um_review: 5
    um_user_photos: 5
    uo-trigger: 1
    wpforms: 12
    wpws_page: 2
    yith_wcan_preset: 1
    ywctm-button-label: 3
    
    ### Security ###
    
    Secure connection (HTTPS): ✔
    Hide errors from visitors: ✔
    
    ### Active Plugins (67) ###
    
    AddToAny Share Buttons: by AddToAny – 1.8.4
    Better Notifications for WP: by Made with Fuel – 1.8.11
    Call to Action for PWA: by Magazine3 – 1.8.8
    Classic Editor: by WordPress Contributors – 1.6.2
    Classic Widgets: by WordPress Contributors – 0.3
    Clickmeeting: by Clickmeeting – 1.0.0
    Cooked: by Boxy Studio – 1.7.11
    Data Analytics for PWA: by Magazine3 – 1.4
    Duplicate Page: by mndpsingh287 – 4.4.8
    Easy WP SMTP: by wpecommerce
    alexanderfoxc – 1.4.7
    
    Enlighter - Customizable Syntax Highlighter: by Andi Dittrich – 4.4.2
    Envato Market: by Envato – 2.0.7
    Salient WPBakery Page Builder: by Michael M - WPBakery.com | Modified by ThemeNectar – 6.7.1
    HubSpot All-In-One Marketing - Forms, Popups, Live Chat: by HubSpot – 8.9.22
    LiteSpeed Cache: by LiteSpeed Technologies – 4.6
    Mailchimp for WooCommerce: by Mailchimp – 2.6.2
    My Custom Functions: by Space X-Chimp – 4.51
    myCred: by myCred – 2.4.4.1
    Permalink Manager Lite: by Maciej Bis – 2.2.17
    Post Expiration Date: by Huguette Inc. – 1.3
    Push Notification: by Magazine3 – 1.22
    PWA for WP: by Magazine3 – 1.7.45
    PWA Pro Extension Manager: by PWAforWP Team – 1.9.2.1
    Redirection: by John Godley – 5.2.3
    Salient Core: by ThemeNectar – 1.9.4
    Salient Portfolio: by ThemeNectar – 1.7.1
    Salient Shortcodes: by ThemeNectar – 1.5
    Salient Social: by ThemeNectar – 1.2.2
    Salient Widgets: by ThemeNectar – 1.2
    WooCommerce: by Automattic – 6.4.1
    Termly | GDPR/CCPA Cookie Consent Banner: by Termly – 3.0.3
    Ultimate Member: by Ultimate Member – 2.3.1
    Ultimate Member - Followers: by Ultimate Member – 2.2.5
    Ultimate Member - Friends: by Ultimate Member – 2.2.3
    Ultimate Member - Groups: by Ultimate Member – 2.2.9
    Ultimate Member - MailChimp: by Ultimate Member – 2.3.2
    Ultimate Member - Private Messages: by Ultimate Member – 2.3.2
    Ultimate Member - myCRED: by Ultimate Member – 2.2.3
    Ultimate Member - Notices: by Ultimate Member – 2.1.1
    Ultimate Member - Real-time Notifications: by Ultimate Member – 2.3.0
    Ultimate Member - Online: by Ultimate Member – 2.1.5
    Ultimate Member - Profile tabs: by Ultimate Member – 1.0.6
    Ultimate Member - reCAPTCHA: by Ultimate Member – 2.2.2
    Ultimate Member - User Reviews: by Ultimate Member – 2.2.2
    Ultimate Member - Social Activity: by Ultimate Member – 2.2.7
    Ultimate Member - User Bookmarks: by Ultimate Member – 2.0.9
    Ultimate Member - User Locations: by Ultimate Member – 1.0.6
    Ultimate Member - User Tags: by Ultimate Member – 2.1.9
    Ultimate Member - Verified Users: by Ultimate Member – 2.1.3
    Ultimate Member - WooCommerce: by Ultimate Member – 2.3.0
    User Switching: by John Blackbourn & contributors – 1.5.8
    Aelia Foundation Classes for WooCommerce: by Aelia – 2.2.5.220330
    WPC Added To Cart Notification for WooCommerce: by WPClever – 2.0.7
    Paystack WooCommerce Payment Gateway: by Tunbosun Ayinla – 5.7.3
    Aelia Currency Switcher for WooCommerce: by Aelia – 4.13.5.220330
    WooCommerce PayPal Payments: by WooCommerce – 1.7.1
    The Courier Guy Shipping for WooCommerce: by The Courier Guy – 5.0.7
    Yoast SEO: by Team Yoast – 18.6
    WPForms Custom Captcha: by WPForms – 1.4.0
    WPForms Post Submissions: by WPForms – 1.3.2
    WPForms Surveys and Polls: by WPForms – 1.7.0
    WPForms: by WPForms – 1.7.3
    WPShapere Lite: by AcmeeDesign Softwares and Solutions – 1.2
    YITH WooCommerce Ajax Product Filter Premium: by YITH – 4.9.0
    YITH WooCommerce Ajax Search: by YITH – 1.18.0
    YITH WooCommerce Catalog Mode Premium: by YITH – 2.10.0
    YITH WooCommerce Multi Vendor Premium: by YITH – 3.15.0
    
    ### Inactive Plugins (1) ###
    
    Query Monitor: by John Blackbourn – 3.9.0
    
    ### Dropin Plugins (1) ###
    
    object-cache.php: object-cache.php
    
    ### Must Use Plugins (2) ###
    
    Health Check Troubleshooting Mode: by  – 1.7.0
    UM redirect fix: by UM team – 1.0
    
    ### Settings ###
    
    API Enabled: –
    Force SSL: –
    Currency: ZAR (ZAR)
    Currency Position: left
    Thousand Separator: ,
    Decimal Separator: .
    Number of Decimals: 2
    Taxonomies: Product Types: external (external)
    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: ✔
    
    ### WC Pages ###
    
    Shop base: #9611 - /market/
    Basket: #9612 - /basket/
    Checkout: #9613 - /checkout/
    My account: #9614 - /my-account/
    Terms and conditions: #363 - /small-print/
    
    ### Theme ###
    
    Name: Salient Child
    Version: (update to version 0 is available)
    Author URL: 
    Child Theme: ✔
    Parent Theme Name: Salient
    Parent Theme Version: 14.0.5
    Parent Theme Author URL: https://themeforest.net/user/themenectar
    WooCommerce Support: ✔
    
    ### Templates ###
    
    Overrides: salient/woocommerce/cart/mini-cart.php
    salient/woocommerce/checkout/form-checkout.php
    salient/woocommerce/checkout/review-order.php
    salient/woocommerce/checkout/terms.php
    salient/woocommerce/content-product.php
    salient/woocommerce/content-single-product.php
    salient/woocommerce/loop/add-to-cart.php
    salient/woocommerce/loop/loop-start.php
    salient/woocommerce/myaccount/form-login.php
    salient/woocommerce/single-product/product-image.php
    salient/woocommerce/single-product/rating.php
    salient/woocommerce/single-product/tabs/description.php
    salient/woocommerce/single-product/tabs/tabs.php
    salient/woocommerce/single-product/title.php
    salient/woocommerce/single-product-reviews.php
    
    ### WooCommerce PayPal Payments ###
    
    Onboarded: ✔
    Shop country code: ZA
    WooCommerce currency supported: –
    PayPal card processing available in country: –
    Pay Later messaging available in country: –
    Webhook status: –
    Vault enabled: ✔
    Logging enabled: –
    Reference Transactions: –
    Used PayPal Checkout plugin: ✔
    
    ### Action Scheduler ###
    
    Canceled: 1
    Oldest: 2022-04-15 11:32:16 +0000
    Newest: 2022-04-15 11:32:16 +0000
    
    Complete: 5,211
    Oldest: 2022-03-21 07:06:28 +0000
    Newest: 2022-04-20 07:17:44 +0000
    
    Failed: 16
    Oldest: 2020-06-29 19:07:13 +0000
    Newest: 2022-03-31 13:45:11 +0000
    
    Pending: 9
    Oldest: 2022-04-20 08:17:44 +0000
    Newest: 2022-04-26 09:40:58 +0000
    
    ### Status report information ###
    
    Generated at: 2022-04-20 09:18:18 +02:00
    
    Mashi

    (@shaonback2)

    Hello @krissieg!

    I see your site has a WP Memory limit of 256MB. Can you please increase that to 1024MB and see if that helps?

    If that doesn’t work then this is likely caused by a conflict with your theme or with another plugin.

    The best way to determine if the issue is being caused by a theme and/or plugin is to temporarily switch your theme to Storefront and disable all plugins except for WooCommerce. Finally, test to see if the issue is resolved.

    To figure out which plugin is causing the problem, continue to the next step – reactivate your other plugins one by one, testing after each, until you find the one causing conflict.

    Here’s a more extensive explanation in our docs: https://docs.woocommerce.com/document/how-to-test-for-conflicts/

    —–

    Tools to help you troubleshoot:

    Meks Quick Plugin Disabler is a plugin you can install which will remember what plugins you currently have active so it’s easy to switch them back on. Link: https://ww.wp.xz.cn/plugins/meks-quick-plugin-disabler/

    You can clone your site to a staging environment and perform tests without modifying your live site or impacting customers. Many hosts provide staging facilities, so it’s worth checking in with them. It’s also possible to do it using the free WP Staging plugin. Link: https://ww.wp.xz.cn/plugins/wp-staging/

    Thread Starter Krissieg

    (@krissieg)

    Ok, thanks I’ll ask our hosting provider to increase the memory and see if that sorts it. Please leave this thread open for now. I’ll get back to you either way.

    Thanks

    Thread Starter Krissieg

    (@krissieg)

    Hi there, I’ve spoken to our hosting and this is what they say about the memory increase:

    In our previous tests, we have tried this, but it is leading only to more performance issues as a big chunk of memory is allocated by one process and leading to a bottle neck in the resource usage. At that point we don’t recommend to set more than 256-512MB for the memory_limit

    Mashi

    (@shaonback2)

    Hello @krissieg!

    A similar issue was solved by clearing transients. Can you please try that?

    WooCommerce transients can be cleared from “WooCommerce > Status > Tools” area.

    Thread Starter Krissieg

    (@krissieg)

    I’ve upped our memory to 1Gb and have cleared the transients. What are transients? We’ll monitor performance and get back to this thread. We find the site struggled when we’re editing products i.e. variations etc.

    Hello,

    You can find a definition of a transient on this page essentially they are pieces of temporary information that work as a complement of a caching system.

    We’ll monitor performance and get back to this thread.

    Great, that sounds like a plan, please keep us informed.

    Best.

    We haven’t heard back from you in a while, so I’m marking this thread closed – we’ll be here if and/or when you are ready to continue.

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

The topic ‘Woocommerce causing CPU spike on server’ is closed to new replies.