Slow queries in the core

  • Resolved Selin Polat

    (@cepkolik)


    1 year, 2 months ago

    I am experiencing slow query. When I say edit the product, it makes me wait for 30-40 seconds. – https://prnt.sc/bcUF_kbQC3XN

    here the System Status Report. – https://prnt.sc/M2ycfN648GLq

    `
### WordPress Environment ###

WordPress address (URL): https://www.cepkolik.com
Site address (URL): https://www.cepkolik.com
WC Version: 8.4.0
REST API Version: ? 8.4.0
WC Blocks Version: ? 11.6.2
Action Scheduler Version: ? 3.7.0
Log Directory Writable: ?
WP Version: 6.4.2
WP Multisite: –
WP Memory Limit: 4 GB
WP Debug Mode: –
WP Cron: ?
Language: tr_TR
External object cache: –

### Server Environment ###

Server Info: LiteSpeed
PHP Version: 8.0.30
PHP Post Max Size: 2 GB
PHP Time Limit: 5000
PHP Max Input Vars: 5000
cURL Version: 7.68.0
OpenSSL/1.1.1f

SUHOSIN Installed: –
MySQL Version: 10.4.32-MariaDB-1:10.4.32+maria~ubu2004
Max Upload Size: 2 GB
Default Timezone is UTC: ?
fsockopen/cURL: ?
SoapClient: ?
DOMDocument: ?
GZip: ?
Multibyte String: ?
Remote Post: ?
Remote Get: ?

### Database ###

WC Database Version: 8.4.0
WC Database Prefix: wp_
Toplam veritaban? boyutu: 2487.12MB
Veritaban? veri boyutu: 1617.63MB
Veritaban? indis boyutu: 869.49MB
wp_woocommerce_sessions: Veriler: 0.08 MB + Dizin: 0.02 MB + Motor InnoDB
wp_woocommerce_api_keys: Veriler: 0.02 MB + Dizin: 0.03 MB + Motor InnoDB
wp_woocommerce_attribute_taxonomies: Veriler: 0.02 MB + Dizin: 0.02 MB + Motor InnoDB
wp_woocommerce_downloadable_product_permissions: Veriler: 0.02 MB + Dizin: 0.06 MB + Motor InnoDB
wp_woocommerce_order_items: Veriler: 0.02 MB + Dizin: 0.02 MB + Motor InnoDB
wp_woocommerce_order_itemmeta: Veriler: 0.02 MB + Dizin: 0.03 MB + Motor InnoDB
wp_woocommerce_tax_rates: Veriler: 0.02 MB + Dizin: 0.06 MB + Motor InnoDB
wp_woocommerce_tax_rate_locations: Veriler: 0.02 MB + Dizin: 0.03 MB + Motor InnoDB
wp_woocommerce_shipping_zones: Veriler: 0.02 MB + Dizin: 0.00 MB + Motor InnoDB
wp_woocommerce_shipping_zone_locations: Veriler: 0.02 MB + Dizin: 0.03 MB + Motor InnoDB
wp_woocommerce_shipping_zone_methods: Veriler: 0.02 MB + Dizin: 0.00 MB + Motor InnoDB
wp_woocommerce_payment_tokens: Veriler: 0.02 MB + Dizin: 0.02 MB + Motor InnoDB
wp_woocommerce_payment_tokenmeta: Veriler: 0.02 MB + Dizin: 0.03 MB + Motor InnoDB
wp_woocommerce_log: Veriler: 0.02 MB + Dizin: 0.02 MB + Motor InnoDB
exportview: Veriler: 0.00 MB + Dizin: 0.00 MB + Motor
json_table: Veriler: 65.55 MB + Dizin: 0.30 MB + Motor InnoDB
searchtitles: Veriler: 0.00 MB + Dizin: 0.00 MB + Motor
selectedCategories: Veriler: 0.00 MB + Dizin: 0.00 MB + Motor
wp_actionscheduler_actions: Veriler: 0.08 MB + Dizin: 0.11 MB + Motor InnoDB
wp_actionscheduler_claims: Veriler: 0.02 MB + Dizin: 0.02 MB + Motor InnoDB
wp_actionscheduler_groups: Veriler: 0.02 MB + Dizin: 0.02 MB + Motor InnoDB
wp_actionscheduler_logs: Veriler: 0.06 MB + Dizin: 0.03 MB + Motor InnoDB
wp_affegg_autoblog: Veriler: 0.02 MB + Dizin: 0.02 MB + Motor InnoDB
wp_affegg_autoblog_item: Veriler: 0.02 MB + Dizin: 0.02 MB + Motor InnoDB
wp_affegg_catalog: Veriler: 0.02 MB + Dizin: 0.08 MB + Motor InnoDB
wp_affegg_egg: Veriler: 0.02 MB + Dizin: 0.03 MB + Motor InnoDB
wp_affegg_price_alert: Veriler: 0.02 MB + Dizin: 0.03 MB + Motor InnoDB
wp_affegg_price_history: Veriler: 0.02 MB + Dizin: 0.03 MB + Motor InnoDB
wp_affegg_product: Veriler: 0.02 MB + Dizin: 0.19 MB + Motor InnoDB
wp_cegg_autoblog: Veriler: 0.02 MB + Dizin: 0.02 MB + Motor InnoDB
wp_cegg_feed1_product: Veriler: 0.02 MB + Dizin: 0.11 MB + Motor InnoDB
wp_cegg_price_alert: Veriler: 0.02 MB + Dizin: 0.03 MB + Motor InnoDB
wp_cegg_price_history: Veriler: 33.55 MB + Dizin: 39.66 MB + Motor InnoDB
wp_cegg_product: Veriler: 5.52 MB + Dizin: 1.84 MB + Motor InnoDB
wp_cky_banners: Veriler: 0.05 MB + Dizin: 0.00 MB + Motor InnoDB
wp_cky_cookies: Veriler: 0.02 MB + Dizin: 0.00 MB + Motor InnoDB
wp_cky_cookie_categories: Veriler: 0.02 MB + Dizin: 0.02 MB + Motor InnoDB
wp_commentmeta: Veriler: 0.06 MB + Dizin: 0.03 MB + Motor InnoDB
wp_comments: Veriler: 1.52 MB + Dizin: 0.73 MB + Motor InnoDB
wp_e_events: Veriler: 0.02 MB + Dizin: 0.02 MB + Motor InnoDB
wp_fast_phone: Veriler: 38.52 MB + Dizin: 0.05 MB + Motor InnoDB
wp_karsilastirma: Veriler: 1.52 MB + Dizin: 0.42 MB + Motor InnoDB
wp_links: Veriler: 0.02 MB + Dizin: 0.02 MB + Motor InnoDB
wp_litespeed_avatar: Veriler: 5.52 MB + Dizin: 3.53 MB + Motor InnoDB
wp_litespeed_crawler: Veriler: 0.02 MB + Dizin: 0.03 MB + Motor InnoDB
wp_litespeed_crawler_blacklist: Veriler: 0.02 MB + Dizin: 0.03 MB + Motor InnoDB
wp_litespeed_url: Veriler: 14.52 MB + Dizin: 22.19 MB + Motor InnoDB
wp_litespeed_url_file: Veriler: 0.45 MB + Dizin: 1.34 MB + Motor InnoDB
wp_options: Veriler: 9.25 MB + Dizin: 1.13 MB + Motor InnoDB
wp_postmeta: Veriler: 1061.84 MB + Dizin: 633.94 MB + Motor InnoDB
wp_posts: Veriler: 214.69 MB + Dizin: 31.14 MB + Motor InnoDB
wp_termmeta: Veriler: 1.52 MB + Dizin: 0.33 MB + Motor InnoDB
wp_terms: Veriler: 2.52 MB + Dizin: 2.84 MB + Motor InnoDB
wp_term_relationships: Veriler: 23.56 MB + Dizin: 21.56 MB + Motor InnoDB
wp_term_taxonomy: Veriler: 3.45 MB + Dizin: 2.72 MB + Motor InnoDB
wp_usermeta: Veriler: 1.13 MB + Dizin: 2.06 MB + Motor InnoDB
wp_users: Veriler: 0.02 MB + Dizin: 0.05 MB + Motor InnoDB
wp_wc_admin_notes: Veriler: 0.06 MB + Dizin: 0.00 MB + Motor InnoDB
wp_wc_admin_note_actions: Veriler: 0.05 MB + Dizin: 0.02 MB + Motor InnoDB
wp_wc_category_lookup: Veriler: 0.02 MB + Dizin: 0.00 MB + Motor InnoDB
wp_wc_customer_lookup: Veriler: 0.02 MB + Dizin: 0.03 MB + Motor InnoDB
wp_wc_download_log: Veriler: 0.02 MB + Dizin: 0.03 MB + Motor InnoDB
wp_wc_orders: Veriler: 0.02 MB + Dizin: 0.11 MB + Motor InnoDB
wp_wc_orders_meta: Veriler: 0.02 MB + Dizin: 0.03 MB + Motor InnoDB
wp_wc_order_addresses: Veriler: 0.02 MB + Dizin: 0.06 MB + Motor InnoDB
wp_wc_order_coupon_lookup: Veriler: 0.02 MB + Dizin: 0.03 MB + Motor InnoDB
wp_wc_order_operational_data: Veriler: 0.02 MB + Dizin: 0.03 MB + Motor InnoDB
wp_wc_order_product_lookup: Veriler: 0.02 MB + Dizin: 0.06 MB + Motor InnoDB
wp_wc_order_stats: Veriler: 0.02 MB + Dizin: 0.05 MB + Motor InnoDB
wp_wc_order_tax_lookup: Veriler: 0.02 MB + Dizin: 0.03 MB + Motor InnoDB
wp_wc_product_attributes_lookup: Veriler: 2.39 MB + Dizin: 1.48 MB + Motor InnoDB
wp_wc_product_download_directories: Veriler: 0.02 MB + Dizin: 0.02 MB + Motor InnoDB
wp_wc_product_meta_lookup: Veriler: 0.02 MB + Dizin: 0.09 MB + Motor InnoDB
wp_wc_rate_limits: Veriler: 0.02 MB + Dizin: 0.02 MB + Motor InnoDB
wp_wc_reserved_stock: Veriler: 0.02 MB + Dizin: 0.00 MB + Motor InnoDB
wp_wc_tax_rate_classes: Veriler: 0.02 MB + Dizin: 0.02 MB + Motor InnoDB
wp_wc_webhooks: Veriler: 0.02 MB + Dizin: 0.02 MB + Motor InnoDB
wp_wpdatacharts: Veriler: 0.02 MB + Dizin: 0.00 MB + Motor InnoDB
wp_wpdatatables: Veriler: 0.02 MB + Dizin: 0.00 MB + Motor InnoDB
wp_wpdatatables_cache: Veriler: 0.02 MB + Dizin: 0.00 MB + Motor InnoDB
wp_wpdatatables_columns: Veriler: 0.09 MB + Dizin: 0.00 MB + Motor InnoDB
wp_wpdatatables_rows: Veriler: 0.02 MB + Dizin: 0.00 MB + Motor InnoDB
wp_wpdatatable_11: Veriler: 0.06 MB + Dizin: 0.00 MB + Motor InnoDB
wp_wpdatatable_13: Veriler: 0.06 MB + Dizin: 0.00 MB + Motor InnoDB
wp_wpdatatable_16: Veriler: 0.08 MB + Dizin: 0.00 MB + Motor InnoDB
wp_wpdatatable_20: Veriler: 0.05 MB + Dizin: 0.00 MB + Motor InnoDB
wp_wpdatatable_21: Veriler: 0.02 MB + Dizin: 0.00 MB + Motor InnoDB
wp_wpdatatable_22: Veriler: 0.02 MB + Dizin: 0.00 MB + Motor InnoDB
wp_wpdatatable_23: Veriler: 0.02 MB + Dizin: 0.00 MB + Motor InnoDB
wp_wpdatatable_23_1: Veriler: 0.02 MB + Dizin: 0.00 MB + Motor InnoDB
wp_wpdatatable_24: Veriler: 0.09 MB + Dizin: 0.00 MB + Motor InnoDB
wp_wpdatatable_24_1: Veriler: 0.08 MB + Dizin: 0.00 MB + Motor InnoDB
wp_wpdatatable_25: Veriler: 0.02 MB + Dizin: 0.00 MB + Motor InnoDB
wp_wpdatatable_26: Veriler: 0.06 MB + Dizin: 0.00 MB + Motor InnoDB
wp_wpdatatable_27: Veriler: 0.02 MB + Dizin: 0.00 MB + Motor InnoDB
wp_wpdatatable_27_1: Veriler: 0.02 MB + Dizin: 0.00 MB + Motor InnoDB
wp_wpdatatable_28: Veriler: 0.02 MB + Dizin: 0.00 MB + Motor InnoDB
wp_wpdatatable_29: Veriler: 0.16 MB + Dizin: 0.00 MB + Motor InnoDB
wp_wpdatatable_4: Veriler: 0.09 MB + Dizin: 0.00 MB + Motor InnoDB
wp_wpdatatable_8: Veriler: 0.06 MB + Dizin: 0.00 MB + Motor InnoDB
wp_wpdatatable_9: Veriler: 0.02 MB + Dizin: 0.00 MB + Motor InnoDB
wp_yoast_indexable: Veriler: 70.41 MB + Dizin: 16.08 MB + Motor InnoDB
wp_yoast_indexable_hierarchy: Veriler: 2.50 MB + Dizin: 3.73 MB + Motor InnoDB
wp_yoast_migrations: Veriler: 0.02 MB + Dizin: 0.02 MB + Motor InnoDB
wp_yoast_primary_term: Veriler: 2.52 MB + Dizin: 3.03 MB + Motor InnoDB
wp_yoast_prominent_words: Veriler: 26.56 MB + Dizin: 60.64 MB + Motor InnoDB
wp_yoast_seo_links: Veriler: 17.52 MB + Dizin: 16.77 MB + Motor InnoDB
wp_yoast_seo_meta: Veriler: 8.52 MB + Dizin: 0.00 MB + Motor InnoDB

### Post Type Counts ###

acf: 6
acf-field: 348
acf-field-group: 4
acf-post-type: 4
acf-taxonomy: 3
akilli-saatler: 138
amp_validated_url: 11
attachment: 112150
attribute_group: 14
cep-telefonlari: 3724
cookielawinfo: 6
custom-css-js: 3
elementor_library: 2
galeri: 1
glossary: 230
karsilastirmalar: 6131
nav_menu_item: 146
oembed_cache: 3467
page: 34
post: 33071
product: 3727
revision: 15
tabletler: 334
tdb_templates: 34
tdc-review: 5
tdc-review-email: 5
vc_grid_item: 2
wp_block: 8
wp_global_styles: 4
wp_navigation: 2
wp_template: 2

### Security ###

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

### Active Plugins (25) ###

Query Monitor: (John Blackbourn) – 3.15.0
Affiliate Egg Pro: (keywordrush.com) – 10.9.2
AMP: (AMP projesine katk?da bulunanlar) – 2.5.1
Content Egg Pro: (keywordrush.com) – 12.5.0
CookieYes | GDPR Cookie Consent: (CookieYes) – 3.1.7
Disable AMP to AMP Linking.: (AMP Support) – 1.0
Elementor: (Elementor.com) – 3.18.3
Envato Market: (Envato) – 2.0.11
LiteSpeed Cache: (LiteSpeed Technologies) – 6.0.0.1
Loco Translate: (Tim Whitlock) – 2.6.6
Permalink Manager for WooCommerce: (BeRocket) – 1.0.8.1
Product Filter for WooCommerce: (XforWooCommerce) – 8.3.0
REHub Framework: (Wpsoul) – 19.5
RH WooCommerce Tools: (Wpsoul) – 1.5
Parola Olmadan Ge?ici Giri?: (StoreApps) – 1.8.3
UpdraftPlus - Backup/Restore: (UpdraftPlus.Com
DavidAnderson) – 1.23.16

Converter for Media: (matt plugins) – 5.11.5
WooCommerce Upsells Shortcode: (SkyVerge) – 1.0.0
WooCommerce: (Automattic) – 8.4.0
Yoast SEO Premium: (Yoast ekibi) – 21.7
Yoast SEO: (Yoast ekibi) – 21.7
WP Glossary - Encyclopedia / Lexicon / Knowledge Base / Wiki / Dictionary: (The WP Instinct Team) – 2.6
wpDataTables: (TMS-Plugins) – 5.8.1
WPS Hide Login: (WPServeur
NicolasKulka
wpformation) – 1.9.10

Yoast SEO: Haberler: (Yoast Ekibi) – 13.1

### Inactive Plugins (4) ###

Advanced Custom Fields PRO: (WP Engine) – 6.2.4
GutenCon: (Wpsoul) – 5.6
kk Star Ratings: (Kamal Khan) – 5.4.6
plugin load filter: (enomoto@celtislab) – 4.1.0

### Dropin Plugins (2) ###

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

### Settings ###

API Enabled: –
Force SSL: –
Currency: TRY (?)
Currency Position: left
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 Woo.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 ###

Ma?aza giri? sayfas?: ? Sayfa g?rünürlü?ü herkese a??k olmal?d?r
Sepet sayfas?: ? Sayfa g?rünürlü?ü herkese a??k olmal?d?r
?deme sayfas?: ? Sayfa g?rünürlü?ü herkese a??k olmal?d?r
Hesab?m sayfas?: #639140 - /hesabim/
?artlar ve ko?ullar: #3581 - /kullanim-kosullari/

### Theme ###

Name: Rehub theme
Version: 19.5.6
Author URL: https://wpsoul.com/
Child Theme: ? – WooCommerce'i kendinizin olu?turmad??? ana bir temada düzenliyorsan?z
yard?mc? bir tema kullanman?z? ?neririz. Bkz.: Nas?l yard?mc? tema olu?turulur?

WooCommerce Support: ?

### Templates ###

Overrides: rehub-theme/woocommerce/archive-product.php
rehub-theme/woocommerce/cart/cross-sells.php
rehub-theme/woocommerce/content-product.php
rehub-theme/woocommerce/global/wrapper-end.php
rehub-theme/woocommerce/global/wrapper-start.php
rehub-theme/woocommerce/loop/add-to-cart.php
rehub-theme/woocommerce/loop/loop-end.php
rehub-theme/woocommerce/loop/loop-start.php
rehub-theme/woocommerce/loop/rating.php
rehub-theme/woocommerce/loop/sale-flash.php
rehub-theme/woocommerce/myaccount/my-account.php
/home/cepkolik2020/public_html/wp-content/plugins/woocommerce/packages/woocommerce-blocks/templates/notices/error.php
/home/cepkolik2020/public_html/wp-content/plugins/woocommerce/packages/woocommerce-blocks/templates/notices/notice.php
/home/cepkolik2020/public_html/wp-content/plugins/woocommerce/packages/woocommerce-blocks/templates/notices/success.php
rehub-theme/woocommerce/product-searchform.php
rehub-theme/woocommerce/single-product/add-to-cart/external.php
rehub-theme/woocommerce/single-product/meta.php
rehub-theme/woocommerce/single-product/product-image.php
rehub-theme/woocommerce/single-product/sale-flash.php
rehub-theme/woocommerce/single-product/share.php
rehub-theme/woocommerce/single-product/tabs/additional-information.php
rehub-theme/woocommerce/single-product/tabs/description.php
rehub-theme/woocommerce/single-product-reviews.php
rehub-theme/woocommerce/single-product.php
rehub-theme/woocommerce/content-product_cat.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
product-virtual-downloadable
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-external-affiliate
settings
async-product-editor-category-field

Daily Cron: ? Next scheduled: 2024-01-09 12:57:37 +03:00
Options: ?
Notes: 65
Onboarding: completed

### Action Scheduler ###

?ptal edildi: 1
Oldest: 2024-01-08 19:44:45 +0300
Newest: 2024-01-08 19:44:45 +0300

Tamamla: 163
Oldest: 2023-12-29 15:57:47 +0300
Newest: 2024-01-08 21:11:43 +0300

Ba?ar?s?z: 9
Oldest: 2023-12-30 23:33:50 +0300
Newest: 2024-01-07 16:21:49 +0300

Bekleyen: 1
Oldest: 2024-01-09 16:00:44 +0300
Newest: 2024-01-09 16:00:44 +0300


### Status report information ###

Generated at: 2024-01-08 21:40:57 +03:00
`

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

Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Support Zubair Zahid (woo-hc)

    (@doublezed2)

    Hello Selin Polat,

    Thank you for your reply and for providing the SSR.

    I understand that you’re experiencing a delay of 30-40 seconds when editing products on your site, which certainly sounds like it could slow down your workflow considerably.

    To begin troubleshooting this slow query issue, I recommend you temporarily deactivate all plugins on your site except for WooCommerce. This step will help determine if there’s a specific plugin that’s contributing to the slow load times.

    If the performance issue persists even after deactivating other plugins, or if the problem is resolved and you need to determine which plugin is causing the slowdown, you can reactivate each plugin one by one, testing the load time after each one to pinpoint the cause.

    Additionally, I suggest enabling High-Performance Order Storage (HPOS), which is a new feature that can help optimize the management of orders in your database, potentially improving overall performance.

    Please try these steps and let me know if there’s an improvement or if you continue to face the same issue. I’m here to assist you every step of the way to ensure a swift and effective resolution. ??

    Have a great day!

    Thread Starter Selin Polat

    (@cepkolik)

    I tried disabling all plugins (except Woocommerce). The result is still the same. 20-30 sec.

    I tried (HPOS) but two plugins gave warnings.

    I don’t know what to do right now. It takes too long to edit a product.

    Plugin Support Paulo P – a11n

    (@paulostp)

    Hello,

    I tried disabling all plugins (except Woocommerce). The result is still the same. 20-30 sec.

    If you’re still experiencing slowness with just WooCommerce activated, then the next step is contacting your web host to check if they have any additional insights.

    Let us know what you find.

    Best,

    Thread Starter Selin Polat

    (@cepkolik)

    I temporarily solved the problem with the method here.

    https://9seeds.com/wordpress-admin-post-editor-performance/

    Plugin Support Paulo P – a11n

    (@paulostp)

    Great! Thanks for sharing the resolution. I’ll go ahead and close this topic.

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Slow queries in the core’ is closed to new replies.