Extremely Poor Performance

  • Resolved kanagency

    (@kanagency)


    10 months, 3 weeks ago

    After migrating to a new hosting provider, splitting the website into two nodes (web & database), we’re now experiencing extremely poor performance.

    Our NewRelic monitoring suggests the main culprit of this performance bottleneck is the amount of calls to “WC_Product_Variable_Data_Store_CPT::read_price_data”. This averages roughly 50 calls to this function, but each time it’s taking about 150-200ms per call, so these in total is a huge issue.

    The site info for the site is as below

    ### wp-core ###

version: 6.2.2
site_language: en_GB
user_language: en_GB
timezone: Europe/London
permalink: /%postname%
https_status: true
multisite: false
user_registration: 0
blog_public: 1
default_comment_status: undefined
environment_type: production
user_count: 4846
dotorg_communication: true

### wp-paths-sizes ###

wordpress_path: /var/www/wadswick.co.uk
wordpress_size: 177.17 MB (185778726 bytes)
uploads_path: /var/www/wadswick.co.uk/wp-content/uploads
uploads_size: 10.98 GB (11794012503 bytes)
themes_path: /var/www/wadswick.co.uk/wp-content/themes
themes_size: 29.99 MB (31450801 bytes)
plugins_path: /var/www/wadswick.co.uk/wp-content/plugins
plugins_size: 191.96 MB (201282466 bytes)
database_size: 3.22 GB (3452469248 bytes)
total_size: 14.59 GB (15664993744 bytes)

### wp-dropins (1) ###

advanced-cache.php: true

### wp-active-theme ###

name: Wadswick (wadswick)
version: 1.3.9
author: Kan Agency / Alchemist Solutions
author_website: (undefined)
parent_theme: Flatsome (flatsome)
theme_features: core-block-patterns, post-thumbnails, woocommerce, title-tag, automatic-feed-links, customize-selective-refresh-widgets, sensei, html5, menus, post-formats, wc-product-gallery-lightbox, widgets
theme_path: /var/www/wadswick.co.uk/wp-content/themes/wadswick
auto_update: Disabled

### wp-parent-theme ###

name: Flatsome (flatsome)
version: 3.17.1
author: UX-Themes
author_website: https://uxthemes.com
theme_path: /var/www/wadswick.co.uk/wp-content/themes/flatsome
auto_update: Disabled

### wp-themes-inactive (1) ###

Twenty Twenty-Three: version: 1.1, author: the WordPress team, Auto-updates enabled

### wp-plugins-active (43) ###

