WC_order_stats table index size keeps growing to GBs

  • Hi,

    I am having some issue in 1 of my site. The indexes of WC_order_stats table keeps growing in GBs.

    If I am optimising the database then it behave normally. After some time the table index size is growing in 1-2GB.

    I am getting the solutions to fix this issue. But I am not getting the exact solution of this issue. Can you please guide me in this.

    Looking forward a fast response.

    Thanks & Regards,
    Aman

Viewing 7 replies - 1 through 7 (of 7 total)
  • Plugin Support Thu P. a11n

    (@thup90)

    Hi Aman,

    Could you share your System Status Report, it would help us to understand your site setup a bit better. You can find it via WooCommerce > Status. Select Get system report and then Copy for support. Once you’ve done that, paste it here in your reply.

    AJ a11n

    (@amandasjackson)

    We haven’t heard back from you in a while, so I’m going to mark this as resolved – if you have any further questions, you can start a new thread.

    Thread Starter amanzestgeek

    (@amanzestgeek)

    Hi

    Sorry for the late reply. I didn’t get any email notification from you. I will share the System Status Report now

    Thread Starter amanzestgeek

    (@amanzestgeek)

    Please check here is the system report that you asked to get from WooCommerce > Status

    
### WordPress Environment ###

WordPress address (URL): https://bntonline.co.za
Site address (URL): https://bntonline.co.za
WC Version: 4.5.0
REST API Version: ? 4.5.0
WC Blocks Version: ? 3.1.0
Action Scheduler Version: ? 3.1.6
WC Admin Version: ? 1.5.0
Log Directory Writable: ?
WP Version: 5.5.1
WP Multisite: –
WP Memory Limit: 10 GB
WP Debug Mode: –
WP Cron: ?
Language: en_US
External object cache: –

### Server Environment ###

Server Info: nginx/1.19.2
PHP Version: 7.4.10
PHP Post Max Size: 64 MB
PHP Time Limit: 6000
PHP Max Input Vars: 1500
cURL Version: 7.68.0
OpenSSL/1.1.1f

SUHOSIN Installed: –
MySQL Version: 5.5.5-10.4.13-MariaDB-1:10.4.13+maria~focal-log
Max Upload Size: 64 MB
Default Timezone is UTC: ? Default timezone is Africa/Johannesburg - it should be UTC
fsockopen/cURL: ?
SoapClient: ?
DOMDocument: ?
GZip: ?
Multibyte String: ?
Remote Post: ?
Remote Get: ?

### Database ###

