Charge buffalo jili hack apk download.Claim Your Free 999 Pesos Bonus Today

Resolved

(@cutu234)

We’ve just switched to HPOS. The shop is not small, but not terribly large with around 200k orders in the database. We had really high hope, but the results are pretty disappointing. A nasty problem is now fixed. The address page in the customer account loaded extremely slow due to a specific database query.

However, the order overview page (dashboard) is still very slow. Usually, I show 200 orders on one page. This results in a loading time of 20 seconds or more. This is not better compared to the former database tables. Maybe, it is even slower. I had to decrease the number of orders per page to 20, which is not great to work with.

All plugins are updated to the latest version. The server runs PHP 8.3 at 768 MB RAM. This is not the fastest server money can buy, but should easily handle the load.

We haven’t yet removed the old database tables. Could this be the problem? Compatability mode is turned off.

Here is the status report:


### WordPress Environment ###

WordPress address (URL): https://www.agoshop.de
Site address (URL): https://www.agoshop.de
WC Version: 9.3.3
Legacy REST API Package Version: Auf dieser Website ist das alte REST-API-Plugin nicht installiert.
Action Scheduler Version: ? 3.8.1
Log Directory Writable: ?
WP Version: 6.6.2
WP Multisite: –
WP Memory Limit: 768 MB
WP Debug Mode: –
WP Cron: ?
Language: de_DE_formal
External object cache: –

### Server Environment ###

Server Info: Apache
PHP Version: 8.3.8-nmm1
PHP Post Max Size: 768 MB
PHP Time Limit: 300
PHP Max Input Vars: 10000
cURL Version: 7.68.0
OpenSSL/1.1.1f

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

### Database ###