Advanced Search Pro: version: 1.1, author: mndpsingh287, Auto-updates disabled
AIOSEO - Image SEO: version: 1.1.7, author: All in One SEO Team, Auto-updates enabled
AIOSEO - Redirects: version: 1.2.11, author: All in One SEO Team, Auto-updates enabled
Akismet Anti-Spam: version: 5.1, author: Automattic, Auto-updates enabled
All in One SEO Pro: version: 4.3.8, author: All in One SEO Team, Auto-updates enabled
Back In Stock Notifier for WooCommerce | WooCommerce Waitlist Pro: version: 3.2, author: codewoogeek, Auto-updates disabled
CAPTCHA 4WP: version: 7.2.1, author: WP White Security, Auto-updates disabled
Classic Editor: version: 1.6.3, author: WordPress Contributors, Auto-updates enabled
Classic Widgets: version: 0.3, author: WordPress Contributors, Auto-updates disabled
Contact Form 7: version: 5.7.7, author: Takayuki Miyoshi, Auto-updates enabled
Contact Form 7 Extension For Mailchimp: version: 0.5.68, author: Renzo Johnson, Auto-updates enabled
Custom Sidebars: version: 3.36, author: WebFactory Ltd, Auto-updates disabled
Discount Rules and Dynamic Pricing for WooCommerce: version: 7.9.1, author: Discount Team, Auto-updates enabled
Facebook for WooCommerce: version: 3.0.23, author: Facebook, Auto-updates enabled
GTM4WP: version: 1.16.2, author: Thomas Geiger, Auto-updates enabled
Imagify: version: 2.1.1, author: Imagify – Optimize Images & Convert WebP, Auto-updates disabled
Klarna Order Management for WooCommerce: version: 1.7.2, author: klarna, krokedil, Auto-updates enabled
Klarna Payments for WooCommerce: version: 3.0.7, author: krokedil, klarna, automattic, Auto-updates enabled
Mailchimp for WooCommerce: version: 2.8.3, author: Mailchimp, Auto-updates disabled
Mailgun: version: 1.9.3, author: Mailgun, Auto-updates enabled
Max Mega Menu: version: 3.2.2, author: megamenu.com, Auto-updates enabled
Max Mega Menu - Pro Addon: version: 2.2.7, author: megamenu.com (latest version: 2.2.8), Auto-updates disabled
Product Badges: version: 2.3.1, author: 99w (latest version: 2.3.2), Auto-updates disabled
Redirection: version: 5.3.10, author: John Godley, Auto-updates disabled
Variation Swatches for WooCommerce: version: 2.0.20, author: Emran Ahmed (latest version: 2.0.21), Auto-updates disabled
Variation Swatches for WooCommerce - Pro: version: 2.0.20, author: Emran Ahmed (latest version: 2.0.21), Auto-updates disabled
WooCommerce: version: 7.7.0, author: Automattic (latest version: 7.7.2), Auto-updates disabled
WooCommerce Gift Cards: version: 1.15.5, author: WooCommerce (latest version: 1.16.1), Auto-updates disabled
WooCommerce Opayo Payment Suite: version: 5.11.0, author: Andrew Benbow, Auto-updates disabled
WooCommerce PayPal Payments: version: 2.0.4, author: WooCommerce (latest version: 2.0.5), Auto-updates disabled
WooCommerce Pre-Orders: version: 1.5.30, author: WooCommerce (latest version: 2.0.2), Auto-updates disabled
WooCommerce Product CSV Import Suite: version: 1.10.57, author: WooCommerce (latest version: 1.10.58), Auto-updates enabled
WooCommerce Shipment Tracking: version: 2.3.1, author: WooCommerce, Auto-updates enabled
WooCommerce Table Rate Shipping: version: 3.1.1, author: WooCommerce, Auto-updates disabled
WooCommerce Tab Manager: version: 1.15.0, author: SkyVerge, Auto-updates disabled
WP-Lister Pro for Amazon: version: 2.5.4, author: WP Lab, Auto-updates disabled
WP All Export Pro: version: 1.6.6, author: Soflyy (latest version: 1.8.3), Auto-updates disabled
WP All Import - WooCommerce Import Add-On Pro: version: 3.3.4, author: Soflyy, Auto-updates disabled
WP All Import Pro: version: 4.8.0, author: Soflyy, Auto-updates disabled
WP Super Cache: version: 1.9.4, author: Automattic, Auto-updates enabled
YITH WooCommerce Cart Messages Premium: version: 1.30.0, author: YITH, Auto-updates disabled
YITH WooCommerce Product Bundles Premium: version: 1.25.0, author: YITH, Auto-updates disabled
YITH WooCommerce Wishlist: version: 3.21.0, author: YITH, Auto-updates enabled

### wp-media ###

image_editor: WP_Image_Editor_Imagick
imagick_module_version: 1691
imagemagick_version: ImageMagick 6.9.11-60 Q16 x86_64 2021-01-25 https://imagemagick.org
imagick_version: 3.7.0
file_uploads: File uploads is turned off
post_max_size: 20M
upload_max_filesize: 20M
max_effective_size: 20 MB
max_file_uploads: 20
imagick_limits: 
	imagick::RESOURCETYPE_AREA: 122 MB
	imagick::RESOURCETYPE_DISK: 1073741824
	imagick::RESOURCETYPE_FILE: 768
	imagick::RESOURCETYPE_MAP: 512 MB
	imagick::RESOURCETYPE_MEMORY: 256 MB
	imagick::RESOURCETYPE_THREAD: 1
	imagick::RESOURCETYPE_TIME: 9.2233720368548E+18