WC Database Version: 4.4.1
WC Database Prefix: wp_28484cf714_
Total Database Size: 19449.34MB
Database Data Size: 1588.76MB
Database Index Size: 17860.58MB
wp_28484cf714_woocommerce_sessions: Data: 2.02MB + Index: 0.02MB + Engine InnoDB
wp_28484cf714_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_28484cf714_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_28484cf714_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.17MB + Engine InnoDB
wp_28484cf714_woocommerce_order_items: Data: 2.52MB + Index: 3.03MB + Engine InnoDB
wp_28484cf714_woocommerce_order_itemmeta: Data: 20.55MB + Index: 20.55MB + Engine InnoDB
wp_28484cf714_woocommerce_tax_rates: Data: 0.02MB + Index: 0.08MB + Engine InnoDB
wp_28484cf714_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_28484cf714_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_28484cf714_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_28484cf714_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_28484cf714_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_28484cf714_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_28484cf714_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
cerber_acl: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
cerber_blocks: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
cerber_countries: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
cerber_lab: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
cerber_lab_ip: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
cerber_lab_net: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
cerber_log: Data: 19.55MB + Index: 11.55MB + Engine InnoDB
cerber_qmem: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
cerber_traffic: Data: 34.55MB + Index: 2.52MB + Engine InnoDB
wp_28484cf714_actionscheduler_actions: Data: 7.02MB + Index: 7.06MB + Engine InnoDB
wp_28484cf714_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_28484cf714_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_28484cf714_actionscheduler_logs: Data: 6.52MB + Index: 4.03MB + Engine InnoDB
wp_28484cf714_adverts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_28484cf714_advert_clicks: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_28484cf714_aepc_custom_audiences: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_28484cf714_aepc_logs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_28484cf714_affiliate_wp_affiliatemeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_28484cf714_affiliate_wp_affiliates: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_28484cf714_affiliate_wp_campaigns: Data: 0.00MB + Index: 0.00MB + Engine
wp_28484cf714_affiliate_wp_creatives: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_28484cf714_affiliate_wp_customermeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_28484cf714_affiliate_wp_customers: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_28484cf714_affiliate_wp_payouts: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_28484cf714_affiliate_wp_referrals: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_28484cf714_affiliate_wp_rest_consumers: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_28484cf714_affiliate_wp_visits: Data: 0.27MB + Index: 0.06MB + Engine InnoDB
wp_28484cf714_apsl_users_social_profile_details: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_28484cf714_as3cf_items: Data: 4.52MB + Index: 4.63MB + Engine InnoDB
wp_28484cf714_asl_brands: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_28484cf714_asl_categories: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_28484cf714_asl_configs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_28484cf714_asl_countries: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_28484cf714_asl_markers: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_28484cf714_asl_settings: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_28484cf714_asl_storelogos: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_28484cf714_asl_stores: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_28484cf714_asl_stores_categories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_28484cf714_asl_stores_view: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_28484cf714_automatewoo_abandoned_carts: Data: 0.02MB + Index: 0.08MB + Engine InnoDB
wp_28484cf714_automatewoo_customers: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
wp_28484cf714_automatewoo_customer_meta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_28484cf714_automatewoo_events: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_28484cf714_automatewoo_guests: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_28484cf714_automatewoo_guest_meta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_28484cf714_automatewoo_logs: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_28484cf714_automatewoo_log_meta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_28484cf714_automatewoo_queue: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_28484cf714_automatewoo_queue_meta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_28484cf714_automatewoo_unsubscribes: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_28484cf714_aza_calltracking: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_28484cf714_aza_calltracking_phones: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_28484cf714_aza_leads: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_28484cf714_aza_offline_marketing_costs: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_28484cf714_aza_targets: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_28484cf714_aza_visits_first: Data: 0.02MB + Index: 0.34MB + Engine InnoDB
wp_28484cf714_aza_visits_last: Data: 0.02MB + Index: 0.34MB + Engine InnoDB
wp_28484cf714_aza_visits_linear: Data: 0.02MB + Index: 0.34MB + Engine InnoDB
wp_28484cf714_aza_visits_position: Data: 0.02MB + Index: 0.34MB + Engine InnoDB
wp_28484cf714_azr_page_visits: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_28484cf714_azr_visitors: Data: 0.09MB + Index: 0.19MB + Engine InnoDB
wp_28484cf714_azr_visitor_posts: Data: 0.27MB + Index: 0.28MB + Engine InnoDB
wp_28484cf714_azr_visitor_tags: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_28484cf714_bobsi_tradefeed_audit: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_28484cf714_bobsi_tradefeed_product: Data: 4.52MB + Index: 0.00MB + Engine InnoDB
wp_28484cf714_bobsi_tradefeed_product_base: Data: 14.52MB + Index: 0.00MB + Engine InnoDB
wp_28484cf714_c2q: Data: 0.36MB + Index: 0.09MB + Engine InnoDB
wp_28484cf714_cerber_files: Data: 7.55MB + Index: 0.00MB + Engine InnoDB
wp_28484cf714_cerber_sets: Data: 1.52MB + Index: 0.00MB + Engine InnoDB
wp_28484cf714_cerber_uss: Data: 0.08MB + Index: 0.02MB + Engine InnoDB
wp_28484cf714_cf7_vdata: Data: 0.16MB + Index: 0.00MB + Engine InnoDB
wp_28484cf714_cf7_vdata_entry: Data: 7.52MB + Index: 0.00MB + Engine InnoDB
wp_28484cf714_cleantalk_ac_log: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_28484cf714_cleantalk_sessions: Data: 16.23MB + Index: 0.00MB + Engine InnoDB
wp_28484cf714_cleantalk_sfw: Data: 2.52MB + Index: 2.52MB + Engine InnoDB
wp_28484cf714_cleantalk_sfw_logs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_28484cf714_cleantalk_spamscan_logs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_28484cf714_clickervolt_actions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_28484cf714_clickervolt_actions_summary: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_28484cf714_clickervolt_aids: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_28484cf714_clickervolt_clicks: Data: 0.25MB + Index: 4.25MB + Engine InnoDB
wp_28484cf714_clickervolt_custom_reports: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_28484cf714_clickervolt_devices: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
wp_28484cf714_clickervolt_external_ids: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_28484cf714_clickervolt_funnel_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_28484cf714_clickervolt_geos: Data: 0.02MB + Index: 0.08MB + Engine InnoDB
wp_28484cf714_clickervolt_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_28484cf714_clickervolt_parallel_ids: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_28484cf714_clickervolt_referrers: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_28484cf714_clickervolt_source_templates: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_28484cf714_clickervolt_stats_base: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_28484cf714_clickervolt_stats_whole_path: Data: 0.13MB + Index: 0.13MB + Engine InnoDB
wp_28484cf714_clickervolt_stats_whole_path_devices: Data: 0.13MB + Index: 0.13MB + Engine InnoDB
wp_28484cf714_clickervolt_stats_whole_path_geos: Data: 0.13MB + Index: 0.13MB + Engine InnoDB
wp_28484cf714_clickervolt_stats_whole_path_referrers: Data: 0.13MB + Index: 0.13MB + Engine InnoDB
wp_28484cf714_clickervolt_stats_whole_path_var1: Data: 0.13MB + Index: 0.13MB + Engine InnoDB
wp_28484cf714_clickervolt_stats_whole_path_var10: Data: 0.13MB + Index: 0.13MB + Engine InnoDB
wp_28484cf714_clickervolt_stats_whole_path_var2: Data: 0.13MB + Index: 0.13MB + Engine InnoDB
wp_28484cf714_clickervolt_stats_whole_path_var3: Data: 0.13MB + Index: 0.13MB + Engine InnoDB
wp_28484cf714_clickervolt_stats_whole_path_var4: Data: 0.13MB + Index: 0.13MB + Engine InnoDB
wp_28484cf714_clickervolt_stats_whole_path_var5: Data: 0.13MB + Index: 0.13MB + Engine InnoDB
wp_28484cf714_clickervolt_stats_whole_path_var6: Data: 0.13MB + Index: 0.13MB + Engine InnoDB
wp_28484cf714_clickervolt_stats_whole_path_var7: Data: 0.13MB + Index: 0.13MB + Engine InnoDB
wp_28484cf714_clickervolt_stats_whole_path_var8: Data: 0.13MB + Index: 0.13MB + Engine InnoDB
wp_28484cf714_clickervolt_stats_whole_path_var9: Data: 0.13MB + Index: 0.13MB + Engine InnoDB
wp_28484cf714_clickervolt_suspicious_clicks: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_28484cf714_clickervolt_urls_paths: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_28484cf714_commentmeta: Data: 0.31MB + Index: 0.23MB + Engine MyISAM
wp_28484cf714_comments: Data: 9.32MB + Index: 3.13MB + Engine MyISAM
wp_28484cf714_db7_forms: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_28484cf714_ewwwio_images: Data: 73.59MB + Index: 42.27MB + Engine InnoDB
wp_28484cf714_ewwwio_queue: Data: 1.52MB + Index: 0.34MB + Engine InnoDB
wp_28484cf714_imagify_files: Data: 0.02MB + Index: 0.08MB + Engine InnoDB
wp_28484cf714_imagify_folders: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_28484cf714_iwp_backup_status: Data: 0.09MB + Index: 0.00MB + Engine InnoDB
wp_28484cf714_iwp_file_list: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_28484cf714_lcs_chat_engines: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_28484cf714_lcs_chat_engines_show_pages: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_28484cf714_lcs_chat_messages: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_28484cf714_lcs_chat_sessions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_28484cf714_lcs_chat_templates: Data: 0.05MB + Index: 0.00MB + Engine InnoDB
wp_28484cf714_lcs_chat_triggers: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_28484cf714_lcs_chat_triggers_conditions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_28484cf714_lcs_chat_users: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_28484cf714_lcs_countries: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_28484cf714_links: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_28484cf714_litespeed_img_optm: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
wp_28484cf714_litespeed_optimizer: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_28484cf714_login_redirects: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_28484cf714_mailster_actions: Data: 54.58MB + Index: 80.20MB + Engine InnoDB
wp_28484cf714_mailster_forms: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_28484cf714_mailster_forms_lists: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_28484cf714_mailster_form_fields: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_28484cf714_mailster_links: Data: 0.06MB + Index: 0.00MB + Engine InnoDB
wp_28484cf714_mailster_lists: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_28484cf714_mailster_lists_subscribers: Data: 3.52MB + Index: 3.03MB + Engine InnoDB
wp_28484cf714_mailster_queue: Data: 1.06MB + Index: 2.88MB + Engine InnoDB
wp_28484cf714_mailster_subscribers: Data: 8.52MB + Index: 12.56MB + Engine InnoDB
wp_28484cf714_mailster_subscriber_fields: Data: 5.52MB + Index: 7.03MB + Engine InnoDB
wp_28484cf714_mailster_subscriber_meta: Data: 24.55MB + Index: 51.09MB + Engine InnoDB
wp_28484cf714_metaseo_images: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_28484cf714_mymail_bak_actions: Data: 0.27MB + Index: 0.47MB + Engine InnoDB
wp_28484cf714_mymail_bak_forms: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_28484cf714_mymail_bak_forms_lists: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_28484cf714_mymail_bak_form_fields: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_28484cf714_mymail_bak_links: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_28484cf714_mymail_bak_lists: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_28484cf714_mymail_bak_lists_subscribers: Data: 0.11MB + Index: 0.16MB + Engine InnoDB
wp_28484cf714_mymail_bak_queue: Data: 0.02MB + Index: 0.13MB + Engine InnoDB
wp_28484cf714_mymail_bak_subscribers: Data: 0.30MB + Index: 0.44MB + Engine InnoDB
wp_28484cf714_mymail_bak_subscriber_fields: Data: 0.08MB + Index: 0.09MB + Engine InnoDB
wp_28484cf714_mymail_bak_subscriber_meta: Data: 1.52MB + Index: 0.94MB + Engine InnoDB
wp_28484cf714_nf_objectmeta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_28484cf714_nf_objects: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_28484cf714_nf_relationships: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_28484cf714_ninja_forms_fav_fields: Data: 0.05MB + Index: 0.00MB + Engine InnoDB
wp_28484cf714_ninja_forms_fields: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_28484cf714_nxs_log: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_28484cf714_options: Data: 276.18MB + Index: 78.66MB + Engine MyISAM
wp_28484cf714_pmxe_exports: Data: 0.47MB + Index: 0.00MB + Engine InnoDB
wp_28484cf714_pmxe_google_cats: Data: 0.38MB + Index: 0.00MB + Engine InnoDB
wp_28484cf714_pmxe_posts: Data: 5.52MB + Index: 0.00MB + Engine InnoDB
wp_28484cf714_pmxe_templates: Data: 0.17MB + Index: 0.00MB + Engine InnoDB
wp_28484cf714_pmxi_files: Data: 0.06MB + Index: 0.00MB + Engine InnoDB
wp_28484cf714_pmxi_history: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_28484cf714_pmxi_images: Data: 0.13MB + Index: 0.00MB + Engine InnoDB
wp_28484cf714_pmxi_imports: Data: 0.11MB + Index: 0.00MB + Engine InnoDB
wp_28484cf714_pmxi_posts: Data: 1.52MB + Index: 0.88MB + Engine InnoDB
wp_28484cf714_pmxi_templates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_28484cf714_postmeta: Data: 103.66MB + Index: 40.37MB + Engine MyISAM
wp_28484cf714_posts: Data: 21.66MB + Index: 3.90MB + Engine MyISAM
wp_28484cf714_POS_Stores: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_28484cf714_POS_Stores_sync_setting: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_28484cf714_rankie_changes: Data: 0.05MB + Index: 0.00MB + Engine InnoDB
wp_28484cf714_rankie_keywords: Data: 0.06MB + Index: 0.00MB + Engine InnoDB
wp_28484cf714_rankie_log: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_28484cf714_rankie_ranks: Data: 0.06MB + Index: 0.00MB + Engine InnoDB
wp_28484cf714_revslider_css: Data: 0.13MB + Index: 0.00MB + Engine InnoDB
wp_28484cf714_revslider_layer_animations: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_28484cf714_revslider_navigations: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_28484cf714_revslider_sliders: Data: 0.05MB + Index: 0.00MB + Engine InnoDB
wp_28484cf714_revslider_slides: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_28484cf714_revslider_static_slides: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_28484cf714_rtwwwap_mlm: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_28484cf714_rtwwwap_referrals: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_28484cf714_seopressor_link: Data: 0.08MB + Index: 0.00MB + Engine InnoDB
wp_28484cf714_seopressor_logs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_28484cf714_seopressor_roles_capabilities: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_28484cf714_seopressor_site_audit: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_28484cf714_seopressor_site_audit_crawler: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_28484cf714_seopressor_smart_linking: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_28484cf714_seopressor_users_custom_roles: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_28484cf714_smush_dir_images: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_28484cf714_social_users: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_28484cf714_stores121: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_28484cf714_swp_cf: Data: 1.52MB + Index: 0.88MB + Engine InnoDB
wp_28484cf714_swp_index: Data: 65.59MB + Index: 33.09MB + Engine InnoDB
wp_28484cf714_swp_log: Data: 281.81MB + Index: 292.14MB + Engine InnoDB
wp_28484cf714_swp_tax: Data: 3.52MB + Index: 4.20MB + Engine InnoDB
wp_28484cf714_swp_terms: Data: 3.52MB + Index: 7.55MB + Engine InnoDB
wp_28484cf714_termmeta: Data: 1.08MB + Index: 0.93MB + Engine MyISAM
wp_28484cf714_terms: Data: 1.38MB + Index: 1.83MB + Engine MyISAM
wp_28484cf714_term_relationships: Data: 2.43MB + Index: 4.35MB + Engine MyISAM
wp_28484cf714_term_taxonomy: Data: 1.28MB + Index: 1.31MB + Engine MyISAM
wp_28484cf714_tinvwl_analytics: Data: 1.52MB + Index: 1.52MB + Engine InnoDB
wp_28484cf714_tinvwl_items: Data: 1.52MB + Index: 0.00MB + Engine InnoDB
wp_28484cf714_tinvwl_lists: Data: 1.52MB + Index: 0.00MB + Engine InnoDB
wp_28484cf714_tm_taskmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_28484cf714_tm_tasks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_28484cf714_usermeta: Data: 73.53MB + Index: 39.00MB + Engine MyISAM
wp_28484cf714_users: Data: 5.43MB + Index: 3.65MB + Engine MyISAM
wp_28484cf714_vcht_logs: Data: 0.14MB + Index: 0.00MB + Engine InnoDB
wp_28484cf714_vcht_operators: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_28484cf714_vcht_sentences: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_28484cf714_wc_admin_notes: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_28484cf714_wc_admin_note_actions: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_28484cf714_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_28484cf714_wc_customer_lookup: Data: 1.52MB + Index: 0.63MB + Engine InnoDB
wp_28484cf714_wc_download_log: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_28484cf714_wc_gpf_render_cache: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_28484cf714_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_28484cf714_wc_order_product_lookup: Data: 3.52MB + Index: 2.83MB + Engine InnoDB
wp_28484cf714_wc_order_stats: Data: 1.52MB + Index: 16779.78MB + Engine InnoDB
wp_28484cf714_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_28484cf714_wc_product_meta_lookup: Data: 2.52MB + Index: 3.22MB + Engine InnoDB
wp_28484cf714_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_28484cf714_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_28484cf714_wc_webhooks: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_28484cf714_wdp_orders: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_28484cf714_wdp_order_items: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_28484cf714_wdp_rules: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_28484cf714_wfblockediplog: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_28484cf714_wfblocks7: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_28484cf714_wfconfig: Data: 0.06MB + Index: 0.00MB + Engine InnoDB
wp_28484cf714_wfcrawlers: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_28484cf714_wffilechanges: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_28484cf714_wffilemods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_28484cf714_wfhits: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_28484cf714_wfhoover: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_28484cf714_wfissues: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_28484cf714_wfknownfilelist: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_28484cf714_wflivetraffichuman: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_28484cf714_wflocs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_28484cf714_wflogins: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_28484cf714_wfls_2fa_secrets: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_28484cf714_wfls_settings: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_28484cf714_wfnotifications: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_28484cf714_wfpendingissues: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_28484cf714_wfreversecache: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_28484cf714_wfsnipcache: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_28484cf714_wfstatus: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_28484cf714_wftrafficrates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_28484cf714_woocommerce_bundled_itemmeta: Data: 2.52MB + Index: 3.03MB + Engine InnoDB
wp_28484cf714_woocommerce_bundled_items: Data: 0.09MB + Index: 0.09MB + Engine InnoDB
wp_28484cf714_woocommerce_gpf_google_taxonomy: Data: 1.52MB + Index: 0.00MB + Engine InnoDB
wp_28484cf714_wpfm_backup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_28484cf714_wpgmza: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_28484cf714_wpgmza_categories: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_28484cf714_wpgmza_category_maps: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_28484cf714_wpgmza_maps: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_28484cf714_wpgmza_polygon: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_28484cf714_wpgmza_polylines: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_28484cf714_wplc_chat_msgs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_28484cf714_wplc_chat_sessions: Data: 0.06MB + Index: 0.00MB + Engine InnoDB
wp_28484cf714_wplc_offline_messages: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_28484cf714_wpmelon_advbedit_temp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_28484cf714_wpms_links: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_28484cf714_wptc_activity_log: Data: 9.02MB + Index: 4.48MB + Engine InnoDB
wp_28484cf714_wptc_backups: Data: 0.09MB + Index: 0.02MB + Engine InnoDB
wp_28484cf714_wptc_current_process: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_28484cf714_wptc_inc_exc_contents: Data: 0.08MB + Index: 0.05MB + Engine InnoDB
wp_28484cf714_wptc_options: Data: 0.13MB + Index: 0.00MB + Engine InnoDB
wp_28484cf714_wptc_processed_files: Data: 121.67MB + Index: 34.59MB + Engine InnoDB
wp_28484cf714_wptc_processed_iterator: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_28484cf714_wptc_processed_restored_files: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_28484cf714_wptc_query_recorder: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_28484cf714_wpvr_logs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_28484cf714_wpvr_source_meta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_28484cf714_wpvr_video_meta: Data: 0.23MB + Index: 0.22MB + Engine InnoDB
wp_28484cf714_wsal_metadata: Data: 224.75MB + Index: 229.67MB + Engine InnoDB
wp_28484cf714_wsal_occurrences: Data: 13.52MB + Index: 15.06MB + Engine InnoDB
wp_28484cf714_wsal_options: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_28484cf714_xoo_wl_list: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_28484cf714_xoo_wl_list_meta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_28484cf714_yoast_seo_links: Data: 1.52MB + Index: 0.30MB + Engine InnoDB
wp_28484cf714_yoast_seo_meta: Data: 2.52MB + Index: 0.00MB + Engine InnoDB
wp_28484cf714_ywrr_email_blocklist: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_28484cf714_ywrr_email_schedule: Data: 1.52MB + Index: 0.00MB + Engine InnoDB
wp_rankie_changes: Data: 0.08MB + Index: 0.00MB + Engine InnoDB
wp_rankie_keywords: Data: 0.22MB + Index: 0.00MB + Engine InnoDB
wp_rankie_log: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_rankie_ranks: Data: 0.17MB + Index: 0.00MB + Engine InnoDB