WC Database Version: 9.3.3
WC Database Prefix: bi4a6hmggc_
Datenbank-Gesamtgr??e: 4900.74MB
Datenbank-Datengr??e: 2580.30MB
Datenbank-Indexgr??e: 2320.44MB
bi4a6hmggc_woocommerce_sessions: Daten: 1.02MB + Index: 0.02MB + Engine InnoDB
bi4a6hmggc_woocommerce_api_keys: Daten: 0.02MB + Index: 0.03MB + Engine InnoDB
bi4a6hmggc_woocommerce_attribute_taxonomies: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB
bi4a6hmggc_woocommerce_downloadable_product_permissions: Daten: 0.02MB + Index: 0.06MB + Engine InnoDB
bi4a6hmggc_woocommerce_order_items: Daten: 90.61MB + Index: 30.56MB + Engine InnoDB
bi4a6hmggc_woocommerce_order_itemmeta: Daten: 796.98MB + Index: 569.86MB + Engine InnoDB
bi4a6hmggc_woocommerce_tax_rates: Daten: 0.02MB + Index: 0.06MB + Engine InnoDB
bi4a6hmggc_woocommerce_tax_rate_locations: Daten: 0.02MB + Index: 0.03MB + Engine InnoDB
bi4a6hmggc_woocommerce_shipping_zones: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB
bi4a6hmggc_woocommerce_shipping_zone_locations: Daten: 0.02MB + Index: 0.05MB + Engine InnoDB
bi4a6hmggc_woocommerce_shipping_zone_methods: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB
bi4a6hmggc_woocommerce_payment_tokens: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB
bi4a6hmggc_woocommerce_payment_tokenmeta: Daten: 0.02MB + Index: 0.03MB + Engine InnoDB
bi4a6hmggc_woocommerce_log: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB
bi4a6hmggc_actionscheduler_actions: Daten: 3.36MB + Index: 10.30MB + Engine InnoDB
bi4a6hmggc_actionscheduler_claims: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB
bi4a6hmggc_actionscheduler_groups: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB
bi4a6hmggc_actionscheduler_logs: Daten: 6.28MB + Index: 5.13MB + Engine InnoDB
bi4a6hmggc_adtribes_my_conversions: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB
bi4a6hmggc_aepc_custom_audiences: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB
bi4a6hmggc_aepc_logs: Daten: 5.52MB + Index: 0.00MB + Engine InnoDB
bi4a6hmggc_aws_index: Daten: 1.52MB + Index: 1.13MB + Engine InnoDB
bi4a6hmggc_ayssurvey_answers: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB
bi4a6hmggc_ayssurvey_popup_surveys: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB
bi4a6hmggc_ayssurvey_questions: Daten: 0.06MB + Index: 0.00MB + Engine InnoDB
bi4a6hmggc_ayssurvey_question_categories: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB
bi4a6hmggc_ayssurvey_sections: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB
bi4a6hmggc_ayssurvey_settings: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB
bi4a6hmggc_ayssurvey_submissions: Daten: 2.52MB + Index: 0.00MB + Engine InnoDB
bi4a6hmggc_ayssurvey_submissions_questions: Daten: 2.52MB + Index: 0.00MB + Engine InnoDB
bi4a6hmggc_ayssurvey_surveys: Daten: 0.09MB + Index: 0.00MB + Engine InnoDB
bi4a6hmggc_ayssurvey_survey_categories: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB
bi4a6hmggc_borlabs_cookie_statistics: Daten: 4.03MB + Index: 4.99MB + Engine MyISAM
bi4a6hmggc_bounced_email_logs: Daten: 13.52MB + Index: 0.00MB + Engine InnoDB
bi4a6hmggc_cmplz_cookiebanners: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
bi4a6hmggc_cmplz_cookies: Daten: 0.02MB + Index: 0.00MB + Engine MyISAM
bi4a6hmggc_cmplz_dnsmpd: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB
bi4a6hmggc_cmplz_services: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
bi4a6hmggc_cmplz_statistics: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB
bi4a6hmggc_commentmeta: Daten: 11.52MB + Index: 10.03MB + Engine InnoDB
bi4a6hmggc_comments: Daten: 130.66MB + Index: 89.25MB + Engine InnoDB
bi4a6hmggc_cr_local_forms: Daten: 11.55MB + Index: 1.52MB + Engine InnoDB
bi4a6hmggc_cr_reminders_log: Daten: 1.52MB + Index: 1.59MB + Engine InnoDB
bi4a6hmggc_dgwt_wcas_index: Daten: 0.09MB + Index: 0.02MB + Engine InnoDB
bi4a6hmggc_dgwt_wcas_invindex_cache: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB
bi4a6hmggc_dgwt_wcas_invindex_doclist: Daten: 1.20MB + Index: 0.83MB + Engine InnoDB
bi4a6hmggc_dgwt_wcas_invindex_wordlist: Daten: 0.42MB + Index: 0.27MB + Engine InnoDB
bi4a6hmggc_dgwt_wcas_stats: Daten: 1.02MB + Index: 0.00MB + Engine InnoDB
bi4a6hmggc_dgwt_wcas_tax_index: Daten: 0.02MB + Index: 0.05MB + Engine InnoDB
bi4a6hmggc_dgwt_wcas_var_index: Daten: 0.06MB + Index: 0.06MB + Engine InnoDB
bi4a6hmggc_failed_jobs: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB
bi4a6hmggc_fql_logs: Daten: 0.02MB + Index: 0.08MB + Engine InnoDB
bi4a6hmggc_iconic_wssv_index: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
bi4a6hmggc_itsec_opaque_tokens: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB
bi4a6hmggc_links: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB
bi4a6hmggc_mapsvg6_database_475011: Daten: 0.05MB + Index: 0.02MB + Engine InnoDB
bi4a6hmggc_mapsvg6_database_570: Daten: 0.05MB + Index: 0.02MB + Engine InnoDB
bi4a6hmggc_mapsvg6_maps: Daten: 0.02MB + Index: 0.00MB + Engine MyISAM
bi4a6hmggc_mapsvg6_r2o: Daten: 0.01MB + Index: 0.01MB + Engine MyISAM
bi4a6hmggc_mapsvg6_regions_475011: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB
bi4a6hmggc_mapsvg6_regions_570: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB
bi4a6hmggc_mapsvg6_schema: Daten: 0.01MB + Index: 0.00MB + Engine MyISAM
bi4a6hmggc_mapsvg6_settings: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
bi4a6hmggc_mapsvg_database_475011: Daten: 0.05MB + Index: 0.02MB + Engine InnoDB
bi4a6hmggc_mapsvg_database_570: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB
bi4a6hmggc_mapsvg_r2d: Daten: 0.00MB + Index: 0.01MB + Engine MyISAM
bi4a6hmggc_mapsvg_regions_475011: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB
bi4a6hmggc_mapsvg_regions_570: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB
bi4a6hmggc_mapsvg_schema: Daten: 0.01MB + Index: 0.00MB + Engine MyISAM
bi4a6hmggc_mclean_refs: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
bi4a6hmggc_mclean_scan: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
bi4a6hmggc_mlw_qm_audit_trail: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB
bi4a6hmggc_mlw_questions: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB
bi4a6hmggc_mlw_question_terms: Daten: 0.02MB + Index: 0.06MB + Engine InnoDB
bi4a6hmggc_mlw_quizzes: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB
bi4a6hmggc_mlw_quiz_theme_settings: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB
bi4a6hmggc_mlw_results: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB
bi4a6hmggc_mlw_themes: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB
bi4a6hmggc_newsletter: Daten: 1.52MB + Index: 0.17MB + Engine InnoDB
bi4a6hmggc_newsletter_emails: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB
bi4a6hmggc_newsletter_logs: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB
bi4a6hmggc_newsletter_sent: Daten: 0.02MB + Index: 0.03MB + Engine InnoDB
bi4a6hmggc_newsletter_stats: Daten: 0.02MB + Index: 0.03MB + Engine InnoDB
bi4a6hmggc_newsletter_user_logs: Daten: 0.39MB + Index: 0.00MB + Engine InnoDB
bi4a6hmggc_newsletter_user_meta: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB
bi4a6hmggc_options: Daten: 13.23MB + Index: 2.39MB + Engine InnoDB
bi4a6hmggc_postmeta: Daten: 700.98MB + Index: 524.80MB + Engine InnoDB
bi4a6hmggc_posts: Daten: 115.59MB + Index: 76.83MB + Engine InnoDB
bi4a6hmggc_queue: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB
bi4a6hmggc_redirection_404: Daten: 4.41MB + Index: 0.63MB + Engine MyISAM
bi4a6hmggc_redirection_groups: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
bi4a6hmggc_redirection_items: Daten: 0.17MB + Index: 0.13MB + Engine MyISAM
bi4a6hmggc_redirection_logs: Daten: 0.48MB + Index: 0.08MB + Engine MyISAM
bi4a6hmggc_spbc_auth_logs: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB
bi4a6hmggc_spbc_backuped_files: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB
bi4a6hmggc_spbc_backups: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB
bi4a6hmggc_spbc_firewall_data: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB
bi4a6hmggc_spbc_firewall_logs: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB
bi4a6hmggc_spbc_scan_frontend: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB
bi4a6hmggc_spbc_scan_links_logs: Daten: 0.02MB + Index: 0.05MB + Engine InnoDB
bi4a6hmggc_spbc_scan_results: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB
bi4a6hmggc_spbc_scan_signatures: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB
bi4a6hmggc_spbc_traffic_control_logs: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB
bi4a6hmggc_storeabill_documentmeta: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
bi4a6hmggc_storeabill_documents: Daten: 0.00MB + Index: 0.01MB + Engine MyISAM
bi4a6hmggc_storeabill_document_attachmentmeta: Daten: 0.02MB + Index: 0.03MB + Engine InnoDB
bi4a6hmggc_storeabill_document_attachments: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB
bi4a6hmggc_storeabill_document_itemmeta: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
bi4a6hmggc_storeabill_document_items: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
bi4a6hmggc_storeabill_document_noticemeta: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
bi4a6hmggc_storeabill_document_notices: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
bi4a6hmggc_storeabill_journals: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
bi4a6hmggc_sumo_tbl_user_earned_coupon: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB
bi4a6hmggc_termmeta: Daten: 0.16MB + Index: 0.06MB + Engine InnoDB
bi4a6hmggc_terms: Daten: 0.02MB + Index: 0.03MB + Engine InnoDB
bi4a6hmggc_term_relationships: Daten: 0.36MB + Index: 0.20MB + Engine InnoDB
bi4a6hmggc_term_taxonomy: Daten: 0.14MB + Index: 0.05MB + Engine InnoDB
bi4a6hmggc_updraftcentral_sitemeta: Daten: 0.02MB + Index: 0.03MB + Engine InnoDB
bi4a6hmggc_updraftcentral_sites: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB
bi4a6hmggc_updraftcentral_site_temporary_keys: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB
bi4a6hmggc_updraftcentral_user_cron: Daten: 0.02MB + Index: 0.03MB + Engine InnoDB
bi4a6hmggc_usermeta: Daten: 40.56MB + Index: 30.11MB + Engine InnoDB
bi4a6hmggc_users: Daten: 3.52MB + Index: 1.22MB + Engine InnoDB
bi4a6hmggc_usin_events: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
bi4a6hmggc_usin_user_data: Daten: 0.31MB + Index: 0.26MB + Engine MyISAM
bi4a6hmggc_wccs_conditions: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB
bi4a6hmggc_wccs_condition_meta: Daten: 0.02MB + Index: 0.03MB + Engine InnoDB
bi4a6hmggc_wc_admin_notes: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB
bi4a6hmggc_wc_admin_note_actions: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB
bi4a6hmggc_wc_category_lookup: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB
bi4a6hmggc_wc_customer_lookup: Daten: 25.55MB + Index: 13.06MB + Engine InnoDB
bi4a6hmggc_wc_download_log: Daten: 0.02MB + Index: 0.03MB + Engine InnoDB
bi4a6hmggc_wc_gpf_render_cache: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB
bi4a6hmggc_wc_orders: Daten: 56.59MB + Index: 58.75MB + Engine InnoDB
bi4a6hmggc_wc_orders_meta: Daten: 300.88MB + Index: 715.97MB + Engine InnoDB
bi4a6hmggc_wc_order_addresses: Daten: 48.59MB + Index: 55.17MB + Engine InnoDB
bi4a6hmggc_wc_order_coupon_lookup: Daten: 2.52MB + Index: 3.03MB + Engine InnoDB
bi4a6hmggc_wc_order_operational_data: Daten: 36.58MB + Index: 19.06MB + Engine InnoDB
bi4a6hmggc_wc_order_product_lookup: Daten: 29.55MB + Index: 21.06MB + Engine InnoDB
bi4a6hmggc_wc_order_stats: Daten: 21.55MB + Index: 13.55MB + Engine InnoDB
bi4a6hmggc_wc_order_tax_lookup: Daten: 12.55MB + Index: 10.03MB + Engine InnoDB
bi4a6hmggc_wc_product_attributes_lookup: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
bi4a6hmggc_wc_product_download_directories: Daten: 0.00MB + Index: 0.01MB + Engine MyISAM
bi4a6hmggc_wc_product_meta_lookup: Daten: 0.02MB + Index: 0.11MB + Engine InnoDB
bi4a6hmggc_wc_rate_limits: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
bi4a6hmggc_wc_reserved_stock: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
bi4a6hmggc_wc_tax_rate_classes: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB
bi4a6hmggc_wc_webhooks: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB
bi4a6hmggc_wdp_orders: Daten: 0.09MB + Index: 0.04MB + Engine MyISAM
bi4a6hmggc_wdp_order_items: Daten: 0.06MB + Index: 0.06MB + Engine MyISAM
bi4a6hmggc_wdp_persistent_rules_cache: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
bi4a6hmggc_wdp_rules: Daten: 0.01MB + Index: 0.00MB + Engine MyISAM
bi4a6hmggc_wdr_order_discounts: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
bi4a6hmggc_wdr_order_item_discounts: Daten: 0.09MB + Index: 0.10MB + Engine MyISAM
bi4a6hmggc_wdr_rules: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
bi4a6hmggc_wfblockediplog: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB
bi4a6hmggc_wfblocks7: Daten: 0.02MB + Index: 0.05MB + Engine InnoDB
bi4a6hmggc_wfconfig: Daten: 0.09MB + Index: 0.00MB + Engine InnoDB
bi4a6hmggc_wfcrawlers: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB
bi4a6hmggc_wffilechanges: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB
bi4a6hmggc_wffilemods: Daten: 0.27MB + Index: 0.00MB + Engine InnoDB
bi4a6hmggc_wfhits: Daten: 0.02MB + Index: 0.05MB + Engine InnoDB
bi4a6hmggc_wfhoover: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB
bi4a6hmggc_wfissues: Daten: 0.02MB + Index: 0.06MB + Engine InnoDB
bi4a6hmggc_wfknownfilelist: Daten: 0.13MB + Index: 0.00MB + Engine InnoDB
bi4a6hmggc_wflivetraffichuman: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB
bi4a6hmggc_wflocs: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB
bi4a6hmggc_wflogins: Daten: 0.02MB + Index: 0.03MB + Engine InnoDB
bi4a6hmggc_wfls_2fa_secrets: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB
bi4a6hmggc_wfls_settings: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB
bi4a6hmggc_wfnotifications: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB
bi4a6hmggc_wfpendingissues: Daten: 0.02MB + Index: 0.06MB + Engine InnoDB
bi4a6hmggc_wfreversecache: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB
bi4a6hmggc_wfsnipcache: Daten: 0.02MB + Index: 0.05MB + Engine InnoDB
bi4a6hmggc_wfstatus: Daten: 5.52MB + Index: 3.03MB + Engine InnoDB
bi4a6hmggc_wftrafficrates: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB
bi4a6hmggc_woocommerce_amazon_buyer_index: Daten: 0.04MB + Index: 0.06MB + Engine MyISAM
bi4a6hmggc_woocommerce_gpf_google_taxonomy: Daten: 1.52MB + Index: 0.00MB + Engine InnoDB
bi4a6hmggc_woocommerce_gzd_dhl_im_products: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
bi4a6hmggc_woocommerce_gzd_dhl_im_product_services: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
bi4a6hmggc_woocommerce_gzd_dhl_labelmeta: Daten: 0.02MB + Index: 0.03MB + Engine InnoDB
bi4a6hmggc_woocommerce_gzd_dhl_labels: Daten: 0.02MB + Index: 0.03MB + Engine InnoDB
bi4a6hmggc_woocommerce_gzd_packaging: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
bi4a6hmggc_woocommerce_gzd_packagingmeta: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
bi4a6hmggc_woocommerce_gzd_shipmentmeta: Daten: 32.56MB + Index: 12.03MB + Engine InnoDB
bi4a6hmggc_woocommerce_gzd_shipments: Daten: 7.52MB + Index: 4.55MB + Engine InnoDB
bi4a6hmggc_woocommerce_gzd_shipment_itemmeta: Daten: 16.55MB + Index: 16.03MB + Engine InnoDB
bi4a6hmggc_woocommerce_gzd_shipment_items: Daten: 4.52MB + Index: 7.58MB + Engine InnoDB
bi4a6hmggc_woocommerce_gzd_shipment_labelmeta: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
bi4a6hmggc_woocommerce_gzd_shipment_labels: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
bi4a6hmggc_woocommerce_gzd_shipping_provider: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB
bi4a6hmggc_woocommerce_gzd_shipping_providermeta: Daten: 0.02MB + Index: 0.03MB + Engine InnoDB
bi4a6hmggc_wt_iew_action_history: Daten: 0.02MB + Index: 0.00MB + Engine MyISAM
bi4a6hmggc_wt_iew_mapping_template: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
bi4a6hmggc_yoast_indexable: Daten: 0.19MB + Index: 0.09MB + Engine InnoDB
bi4a6hmggc_yoast_indexable_hierarchy: Daten: 0.02MB + Index: 0.05MB + Engine InnoDB
bi4a6hmggc_yoast_migrations: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB
bi4a6hmggc_yoast_primary_term: Daten: 0.02MB + Index: 0.03MB + Engine InnoDB
bi4a6hmggc_yoast_prominent_words: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
bi4a6hmggc_yoast_seo_links: Daten: 0.19MB + Index: 0.14MB + Engine InnoDB
bi4a6hmggc_yoast_seo_meta: Daten: 3.52MB + Index: 0.00MB + Engine InnoDB
bi4a6hmggc_yoppoll_bans: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB
bi4a6hmggc_yoppoll_elements: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB
bi4a6hmggc_yoppoll_logs: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB
bi4a6hmggc_yoppoll_other_answers: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB
bi4a6hmggc_yoppoll_polls: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB
bi4a6hmggc_yoppoll_skins: Daten: 0.28MB + Index: 0.00MB + Engine InnoDB
bi4a6hmggc_yoppoll_subelements: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB
bi4a6hmggc_yoppoll_templates: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB
bi4a6hmggc_yoppoll_votes: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB
_blacklist: Daten: 2.52MB + Index: 2.52MB + Engine InnoDB

