execution time long and memory usage spikes on admin products page

Hi,

I did some modification tests (in products page list) on several products at the same time (enable/disable or change stock quantity on just only 2/3 products) and the execution time is very long and my usage spikes by about 500-700MB which does not seem normal.

I can’t configure WC to prevent these spike…
I’ve PHP memory limit set to 200M and server RAM memory to 1.5G…

These are some of the mistakes:

[Fri Apr 19 06:27:30 2019] [error] [client 172.68.xxx.xxx] FastCGI:
server
"/var/run/php-wp_8dcsqj.fcgi" stderr: PHP message: PHP Fatal error: Out
of memory (allocated 16777216) (tried to allocate 20480 bytes) in
 /home/wp_8dcsqj/domain.com/wp-includes/wp-db.php on line
2610, referer:
https://domain.com/wp-admin/edit.php?post_type=product

[Fri Apr 19 06:27:58 2019] [error] [client 173.236.xxx.xxx]
FastCGI: server "/var/run/php-wp_8dcsqj.fcgi" stderr: PHP message: PHP
Fatal
error:  Out of memory (allocated 12582912) (tried to allocate
524288 bytes) in
/home/wp_8dcsqj/domain.com/wp-content/plugins/jetpack/locales.php
on line 2252, referer: 
https://domain.com/shop/attribute/

[Fri Apr 19 06:27:58 2019] [error] [client 173.236.xxx.xxx]
FastCGI: server "/var/run/php-wp_8dcsqj.fcgi" stderr: PHP message: PHP
Fatal
error:  Out of memory (allocated 10485760) (tried to allocate 524288
bytes) in
/home/wp_8dcsqj/domain.com/wp-content/plugins/jetpack/locales.php
on on line 2252, referer:
https://domain.com/shop/path-to-product/

My WC status report:

### WordPress Environment ###

WC Version: 3.5.8
Log Directory Writable: ?
WP Version: 5.1.1
WP Multisite: –
WP Memory Limit: 256 MB
WP Debug Mode: –
WP Cron: ?
Language: it_IT
External object cache: –

### Server Environment ###

Server Info: Apache
PHP Version: 7.1.22
HP Post Max Size: 505 MB
PHP Time Limit: 500
PHP Max Input Vars: 1500
cURL Version: 7.35.0
OpenSSL/1.0.1f

SUHOSIN Installed: –
MySQL Version: 5.6.39-log
Max Upload Size: 500 MB
Default Timezone is UTC: ?
fsockopen/cURL: ?
SoapClient: ?
DOMDocument: ?
GZip: ?
Multibyte String: ?
Remote Post: ?
Remote Get: ?

### Database ###

WC Database Version: 3.5.8
WC Database Prefix: wp_
MaxMind GeoIP Database: ?
Dimensione totale database: 14.70MB
Dimensione dati database: 12.13MB
Dimensione indice database: 2.57MB
wp_woocommerce_sessions: Dati: 0.47MB + Indice: 0.02MB
wp_woocommerce_api_keys: Dati: 0.02MB + Indice: 0.03MB
wp_woocommerce_attribute_taxonomies: Dati: 0.02MB + Indice: 0.02MB
wp_woocommerce_downloadable_product_permissions: Dati: 0.02MB + Indice: 0.05MB
wp_woocommerce_order_items: Dati: 0.02MB + Indice: 0.02MB
wp_woocommerce_order_itemmeta: Dati: 0.02MB + Indice: 0.03MB
wp_woocommerce_tax_rates: Dati: 0.02MB + Indice: 0.06MB
wp_woocommerce_tax_rate_locations: Dati: 0.02MB + Indice: 0.03MB
wp_woocommerce_shipping_zones: Dati: 0.02MB + Indice: 0.00MB
wp_woocommerce_shipping_zone_locations: Dati: 0.02MB + Indice: 0.03MB
wp_woocommerce_shipping_zone_methods: Dati: 0.02MB + Indice: 0.00MB
wp_woocommerce_payment_tokens: Dati: 0.02MB + Indice: 0.02MB
wp_woocommerce_payment_tokenmeta: Dati: 0.02MB + Indice: 0.03MB
wp_woocommerce_log: Dati: 0.02MB + Indice: 0.02MB
wp_adtribes_my_conversions: Dati: 0.02MB + Indice: 0.02MB
wp_atum_order_itemmeta: Dati: 0.02MB + Indice: 0.03MB
wp_atum_order_items: Dati: 0.02MB + Indice: 0.02MB
wp_atum_product_data: Dati: 0.02MB + Indice: 0.03MB
wp_commentmeta: Dati: 0.02MB + Indice: 0.03MB
wp_comments: Dati: 0.02MB + Indice: 0.09MB
wp_failed_jobs: Dati: 0.02MB + Indice: 0.00MB
wp_links: Dati: 0.02MB + Indice: 0.02MB
wp_mailchimp_carts: Dati: 0.02MB + Indice: 0.00MB
wp_options: Dati: 2.50MB + Indice: 0.08MB
wp_postmeta: Dati: 1.52MB + Indice: 0.50MB
wp_posts: Dati: 0.44MB + Indice: 0.13MB
wp_queue: Dati: 0.02MB + Indice: 0.00MB
wp_termmeta: Dati: 0.02MB + Indice: 0.03MB
wp_terms: Dati: 0.09MB + Indice: 0.13MB
wp_term_relationships: Dati: 0.08MB + Indice: 0.06MB
wp_term_taxonomy: Dati: 0.11MB + Indice: 0.13MB
wp_tm_taskmeta: Dati: 0.02MB + Indice: 0.03MB
wp_tm_tasks: Dati: 0.02MB + Indice: 0.02MB
wp_usermeta: Dati: 0.05MB + Indice: 0.03MB
wp_users: Dati: 0.02MB + Indice: 0.05MB
wp_wcpdf_invoice_number: Dati: 0.02MB + Indice: 0.00MB
wp_wc_download_log: Dati: 0.02MB + Indice: 0.03MB
wp_wc_webhooks: Dati: 0.02MB + Indice: 0.02MB
wp_wfblockediplog: Dati: 0.02MB + Indice: 0.00MB
wp_wfblocks7: Dati: 0.02MB + Indice: 0.05MB
wp_wfconfig: Dati: 0.44MB + Indice: 0.00MB
wp_wfcrawlers: Dati: 0.02MB + Indice: 0.00MB
wp_wffilechanges: Dati: 0.02MB + Indice: 0.00MB
wp_wffilemods: Dati: 2.52MB + Indice: 0.00MB
wp_wfhits: Dati: 1.11MB + Indice: 0.25MB
wp_wfhoover: Dati: 0.02MB + Indice: 0.02MB
wp_wfissues: Dati: 0.02MB + Indice: 0.06MB
wp_wfknownfilelist: Dati: 1.52MB + Indice: 0.00MB
wp_wflivetraffichuman: Dati: 0.02MB + Indice: 0.02MB
wp_wflocs: Dati: 0.02MB + Indice: 0.00MB
wp_wflogins: Dati: 0.14MB + Indice: 0.06MB
wp_wfnotifications: Dati: 0.02MB + Indice: 0.00MB
wp_wfpendingissues: Dati: 0.02MB + Indice: 0.06MB
wp_wfreversecache: Dati: 0.02MB + Indice: 0.00MB
wp_wfsnipcache: Dati: 0.02MB + Indice: 0.05MB
wp_wfstatus: Dati: 0.13MB + Indice: 0.09MB
wp_wftrafficrates: Dati: 0.02MB + Indice: 0.00MB
wp_yith_wcwl: Dati: 0.02MB + Indice: 0.02MB
wp_yith_wcwl_lists: Dati: 0.02MB + Indice: 0.03MB
wp_yoast_seo_links: Dati: 0.06MB + Indice: 0.02MB
wp_yoast_seo_meta: Dati: 0.05MB + Indice: 0.00MB