### Post Type Counts ###

acf: 1
acf-field: 3
acf-field-group: 3
aiosrs-schema: 1
attachment: 16741
blocks: 48
bnt-videos: 1
custom_css: 1
ec_woo_ddb_template: 12
iwp_log: 646
mts_notification_bar: 1
nav_menu_item: 159
newsletter: 34
nf_sub: 239
oembed_cache: 391
page: 65
post: 249
product: 18876
product_variation: 1006
quote: 55
revision: 88
sa_slider: 1
shop_coupon: 11
shop_order: 8860
shop_order_refund: 116
slider: 6
sp_wps_shortcodes: 1
testimonials: 200
wcct_countdown: 1
wpcf7_contact_form: 15
wpgae_click_event: 1
wptwa_accounts: 12
wpvr_source: 1
wpvr_video: 8

### Security ###

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

### Active Plugins (60) ###

Backup and Staging by WP Time Capsule: by Revmakx – 1.21.24
DF Coder Testimonials: by DF coder – 0.1
POS Store: by Asif – 3.0 – Installed version not tested with active version of WooCommerce 4.5.0
PW Woocomerce Brands coupon Addons: by Proword – 1.1 – Installed version not tested with active version of WooCommerce 4.5.0
Adminimize: by Frank Bültge – 1.11.7
Advanced Access Manager: by Vasyl Martyniuk <[email protected]> – 6.6.2
Advanced CF7 DB: by Vsourz Digital – 1.8.1
Advanced Database Cleaner PRO: by Younes JFR. – 3.1.5
Agile Store Locator: by AGILELOGIX – 1.2.4
WP Offload Media Lite: by Delicious Brains – 2.4.3
Change WordPress Login Logo: by Boopathi Rajan – 1.1.5
Classic Editor: by WordPress Contributors – 1.6
Anti-Spam by CleanTalk: by СleanTalk  – 5.145.2
Connects - Contact Form 7 Addon: by Brainstorm Force – 1.1.1
Connects - Mailster Addon: by Brainstorm Force – 2.2.1
Connects - WooCommerce Checkout Form: by Brainstorm Force – 1.1.2 – Installed version not tested with active version of WooCommerce 4.5.0
Contact Form 7: by Takayuki Miyoshi – 5.2.1
Convert Plus: by Brainstorm Force – 3.5.6
Duplicate Page: by mndpsingh287 – 4.3
Easy WP SMTP: by wpecommerce
alexanderfoxc – 1.4.1

