Editing products with version >4.9 leads to server lock due to high DB load

Resolved

(@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)

Plugin Support 3 Sons Development – a11n
(@3sonsdevelopment)

1 year, 2 months ago

Hi @gmwp1111,

I’d suggest opening up a new issue about that and link to this one that’s closed.

https://github.com/woocommerce/woocommerce-admin/issues/3664

That way this gets back in front of the developers again so they can see if there are any adjustments that need to be made to it now.

https://github.com/woocommerce/woocommerce-admin/issues/new/choose

Thanks!

Plugin Support MayKato woo-hc
(@maykato)

1 year, 1 month ago

Hi @gmwp1111

We’ve not heard back from you in a while, so I’m marking this thread as resolved. If you have other questions, please feel free to open a new topic.

Thread Starter gmwp1111
(@gmwp1111)

1 year, 1 month ago

Just in case someone has the same or similar issues: I was able to solve the problem by switching my database from my MyISAM to InnoDB.

pcball80
(@pcball80)

11 months, 2 weeks ago

@gmwp1111 its working. I just want to say thank you for your advice and solutions.

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.

Views