PHJL online casino.REGISTER NOW GET FREE 888 PESOS REWARDS!

Resolved

(@rhand)

When we go from checkout to

/checkout/order-received/7037/?key=wc_order_gSk8KJuLwUJv2

it tends to take us 10-20 seconds.

When we check with Query Monitor it seems queries are 1-2 seconds only so the remaining 10-15 seconds must be caused by something else. We tried with and without Object Caching using Redis and that does not seems to matter either. Object caching seems to help with catching 80-0-% of the queries.

We also use JIT compilation by PHP 8, gzip and Brotli for static data and turned off most plugins including WP Rocket and Imagify . But all that does not seem to help. We do think it may be connected to Fancy Product Designer or its Exporter, but have not been able to pinpoint the issue nor can we live without it.

What tools can we use to see why the request to get order-overview is taking so long?

Status report

`
### WordPress Environment ###

WordPress address (URL): https://snaakontwerp.nl
Site address (URL): https://snaakontwerp.nl
WC Version: 8.2.1
REST API Version: ? 8.2.1
WC Blocks Version: ? 11.1.2
Action Scheduler Version: ? 3.6.3
Log Directory Writable: ?
WP Version: 6.4.1
WP Multisite: –
WP Memory Limit: 1 GB
WP Debug Mode: –
WP Cron: ?
Language: nl_NL
External object cache: ?

### Server Environment ###

Server Info: nginx/1.24.0
PHP Version: 8.0.30
PHP Post Max Size: 100 MB
PHP Time Limit: 300
PHP Max Input Vars: 3000
cURL Version: 7.61.1
OpenSSL/1.1.1k

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

### Database ###

WC Database Version: 8.2.1
WC Database Prefix: wp_
Total Database Size: 96.08MB
Database Data Size: 89.64MB
Database Index Size: 6.44MB
wp_woocommerce_sessions: Data: 2.06MB + Index: 0.02MB + Engine InnoDB
wp_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_woocommerce_order_items: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_woocommerce_order_itemmeta: Data: 27.52MB + Index: 0.16MB + Engine InnoDB
wp_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_actionscheduler_actions: Data: 0.23MB + Index: 0.30MB + Engine InnoDB
wp_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_actionscheduler_logs: Data: 1.19MB + Index: 0.19MB + Engine InnoDB
wp_check_email_log: Data: 0.06MB + Index: 0.00MB + Engine InnoDB
wp_cmplz_cookiebanners: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_cmplz_cookies: Data: 0.05MB + Index: 0.00MB + Engine InnoDB
wp_cmplz_services: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_comments: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
wp_e_events: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_e_notes: Data: 0.02MB + Index: 0.17MB + Engine InnoDB
wp_e_notes_users_relations: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_e_submissions: Data: 0.02MB + Index: 0.27MB + Engine InnoDB
wp_e_submissions_actions_log: Data: 0.02MB + Index: 0.11MB + Engine InnoDB
wp_e_submissions_values: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_fpd_categories: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_fpd_category_products_rel: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_fpd_designs: Data: 0.45MB + Index: 0.00MB + Engine InnoDB
wp_fpd_print_jobs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_fpd_products: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_fpd_views: Data: 0.28MB + Index: 0.00MB + Engine InnoDB
wp_imagify_files: Data: 0.02MB + Index: 0.08MB + Engine InnoDB
wp_imagify_folders: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_nf3_actions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_nf3_action_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_nf3_chunks: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_nf3_fields: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_nf3_field_meta: Data: 0.05MB + Index: 0.00MB + Engine InnoDB
wp_nf3_forms: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_nf3_form_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_nf3_objects: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_nf3_object_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_nf3_relationships: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_nf3_upgrades: Data: 0.05MB + Index: 0.00MB + Engine InnoDB
wp_options: Data: 4.06MB + Index: 0.14MB + Engine InnoDB
wp_postmeta: Data: 13.52MB + Index: 1.73MB + Engine InnoDB
wp_posts: Data: 17.17MB + Index: 0.52MB + Engine InnoDB
wp_termmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_terms: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_term_relationships: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_term_taxonomy: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_tm_taskmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_tm_tasks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_usermeta: Data: 1.05MB + Index: 0.03MB + Engine InnoDB
wp_users: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_wc_admin_notes: Data: 0.09MB + Index: 0.00MB + Engine InnoDB
wp_wc_admin_note_actions: Data: 0.06MB + Index: 0.02MB + Engine InnoDB
wp_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wc_customer_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wc_orders: Data: 0.02MB + Index: 0.11MB + Engine InnoDB
wp_wc_orders_meta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wc_order_addresses: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wc_order_operational_data: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wc_order_product_lookup: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_wc_order_stats: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wc_product_attributes_lookup: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wc_product_download_directories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wc_product_meta_lookup: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
wp_wc_rate_limits: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wfblockediplog: Data: 0.17MB + Index: 0.00MB + Engine InnoDB
wp_wfblocks7: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_wfconfig: Data: 2.38MB + Index: 0.00MB + Engine InnoDB
wp_wfcrawlers: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wffilechanges: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wffilemods: Data: 10.52MB + Index: 0.00MB + Engine InnoDB
wp_wfhits: Data: 1.02MB + Index: 0.22MB + Engine InnoDB
wp_wfhoover: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wfissues: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_wfknownfilelist: Data: 5.52MB + Index: 0.00MB + Engine InnoDB
wp_wflivetraffichuman: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wflocs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wflogins: Data: 0.09MB + Index: 0.03MB + Engine InnoDB
wp_wfls_2fa_secrets: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wfls_role_counts: Data: 0.00MB + Index: 0.00MB + Engine MEMORY
wp_wfls_settings: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wfnotifications: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wfpendingissues: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_wfreversecache: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wfsecurityevents: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wfsnipcache: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_wfstatus: Data: 0.19MB + Index: 0.11MB + Engine InnoDB
wp_wftrafficrates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wfwaffailures: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wpforms_payments: Data: 0.02MB + Index: 0.14MB + Engine InnoDB
wp_wpforms_payment_meta: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_wpforms_tasks_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wpmailsmtp_debug_events: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wpmailsmtp_tasks_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wpr_rocket_cache: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_wpr_rucss_used_css: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
wp_yoast_indexable: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
wp_yoast_indexable_hierarchy: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_yoast_migrations: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_yoast_primary_term: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_yoast_seo_links: Data: 0.02MB + Index: 0.03MB + Engine InnoDB

### Post Type Counts ###

acf-field: 1
acf-field-group: 1
addify_quote: 2
addify_rfq: 1
attachment: 2741
custom_css: 1
customize_changeset: 3
elementor_library: 11
nav_menu_item: 6
page: 12
post: 3
product: 9
product_variation: 9
revision: 500
seedprod: 2
shop_order: 38
wcpa_pt_forms: 8
wp_global_styles: 3
wpforms: 2

### Security ###

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

### Active Plugins (13) ###

Query Monitor: by John Blackbourn – 3.15.0
Advanced Custom Fields PRO: by WP Engine – 6.2.1.1
The SEO Framework: by The SEO Framework Team – 4.2.8
Complianz | GDPR/CCPA Cookie Consent: by Really Simple Plugins – 6.5.5
Elementor Pro: by Elementor.com – 3.17.1
Elementor: by Elementor.com – 3.17.2
Fancy Product Designer PRO Export: by fancyproductdesigner.com – 1.4.1
Fancy Product Designer: by fancyproductdesigner.com – 6.1.01
Loco Translate: by Tim Whitlock – 2.6.6
Redis Object Cache: by Till Krüss – 2.4.4
WooCommerce Custom Product Addons Free: by Acowebs – 3.0.4
WooCommerce: by Automattic – 8.2.1 (update to version 8.2.2 is available)
WPForms Lite: by WPForms – 1.8.4.1

### Inactive Plugins (7) ###

Check & Log Email: by WPOmnia – 1.0.8
Imagify: by Imagify – Optimize Images & Convert WebP – 2.1.2
Preview E-mails for WooCommerce: by Digamber Pradhan – 2.1.6
Regenerate Thumbnails: by Alex Mills (Viper007Bond) – 3.1.6
Wordfence Security: by Wordfence – 7.10.7
WP-Optimize - Clean, Compress, Cache: by David Anderson
Ruhani Rabin
Team Updraft – 3.2.21

WP Rocket: by WP Media – 3.15.3

### Dropin Plugins (4) ###

advanced-cache.php: advanced-cache.php
db.php: Query Monitor Database Class (Drop-in)
maintenance.php: maintenance.php
object-cache.php: Redis Object Cache Drop-In

### Must Use Plugins (1) ###

Snaakontwerp Custom: by Jasper Frumau –

### Settings ###

API Enabled: –
Force SSL: –
Currency: EUR (€)
Currency Position: left_space
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: ?
Enforce Approved Product Download Directories: –
HPOS feature screen enabled: –
HPOS feature enabled: –
Order datastore: WC_Order_Data_Store_CPT
HPOS data sync enabled: –

### WC Pages ###

Shop base: #336 - /producten/
Cart: #784 - /cart/
Checkout: #782 - /checkout/
My account: #788 - /mijn-account/
Terms and conditions: ? Page not set

### Theme ###

Name: Snaakontwerp
Version: 1.1.7
Author URL: https://imagewize.com
Child Theme: ?
Parent Theme Name: Astra
Parent Theme Version: 4.4.0 – 4.4.1 is available
Parent Theme Author URL: https://wpastra.com/about/?utm_source=theme_preview&utm_medium=author_link&utm_campaign=astra_theme
WooCommerce Support: ?

### Templates ###

Overrides: astra-child/woocommerce/emails/email-order-details.php
astra-child/woocommerce/emails/email-order-items.php


### Admin ###

Enabled Features: activity-panels
analytics
product-block-editor
coupons
core-profiler
customer-effort-score-tracks
import-products-task
experimental-fashion-sample-products
shipping-smart-defaults
shipping-setting-tour
homescreen
marketing
mobile-app-banner
navigation
onboarding
onboarding-tasks
product-variation-management
remote-inbox-notifications
remote-free-extensions
payment-gateway-suggestions
shipping-label-banner
subscriptions
store-alerts
transient-notices
woo-mobile-welcome
wc-pay-promotion
wc-pay-welcome-page

Disabled Features: customize-store
minified-js
new-product-management-experience
settings
async-product-editor-category-field

Daily Cron: ? Next scheduled: 2023-11-15 10:13:51 +01:00
Options: ?
Notes: 171
Onboarding: completed

### Action Scheduler ###

Complete: 378
Oldest: 2023-10-15 04:11:08 +0200
Newest: 2023-11-15 03:07:30 +0100

Failed: 421
Oldest: 2022-11-02 10:28:13 +0100
Newest: 2023-11-14 05:59:04 +0100

Pending: 5
Oldest: 2023-11-15 06:28:55 +0100
Newest: 2023-11-19 04:52:51 +0100


### Status report information ###

Generated at: 2023-11-15 03:08:11 +01:00

This topic was modified 1 year, 3 months ago by Rhand.

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

Viewing 4 replies - 1 through 4 (of 4 total)

Thread Starter

Rhand

(@rhand)

1 year, 3 months ago

Did see these MariaDB warnings

tail /var/log/mariadb/mariadb.log
2023-11-14  6:34:02 50291 [Warning] Aborted connection 50291 to db: 'psa' user: 'admin' host: 'localhost' (Got timeout reading communication packets)
2023-11-14  6:34:02 50292 [Warning] Aborted connection 50292 to db: 'psa' user: 'admin' host: 'localhost' (Got timeout reading communication packets)
2023-11-15  0:15:16 53119 [Warning] Aborted connection 53119 to db: 'psa' user: 'admin' host: 'localhost' (Got an error reading communication packets)
2023-11-15  2:23:00 53594 [Warning] Aborted connection 53594 to db: 'wp_swrgw' user: 'wp_g8v0z' host: 'localhost' (Got an error reading communication packets)

So perhaps I need

[mysqld]
max_allowed_packet=256M
innodb_buffer_pool_size=1024M
query_cache_size=64M

based on https://support.plesk.com/hc/en-us/articles/12377745364375-How-to-troubleshoot-slow-performance-of-MySQL-on-a-Plesk-server- and https://dba.stackexchange.com/questions/19135/mysql-error-reading-communication-packets .

Again Query Monitor did not complain or show the 15-20 seconds delay and Object Cache should help and did help with 90% of queries.. but perhaps not with final query for order overview?

Thread Starter

Rhand

(@rhand)

1 year, 3 months ago

Do see in console request checkout/order-received/7040/?key=wc_order_DNrtfE6qQVB3U takes 1.8 seconds besides all the in memory files. Total 1.88 seconds. Query Monitor mentioned 0.88 seconds, 68.3 MB, 0.02 seconds and 52 queries and 92.7% handled by Object Cache.

In database processes I only saw multiple sleep commands

plesk db "SHOW FULL PROCESSLIST"
+-------+-------------+-----------+----------+---------+-------+--------------------------+-----------------------+----------+
| Id    | User        | Host      | db       | Command | Time  | State                    | Info                  | Progress |
+-------+-------------+-----------+----------+---------+-------+--------------------------+-----------------------+----------+
|     1 | system user |           | NULL     | Daemon  |  NULL | InnoDB purge coordinator | NULL                  |    0.000 |
|     3 | system user |           | NULL     | Daemon  |  NULL | InnoDB shutdown handler  | NULL                  |    0.000 |
|     2 | system user |           | NULL     | Daemon  |  NULL | InnoDB purge worker      | NULL                  |    0.000 |
|     4 | system user |           | NULL     | Daemon  |  NULL | InnoDB purge worker      | NULL                  |    0.000 |
|     5 | system user |           | NULL     | Daemon  |  NULL | InnoDB purge worker      | NULL                  |    0.000 |
| 27340 | admin       | localhost | psa      | Sleep   |    16 |                          | NULL                  |    0.000 |
| 52875 | admin       | localhost | psa      | Sleep   | 23117 |                          | NULL                  |    0.000 |
| 52876 | admin       | localhost | psa      | Sleep   | 23116 |                          | NULL                  |    0.000 |
| 54569 | wp_g8v0z    | localhost | wp_swrgw | Sleep   |    18 |                          | NULL                  |    0.000 |
| 54577 | admin       | localhost | psa      | Query   |     0 | Init                     | SHOW FULL PROCESSLIST |    0.000 |
+-------+-------------+-----------+----------+---------+-------+--------------------------+-----------------------+----------+

But for WordPress user wp_g8v0z | localhost | wp_swrgw | Sleep | 18 is removed soon thereafter so all processed.

It must be the Ajax request getting data that is taking so long. But the bottleneck is still not quite clear.

Thread Starter

Rhand

(@rhand)

1 year, 3 months ago

Based on https://woo.com/document/endless-loadingspinner-on-the-checkout-page/ we are testing

add_filter( 'woocommerce_defer_transactional_emails', '__return_true' );

It seems to be helping us to delay the transactional emails. It speeds up the checkout to order received part. Never needed this before however.

This reply was modified 1 year, 3 months ago by Rhand.

Plugin Support

Shameem R. a11n

(@shameemreza)

1 year, 3 months ago

Hi @rhand

I’m glad you were able to find a solution to your inquiry here and thanks for sharing it with the community too! ??

Should you have further inquiries, kindly create a new topic here.

Thanks!

Viewing 4 replies - 1 through 4 (of 4 total)

The topic ‘Checkout to order-overview 10-20 seconds’ is closed to new replies.