Email Template: by Asif Amod – 1.0.3
Enhanced E-commerce for Woocommerce store: by Tatvic – 2.3.5 – Installed version not tested with active version of WooCommerce 4.5.0
Froged: by Froged Technologies – 1.0.7 – Installed version not tested with active version of WooCommerce 4.5.0
Imagify: by WP Media – 1.9.10
Mailster SendGrid Integration: by EverPress – 2.1
Mailster for WooCommerce: by EverPress – 1.4 – Installed version not tested with active version of WooCommerce 4.5.0
Mailster - Email Newsletter Plugin for WordPress: by EverPress – 2.4.14
Max Mega Menu: by megamenu.com – 2.9.0.2
Ninja Forms: by Saturday Drive – 3.4.26
Product CSV Import Export (BASIC): by WebToffee – 1.8.3 – Installed version not tested with active version of WooCommerce 4.5.0
reCaptcha for WooCommerce: by I Thirteen Web Solution – 1.0.13 – Installed version not tested with active version of WooCommerce 4.5.0
SearchWP WooCommerce Integration: by SearchWP – 1.3.9 – Installed version not tested with active version of WooCommerce 4.5.0
SearchWP: by SearchWP
LLC – 3.1.15

ShoppingFeeder: by ShoppingFeeder – 1.3.6 – Installed version not tested with active version of WooCommerce 4.5.0
Simple Social Page Widget & Shortcode: by Dylan Ryan – 1.7.0
TI WooCommerce Wishlist: by TemplateInvaders – 1.21.1 – Installed version not tested with active version of WooCommerce 4.5.0
Widget Shortcode: by Hassan Derakhshandeh – 0.3.5
Woocomerce Brands Pro: by Proword – 4.3.9 – Installed version not tested with active version of WooCommerce 4.5.0
WooCommerce Bulk Edit Product Variations: by matterico_themes – 2.7 – Installed version not tested with active version of WooCommerce 4.5.0
Product Slider for WooCommerce: by ShapedPlugin – 2.2.3 – Installed version not tested with active version of WooCommerce 4.5.0
WooCommerce Admin: by WooCommerce – 1.5.0 – Installed version not tested with active version of WooCommerce 4.5.0
WooCommerce Advanced Bulk Edit: by George Iron – 4.4.4 – Installed version not tested with active version of WooCommerce 4.5.0
Woocommerce API: by Asif – 2.0 – Installed version not tested with active version of WooCommerce 4.5.0
WooCommerce Extra Product Sorting Options: by SkyVerge – 2.8.4 – Installed version not tested with active version of WooCommerce 4.5.0
Fastway for WooCommerce: by Fastway – 1.1.3 – Installed version not tested with active version of WooCommerce 4.5.0
Virtual Card Services Payment Gateway: by VCS – 1 – Installed version not tested with active version of WooCommerce 4.5.0
More Sorting Options for WooCommerce: by WP Wham – 3.2.5 – Installed version not tested with active version of WooCommerce 4.5.0
WooCommerce MultiStep Checkout: by Kole Roy – 2.5 – Installed version not tested with active version of WooCommerce 4.5.0
WooCommerce PayFast Gateway: by WooCommerce – 1.4.15 – Installed version not tested with active version of WooCommerce 4.5.0
WooCommerce Product Bundles: by SomewhereWarm – 5.4.0 – Installed version not tested with active version of WooCommerce 4.5.0
WooCommerce: by Automattic – 4.5.0 (update to version 4.5.2 is available)
Yoast SEO Premium: by Team Yoast – 12.5
WP Cloudflare Super Page Cache: by Salvatore Fresta – 4.3.6
WP File Manager: by mndpsingh287 – 6.9
WP-Optimize - Clean, Compress, Cache: by David Anderson
Ruhani Rabin
Team Updraft – 3.1.2