imagemagick_file_formats: 3FR, 3G2, 3GP, AAI, AI, APNG, ART, ARW, AVI, AVIF, AVS, BGR, BGRA, BGRO, BIE, BMP, BMP2, BMP3, BRF, CAL, CALS, CANVAS, CAPTION, CIN, CIP, CLIP, CMYK, CMYKA, CR2, CR3, CRW, CUR, CUT, DATA, DCM, DCR, DCX, DDS, DFONT, DNG, DPX, DXT1, DXT5, EPDF, EPI, EPS, EPS2, EPS3, EPSF, EPSI, EPT, EPT2, EPT3, ERF, FAX, FILE, FITS, FRACTAL, FTP, FTS, G3, G4, GIF, GIF87, GRADIENT, GRAY, GRAYA, GROUP4, H, HALD, HDR, HEIC, HISTOGRAM, HRZ, HTM, HTML, HTTP, HTTPS, ICB, ICO, ICON, IIQ, INFO, INLINE, IPL, ISOBRL, ISOBRL6, J2C, J2K, JBG, JBIG, JNG, JNX, JP2, JPC, JPE, JPEG, JPG, JPM, JPS, JPT, JSON, K25, KDC, LABEL, M2V, M4V, MAC, MAGICK, MAP, MASK, MAT, MATTE, MEF, MIFF, MKV, MNG, MONO, MOV, MP4, MPC, MPG, MRW, MSL, MTV, MVG, NEF, NRW, NULL, ORF, OTB, OTF, PAL, PALM, PAM, PATTERN, PBM, PCD, PCDS, PCL, PCT, PCX, PDB, PDF, PDFA, PEF, PES, PFA, PFB, PFM, PGM, PGX, PICON, PICT, PIX, PJPEG, PLASMA, PNG, PNG00, PNG24, PNG32, PNG48, PNG64, PNG8, PNM, POCKETMOD, PPM, PREVIEW, PS, PS2, PS3, PSB, PSD, PTIF, PWP, RADIAL-GRADIENT, RAF, RAS, RAW, RGB, RGBA, RGBO, RGF, RLA, RLE, RMF, RW2, SCR, SCT, SFW, SGI, SHTML, SIX, SIXEL, SPARSE-COLOR, SR2, SRF, STEGANO, SUN, TEXT, TGA, THUMBNAIL, TIFF, TIFF64, TILE, TIM, TTC, TTF, TXT, UBRL, UBRL6, UIL, UYVY, VDA, VICAR, VID, VIDEO, VIFF, VIPS, VST, WBMP, WEBM, WEBP, WMV, WPG, X, X3F, XBM, XC, XCF, XPM, XPS, XV, XWD, YCbCr, YCbCrA, YUV
gd_version: not available
ghostscript_version: 9.55.0

### wp-server ###

server_architecture: Linux 5.15.0-71-generic x86_64
httpd_software: nginx/1.18.0
php_version: 8.0.28 64bit
php_sapi: fpm-fcgi
max_input_variables: 5000
time_limit: 600
memory_limit: 256M
admin_memory_limit: 2G
max_input_time: 60
upload_max_filesize: 20M
php_post_max_size: 20M
curl_version: 7.81.0 OpenSSL/3.0.2
suhosin: false
imagick_availability: true
pretty_permalinks: true

### wp-database ###

extension: mysqli
server_version: 5.7.42
client_version: mysqlnd 8.0.28
max_allowed_packet: 1073741824
max_connections: 500

### wp-constants ###

WP_HOME: undefined
WP_SITEURL: undefined
WP_CONTENT_DIR: /var/www/wadswick.co.uk/wp-content
WP_PLUGIN_DIR: /var/www/wadswick.co.uk/wp-content/plugins
WP_MEMORY_LIMIT: 256M
WP_MAX_MEMORY_LIMIT: 2G
WP_DEBUG: false
WP_DEBUG_DISPLAY: false
WP_DEBUG_LOG: false
SCRIPT_DEBUG: false
WP_CACHE: true
CONCATENATE_SCRIPTS: undefined
COMPRESS_SCRIPTS: undefined
COMPRESS_CSS: undefined
WP_ENVIRONMENT_TYPE: Undefined
DB_CHARSET: utf8
DB_COLLATE: undefined

### wp-filesystem ###

wordpress: writable
wp-content: writable
uploads: writable
plugins: writable
themes: writable
mu-plugins: writable

### aioseo (1) ###

noindexed: Author Archives, Date Archives, Categories (category)

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

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Support lionel.a11n

    (@lioneldaniel)

    10 months, 2 weeks ago

    Hello @kanagency,

    In general, performance is tightly connected to the plugin stack you are using and your server environment. We have some general advice for addressing performance issues on our blog (these tips range from general to technical – you already are monitoring your speed, for instance): Ten Ways to Improve the Speed of Your WooCommerce Store

    For your specific issue, it sounds like a plugin (or perhaps a theme feature, though Flatsome is a fairly popular theme so I doubt it) is initiating the numerous calls.

    From the report you sent, I’d try disabling your “Discount Rules and Dynamic Pricing for WooCommerce” plugin and re-benchmarking your site. If that doesn’t work, I recommend a full conflict test to narrow down the issue – here’s a guide to conduct that test: Conflict Testing Guide

    You could try disabling plugins ad-hoc to test, but we find the thorough testing process to be a much faster way to resolve issues.

    We look forward to hearing back from you, and if you have any further questions or details please include those in your reply. Thanks!

    Plugin Support Gabriel – a11n

    (@gabrielfuentes)

    10 months, 1 week ago

    As you haven’t responded in a while, I’m marking this as resolved. We’ll be here for you if/when you need us.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Extremely Poor Performance’ is closed to new replies.