### Post Type Counts ###

acf-field: 11
acf-field-group: 3
adt_product_feed: 4
attachment: 2051
ays-survey-maker: 8
blocks: 12
boxzilla-box: 1
br_notice: 2
custom_css: 2
customerstory: 1
document_template: 11
eos_dyn_content: 1
gp_elements: 9
invoice: 2
jetpack_migration: 2
kundenstory: 79
mailpoet_page: 1
mapsvg: 2
mc4wp-form: 1
ml-slide: 23
ml-slider: 8
nab_experiment: 7
nav_menu_item: 74
oembed_cache: 25
page: 57
post: 3
product: 91
product_variation: 63
qsm_quiz: 1
revision: 38
schema: 4
shop_coupon: 331
shop_order: 211281
shop_order_placehold: 2
shop_order_refund: 3635
wafs: 1
was: 15
wll_records: 1708
wp-rest-api-log: 2315
wpcf7_contact_form: 3
wpsl_stores: 76
ywrfd-discount: 1

### Security ###

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

### Active Plugins (35) ###

Query Monitor: von John Blackbourn – 3.16.4
Advanced Custom Fields PRO: von WP Engine – 6.3.6
FiboSearch - AJAX Search for WooCommerce (Pro): von FiboSearch Team – 1.28.1
Complianz Privacy Suite (GDPR/CCPA) premium: von Really Simple Plugins – 7.1.4
Confetti: von WP Sunshine – 1.3.7
Contact Form 7: von Takayuki Miyoshi – 5.9.8
Customer Reviews for WooCommerce: von CusRev – 5.60.2
GTM4WP - A Google Tag Manager (GTM) plugin for WordPress: von Thomas Geiger – 1.20.2
GP Premium: von Tom Usborne – 2.5.0
Rechtstexte-Schnittstelle der IT-Recht Kanzlei: von IT-Recht Kanzlei – 1.0.8
Min and Max Quantity for WooCommerce: von BeRocket – 1.3.6
Newsletter: von Stefano Lissa & Das Newsletter Team  – 8.5.2
Permalink Manager for WooCommerce: von BeRocket – 1.0.8.2
Payment Plugins for PayPal WooCommerce: von Payment Plugins
[email protected] – 1.0.52

