Slot png background,Bali monkeypox app.REGISTER NOW GET FREE 888 PESOS REWARDS!

Resolved aeminium01
(@aeminium01)

1 year, 1 month ago
Hi
I have a problem that I never experienced before with Woocommerce software.
After restoring a online store with 700.000 products in a new server (VPS) all went fine.
I’ve updated all plugins to the latest version, including Woocommerce to 8.1.1.
After the Woocommerce update both frontend and wp backend became extremely slow. Everything that you can click on takes at least 30 to 45 seconds to load.

I’ve made some tests:
- deactivated main theme and switch to default wp theme with no results
- deactivated all plugins one by one, and only when I deactivated Woocommerce the problem stops
- even if Woocommerce is the only active plugin the problem continues
- if all plugins – except Woocommerce – are turned on the frontend and wp backend work fine
I noticed that when Woocommerce is turned on I have this very long query:

SELECT usr8_posts.ID
FROM usr8_posts
LEFT JOIN usr8_term_relationships
ON (usr8_posts.ID = usr8_term_relationships.object_id)
WHERE 1=1
AND ( usr8_term_relationships.term_taxonomy_id IN (2,3,4,5) )
AND usr8_posts.post_type = ‘product’
AND ((usr8_posts.post_status = ‘publish’))
GROUP BY usr8_posts.ID
ORDER BY usr8_posts.post_date DESC
LIMIT 0, 1

from caller: WP_Query->get_posts()

this one takes 30 seconds to complete!

And another much smaller query:

SELECT post_status, COUNT( * ) AS num_posts
FROM usr8_posts
WHERE post_type = ‘product’
GROUP BY post_status

from caller: wp_count_posts()

This one takes 0,7948 seconds

Also, another thing that I’ve noticed: when Woocommerce is active, the wp health check says that I’ve a problem with my REST API, but when Woocommerce is inactive, the wp health check doesn’t show that warning.

I would appreciate any help with this problem.

Here is the Woocommerce status:

` WordPress Environment WordPress address (URL): https://musicdstore.pt Site address (URL): https://musicdstore.pt WC Version: 8.1.1 REST API Version: ? 8.1.1 WC Blocks Version: ? 10.9.3 Action Scheduler Version: ? 3.6.2 Log Directory Writable: ? WP Version: 6.3.1 WP Multisite: – WP Memory Limit: 3 GB WP Debug Mode: – WP Cron: – Language: pt_PT External object cache: – Server Environment Server Info: Apache PHP Version: 7.4.33 PHP Post Max Size: 1 GB PHP Time Limit: 3600 PHP Max Input Vars: 5000 cURL Version: 7.61.1 OpenSSL/1.1.1k SUHOSIN Installed: – MySQL Version: 5.5.5-10.3.39-MariaDB Max Upload Size: 256 MB Default Timezone is UTC: ? fsockopen/cURL: ? SoapClient: ? DOMDocument: ? GZip: ? Multibyte String: ? Remote Post: ? Remote Get: ? Database WC Database Version: 8.1.1 WC Database Prefix: usr8_ Tamanho total da base de dados: 4583.62MB Tamanho dos dados da base de dados: 2566.87MB Tamanho do índice da base de dados: 2016.75MB usr8_woocommerce_sessions: Dados: 0.02MB + índice: 0.02MB + Engine InnoDB usr8_woocommerce_api_keys: Dados: 0.02MB + índice: 0.03MB + Engine InnoDB usr8_woocommerce_attribute_taxonomies: Dados: 0.02MB + índice: 0.02MB + Engine InnoDB usr8_woocommerce_downloadable_product_permissions: Dados: 0.02MB + índice: 0.06MB + Engine InnoDB usr8_woocommerce_order_items: Dados: 0.02MB + índice: 0.02MB + Engine InnoDB usr8_woocommerce_order_itemmeta: Dados: 0.02MB + índice: 0.03MB + Engine InnoDB usr8_woocommerce_tax_rates: Dados: 0.02MB + índice: 0.06MB + Engine InnoDB usr8_woocommerce_tax_rate_locations: Dados: 0.02MB + índice: 0.03MB + Engine InnoDB usr8_woocommerce_shipping_zones: Dados: 0.02MB + índice: 0.00MB + Engine InnoDB usr8_woocommerce_shipping_zone_locations: Dados: 0.02MB + índice: 0.03MB + Engine InnoDB usr8_woocommerce_shipping_zone_methods: Dados: 0.02MB + índice: 0.00MB + Engine InnoDB usr8_woocommerce_payment_tokens: Dados: 0.02MB + índice: 0.02MB + Engine InnoDB usr8_woocommerce_payment_tokenmeta: Dados: 0.02MB + índice: 0.03MB + Engine InnoDB usr8_woocommerce_log: Dados: 0.02MB + índice: 0.02MB + Engine InnoDB usr8_actionscheduler_actions: Dados: 0.02MB + índice: 0.11MB + Engine InnoDB usr8_actionscheduler_claims: Dados: 0.02MB + índice: 0.02MB + Engine InnoDB usr8_actionscheduler_groups: Dados: 0.02MB + índice: 0.02MB + Engine InnoDB usr8_actionscheduler_logs: Dados: 0.02MB + índice: 0.03MB + Engine InnoDB usr8_commentmeta: Dados: 0.02MB + índice: 0.03MB + Engine InnoDB usr8_comments: Dados: 0.02MB + índice: 0.09MB + Engine InnoDB usr8_e_events: Dados: 0.02MB + índice: 0.02MB + Engine InnoDB usr8_e_submissions: Dados: 0.02MB + índice: 0.27MB + Engine InnoDB usr8_e_submissions_actions_log: Dados: 0.02MB + índice: 0.11MB + Engine InnoDB usr8_e_submissions_values: Dados: 0.02MB + índice: 0.03MB + Engine InnoDB usr8_links: Dados: 0.02MB + índice: 0.02MB + Engine InnoDB usr8_options: Dados: 5.36MB + índice: 0.08MB + Engine InnoDB usr8_postmeta: Dados: 1649.00MB + índice: 1501.00MB + Engine InnoDB usr8_posts: Dados: 259.81MB + índice: 171.55MB + Engine InnoDB usr8_snippets: Dados: 0.02MB + índice: 0.03MB + Engine InnoDB usr8_termmeta: Dados: 0.06MB + índice: 0.06MB + Engine InnoDB usr8_terms: Dados: 0.02MB + índice: 0.03MB + Engine InnoDB usr8_term_relationships: Dados: 57.63MB + índice: 35.61MB + Engine InnoDB usr8_term_taxonomy: Dados: 0.02MB + índice: 0.03MB + Engine InnoDB usr8_usermeta: Dados: 0.05MB + índice: 0.03MB + Engine InnoDB usr8_users: Dados: 0.02MB + índice: 0.05MB + Engine InnoDB usr8_wc_admin_notes: Dados: 0.08MB + índice: 0.00MB + Engine InnoDB usr8_wc_admin_note_actions: Dados: 0.06MB + índice: 0.02MB + Engine InnoDB usr8_wc_category_lookup: Dados: 0.02MB + índice: 0.00MB + Engine InnoDB usr8_wc_customer_lookup: Dados: 0.02MB + índice: 0.03MB + Engine InnoDB usr8_wc_download_log: Dados: 0.02MB + índice: 0.03MB + Engine InnoDB usr8_wc_orders: Dados: 0.02MB + índice: 0.11MB + Engine InnoDB usr8_wc_orders_meta: Dados: 0.02MB + índice: 0.03MB + Engine InnoDB usr8_wc_order_addresses: Dados: 0.02MB + índice: 0.06MB + Engine InnoDB usr8_wc_order_coupon_lookup: Dados: 0.02MB + índice: 0.03MB + Engine InnoDB usr8_wc_order_operational_data: Dados: 0.02MB + índice: 0.03MB + Engine InnoDB usr8_wc_order_product_lookup: Dados: 0.02MB + índice: 0.06MB + Engine InnoDB usr8_wc_order_stats: Dados: 0.02MB + índice: 0.05MB + Engine InnoDB usr8_wc_order_tax_lookup: Dados: 0.02MB + índice: 0.03MB + Engine InnoDB usr8_wc_product_attributes_lookup: Dados: 0.02MB + índice: 0.02MB + Engine InnoDB usr8_wc_product_download_directories: Dados: 0.02MB + índice: 0.02MB + Engine InnoDB usr8_wc_product_meta_lookup: Dados: 72.63MB + índice: 88.20MB + Engine InnoDB usr8_wc_rate_limits: Dados: 0.02MB + índice: 0.02MB + Engine InnoDB usr8_wc_reserved_stock: Dados: 0.02MB + índice: 0.00MB + Engine InnoDB usr8_wc_tax_rate_classes: Dados: 0.02MB + índice: 0.02MB + Engine InnoDB usr8_wc_webhooks: Dados: 0.02MB + índice: 0.02MB + Engine InnoDB usr8_wt_iew_action_history: Dados: 1.52MB + índice: 0.00MB + Engine InnoDB usr8_wt_iew_cron: Dados: 0.02MB + índice: 0.00MB + Engine InnoDB usr8_wt_iew_ftp: Dados: 0.02MB + índice: 0.00MB + Engine InnoDB usr8_wt_iew_mapping_template: Dados: 0.09MB + índice: 0.00MB + Engine InnoDB usr8_yoast_indexable: Dados: 490.00MB + índice: 185.72MB + Engine InnoDB usr8_yoast_indexable_hierarchy: Dados: 29.56MB + índice: 32.58MB + Engine InnoDB usr8_yoast_migrations: Dados: 0.02MB + índice: 0.02MB + Engine InnoDB usr8_yoast_primary_term: Dados: 0.02MB + índice: 0.03MB + Engine InnoDB usr8_yoast_seo_links: Dados: 0.02MB + índice: 0.03MB + Engine InnoDB Post Type Counts acf-field: 9 acf-field-group: 1 attachment: 351943 custom_css: 1 elementor_library: 12 nav_menu_item: 2 page: 15 post: 1 product: 714337 revision: 614 Security Secure connection (HTTPS): ? Hide errors from visitors: ? Active Plugins (16) Query Monitor: por John Blackbourn – 3.13.1 Advanced Custom Fields: por WP Engine – 6.2.1 Classic Editor: por WordPress Contributors – 1.6.3 Classic Widgets: por Contribuidores do WordPress – 0.3 Code Snippets: por Code Snippets Pro – 3.5.0 Delete Expired Transients: por WebAware – 2.0.7 Elementor Pro: por Elementor.com – 3.16.2 Elementor: por Elementor.com – 3.16.4 Loco Translate: por Tim Whitlock – 2.6.6 Malina Elements: por Artstudioworks – 2.4.5 Advanced Editor Tools: por Automattic – 5.9.2 WooCommerce: por Automattic – 8.1.1 Yoast SEO: por Team Yoast – 21.2 WP Crontrol: por John Blackbourn & crontributors – 1.15.3 Product Import Export for WooCommerce Add-on: por WebToffee – 1.1.5 Import Export for WooCommerce Wrapper: por WebToffee – 1.1.8 Inactive Plugins (0) Dropin Plugins (1) db.php: Query Monitor Database Class (Drop-in) 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) 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 Página da Loja: #15 – /musica/ Carrinho: #16 – /carrinho/ Finalizar compras: #17 – /finalizar-compra/ A minha conta: #18 – /minha-conta/ Termos e condi??es: #58 – /termos-e-condicoes-de-servico/ Theme Name: Malina child-theme Version: 1.0 Author URL: https://themeforest.net/user/artstudioworks Child Theme: ? Parent Theme Name: Malina Parent Theme Version: 2.4.1 Parent Theme Author URL: https://themeforest.net/user/artstudioworks WooCommerce Support: ? Templates Archive Template: O seu tema tem um ficheiro woocommerce.php pelo que n?o poderá substituir o modelo personalizado woocommerce/archive-product.php (o ficheiro woocommerce.php tem prioridade sobre o ficheiro archive-product.php). Isto destina-se a evitar problemas de apresenta??o. Overrides: malina/woocommerce/cart/cart.php malina/woocommerce/global/quantity-input.php malina/woocommerce/single-product/product-image.php malina/woocommerce/single-product.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 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 product-variation-management settings async-product-editor-category-field Daily Cron: ? Next scheduled: 2023-10-03 19:01:33 +00:00 Options: ? Notes: 89 Onboarding: skipped Action Scheduler Concluída: 21 Oldest: 2023-09-29 18:32:29 +0000 Newest: 2023-10-02 15:38:49 +0000 Pendente: 2 Oldest: 2023-10-02 22:03:19 +0000 Newest: 2023-10-03 14:44:51 +0000 Falhada: 10 Oldest: 2023-02-22 19:04:25 +0000 Newest: 2023-10-01 22:29:49 +0000 Cancelada: 1 Oldest: 2023-10-01 14:44:27 +0000 Newest: 2023-10-01 14:44:27 +0000 Status report information Generated at: 2023-10-02 22:03:23 +00:00 `