WP Rocket: by WP Media – 3.3.6
WhatsApp Click to Chat: by Indie Plugins – 2.2.1
YITH WooCommerce Product Countdown Premium: by YITH – 1.4.0 – Installed version not tested with active version of WooCommerce 4.5.0
YITH WooCommerce Review Reminder: by YITH – 1.6.6 – Installed version not tested with active version of WooCommerce 4.5.0
Zapper Payments for WooCommerce: by Zapper Development – 2.1.3 – Installed version not tested with active version of WooCommerce 4.5.0

### Inactive Plugins (4) ###

EWWW Image Optimizer: by Exactly WWW – 5.7.0
Woocommerce Waitlist( Back in stock notifier ): by  – 2.4 – Installed version not tested with active version of WooCommerce 4.5.0
WP Cerber Security, Anti-spam & Malware Scan: by Cerber Tech Inc. – 8.6.7
WP Crontrol: by John Blackbourn & crontributors – 1.8.5

### Dropin Plugins (1) ###

advanced-cache.php: advanced-cache.php

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

WP Time Capsule: by Revmakx –

### Settings ###

API Enabled: ?
Force SSL: ?
Currency: ZAR (R)
Currency Position: left
Thousand Separator: ,
Decimal Separator: .
Number of Decimals: 2
Taxonomies: Product Types: bundle (bundle)
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: –

