Support » Plugin: WooCommerce » Editing products with version >4.9 leads to server lock due to high DB load

  • Resolved gmwp1111

    (@gmwp1111)


    After updating from version 4.7.1 to 4.9.2 and newer versions (tried 5.1.0 and 5.2.2) we suffer from an extreme database load when editing products. This leads to a server lock which lasts for 15-20 minutes. The shop is hosted on a very fast dedicated server with 20 cores and 256GB RAM. Here is a screenshot from Plesk showing the memory load of the apache server. The peaks happened when we edited products in the backend: https://jumpshare.com/v/ldSdsqXMQ4vHcDBPABTZ

    Our hoster told us that the following query is responsible for this high load:

     12727256 | path          | localhost | path        | Query   | 637   | storing result in query cache | SELECT SQL_CALC_FOUND_ROWS  wordpresswp_posts.*, low_stock_amount_meta.meta_value AS low_stock_amount, MAX( product_looku
    p.date_created ) AS last_order_date FROM wordpresswp_posts  LEFT JOIN wordpresswp_wc_product_meta_lookup wc_product_meta_lookup ON wordpresswp_posts.ID = wc_product_meta_lookup.product_id  LEFT JOIN wordpresswp_postmeta AS low_stock_amo
    unt_meta ON wordpresswp_posts.ID = low_stock_amount_meta.post_id AND low_stock_amount_meta.meta_key = '_low_stock_amount'  LEFT JOIN wordpresswp_wc_order_product_lookup product_lookup ON wordpresswp_posts.ID = CASE
                                    WHEN wordpresswp_posts.post_type = 'product' THEN product_lookup.product_id
                                    WHEN wordpresswp_posts.post_type = 'product_variation' THEN product_lookup.variation_id
                            END WHERE 1=1  AND wordpresswp_posts.post_type IN ('product', 'product_variation') AND ((wordpresswp_posts.post_status = 'publish'))
                            AND wc_product_meta_lookup.stock_quantity IS NOT NULL
                            AND wc_product_meta_lookup.stock_status IN('instock','outofstock')
                            AND (
                                    (
                                            low_stock_amount_meta.meta_value > ''
                                            AND wc_product_meta_lookup.stock_quantity <= CAST(low_stock_amount_meta.meta_value AS SIGNED)
                                    )
                                    OR (
                                            (
                                                    low_stock_amount_meta.meta_value IS NULL OR low_stock_amount_meta.meta_value <= ''
                                            )
                                            AND wc_product_meta_lookup.stock_quantity <= 99
                                    )
                            ) GROUP BY wordpresswp_posts.ID ORDER BY wordpresswp_posts.post_date DESC, wordpresswp_posts.ID DESC LIMIT 0, 1 | 0.000    |

    and provided also this EXPLAIN:

    +------+-------------+------------------------+--------+-------------------------------------+---------+---------+---------------------------------------------+--------+-------------------------------------------------+
    | id   | select_type | table                  | type   | possible_keys                       | key     | key_len | ref                                         | rows   | Extra                                           |
    +------+-------------+------------------------+--------+-------------------------------------+---------+---------+---------------------------------------------+--------+-------------------------------------------------+
    |    1 | SIMPLE      | wc_product_meta_lookup | ALL    | PRIMARY,stock_status,stock_quantity | NULL    | NULL    | NULL                                        |   6115 | Using where; Using temporary; Using filesort    |
    |    1 | SIMPLE      | wordpresswp_posts      | eq_ref | PRIMARY,type_status_date            | PRIMARY | 8       | meuk_live.wc_product_meta_lookup.product_id |      1 | Using where                                     |
    |    1 | SIMPLE      | low_stock_amount_meta  | ref    | post_id,meta_key                    | post_id | 8       | meuk_live.wordpresswp_posts.ID              |     26 | Using where                                     |
    |    1 | SIMPLE      | product_lookup         | ALL    | NULL                                | NULL    | NULL    | NULL                                        | 178872 | Using where; Using join buffer (flat, BNL join) |
    +------+-------------+------------------------+--------+-------------------------------------+---------+---------+---------------------------------------------+--------+-------------------------------------------------+
    4 rows in set (0.00 sec)

    This sounds similar to the issue mentioned here: https://github.com/woocommerce/woocommerce-admin/issues/3664

    We returned back to version 4.7.1 now but are looking for any solutions.

    Thanks!

    Woocommerce Status report:

    
    ### WordPress Environment ###
    
    WC Version: 4.7.1
    REST API Version: ✔ 4.7.1
    WC Blocks Version: ✔ 3.6.0
    Action Scheduler Version: ✔ 3.1.6
    WC Admin Version: ✔ 1.6.3
    Log Directory Writable: ✔
    WP Version: 5.7.1
    WP Multisite: –
    WP Memory Limit: 1 GB
    WP Debug Mode: –
    WP Cron: –
    Language: de_DE
    External object cache: ✔
    
    ### Server Environment ###
    
    Server Info: Apache
    PHP Version: 7.4.16
    PHP Post Max Size: 32 MB
    PHP Time Limit: 360
    PHP Max Input Vars: 1000
    cURL Version: 7.29.0
    NSS/3.53.1
    
    SUHOSIN Installed: –
    MySQL Version: 5.5.5-10.2.37-MariaDB
    Max Upload Size: 32 MB
    Default Timezone is UTC: ✔
    fsockopen/cURL: ✔
    SoapClient: ✔
    DOMDocument: ✔
    GZip: ✔
    Multibyte String: ✔
    Remote Post: ✔
    Remote Get: ✔
    
    ### Database ###
    
    WC Database Version: 5.2.2
    WC Database Prefix: wordpresswp_
    Total Database Size: 3327.48MB
    Database Data Size: 2089.33MB
    Database Index Size: 1238.15MB
    wordpresswp_woocommerce_sessions: Data: 8.87MB + Index: 0.07MB + Engine MyISAM
    wordpresswp_woocommerce_api_keys: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wordpresswp_woocommerce_attribute_taxonomies: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wordpresswp_woocommerce_downloadable_product_permissions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wordpresswp_woocommerce_order_items: Data: 24.69MB + Index: 11.01MB + Engine MyISAM
    wordpresswp_woocommerce_order_itemmeta: Data: 312.84MB + Index: 158.20MB + Engine MyISAM
    wordpresswp_woocommerce_tax_rates: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wordpresswp_woocommerce_tax_rate_locations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wordpresswp_woocommerce_shipping_zones: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wordpresswp_woocommerce_shipping_zone_locations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wordpresswp_woocommerce_shipping_zone_methods: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wordpresswp_woocommerce_payment_tokens: Data: 0.08MB + Index: 0.03MB + Engine MyISAM
    wordpresswp_woocommerce_payment_tokenmeta: Data: 0.31MB + Index: 0.21MB + Engine MyISAM
    wordpresswp_woocommerce_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    $table: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wordpresswp_actionscheduler_actions: Data: 7.02MB + Index: 7.06MB + Engine InnoDB
    wordpresswp_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wordpresswp_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wordpresswp_actionscheduler_logs: Data: 6.02MB + Index: 5.03MB + Engine InnoDB
    wordpresswp_adtribes_my_conversions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wordpresswp_borlabs_cookie_consent_log: Data: 331.96MB + Index: 57.24MB + Engine MyISAM
    wordpresswp_borlabs_cookie_content_blocker: Data: 0.01MB + Index: 0.00MB + Engine MyISAM
    wordpresswp_borlabs_cookie_cookies: Data: 0.01MB + Index: 0.00MB + Engine MyISAM
    wordpresswp_borlabs_cookie_groups: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wordpresswp_borlabs_cookie_script_blocker: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wordpresswp_bounced_email_logs: Data: 0.01MB + Index: 0.00MB + Engine MyISAM
    wordpresswp_commentmeta: Data: 3.52MB + Index: 4.03MB + Engine InnoDB
    wordpresswp_comments: Data: 169.69MB + Index: 88.25MB + Engine InnoDB
    wordpresswp_duplicator_pro_entities: Data: 0.01MB + Index: 0.00MB + Engine MyISAM
    wordpresswp_duplicator_pro_packages: Data: 13.74MB + Index: 0.04MB + Engine MyISAM
    wordpresswp_email_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wordpresswp_epkb_kb_search_data: Data: 0.01MB + Index: 0.02MB + Engine MyISAM
    wordpresswp_ewwwio_images: Data: 10.72MB + Index: 4.63MB + Engine MyISAM
    wordpresswp_ewwwio_queue: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wordpresswp_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wordpresswp_loginizer_logs: Data: 0.05MB + Index: 0.00MB + Engine InnoDB
    wordpresswp_mailpoet_custom_fields: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wordpresswp_mailpoet_dynamic_segment_filters: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wordpresswp_mailpoet_feature_flags: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wordpresswp_mailpoet_forms: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wordpresswp_mailpoet_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wordpresswp_mailpoet_mapping_to_external_entities: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wordpresswp_mailpoet_newsletters: Data: 0.91MB + Index: 0.01MB + Engine MyISAM
    wordpresswp_mailpoet_newsletter_links: Data: 13.75MB + Index: 4.59MB + Engine MyISAM
    wordpresswp_mailpoet_newsletter_option: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wordpresswp_mailpoet_newsletter_option_fields: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wordpresswp_mailpoet_newsletter_posts: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wordpresswp_mailpoet_newsletter_segment: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wordpresswp_mailpoet_newsletter_templates: Data: 16.53MB + Index: 0.00MB + Engine MyISAM
    wordpresswp_mailpoet_premium_newsletter_extra_data: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wordpresswp_mailpoet_scheduled_tasks: Data: 0.80MB + Index: 0.25MB + Engine MyISAM
    wordpresswp_mailpoet_scheduled_task_subscribers: Data: 6.35MB + Index: 6.09MB + Engine MyISAM
    wordpresswp_mailpoet_segments: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wordpresswp_mailpoet_sending_queues: Data: 230.31MB + Index: 0.44MB + Engine MyISAM
    wordpresswp_mailpoet_settings: Data: 0.01MB + Index: 0.00MB + Engine MyISAM
    wordpresswp_mailpoet_statistics_clicks: Data: 1.48MB + Index: 2.63MB + Engine MyISAM
    wordpresswp_mailpoet_statistics_forms: Data: 0.27MB + Index: 0.43MB + Engine MyISAM
    wordpresswp_mailpoet_statistics_newsletters: Data: 4.48MB + Index: 6.99MB + Engine MyISAM
    wordpresswp_mailpoet_statistics_opens: Data: 2.52MB + Index: 10.46MB + Engine MyISAM
    wordpresswp_mailpoet_statistics_unsubscribes: Data: 0.07MB + Index: 0.13MB + Engine MyISAM
    wordpresswp_mailpoet_statistics_woocommerce_purchases: Data: 0.12MB + Index: 0.14MB + Engine MyISAM
    wordpresswp_mailpoet_stats_notifications: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wordpresswp_mailpoet_subscribers: Data: 6.17MB + Index: 5.70MB + Engine MyISAM
    wordpresswp_mailpoet_subscriber_custom_field: Data: 0.43MB + Index: 0.43MB + Engine MyISAM
    wordpresswp_mailpoet_subscriber_ips: Data: 0.06MB + Index: 0.11MB + Engine MyISAM
    wordpresswp_mailpoet_subscriber_segment: Data: 2.57MB + Index: 2.34MB + Engine MyISAM
    wordpresswp_mailpoet_user_flags: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wordpresswp_mclean_refs: Data: 3.28MB + Index: 1.46MB + Engine MyISAM
    wordpresswp_mclean_scan: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wordpresswp_ms_snippets: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wordpresswp_novalnet_aff_account_detail: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wordpresswp_novalnet_aff_user_detail: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wordpresswp_novalnet_callback_history: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wordpresswp_novalnet_subscription_details: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wordpresswp_novalnet_transaction_detail: Data: 0.25MB + Index: 0.27MB + Engine InnoDB
    wordpresswp_novalnet_webhook_history: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wordpresswp_options: Data: 4.45MB + Index: 1.19MB + Engine InnoDB
    wordpresswp_pimwick_gift_card: Data: 0.07MB + Index: 0.06MB + Engine MyISAM
    wordpresswp_pimwick_gift_card_activity: Data: 0.27MB + Index: 0.07MB + Engine MyISAM
    wordpresswp_pmxe_exports: Data: 0.01MB + Index: 0.00MB + Engine MyISAM
    wordpresswp_pmxe_google_cats: Data: 0.26MB + Index: 0.05MB + Engine MyISAM
    wordpresswp_pmxe_posts: Data: 0.04MB + Index: 0.02MB + Engine MyISAM
    wordpresswp_pmxe_templates: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wordpresswp_postmeta: Data: 407.00MB + Index: 514.92MB + Engine InnoDB
    wordpresswp_posts: Data: 33.55MB + Index: 15.00MB + Engine InnoDB
    wordpresswp_pp_pick_order_status: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wordpresswp_snippets: Data: 0.05MB + Index: 0.00MB + Engine MyISAM
    wordpresswp_social_users: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wordpresswp_statify: Data: 78.61MB + Index: 92.77MB + Engine InnoDB
    wordpresswp_stock_log: Data: 2.52MB + Index: 0.00MB + Engine InnoDB
    wordpresswp_storeabill_documentmeta: Data: 36.56MB + Index: 26.08MB + Engine InnoDB
    wordpresswp_storeabill_documents: Data: 2.52MB + Index: 1.28MB + Engine InnoDB
    wordpresswp_storeabill_document_itemmeta: Data: 157.69MB + Index: 94.25MB + Engine InnoDB
    wordpresswp_storeabill_document_items: Data: 14.52MB + Index: 12.55MB + Engine InnoDB
    wordpresswp_storeabill_document_noticemeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wordpresswp_storeabill_document_notices: Data: 3.52MB + Index: 1.52MB + Engine InnoDB
    wordpresswp_storeabill_journals: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wordpresswp_termmeta: Data: 0.05MB + Index: 0.04MB + Engine MyISAM
    wordpresswp_terms: Data: 0.08MB + Index: 0.09MB + Engine InnoDB
    wordpresswp_term_relationships: Data: 1.52MB + Index: 1.36MB + Engine InnoDB
    wordpresswp_term_taxonomy: Data: 0.08MB + Index: 0.11MB + Engine InnoDB
    wordpresswp_torro_containers: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wordpresswp_torro_elements: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wordpresswp_torro_element_choices: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wordpresswp_torro_element_settings: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wordpresswp_torro_submissionmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wordpresswp_torro_submissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    wordpresswp_torro_submission_values: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wordpresswp_usermeta: Data: 28.55MB + Index: 18.06MB + Engine InnoDB
    wordpresswp_users: Data: 1.52MB + Index: 0.80MB + Engine InnoDB
    wordpresswp_wcpdf_invoice_number: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wordpresswp_wc_admin_notes: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wordpresswp_wc_admin_note_actions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wordpresswp_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wordpresswp_wc_customer_lookup: Data: 4.52MB + Index: 4.03MB + Engine InnoDB
    wordpresswp_wc_download_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wordpresswp_wc_inventory_history: Data: 0.02MB + Index: 0.08MB + Engine InnoDB
    wordpresswp_wc_order_coupon_lookup: Data: 0.27MB + Index: 0.28MB + Engine InnoDB
    wordpresswp_wc_order_product_lookup: Data: 30.56MB + Index: 21.06MB + Engine InnoDB
    wordpresswp_wc_order_stats: Data: 8.52MB + Index: 7.53MB + Engine InnoDB
    wordpresswp_wc_order_tax_lookup: Data: 6.52MB + Index: 5.03MB + Engine InnoDB
    wordpresswp_wc_product_meta_lookup: Data: 0.51MB + Index: 0.62MB + Engine MyISAM
    wordpresswp_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wordpresswp_wc_tax_rate_classes: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wordpresswp_wc_webhooks: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wordpresswp_woocommerce_gzd_dhl_im_products: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wordpresswp_woocommerce_gzd_dhl_im_product_services: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wordpresswp_woocommerce_gzd_dhl_labelmeta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wordpresswp_woocommerce_gzd_dhl_labels: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wordpresswp_woocommerce_gzd_packaging: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wordpresswp_woocommerce_gzd_packagingmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wordpresswp_woocommerce_gzd_shipmentmeta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wordpresswp_woocommerce_gzd_shipments: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wordpresswp_woocommerce_gzd_shipment_itemmeta: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wordpresswp_woocommerce_gzd_shipment_items: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wordpresswp_woocommerce_gzd_shipping_provider: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wordpresswp_woocommerce_gzd_shipping_providermeta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wordpresswp_wpml_mails: Data: 39.82MB + Index: 0.03MB + Engine MyISAM
    wordpresswp_wp_wc_poin_of_sale_cache: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wordpresswp_wsal_metadata: Data: 10.52MB + Index: 17.09MB + Engine InnoDB
    wordpresswp_wsal_occurrences: Data: 1.52MB + Index: 1.75MB + Engine InnoDB
    wordpresswp_yith_wcwl: Data: 1.52MB + Index: 1.16MB + Engine InnoDB
    wordpresswp_yith_wcwl_lists: Data: 0.31MB + Index: 0.22MB + Engine InnoDB
    wordpresswp_yoast_indexable: Data: 28.55MB + Index: 18.42MB + Engine InnoDB
    wordpresswp_yoast_indexable_hierarchy: Data: 1.50MB + Index: 1.16MB + Engine InnoDB
    wordpresswp_yoast_migrations: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wordpresswp_yoast_primary_term: Data: 0.16MB + Index: 0.20MB + Engine InnoDB
    wordpresswp_yoast_seo_links: Data: 0.30MB + Index: 0.08MB + Engine MyISAM
    wordpresswp_yoast_seo_meta: Data: 0.27MB + Index: 0.23MB + Engine MyISAM
    
    ### Post Type Counts ###
    
    amn_mi-lite: 3
    attachment: 9601
    atum_supplier: 2
    blocks: 5
    custom_css: 4
    document_template: 6
    epkb_post_type_1: 16
    gdprc_consent: 3
    gdprc_script: 1
    gift_card: 145
    jetpack_migration: 2
    mailpoet_page: 1
    mc4wp-form: 2
    mts_notification_bar: 1
    nav_menu_item: 77
    oembed_cache: 15
    page: 33
    popup: 1
    popup_theme: 9
    pos_temp_register_or: 876
    post: 61
    product: 2473
    product_variation: 4490
    product-feed: 2
    pw_bogo: 2
    revision: 1
    sc_parcel_template: 2
    shop_coupon: 108
    shop_order: 61003
    shop_order_refund: 3876
    torro_form: 1
    ufaq: 69
    user_request: 2
    vc_grid_item: 2
    vc4_templates: 19
    wafs: 2
    wc_order_status: 18
    wcpf_item: 1
    wcpf_project: 1
    woo_discount: 1
    
    ### Security ###
    
    Secure connection (HTTPS): ✔
    Hide errors from visitors: ✔
    
    ### Active Plugins (52) ###
    
    Add-on WooCommerce MailPoet 3: by Tikweb – 1.1.8 – Installed version not tested with active version of WooCommerce 4.7.1
    Angell EYE Updater: by Angell EYE – 2.0.16
    Borlabs Cookie - Cookie Opt-in: by Benjamin A. Bornschein
    Borlabs – 2.2.23
    
    Bounce Handler Mailpoet: by Tikweb – 1.3.21
    Classic Editor: by WordPress Contributors – 1.6
    Code Snippets: by Code Snippets Pro – 2.14.1
    DHL for WooCommerce: by DHL – 2.5.3 – Installed version not tested with active version of WooCommerce 4.7.1
    Duplicator Pro: by Snap Creek – 4.0.2
    Duplicator Pro: by Snap Creek – 4.0.2
    Google Tag Manager for WordPress: by Thomas Geiger – 1.11.6
    EWWW Image Optimizer: by Exactly WWW – 6.1.0
    Statify – Extended Evaluation: by Patrick Robrecht – 2.6.1
    OMGF: by Daan from FFW.Press – 4.3.0
    Komfortkasse for WooCommerce: by Komfortkasse Integration Team – 1.3.15 – Installed version not tested with active version of WooCommerce 4.7.1
    Loginizer Security: by Softaculous – 1.6.6
    MailPoet 3 Premium (New): by MailPoet – 3.60.0
    MailPoet 3 (New): by MailPoet – 3.60.7
    MemcacheD Is Your Friend: by Jeffrey Schutzman - - uses code from Ryan Boren
    Denis de Bernardy
    Matt Martz
    Mike Schroder
    Scott Taylor – 2.0.0
    
    PayPal for WooCommerce: by Angell EYE – 2.5.6
    PW WooCommerce BOGO Pro: by Pimwick
    LLC – 2.144
    
    PW WooCommerce Bulk Edit Pro: by Pimwick
    LLC – 2.280
    
    PW WooCommerce Gift Cards Pro: by Pimwick
    LLC – 1.304
    
    Server IP & Memory Usage Display: by Apasionados
    Apasionados del Marketing – 2.1.0
    
    Statify: by pluginkollektiv – 1.8.2
    Advanced Editor Tools (previously TinyMCE Advanced): by Automattic – 5.6.0
    Ultimate FAQ - WordPress FAQ Plugin: by Etoile Web Design – 1.9.12
    Vendidero Helper: by Vendidero – 1.3.0
    Advanced Order Export For WooCommerce: by AlgolPlus – 3.1.8
    Country Based Restrictions for WooCommerce: by zorem – 2.9
    Product Feed PRO for WooCommerce: by AdTribes.io – 9.9.4
    Variation Swatches for WooCommerce - Pro: by Emran Ahmed – 1.1.13
    Variation Swatches for WooCommerce: by Emran Ahmed – 1.1.13
    WooCommerce Checkout Add-Ons: by SkyVerge – 2.5.4
    WooCommerce Cost of Goods: by SkyVerge – 2.10.0
    WooCommerce Dropshippers: by ArticNet LLC. – 3.0.13 – Installed version not tested with active version of WooCommerce 4.7.1
    Germanized for WooCommerce Pro: by vendidero – 3.1.7
    Germanized for WooCommerce: by vendidero – 3.3.7
    Novalnet payment plugin - WooCommerce: by Novalnet AG – 12.0.5
    WooCommerce Order Status Manager: by SkyVerge – 1.13.2
    WooCommerce PDF Invoices & Packing Slips: by Ewout Fernhout – 2.8.2
    WooCommerce PDF Invoices & Packing Slips Premium Templates: by Ewout Fernhout – 2.10.2
    WooCommerce Product SKU Generator: by SkyVerge – 2.4.5 – Installed version not tested with active version of WooCommerce 4.7.1
    WooCommerce Single Product Checkout: by Varun Sridharan – 0.7 – Installed version not tested with active version of WooCommerce 4.7.1
    Sofort Banking for WooCommerce: by Sven Wagener – 1.4.5 – Installed version not tested with active version of WooCommerce 4.7.1
    WooCommerce: by Automattic – 4.7.1 (update to version 5.2.2 is available)
    Yoast SEO: by Team Yoast – 16.0.2
    WP Activity Log for WooCommerce: by WP White Security – 1.2 – Installed version not tested with active version of WooCommerce 4.7.1
    WP Mail Logging: by MailPoet – 1.9.7
    WP Rocket: by WP Media – 3.8.8
    WP Activity Log: by WP White Security – 4.2.1
    WP Overnight Sidekick: by Jeremiah Prummer
    Ewout Fernhout
    Michael Kluver – 2.3.1
    
    YITH WooCommerce Wishlist: by YITH – 3.0.20
    
    ### Inactive Plugins (10) ###
    
    Child Theme Configurator: by Lilaea Media – 2.5.8
    Disable Emails: by WebAware – 1.7.0
    Minimal Coming Soon & Maintenance Mode: by WebFactory Ltd – 2.27
    Popup Maker: by Popup Maker – 1.16.1
    Query Monitor: by John Blackbourn – 3.6.7
    SiteOrigin CSS: by SiteOrigin – 1.2.13
    Torro Forms: by Awesome UG – 1.0.10
    WooCommerce: by Automattic – 5.1.0 (update to version 5.2.2 is available)
    WooCommerce: by Automattic – 5.2.2
    WP Downgrade | Specific Core Version: by Reisetiger – 1.2.2
    
    ### Dropin Plugins (3) ###
    
    advanced-cache.php: advanced-cache.php
    maintenance.php: maintenance.php
    object-cache.php: object-cache.php
    
    ### Settings ###
    
    API Enabled: ✔
    Force SSL: ✔
    Currency: EUR (€)
    Currency Position: right
    Thousand Separator: .
    Decimal Separator: ,
    Number of Decimals: 2
    Taxonomies: Product Types: external (external)
    gift-card (gift-card)
    grouped (grouped)
    pw gift card (pw-gift-card)
    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: #5 - /shop/
    Cart: #6 - /warenkorb/
    Checkout: #7 - /checkout/
    My account: #8 - /my-account/
    Terms and conditions: #11 - /agb/
    
    ### Theme ###
    
    Name: Flatsome Child
    Version: 3.11.0.1585888639
    Author URL: http://www.uxthemes.com/
    Child Theme: ✔
    Parent Theme Name: Flatsome
    Parent Theme Version: 3.13.1
    Parent Theme Author URL: http://www.uxthemes.com/
    WooCommerce Support: ✔
    
    ### Templates ###
    
    Overrides: flatsome/woocommerce/archive-product.php
    flatsome/woocommerce/cart/cart-empty.php
    flatsome/woocommerce/cart/cart-shipping.php
    flatsome/woocommerce/cart/cart.php
    flatsome/woocommerce/checkout/form-checkout.php
    flatsome/woocommerce/checkout/form-coupon.php
    flatsome/woocommerce/checkout/terms.php
    flatsome/woocommerce/checkout/thankyou.php
    flatsome/woocommerce/content-product-cat.php
    flatsome/woocommerce/content-product.php
    flatsome/woocommerce/content-single-product.php
    flatsome/woocommerce/content-widget-product.php
    flatsome-child/woocommerce/emails/admin-cancelled-order.php
    flatsome-child/woocommerce/emails/customer-completed-order.php
    flatsome-child/woocommerce/emails/customer-processing-order.php
    flatsome-child/woocommerce/emails/email-styles.php
    flatsome/woocommerce/global/breadcrumb.php
    flatsome/woocommerce/global/quantity-input.php
    flatsome/woocommerce/global/wrapper-end.php
    flatsome/woocommerce/global/wrapper-start.php
    flatsome/woocommerce/loop/loop-end.php
    flatsome/woocommerce/loop/loop-start.php
    flatsome/woocommerce/loop/pagination.php
    flatsome/woocommerce/loop/result-count.php
    flatsome/woocommerce/loop/sale-flash.php
    flatsome/woocommerce/myaccount/form-login.php
    flatsome/woocommerce/myaccount/navigation.php
    flatsome/woocommerce/notices/error.php
    flatsome/woocommerce/notices/notice.php
    flatsome/woocommerce/notices/success.php
    flatsome/woocommerce/product-searchform.php
    flatsome/woocommerce/single-product/photoswipe.php
    flatsome/woocommerce/single-product/price.php
    flatsome/woocommerce/single-product/product-image.php
    flatsome/woocommerce/single-product/product-thumbnails.php
    flatsome/woocommerce/single-product/rating.php
    flatsome/woocommerce/single-product/related.php
    flatsome/woocommerce/single-product/review.php
    flatsome/woocommerce/single-product/sale-flash.php
    flatsome/woocommerce/single-product/share.php
    flatsome/woocommerce/single-product/short-description.php
    flatsome/woocommerce/single-product/tabs/tabs.php
    flatsome/woocommerce/single-product/title.php
    flatsome/woocommerce/single-product/up-sells.php
    flatsome/woocommerce/single-product-reviews.php
    flatsome/woocommerce/single-product.php
    flatsome/woocommerce/content-product_cat.php
    
    
    • This topic was modified 1 year, 2 months ago by gmwp1111.
    • This topic was modified 1 year, 2 months ago by gmwp1111.
    • This topic was modified 1 year, 2 months ago by gmwp1111.
Viewing 4 replies - 1 through 4 (of 4 total)
Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Editing products with version >4.9 leads to server lock due to high DB load’ is closed to new replies.