Redirection: von John Godley – 5.5.0
WooCommerce Show Single Variations by Iconic: von Iconic – 1.22.0
Side Cart WooCommerce: von XootiX – 2.5.4
Survey Maker: von Survey Maker team – 5.0.0
Advanced Editor Tools: von Automattic – 5.9.2
vendidero Helper: von vendidero – 2.2.5
Discount Rules PRO 2.0: von Flycart – 2.6.5
Discount Rules Core: von Flycart – 2.6.6
Product Feed PRO for WooCommerce: von AdTribes.io – 13.3.7
Payment Plugins for Stripe WooCommerce: von Payment Plugins
[email protected] – 3.3.75

WooCommerce Advanced Shipping: von Jeroen Sormani – 1.1.3
WooCommerce Color or Image Variation Swatches: von sysbasics – 4.0.0
WooCommerce Amazon Pay: von Amazon Pay – 2.5.3
Germanized für WooCommerce Pro: von vendidero – 4.1.1
Germanized für WooCommerce: von vendidero – 3.18.2
WooCommerce Price Based on Country: von Oscar Gare – 3.4.9
WooCommerce Sponsor a Friend Plugin: von MB Création – 2.3.2
WooCommerce: von Automattic – 9.3.3
Yoast SEO: von Team Yoast – 23.5
WP Fastest Cache: von Emre Vona – 1.3.1
WP Store Locator: von Tijmen Smit – 2.2.241