### WC Pages ###

Shop base: #32770 - /shop/
Cart: #9 - /cart/
Checkout: #10 - /checkout/
My account: #11 - /my-account/
Terms and conditions: #2725 - /terms-conditions/

### Theme ###

Name: Flatsome Child
Version: 3.2
Author URL: 
Child Theme: ?
Parent Theme Name: Flatsome
Parent Theme Version: 3.12.2
Parent Theme Author URL: https://www.uxthemes.com/
WooCommerce Support: ?

### Templates ###

Overrides: flatsome-child/woocommerce/archive-product.php
flatsome-child/woocommerce/cart/cart-empty.php
flatsome-child/woocommerce/cart/cart-shipping.php
flatsome-child/woocommerce/cart/cart.php
flatsome-child/woocommerce/checkout/form-checkout.php
flatsome-child/woocommerce/checkout/form-coupon.php
flatsome-child/woocommerce/checkout/terms.php
flatsome-child/woocommerce/checkout/thankyou.php
flatsome-child/woocommerce/content-product.php
flatsome-child/woocommerce/content-product_cat.php
flatsome-child/woocommerce/content-single-product.php
flatsome-child/woocommerce/content-widget-product.php
flatsome-child/woocommerce/emails/admin-cancelled-order.php
flatsome-child/woocommerce/emails/admin-failed-order.php
flatsome-child/woocommerce/emails/admin-new-order.php
flatsome-child/woocommerce/emails/customer-completed-order.php
flatsome-child/woocommerce/emails/customer-invoice.php
flatsome-child/woocommerce/emails/customer-new-account.php
flatsome-child/woocommerce/emails/customer-note.php
flatsome-child/woocommerce/emails/customer-on-hold-order.php
flatsome-child/woocommerce/emails/customer-processing-order.php
flatsome-child/woocommerce/emails/customer-refunded-order.php
flatsome-child/woocommerce/emails/customer-reset-password.php
flatsome-child/woocommerce/emails/email-addresses.php
flatsome-child/woocommerce/emails/email-downloads.php
flatsome-child/woocommerce/emails/email-footer.php
flatsome-child/woocommerce/emails/email-header.php
flatsome-child/woocommerce/emails/email-order-details.php
flatsome-child/woocommerce/emails/email-order-items.php
flatsome-child/woocommerce/emails/email-styles.php
flatsome-child/woocommerce/global/breadcrumb.php
flatsome-child/woocommerce/global/quantity-input.php
flatsome-child/woocommerce/global/wrapper-end.php
flatsome-child/woocommerce/global/wrapper-start.php
flatsome-child/woocommerce/loop/loop-end.php
flatsome-child/woocommerce/loop/loop-start.php
flatsome-child/woocommerce/loop/pagination.php
flatsome-child/woocommerce/loop/result-count.php
flatsome-child/woocommerce/loop/sale-flash.php
flatsome-child/woocommerce/myaccount/form-login.php
flatsome-child/woocommerce/myaccount/navigation.php
flatsome-child/woocommerce/notices/error.php
flatsome-child/woocommerce/notices/notice.php
flatsome-child/woocommerce/notices/success.php
flatsome-child/woocommerce/product-searchform.php
flatsome-child/woocommerce/single-product/photoswipe.php
flatsome-child/woocommerce/single-product/price.php
flatsome-child/woocommerce/single-product/product-image.php
flatsome-child/woocommerce/single-product/product-thumbnails.php
flatsome-child/woocommerce/single-product/rating.php
flatsome-child/woocommerce/single-product/related.php
flatsome-child/woocommerce/single-product/review.php
flatsome-child/woocommerce/single-product/sale-flash.php
flatsome-child/woocommerce/single-product/share.php
flatsome-child/woocommerce/single-product/short-description.php
flatsome-child/woocommerce/single-product/tabs/tabs.php
flatsome-child/woocommerce/single-product/title.php
flatsome-child/woocommerce/single-product/up-sells.php
flatsome-child/woocommerce/single-product-reviews.php version 3.6.0 is out of date. The core version is 4.3.0
flatsome-child/woocommerce/single-product.php

