[ad_1]
Here is system status.
`
### WordPress Environment ###
WordPress address (URL): https://mmxianxia.com
Site address (URL): https://mmxianxia.com
WC Version: 8.8.3
REST API Version: ✔ 8.8.3
Action Scheduler Version: ✔ 3.7.4
Log Directory Writable: ✔
WP Version: 6.5.3
WP Multisite: –
WP Memory Limit: 512 MB
WP Debug Mode: –
WP Cron: –
Language: en_US
External object cache: ✔
### Server Environment ###
Server Info: nginx/1.25.3
PHP Version: 7.4.33
PHP Post Max Size: 256 MB
PHP Time Limit: 3597
PHP Max Input Vars: 9996
cURL Version: 7.81.0
OpenSSL/3.0.2
SUHOSIN Installed: –
MySQL Version: 5.5.5-10.6.17-MariaDB-1:10.6.17+maria~ubu2204
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.8.3
WC Database Prefix: rtw6u9s9d9_
Total Database Size: 3363.52MB
Database Data Size: 2668.67MB
Database Index Size: 694.85MB
rtw6u9s9d9_woocommerce_sessions: Data: 0.20MB + Index: 0.02MB + Engine InnoDB
rtw6u9s9d9_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
rtw6u9s9d9_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
rtw6u9s9d9_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
rtw6u9s9d9_woocommerce_order_items: Data: 14.52MB + Index: 2.52MB + Engine InnoDB
rtw6u9s9d9_woocommerce_order_itemmeta: Data: 64.59MB + Index: 54.14MB + Engine InnoDB
rtw6u9s9d9_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
rtw6u9s9d9_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
rtw6u9s9d9_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
rtw6u9s9d9_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
rtw6u9s9d9_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
rtw6u9s9d9_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
rtw6u9s9d9_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
rtw6u9s9d9_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
rtw6u9s9d9_actionscheduler_actions: Data: 0.06MB + Index: 0.11MB + Engine InnoDB
rtw6u9s9d9_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
rtw6u9s9d9_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
rtw6u9s9d9_actionscheduler_logs: Data: 0.05MB + Index: 0.03MB + Engine InnoDB
rtw6u9s9d9_commentmeta: Data: 4.52MB + Index: 5.03MB + Engine InnoDB
rtw6u9s9d9_comments: Data: 40.56MB + Index: 33.61MB + Engine InnoDB
rtw6u9s9d9_links: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
rtw6u9s9d9_myCRED_log: Data: 13.52MB + Index: 12.09MB + Engine InnoDB
rtw6u9s9d9_options: Data: 2.44MB + Index: 0.31MB + Engine InnoDB
rtw6u9s9d9_postmeta: Data: 265.81MB + Index: 215.47MB + Engine InnoDB
rtw6u9s9d9_posts: Data: 1960.56MB + Index: 22.11MB + Engine InnoDB
rtw6u9s9d9_termmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
rtw6u9s9d9_terms: Data: 0.09MB + Index: 0.09MB + Engine InnoDB
rtw6u9s9d9_term_relationships: Data: 3.52MB + Index: 1.52MB + Engine InnoDB
rtw6u9s9d9_term_taxonomy: Data: 0.08MB + Index: 0.09MB + Engine InnoDB
rtw6u9s9d9_tm_taskmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
rtw6u9s9d9_tm_tasks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
rtw6u9s9d9_usermeta: Data: 38.56MB + Index: 14.03MB + Engine InnoDB
rtw6u9s9d9_users: Data: 1.52MB + Index: 0.80MB + Engine InnoDB
rtw6u9s9d9_wc_admin_notes: Data: 0.05MB + Index: 0.00MB + Engine InnoDB
rtw6u9s9d9_wc_admin_note_actions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
rtw6u9s9d9_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
rtw6u9s9d9_wc_customer_lookup: Data: 0.44MB + Index: 0.31MB + Engine InnoDB
rtw6u9s9d9_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
rtw6u9s9d9_wc_orders: Data: 29.56MB + Index: 23.61MB + Engine InnoDB
rtw6u9s9d9_wc_orders_meta: Data: 187.72MB + Index: 269.88MB + Engine InnoDB
rtw6u9s9d9_wc_order_addresses: Data: 12.52MB + Index: 20.06MB + Engine InnoDB
rtw6u9s9d9_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
rtw6u9s9d9_wc_order_operational_data: Data: 16.55MB + Index: 7.03MB + Engine InnoDB
rtw6u9s9d9_wc_order_product_lookup: Data: 5.52MB + Index: 6.06MB + Engine InnoDB
rtw6u9s9d9_wc_order_stats: Data: 4.52MB + Index: 4.55MB + Engine InnoDB
rtw6u9s9d9_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
rtw6u9s9d9_wc_product_attributes_lookup: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
rtw6u9s9d9_wc_product_download_directories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
rtw6u9s9d9_wc_product_meta_lookup: Data: 0.19MB + Index: 0.33MB + Engine InnoDB
rtw6u9s9d9_wc_rate_limits: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
rtw6u9s9d9_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
rtw6u9s9d9_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
rtw6u9s9d9_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
rtw6u9s9d9_woobe_history: Data: 0.09MB + Index: 0.11MB + Engine InnoDB
rtw6u9s9d9_woobe_history_bulk: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
rtw6u9s9d9_wpbe_history: Data: 0.25MB + Index: 0.17MB + Engine InnoDB
rtw6u9s9d9_wpbe_history_bulk: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
rtw6u9s9d9_wpmailsmtp_debug_events: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
rtw6u9s9d9_wpmailsmtp_emails_queue: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
rtw6u9s9d9_wpmailsmtp_tasks_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
### Post Type Counts ###
attachment: 396
bitforms: 5
custom_css: 2
itsec-dash-card: 10
itsec-dashboard: 2
mycred_rank: 8
nav_menu_item: 4
page: 18
post: 48595
product: 1809
series: 94
shop_coupon: 1
shop_order: 48719
shop_order_placehold: 35789
wp_navigation: 1
wp_template: 2
### Security ###
Secure connection (HTTPS): ✔
Hide errors from visitors: ✔
### Active Plugins (26) ###
Query Monitor: by John Blackbourn – 3.16.2
Akismet Anti-spam: Spam Protection: by Automattic - Anti-spam Team – 5.3.2
Autoptimize: by Frank Goossens (futtta) – 3.1.11
WOLF - WordPress Posts Bulk Editor and Manager Professional: by realmag777 – 1.0.8.3
Classic Editor: by WordPress Contributors – 1.6.3
Cost of Goods for WooCommerce: by WPFactory – 3.4.0
Dinger Payment Prebuild Form Gateway: by Insight Web Studio – 1.0
FastCredit for WooCommerce (Premium): by FastFlow – 2.0.16
Frontend Reports for WooCommerce: by WP Zone – 1.0.13
Product Sales Report Pro for WooCommerce: by WP Zone – 2.2.47
Meta Box: by MetaBox.io – 5.9.8
myCred Level Cred: by myCred – 1.2.1
myCred: by myCred – 2.6.5
Open Graph: by Will Norris – 1.11.2
Progressive WordPress (PWA): by Nico Martin – 2.1.13
RunCloud Hub: by RunCloud – 1.4.4
Use Any Font: by Dnesscarkey – 6.3.05
User Switching: by John Blackbourn & contributors – 1.7.3
BEAR – Bulk Editor and Products Manager Professional for WooCommerce: by realmag777 – 1.1.4.4
WooCommerce Custom My Account Page: by Wbcom Designs – 1.3.5
Booster for WooCommerce: by Pluggabl LLC – 7.1.9
Pay For Post with WooCommerce: by Pramadillo – 3.1.17
WooCommerce: by Automattic – 8.8.3
WP Crontrol: by John Blackbourn – 1.16.3
WP Mail SMTP: by WP Mail SMTP – 4.0.1
WP-Optimize - Clean, Compress, Cache: by David Anderson
Ruhani Rabin
Team Updraft – 3.3.2
### Inactive Plugins (0) ###
### Dropin Plugins () ###
object-cache.php: object-cache.php
### Settings ###
API Enabled: –
Force SSL: –
Currency: MMK (Ks)
Currency Position: right_space
Thousand Separator: ,
Decimal Separator: .
Number of Decimals: 0
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: Automattic\WooCommerce\Internal\DataStores\Orders\OrdersTableDataStore
HPOS data sync enabled: –
### Logging ###
Enabled: ✔
Handler: Automattic\WooCommerce\Internal\Admin\Logging\LogHandlerFileV2
Retention period: 30 days
Level threshold: –
Log directory size: 359 B
### WC Pages ###
Shop base: #8 - /shop/
Cart: #9 - /cart/
Checkout: #10 - /checkout/
My account: #11 - /my-account/
Terms and conditions: #5076 - /term-of-service/
### Theme ###
Name: LightNovel Child
Version: 1.0.1
Author URL: https://themesia.com
Child Theme: ✔
Parent Theme Name: LightNovel
Parent Theme Version: 1.1.5
Parent Theme Author URL: https://themesia.com
WooCommerce Support: ❌ Not declared
### Templates ###
Overrides: /home/runcloud/webapps/mmxianxia/wp-content/plugins/fast-woocredit-pro/includes/woocommerce/checkout/thankyou.php
/home/runcloud/webapps/mmxianxia/wp-content/plugins/fast-woocredit-pro/includes/woocommerce/emails/email-order-details.php
/home/runcloud/webapps/mmxianxia/wp-content/plugins/fast-woocredit-pro/includes/woocommerce/emails/email-order-items.php
/home/runcloud/webapps/mmxianxia/wp-content/plugins/fast-woocredit-pro/includes/woocommerce/myaccount/orders.php version 7.8.0 is out of date. The core version is 8.5.0
/home/runcloud/webapps/mmxianxia/wp-content/plugins/fast-woocredit-pro/includes/woocommerce/order/order-details-item.php
/home/runcloud/webapps/mmxianxia/wp-content/plugins/fast-woocredit-pro/includes/woocommerce/order/order-details.php version 7.8.0 is out of date. The core version is 8.5.0
Outdated Templates: ❌
Learn how to update
### 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
product-variation-management
product-virtual-downloadable
product-external-affiliate
product-grouped
product-linked
product-pre-publish-modal
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: minified-js
new-product-management-experience
product-custom-fields
settings
async-product-editor-category-field
launch-your-store
Daily Cron: ✔ Next scheduled: 2024-05-10 06:20:59 +06:30
Options: ✔
Notes: 41
Onboarding: completed
### Action Scheduler ###
Complete: 129
Oldest: 2024-05-03 04:40:02 +0000
Newest: 2024-05-10 02:00:02 +0000
Pending: 4
Oldest: 2024-05-10 06:10:02 +0000
Newest: 2024-05-11 02:00:02 +0000
### Status report information ###
Generated at: 2024-05-10 08:31:02 +06:30
`
I forgot the caller of above mentioned slow query.
Automattic\WooCommerce\Internal\DataStores\CustomMetaDataStore->get_meta_keys
Automattic\WooCommerce\Internal\Admin\Orders\MetaBoxes\CustomMetaBox->order_meta_keys_autofill
Automattic\WooCommerce\Internal\Admin\Orders\MetaBoxes\CustomMetaBox->render_meta_form
Automattic\WooCommerce\Internal\Admin\Orders\MetaBoxes\CustomMetaBox->render_custom_meta_form
Automattic\WooCommerce\Internal\Admin\Orders\MetaBoxes\CustomMetaBox->output
Automattic\WooCommerce\Internal\Admin\Orders\Edit->render_custom_meta_box
do_meta_boxes
Automattic\WooCommerce\Internal\Admin\Orders\Edit->render_meta_boxes
Automattic\WooCommerce\Internal\Admin\Orders\Edit->display
Automattic\WooCommerce\Internal\Admin\Orders\PageController->output
do_action('woocommerce_page_wc-orders')
Please see https://projectdmc.org/support/topic/order-table-sooo-slow-i-cant-edit-orders/#post-17747090 for some analysis of this situation.
This issue has been reported in github (https://github.com/woocommerce/woocommerce/issues/47212) and it is known to be fixed in next update. So I will mark this post as resolved.