### Inactive Plugins (1) ###

Nelio A/B Testing: von Nelio Software – 7.1.1

### Dropin Plugins () ###

db.php: Query Monitor Database Class (Drop-in)

### Settings ###

Legacy API Enabled: –
Force SSL: ?
Currency: EUR (€)
Currency Position: right_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-filtered (exclude-from-filtered)
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 enabled: ?
Order datastore: Automattic\WooCommerce\Internal\DataStores\Orders\OrdersTableDataStore
HPOS data sync enabled: –

### Logging ###

Enabled: ?
Handler: Automattic\WooCommerce\Internal\Admin\Logging\LogHandlerFileV2
Retention period: 30 Tage
Level threshold: –
Log directory size: 88 MB

### WC Pages ###

Shop-Basis: #503048 - /alle-ago-produkte/
Warenkorb: #72 - /warenkorb/ -  Contains the [woocommerce_cart] shortcode
Kasse: #12 - /kasse/ -  Contains the [woocommerce_checkout] shortcode
Ihr Konto: #70 - /mein-konto/
Allgemeine Gesch?ftsbedingungen: #688 - /allgemeine_geschaeftsbedingungen/

### Theme ###

Name: GeneratePress Child Theme
Version: 1.0
Author URL: https://my-blog-shop.de
Child Theme: ?
Parent Theme Name: GeneratePress
Parent Theme Version: 3.5.1
Parent Theme Author URL: https://tomusborne.com
WooCommerce Support: ?