Outdated Templates: ?
					
					
						Learn how to update

### More Sorting Settings ###

More Sorting for WooCommerce: yes
Custom Sorting: no
Sort by date (ascending): 
Sort by date (descending): 
Sort by title: A to Z: 
Sort by title: Z to A: 
Sort by slug: A to Z: 
Sort by slug: Z to A: 
Sort by SKU: low to high: 
Sort by SKU: high to low: 
Sort by SKU: no
Sort by stock quantity: low to high: 
Sort by stock quantity: high to low: 
Sort by total sales: low to high: 
Sort by total sales: high to low: 
Sort by last modified date: oldest to newest: 
Sort by last modified date: newest to oldest: 
Sort by author ID (ascending): 
Sort by author ID (descending): 
Sort by product ID (ascending): 
Sort by product ID (descending): 
Sort by number of comments (ascending): 
Sort by number of comments (descending): 
Random sorting: 
No sorting: 
Custom Meta Sorting: no
Total Options: 1
Enable/Disable: yes
Type: meta_value
Meta Key: 
Secondary Sorting: none
Order: asc
Parameter: custom_sorting_1
Title: Custom Meta Sorting #1
Default Sorting Options: no
Default sorting: Default sorting
Sort by popularity: Sort by popularity
Remove "Sort by popularity": yes
Sort by average rating: Sort by average rating
Remove "Sort by average rating": yes
Sort by newness: Sort by newness
Remove "Sort by newness": yes
Sort by price: low to high: Sort by price: low to high
Remove "Sort by price: low to high": yes
Sort by price: high to low: Sort by price: high to low
Remove "Sort by price: high to low": yes
Rearrange Sorting: no
Rearrange Sorting: stock_quantity-asc
stock_quantity-desc
menu_order
popularity
rating
date
price
price-desc
date-asc
date-desc
title-asc
title-desc
name-asc
name-desc
sku-asc
sku-desc
total_sales-asc
total_sales-desc
modified-asc
modified-desc
author-asc
author-desc
product_id-asc
product_id-desc
comment_count-asc
comment_count-desc
rand
none
Remove All Sorting (Including WooCommerce Default): no
Enable/Disable: no
Theme: avada

### TI WooCommerce Wishlist Templates ###

Overrides: –

### Action Scheduler ###

Canceled: 502
Oldest: 2020-08-16 05:49:37 +0200
Newest: 2020-09-07 00:09:46 +0200

Complete: 19,601
Oldest: 2020-08-16 05:49:37 +0200
Newest: 2020-09-16 05:05:38 +0200

Pending: 2
Oldest: 2020-09-16 06:05:38 +0200
Newest: 2020-09-16 18:17:18 +0200
    Thread Starter amanzestgeek

    (@amanzestgeek)

    We just optimise the table yesterday. The index size of the WC_order_stats table yesterday was 171.5GB

    Hi,

    I have exactly the same problem.
    If anyone have a solution, please let me know ??
    Thank you!

    Hi Aman,

    Did you finally find a solution ?

    Thanks,
    N.

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘WC_order_stats table index size keeps growing to GBs’ is closed to new replies.