Best regards

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

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

cberzosabc
(@cberzosabc)

1 year, 1 month ago

Hello, I have the same problems. The front loads very fast but if I try to enter products or orders in the back, the page takes 20 or 30 seconds to load. I also have slow or repeated database calls. I’m writing in case someone knows the solution. If I discover it I will share it with you

Saif
(@babylon1999)

1 year, 1 month ago

Hello @aeminium01,

Thank you for reaching out!

The issue you’ve mentioned matches what’s reported here: https://github.com/woocommerce/woocommerce/issues/40065

I noticed that you’re using the same version of MySQL as mentioned in the report, so your database engine might be the cause, as suggested in the comment. Could you possibly try to upgrade it?

In addition, could you try to clone your site to a localhost tool such as LocalWP? Do you experience the same problem?

Look forward to hearing back from you.

Thread Starter aeminium01
(@aeminium01)

1 year, 1 month ago

Following @babylon1999 advice, I’ve updated MariaDB from 10.3.39 to 10.6.15

I’ve also upgraded PHP from 7.4. to 8.0

All plugins updated, Woocommerce also to 8.2.

The long query keeps very slow and the other one:

SELECT post_status, COUNT( * ) AS num_posts
FROM usr8_posts
WHERE post_type = ‘product’
GROUP BY post_status

from caller: wp_count_posts()

is bigger than before, 5 seconds more or less

Saif
(@babylon1999)

1 year, 1 month ago

Thanks for the feedback, @aeminium01!

I updated the report with your findings. At this time, we do not have an estimate for when the team will investigate this further as the issue is still not considered reproducible.

I suggest you subscribe to the thread from the sidebar to receive updates. :?)

Link to image: https://d.pr/i/JYeKlx

Let us know if you have any other questions.

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

The topic ‘After Woocommerce update both frontend and wp backend became extremely slow’ is closed to new replies.