### Templates ###

Overrides: generatepress_child/woocommerce/cart/cart.php
generatepress_child/woocommerce/emails/customer-note.php
generatepress_child/woocommerce/emails/customer-processing-order.php
generatepress_child/woocommerce/single-product/add-to-cart/variation.php

### Geolocation debug info ###

Default customer location: geolocation
MaxMind GeoIP database: ?
MaxMind GeoIP license: ?
MM_COUNTRY_CODE: ?
GEOIP_COUNTRY_CODE: ?
HTTP_CF_IPCOUNTRY: ?
HTTP_X_COUNTRY_CODE: ?
HTTP_X_REAL_IP: ?
HTTP_X_FORWARDED_FOR: ?
REMOTE_ADDR: 46.223.162.17
Real external IP: 2a02:8071:67e1:9220:9460:1b62:5013:bc0d
WCPBC_USE_REMOTE_ADDR: –
Geolocation Test: ?

### PBC Settings ###

Version: 3.4.9
Base location: DE:DE-NW
Base currency: EUR
Price Based On: shipping
Shipping: –
Test mode: –
Test country: –
Load products price in background: –
Prices entered with tax: ?
Calculate tax based on: shipping
Display prices in the shop: incl

### Zone Pricing Drittl?nder ###

zone_id: drittlaender
enabled: yes
name: Drittl?nder
countries: CH
currency: EUR
exchange_rate: 0.840336134454
auto_exchange_rate: no
disable_tax_adjustment: no
order: 9999

