New WooCommerce install. Resource Usage Spikes – Dashboard Slow

  • Resolved mxnewengland

    (@mxnewengland)


    3 years, 10 months ago

    Hi,

    I recently added a store to my website with the WooCommerce and Printfull plugins. I’m currently experiencing an issue where the WordPress dashboard is so slow it is virtually un-navigable and sometimes returns errors.

    I reached out to GoDaddy as well as the theme creator with no success.(GoDaddy response: “We tried updating the setting and Deactivating and activating it again , however we still see some issue with Woo -commerce as per our team either you need to contact the plugin administrator directly https://woocommerce.com/contact-us/ or contact our WordPress premium support”

    This is the info I have gathered so far:

    I’m currently experiencing spikes in resource usage. With WooCommerce plugin active, navigating the wordpress dashboard results in:
    Physical memory at limit.
    I/O usage at limit with faults.
    IOPSf faults (possibly PMemF).

    With only the WooCommerce plugin deactivated these issues go away.

    This is the case on both my child Risotto theme as well as the Twenty Sixteen theme.

    All themes and plugins up to date.

    Below is the system status report from my staging site.

    
### WordPress Environment ###

WordPress address (URL): https://www.mxnewengland.com/dec20
Site address (URL): https://www.mxnewengland.com/dec20
WC Version: 4.8.0
REST API Version: ? 4.8.0
WC Blocks Version: ? 3.8.1
Action Scheduler Version: ? 3.1.6
WC Admin Version: ? 1.7.3
Log Directory Writable: ?
WP Version: 5.6
WP Multisite: –
WP Memory Limit: 256 MB
WP Debug Mode: –
WP Cron: ?
Language: en
External object cache: –

### Server Environment ###

Server Info: Apache
PHP Version: 7.4.11
PHP Post Max Size: 32 MB
PHP Time Limit: 30
PHP Max Input Vars: 1000
cURL Version: 7.71.0
OpenSSL/1.1.1d

SUHOSIN Installed: –
MySQL Version: 5.6.49-cll-lve
Max Upload Size: 32 MB
Default Timezone is UTC: ?
fsockopen/cURL: ?
SoapClient: ?
DOMDocument: ?
GZip: ?
Multibyte String: ?
Remote Post: ?
Remote Get: ?

### Database ###

WC Database Version: 4.8.0
WC Database Prefix: wpstg0_
Total Database Size: 81.06MB
Database Data Size: 66.55MB
Database Index Size: 14.51MB
wpstg0_woocommerce_sessions: Data: 2.75MB + Index: 0.16MB + Engine MyISAM
wpstg0_woocommerce_api_keys: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wpstg0_woocommerce_attribute_taxonomies: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wpstg0_woocommerce_downloadable_product_permissions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpstg0_woocommerce_order_items: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpstg0_woocommerce_order_itemmeta: Data: 0.01MB + Index: 0.01MB + Engine MyISAM
wpstg0_woocommerce_tax_rates: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpstg0_woocommerce_tax_rate_locations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpstg0_woocommerce_shipping_zones: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpstg0_woocommerce_shipping_zone_locations: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wpstg0_woocommerce_shipping_zone_methods: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpstg0_woocommerce_payment_tokens: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpstg0_woocommerce_payment_tokenmeta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpstg0_woocommerce_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpstg0_actionscheduler_actions: Data: 0.83MB + Index: 0.27MB + Engine MyISAM
wpstg0_actionscheduler_claims: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpstg0_actionscheduler_groups: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wpstg0_actionscheduler_logs: Data: 0.53MB + Index: 0.38MB + Engine MyISAM
wpstg0_commentmeta: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wpstg0_comments: Data: 0.02MB + Index: 0.01MB + Engine MyISAM
wpstg0_eg_grids: Data: 0.03MB + Index: 0.01MB + Engine MyISAM
wpstg0_eg_item_elements: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wpstg0_eg_item_skins: Data: 0.60MB + Index: 0.01MB + Engine MyISAM
wpstg0_eg_navigation_skins: Data: 0.08MB + Index: 0.01MB + Engine MyISAM
wpstg0_links: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpstg0_ms_snippets: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpstg0_options: Data: 3.11MB + Index: 0.06MB + Engine MyISAM
wpstg0_postmeta: Data: 5.78MB + Index: 3.23MB + Engine MyISAM
wpstg0_posts: Data: 2.94MB + Index: 0.44MB + Engine MyISAM
wpstg0_redirection_404: Data: 0.70MB + Index: 0.11MB + Engine MyISAM
wpstg0_redirection_groups: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpstg0_redirection_items: Data: 0.00MB + Index: 0.02MB + Engine MyISAM
wpstg0_redirection_logs: Data: 0.02MB + Index: 0.00MB + Engine MyISAM
wpstg0_revslider_css: Data: 0.09MB + Index: 0.00MB + Engine MyISAM
wpstg0_revslider_css_bkp: Data: 0.09MB + Index: 0.00MB + Engine MyISAM
wpstg0_revslider_layer_animations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpstg0_revslider_layer_animations_bkp: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpstg0_revslider_navigations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpstg0_revslider_navigations_bkp: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpstg0_revslider_sliders: Data: 0.03MB + Index: 0.00MB + Engine MyISAM
wpstg0_revslider_sliders_bkp: Data: 0.03MB + Index: 0.00MB + Engine MyISAM
wpstg0_revslider_slides: Data: 0.03MB + Index: 0.00MB + Engine MyISAM
wpstg0_revslider_slides_bkp: Data: 0.03MB + Index: 0.00MB + Engine MyISAM
wpstg0_revslider_static_slides: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpstg0_revslider_static_slides_bkp: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpstg0_sbi_instagram_feeds_posts: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpstg0_sbi_instagram_posts: Data: 0.13MB + Index: 0.00MB + Engine MyISAM
wpstg0_snippets: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpstg0_termmeta: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wpstg0_terms: Data: 0.00MB + Index: 0.02MB + Engine MyISAM
wpstg0_term_relationships: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wpstg0_term_taxonomy: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wpstg0_usermeta: Data: 0.01MB + Index: 0.01MB + Engine MyISAM
wpstg0_users: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wpstg0_wc_admin_notes: Data: 0.01MB + Index: 0.00MB + Engine MyISAM
wpstg0_wc_admin_note_actions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpstg0_wc_category_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpstg0_wc_customer_lookup: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wpstg0_wc_download_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpstg0_wc_order_coupon_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpstg0_wc_order_product_lookup: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wpstg0_wc_order_stats: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wpstg0_wc_order_tax_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpstg0_wc_product_meta_lookup: Data: 0.25MB + Index: 0.19MB + Engine MyISAM
wpstg0_wc_reserved_stock: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpstg0_wc_tax_rate_classes: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wpstg0_wc_webhooks: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpstg0_wpfm_backup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpstg1_actionscheduler_actions: Data: 0.60MB + Index: 0.20MB + Engine MyISAM
wpstg1_actionscheduler_claims: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpstg1_actionscheduler_groups: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wpstg1_actionscheduler_logs: Data: 0.39MB + Index: 0.28MB + Engine MyISAM
wpstg1_commentmeta: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wpstg1_comments: Data: 0.02MB + Index: 0.01MB + Engine MyISAM
wpstg1_eg_grids: Data: 0.03MB + Index: 0.01MB + Engine MyISAM
wpstg1_eg_item_elements: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wpstg1_eg_item_skins: Data: 0.60MB + Index: 0.01MB + Engine MyISAM
wpstg1_eg_navigation_skins: Data: 0.08MB + Index: 0.01MB + Engine MyISAM
wpstg1_links: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpstg1_ms_snippets: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpstg1_options: Data: 2.35MB + Index: 0.06MB + Engine MyISAM
wpstg1_postmeta: Data: 4.96MB + Index: 2.43MB + Engine MyISAM
wpstg1_posts: Data: 2.75MB + Index: 0.37MB + Engine MyISAM
wpstg1_redirection_404: Data: 0.79MB + Index: 0.11MB + Engine MyISAM
wpstg1_redirection_groups: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpstg1_redirection_items: Data: 0.00MB + Index: 0.02MB + Engine MyISAM
wpstg1_redirection_logs: Data: 0.01MB + Index: 0.00MB + Engine MyISAM
wpstg1_revslider_css: Data: 0.09MB + Index: 0.00MB + Engine MyISAM
wpstg1_revslider_layer_animations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpstg1_revslider_navigations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpstg1_revslider_sliders: Data: 0.03MB + Index: 0.00MB + Engine MyISAM
wpstg1_revslider_slides: Data: 0.03MB + Index: 0.00MB + Engine MyISAM
wpstg1_revslider_static_slides: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpstg1_sbi_instagram_feeds_posts: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpstg1_sbi_instagram_posts: Data: 0.13MB + Index: 0.00MB + Engine MyISAM
wpstg1_snippets: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpstg1_termmeta: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wpstg1_terms: Data: 0.00MB + Index: 0.02MB + Engine MyISAM
wpstg1_term_relationships: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wpstg1_term_taxonomy: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wpstg1_usermeta: Data: 0.01MB + Index: 0.01MB + Engine MyISAM
wpstg1_users: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wpstg1_wc_admin_notes: Data: 0.01MB + Index: 0.00MB + Engine MyISAM
wpstg1_wc_admin_note_actions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpstg1_wc_category_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpstg1_wc_customer_lookup: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wpstg1_wc_download_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpstg1_wc_order_coupon_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpstg1_wc_order_product_lookup: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wpstg1_wc_order_stats: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wpstg1_wc_order_tax_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpstg1_wc_product_meta_lookup: Data: 0.25MB + Index: 0.19MB + Engine MyISAM
wpstg1_wc_reserved_stock: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpstg1_wc_tax_rate_classes: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wpstg1_wc_webhooks: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpstg1_woocommerce_api_keys: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wpstg1_woocommerce_attribute_taxonomies: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wpstg1_woocommerce_downloadable_product_permissions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpstg1_woocommerce_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpstg1_woocommerce_order_itemmeta: Data: 0.01MB + Index: 0.01MB + Engine MyISAM
wpstg1_woocommerce_order_items: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpstg1_woocommerce_payment_tokenmeta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpstg1_woocommerce_payment_tokens: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpstg1_woocommerce_sessions: Data: 2.86MB + Index: 0.16MB + Engine MyISAM
wpstg1_woocommerce_shipping_zones: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpstg1_woocommerce_shipping_zone_locations: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wpstg1_woocommerce_shipping_zone_methods: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpstg1_woocommerce_tax_rates: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpstg1_woocommerce_tax_rate_locations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpstg1_wpfm_backup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_actionscheduler_actions: Data: 0.90MB + Index: 0.36MB + Engine MyISAM
wp_actionscheduler_claims: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_actionscheduler_groups: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wp_actionscheduler_logs: Data: 0.53MB + Index: 0.41MB + Engine MyISAM
wp_commentmeta: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wp_comments: Data: 0.02MB + Index: 0.01MB + Engine MyISAM
wp_eg_grids: Data: 0.03MB + Index: 0.01MB + Engine MyISAM
wp_eg_item_elements: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wp_eg_item_skins: Data: 0.60MB + Index: 0.01MB + Engine MyISAM
wp_eg_navigation_skins: Data: 0.08MB + Index: 0.01MB + Engine MyISAM
wp_links: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_ms_snippets: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_options: Data: 3.17MB + Index: 0.11MB + Engine MyISAM
wp_postmeta: Data: 18.28MB + Index: 3.06MB + Engine MyISAM
wp_posts: Data: 3.01MB + Index: 0.58MB + Engine MyISAM
wp_redirection_404: Data: 0.98MB + Index: 0.14MB + Engine MyISAM
wp_redirection_groups: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_redirection_items: Data: 0.00MB + Index: 0.02MB + Engine MyISAM
wp_redirection_logs: Data: 0.03MB + Index: 0.00MB + Engine MyISAM
wp_revslider_css: Data: 0.09MB + Index: 0.00MB + Engine MyISAM
wp_revslider_css_bkp: Data: 0.09MB + Index: 0.00MB + Engine MyISAM
wp_revslider_layer_animations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_revslider_layer_animations_bkp: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_revslider_navigations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_revslider_navigations_bkp: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_revslider_sliders: Data: 0.03MB + Index: 0.00MB + Engine MyISAM
wp_revslider_sliders_bkp: Data: 0.03MB + Index: 0.00MB + Engine MyISAM
wp_revslider_slides: Data: 0.03MB + Index: 0.00MB + Engine MyISAM
wp_revslider_slides_bkp: Data: 0.03MB + Index: 0.00MB + Engine MyISAM
wp_revslider_static_slides: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_revslider_static_slides_bkp: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_sbi_instagram_feeds_posts: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_sbi_instagram_posts: Data: 0.13MB + Index: 0.00MB + Engine MyISAM
wp_snippets: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_termmeta: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wp_terms: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wp_term_relationships: Data: 0.01MB + Index: 0.03MB + Engine MyISAM
wp_term_taxonomy: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wp_usermeta: Data: 0.01MB + Index: 0.01MB + Engine MyISAM
wp_users: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wp_wc_admin_notes: Data: 0.01MB + Index: 0.00MB + Engine MyISAM
wp_wc_admin_note_actions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wc_category_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wc_customer_lookup: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wp_wc_download_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wc_order_coupon_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wc_order_product_lookup: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wp_wc_order_stats: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wp_wc_order_tax_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wc_product_meta_lookup: Data: 0.26MB + Index: 0.25MB + Engine MyISAM
wp_wc_reserved_stock: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wc_tax_rate_classes: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wp_wc_webhooks: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_woocommerce_api_keys: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wp_woocommerce_attribute_taxonomies: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wp_woocommerce_downloadable_product_permissions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_woocommerce_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_woocommerce_order_itemmeta: Data: 0.01MB + Index: 0.01MB + Engine MyISAM
wp_woocommerce_order_items: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_woocommerce_payment_tokenmeta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_woocommerce_payment_tokens: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_woocommerce_sessions: Data: 4.09MB + Index: 0.23MB + Engine MyISAM
wp_woocommerce_shipping_zones: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_woocommerce_shipping_zone_locations: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wp_woocommerce_shipping_zone_methods: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_woocommerce_tax_rates: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_woocommerce_tax_rate_locations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wpfm_backup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM

### Post Type Counts ###

attachment: 793
calendar: 1
custom_css: 1
customize_changeset: 1
nav_menu_item: 10
page: 67
post: 2
product: 57
product_variation: 2868
revision: 758
shop_coupon: 4
shop_order: 3
tribe_events: 7
tribe_organizer: 28
tribe_venue: 109
vc_grid_item: 1
wpcf7_contact_form: 3

### Security ###

Secure connection (HTTPS): ?
Hide errors from visitors: ?

### Active Plugins (27) ###

Query Monitor: by John Blackbourn – 3.6.5
SSL Zen - Free SSL Certificate & HTTPS Redirect for WordPress: by SSL Zen – 3.0.13
All-in-One WP Migration: by ServMask – 7.32
Contact Form 7 - reCAPTCHA: by iambriansreed – 1.2.0
Contact Form 7: by Takayuki Miyoshi – 5.3.2
Enable jQuery Migrate Helper: by The WordPress Team – 1.3.0
Essential Grid: by ThemePunch – 3.0.11
The Events Calendar PRO: by Modern Tribe
Inc. – 5.2.1.1

Health Check & Troubleshooting: by The www.ads-software.com community – 1.4.5
Smash Balloon Instagram Feed: by Smash Balloon – 2.6.2
WPBakery Page Builder: by Michael M - WPBakery.com – 6.5.0
Limit Login Attempts: by Johan Eenfeldt – 1.7.1
Printful Integration for WooCommerce: by Printful – 2.1.18
Really Simple SSL: by Really Simple Plugins – 4.0.5
Redirection: by John Godley – 4.9.2
Slider Revolution: by ThemePunch – 6.3.4
The Events Calendar Shortcode & Block: by Event Calendar Newsletter – 2.4
The Events Calendar: by Modern Tribe
Inc. – 5.3.1.1

UpdraftPlus - Backup/Restore: by UpdraftPlus.Com
DavidAnderson – 1.16.43

Export & Import Templates for WPBakery Page Builder: by Tomiup – 1.0.0
Webnus Importer: by Webnus – 1.0
Webnus Shortcodes: by Webnus – 1.0
WooCommerce PayPal Checkout Gateway: by WooCommerce – 2.1.1
WooCommerce: by Automattic – 4.8.0
WP File Manager: by mndpsingh287 – 6.9
WP-PageNavi: by Lester 'GaMerZ' Chan – 2.93.3
WP STAGING: by WP-STAGING – 2.8.0

### Inactive Plugins (0) ###

### Dropin Plugins (1) ###

db.php: Query Monitor Database Class

### Must Use Plugins (3) ###

Health Check Troubleshooting Mode: by  – 1.5.1
installatron_hide_status_test.php: by  –
WP STAGING Optimizer: by René Hermenau – 1.4

### Settings ###

API Enabled: ?
Force SSL: –
Currency: USD ($)
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: #5701 - /shop/
Cart: #7254 - /cart/
Checkout: #7256 - /checkout/
My account: ? Page not set
Terms and conditions: ? Page not set

### Theme ###

Name: Twenty Sixteen
Version: 2.3
Author URL: https://www.ads-software.com/
Child Theme: ? – If you are modifying WooCommerce on a parent theme that you did not build personally we recommend using a child theme. See: How to create a child theme
WooCommerce Support: ?

### Templates ###

Overrides: –

### Action Scheduler ###

Complete: 3,011
Oldest: 2020-11-24 16:43:16 -0500
Newest: 2021-01-05 18:34:44 -0500

Failed: 10
Oldest: –
Newest: –

    Thanks,

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

Viewing 7 replies - 1 through 7 (of 7 total)
  • Plugin Support RK a11n

    (@riaanknoetze)

    Hi there,

    I see that you have Query Monitor installed already – Are there any specific DB queries being flagged as excessively slow? Are you seeing the same issue on a staging site that’s running on a local hosting environment (e.g. when using Local by Flywheel)?

    Thread Starter mxnewengland

    (@mxnewengland)

    Hi thanks for your reply,

    The Query Monitor was installed by the theme support agent so I assume they already checked that? I’m not familiar at all with the plugin but if you can tell me how to look for flagged excessively slow DB queries I will certainly give it a double check.

    I do not have a local hosting environment but can work on adding one if it is 100% necessary to troubleshoot this issue.

    Plugin Support mouli a11n

    (@mouli)

    @mxnewengland
    Issues like this may be caused by either a conflict with your theme or with another plugin. You can read more about plugin and theme conflicts here:
    https://docs.woocommerce.com/document/woocommerce-self-service-guide/

    The best way to determine if the issue is being caused by a theme and/or plugin is to do the following:

    1. Temporarily switch your theme back to the Storefront (https://www.woocommerce.com/storefront/) or TwentyNineteen (https://www.ads-software.com/themes/twentynineteen/) Theme.
    2. Disable all plugins except for WooCommerce.
    3. Test to see if the issue has been resolved.

    If that resolves the issue, then one-by-one you can switch back your theme and re-enable your plugins, testing in between, until you find the one causing the conflict.

    If doing this on your live site is not possible, can you create a duplicate site? We suggest using WP Staging (https://www.ads-software.com/plugins/wp-staging/) if your hosting provider does not offer a staging server as an option.

    Thread Starter mxnewengland

    (@mxnewengland)

    Hi,

    I’ve spent a few hours working on plugin conflict testing. Unfortunately It doesn’t seem to have provided any concrete information.

    I started by deactivating all plugins except WooCommerce.
    Then I opened up the current resource usage page and navigated several pages in the wordpress dashboard (permalinks, apperances, marketing, analytics, products, and plugins)

    I noted no usage limits or faults at this time.

    I then started activating plugins one by one, leaving the plugins that did not have a negative affect on resource usage active, and deactivating those which caused faults.
    I identified conflicts with about 9 plugins.

    This is when things got confusing. When I was reaching the end of the plugins list to test, I randomly started getting faults. I figured I made an error thinking the previously activated plugin was good when it wasn’t so I re tested. I made it back about 4 “good” plugins before the errors went away.

    Once things got confusing I decided to start over, testing again but leaving all plugins deactivated except for the one I was testing. With this method I only had bad results with one plugin, the WP file manager. After completing the testing I went back to double check the Wp file manager plugin. This time it tested fine.

    From there I reactivated all plugins and the site hit limit on physical memory and I/O usage. AS well as 12 PMemF faults.

    With all plugins except WooCommerce active the site has no issues when I navigate dashboard pages. Though this test seems inconclusive since I can not navigate the Analytics or Products pages with the WooCommerce plugin deactivated. It always seems to be one of these two pages I navigate to that causes the usage issues and faults.

    With all plugins active I cna navigate all dashboard pages with exception of WooCommerce pages: Products, Analytics, Marketing. Immediately bring I/O usage spikes, PMemF faults and ocassionally return a 404 Page Not Found error.

    • This reply was modified 3 years, 10 months ago by mxnewengland.
    Plugin Support mouli a11n

    (@mouli)

    Hi there,
    Nice work on the conflict testing ??
    Testing plugins one at a time is useful but will not highlight conflicts between plugins which is what I still suspect is causing this.
    Did you find anything useful in the Query Monitor as this should highlight slow queries with enough info to determine their origin.

    Looking at your System Status Report, I suggest that you try increasing these environment variables to the following:

    PHP Time Limit: 300
    PHP Max Input Vars: 10000

    I hope that helps you to figure it out.
    Feel free to get back to us if you have further questions.

    Plugin Support abwaita a11n

    (@abwaita)

    Hi @mxnewengland,

    We’ve not heard back from you in a while, so I’m marking this thread as resolved. Hopefully, you were able to find a solution to your problem!

    If you have further questions, please feel free to open a new topic.

    Thanks.

    Thread Starter mxnewengland

    (@mxnewengland)

    Hi sorry for the delay in updating you all.

    The issue was not resolved yet but I received this info from godaddy premium wordpress support:

    “I reviewed your WordPress website mxnewengland.com and I was able to duplicate the issue with the resources spike.

    You have 25 active plugins.

    Unfortunately, this issue was caused because your website is quite resource-intensive and your current hosting plan is not suitable for websites like that.

    I tested your website on our test server with more resources (Ultimate hosting package) and everything was working properly without problem with resources.

    Therefore I recommend you to consider upgrading to a bigger package.”

    Still working to verify this is in fact the issue.

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘New WooCommerce install. Resource Usage Spikes – Dashboard Slow’ is closed to new replies.