### Post Type Counts ###

attachment: 169
atum_purchase_order: 1
atum_supplier: 2
blocks: 24
custom_css: 1
customize_changeset: 2
featured_item: 8
jetpack_migration: 2
jp_img_sitemap: 1
jp_sitemap: 1
jp_sitemap_master: 1
nav_menu_item: 22
page: 19
post: 7
product: 17
product_variation: 115
revision: 10
shop_order: 1
site-review: 66
wc_order_email: 7
wc_order_status: 25
wishlist: 1
wp-types-group: 1

### Security ###

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

### Active Plugins (21) ###

Admin Menu Editor: by Janis Elsts – 1.8.8
AfterShip - WooCommerce Tracking: by AfterShip – 1.9.4 – Non testato con la versione attiva di WooCommerce
Autoptimize: by Frank Goossens (futtta) – 2.4.4
Enhanced Media Library: by wpUXsolutions – 2.7.2
Google Analytics Dashboard per WP (GADWP): by ExactMetrics – 5.3.7
Jetpack by WordPress.com: by Automattic – 7.2.1
Loco Translate: by Tim Whitlock – 2.2.2
WooCommerce - Mostra solo il prezzo più basso per i prodotti con varianti: by Fernando Tellado – 0.9.8
UpdraftPlus - Backup/Restore: by UpdraftPlus.Com
DavidAnderson – 1.16.12

Proxy Cache Purge: by Mika Epstein – 4.8
WooCommerce Smart COD: by Stratos Vetsos – 1.4.9.6
Product Feed PRO for WooCommerce: by AdTribes.io – 5.3.9
WooCommerce Order Status Manager: by SkyVerge – 1.9.4
WooCommerce PDF Invoices: by Bas Elbers – 2.9.16 – Non testato con la versione attiva di WooCommerce
WooCommerce Services: by Automattic – 1.19.0
WooCommerce: by Automattic – 3.5.8 – 3.6.1 è disponibile
WooSidebars: by WooCommerce – 1.4.5
Wordfence Security: by Wordfence – 7.2.5
Yoast SEO Premium: by Team Yoast – 11.0
WC VAT number or TAX code EU: by Christian Pucci – 1.2.0
Yoast SEO: WooCommerce: by Team Yoast – 11.0

### Settings ###

API Enabled: –
Force SSL: –
Currency: EUR (€)
Currency Position: right
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)

### WC Pages ###

Shop base: #76 - /shop/
Carrello: #75 - /carrello/
Cassa: #74 - /checkout/
Il mio account: #73 - /account/
Termini e condizioni: #312 - /termini-e-condizioni/

### Theme ###

Name: Flatsome Child
Version: 3.0
Author URL: 
Child Theme: ?
Parent Theme Name: Flatsome
Parent Theme Version: 3.8.3
Parent Theme Author URL: https://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/thankyou.php
flatsome/woocommerce/content-product.php
flatsome/woocommerce/content-product_cat.php
flatsome/woocommerce/content-single-product.php
flatsome/woocommerce/content-widget-product.php
flatsome-child/woocommerce/emails/email-styles.php
flatsome-child/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-child/woocommerce/myaccount/view-order.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-child/woocommerce/single-product/product-attributes.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

What can I do or check for me to solve the problem?

Thank a lot

• This topic was modified 5 years, 7 months ago by ranone.