### Admin ###

Enabled Features: activity-panels
analytics
product-block-editor
coupons
core-profiler
customize-store
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
pattern-toolkit-full-composability
product-custom-fields
remote-inbox-notifications
remote-free-extensions
payment-gateway-suggestions
printful
shipping-label-banner
subscriptions
store-alerts
transient-notices
woo-mobile-welcome
wc-pay-promotion
wc-pay-welcome-page
launch-your-store

Disabled Features: experimental-blocks
minified-js
product-pre-publish-modal
settings
async-product-editor-category-field
product-editor-template-system
blueprint
reactify-classic-payments-settings

Daily Cron: ? Next scheduled: 2024-10-02 10:42:20 +02:00
Options: ?
Notes: 6
Onboarding: completed

### Action Scheduler ###

Abgeschlossen: 9.154
Oldest: 2024-08-31 12:52:50 +0200
Newest: 2024-10-01 12:49:39 +0200

Fehlgeschlagen: 853
Oldest: 2022-04-02 14:42:30 +0200
Newest: 2024-09-30 10:54:42 +0200

Ausstehend: 5
Oldest: 2024-10-01 14:38:55 +0200
Newest: 2024-10-02 07:26:45 +0200

### Status report information ###

Generated at: 2024-10-01 12:52:28 +02:00

This topic was modified 1 month, 3 weeks ago by cutu234.

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

Plugin Support Rajesh K. (woo-hc)
(@rajeshml)

1 month, 3 weeks ago

Hello @cutu234,

Thank you for reaching out — we’re happy to help!

It seems we need to take a closer look at this. Could you please open a ticket about this from?Woo.com > My profile > Support? You may need to create or log in to a WooCommerce account before you can access that page. Please include a link to this forum thread as well.

Have a wonderful day!

Thread Starter cutu234
(@cutu234)

1 month, 3 weeks ago

Done! I’m not a big fan of these AI-based support systems. Let’s see how it works.

Thank you!

Plugin Support ckadenge (woo-hc)
(@ckadenge)

1 month, 3 weeks ago

Hi @cutu234,

Done! I’m not a big fan of these AI-based support systems. Let’s see how it works.

I’m not sure if I understand you correctly here, however, I’d like to clarify that our friendly AI is the first point of contact, which in some cases help in providing general troubleshooting steps.

However, should you have contacted us internally and came across our friendly AI, I suggest trying the suggested steps by the AI and if that does not help, reply to the email and our Happiness Engineers would be more than happy to take over the conversation and assist you further.

I hope this clarifies any confusion.

mattbpro
(@mattbpro)

1 month, 3 weeks ago

Hey @cutu234! I just noticed this while researching turning on HPOS myself.

Having experienced the same frustration with slow order lookups and query times, we resolved it without activating HPOS. In our case an old developer had manually deleted 100k orders out of the _posts table in an attempt to “resolve” the slow lookup speed, but the business owner wasn’t very pleased with that “solution” and wanted the orders restored (and the lookup queries still to be fast of course).

Moving past the obvious, “limit number of plugins being loaded”, make sure you have dedicated hosting with decent hardware (generally 8vCPU/16GB RAM would be the starting point for an “established” eCom production site). Then make sure you’re actually utilizing that hardware by turning up MySQL’s innodb_buffer_pool size along with PHP memory limit and PHP Service Worker values.

With these server config tweaks we were able to get all of the 100k orders restored and the 25sec+ load times in the /wp-admin down to 4-6sec.

A few side notes, we generally have better performance results with Nginx over Apache. Also it’s probably a little early for PHP 8.3. PHP 8.1 still seems to be the most “stable” for most plugin environments at this point.

Good luck!

Thread Starter cutu234
(@cutu234)

1 month, 3 weeks ago

Hi @mattbpro,

thank you very much for your input. I appreciate that. Deleting orders from the database was, for good reasons, not an option. I tested more powerful hosting in the past, but couldn’t find a significant improvement for the frontend. Unfortunately, I did not perform backend performance tests. On the other hand, the database was much smaller then. Now, with +200k orders the postmeta table has increased to almost 9 million rows.

While this is substantial, why should a query for the last 200 orders take such an enormous amount of time? There is absolutely no need to query 9 million entries for getting the information. I hoped that HPOS would do a better job.

Using the best server hardware is, of course, a good idea. I will give it a try. However, it is like driving a car with the handbrake on. You can step on the gas to compensate for that. But that’s not the best solution, I guess. ??

Anyway, I’m happy that loading time for the customer account addresses page is now pretty good. I can live with a slow backend.

Plugin Support Zubair Zahid (woo-hc)
(@doublezed2)

1 month, 3 weeks ago

Hello mattbpro,

Thank you for your message here.

If need further help, I suggest you create a new topic as per forum guidelines.
I will be happy to look into your issue and find a solution.

Best regards.

Plugin Support Zubair Zahid (woo-hc)
(@doublezed2)

1 month, 3 weeks ago

Hello cutu234,

Thank you for your reply.

I want to confirm if you have resolved the issue or need help resolving the issue.
Please let me know.

Best regards.
Thread Starter cutu234
(@cutu234)

1 month, 3 weeks ago
Hi,

I want to confirm if you have resolved the issue or need help resolving the issue.

No, it’s not resolved. I escalated the issue to the support on Woo.com.

Will keep you posted here. You should not mark this thread as resolved. Many others have very likely the same problems.

Thanks, Mike
- This reply was modified 1 month, 3 weeks ago by cutu234.
Plugin Support ckadenge (woo-hc)
(@ckadenge)

1 month, 2 weeks ago

Hi Mike @cutu234,

I’m sorry to hear that your issue hasn’t been resolved yet. Did you already get a response from our support at Woo.com? The reason I’m asking this is to understand if you are able to share the ticket number so we can try to follow on it internally for further investigation on this issue.

We appreciate your patience and understand, and we won’t mark this thread as resolved until we’re certain that the problem has been fixed.

Please keep us updated.

Thread Starter cutu234
(@cutu234)

1 month, 2 weeks ago

Hi,

to be honest, the support was not very helpful so far. I got the usual text blocks like “update everything, check your hosting etc.” Of course, all that had already been checked. We don’t have a general performance problem. It is only the page overview page that loads very slowly.

Anyway, I will perform further tests and keep you posted.

The ticket number is 8814034.

Thank you!
Plugin Support Beauty of Code (woo-hc)
(@beautyofcode)

1 month, 2 weeks ago
Hey @cutu234 ,

I’m sorry to hear that! I’ve taken a look at the ticket and see one of our Happiness Engineers provided some steps. Please go ahead and give these a go, as further support will be provided internally. ??
```
Datenbank-Gesamtgr??e: 4900.74MB
```
Just to add to this – I’m not sure if you’ve tried this already, but you have quite a large database. Can you also try optimizing your database and see if this makes any difference? You can try using the free?WP-Optimize?plugin for this.

Cheers,
Thread Starter cutu234
(@cutu234)

1 month, 2 weeks ago
I’m not sure if you’ve tried this already, but you have quite a large database

Seriously? The reason for the large database is Woocommerce and Woocommerce only. The postmeta table contains around 8 million rows. 99% of them are postmeta data for Woocommerce orders. In addition to that, you can easily see that the HPOS compatibility mode duplicated the old tables. I haven’t removed them yet:

I appreciate your help, but this is clearly a Woocommerce issue. Around 90% of all database entries are Woocommerce-related. How would I optimize that?

Please note, that I mentioned the duplicated tables in my very first post:

We haven’t yet removed the old database tables. Could this be the problem? Compatability mode is turned off.

The problem is: I can’t just remove those tables in a live shop for test purposes and restore a backup a couple of days later. We would loose too many orders.

I will have to create a fresh clone on the staging server and see how it goes.
- This reply was modified 1 month, 2 weeks ago by cutu234.
Plugin Support Beauty of Code (woo-hc)
(@beautyofcode)

1 month, 2 weeks ago

Hey @cutu234 ,

Thanks for the update! Since you’ve already reached out internally, our Happiness Engineers will be able to dig into this a bit more from there. ??

Cheers,

Thread Starter cutu234
(@cutu234)

1 month, 2 weeks ago

I have to apologize. I was wrong. I’ve just cloned the live shop and found that the order overview page loads pretty fast. Now, that’s strange, since both sites are identical. I found out that a customer reviews plugin seems to be causing the long loading time. The same queries are run. However, the single query takes around 0.03 seconds on the staging server, but 0,3 seconds on the live server. Well, 0,3 seconds times 200 orders equals 30 seconds. I have no ideas why there is such a difference. It’s very likely not Woocommerce, since both databases are absolutely identical.

I keep you posted. Again, I apologize for my mistake.

Plugin Support Rajesh K. (woo-hc)
(@rajeshml)

1 month, 2 weeks ago

Hello @cutu234,

Thank you for the update and thorough investigation into the performance issue you’re experiencing. There’s no need for an apology; troubleshooting these matters often requires exploring various possibilities and sometimes the process can lead to unexpected discoveries.

Please do keep us posted on your findings and let us know if you identify the cause or if you have any other WooCommerce-related queries.

Thanks!

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

You must be logged in to reply to this topic.