• Resolved regalguy

    (@regalguy)


    I’ve been having issues with slow product pages and integration to other services which sync product data. We’ve noticed the field “_wc_facebook_enhanced_catalog_attributes_size” has a size size of over 50MB.

    It looks like it’s adding lots of garage data to the field such a loads of ‘\’ backslashes.

Viewing 14 replies - 1 through 14 (of 14 total)
  • Saif

    (@babylon1999)

    Hello @regalguy,

    Thank you for reaching out!

    We’ve noticed the field “_wc_facebook_enhanced_catalog_attributes_size” has a size size of over 50MB.

    Is that a database table? I can’t seem to find it on my test site.

    Can you please share more details about this along with some screenshots?

    Additionally, kindly attach a copy of your site’s system status report. 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 response.

    Look forward to hearing back from you.

    Thread Starter regalguy

    (@regalguy)

    Hi,

    I was given the field name by a developer who has trouble syncing products with their plugin.

    I did search the database for the field but couldn’t find it.

    I don’t have any screenshots as i’m not sure how that field was found.

    Please see system report below. Thank you

    WordPress Environment
    
    WordPress address (URL): https://www.regaldog.co.uk
    Site address (URL): https://www.regaldog.co.uk
    WC Version: 7.8.2
    REST API Version: ✔ 7.8.2
    WC Blocks Version: ✔ 10.2.4
    Action Scheduler Version: ✔ 3.5.4
    Log Directory Writable: ✔
    WP Version: 6.2.2
    WP Multisite: –
    WP Memory Limit: 2 GB
    WP Debug Mode: –
    WP Cron: –
    Language: en_GB
    External object cache: ✔ Server Environment Server Info: Apache/2.4.57 (Debian)
    PHP Version: 8.1.20
    PHP Post Max Size: 100 MB
    PHP Time Limit: 300
    PHP Max Input Vars: 10000
    cURL Version: 7.64.0
    OpenSSL/1.1.1n SUHOSIN Installed: –
    MySQL Version: 10.4.20-MariaDB-1:10.4.20+maria~buster-log
    Max Upload Size: 100 MB
    Default Timezone is UTC: ✔
    fsockopen/cURL: ✔
    SoapClient: ✔
    DOMDocument: ✔
    GZip: ✔
    Multibyte String: ✔
    Remote Post: ✔
    Remote Get: ✔ Database WC Database Version: 7.8.2
    WC Database Prefix: 475_
    Total Database Size: 2897.79MB
    Database Data Size: 2441.89MB
    Database Index Size: 455.90MB
    475_woocommerce_sessions: Data: 31.02MB + Index: 0.25MB + Engine InnoDB
    475_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    475_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    475_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    475_woocommerce_order_items: Data: 5.52MB + Index: 1.52MB + Engine InnoDB
    475_woocommerce_order_itemmeta: Data: 1233.69MB + Index: 43.14MB + Engine InnoDB
    475_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    475_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    475_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    475_woocommerce_shipping_zone_locations: Data: 0.05MB + Index: 0.03MB + Engine InnoDB
    475_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    475_woocommerce_payment_tokens: Data: 0.06MB + Index: 0.02MB + Engine InnoDB
    475_woocommerce_payment_tokenmeta: Data: 0.14MB + Index: 0.20MB + Engine InnoDB
    475_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    475_actionscheduler_actions: Data: 46.16MB + Index: 47.33MB + Engine InnoDB
    475_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    475_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    475_actionscheduler_logs: Data: 30.09MB + Index: 25.11MB + Engine InnoDB
    475_afwc_campaigns: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    475_afwc_commission_plans: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    475_afwc_hits: Data: 0.23MB + Index: 0.00MB + Engine InnoDB
    475_afwc_payouts: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    475_afwc_payout_orders: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    475_afwc_referrals: Data: 0.02MB + Index: 0.08MB + Engine InnoDB
    475_atum_order_itemmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    475_atum_order_items: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    475_atum_product_data: Data: 0.17MB + Index: 0.16MB + Engine InnoDB
    475_bv_fw_requests: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    475_bv_ip_store: Data: 0.28MB + Index: 0.16MB + Engine InnoDB
    475_bv_lp_requests: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    475_bwf_action_claim: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    475_bwf_contact: Data: 1.52MB + Index: 0.84MB + Engine InnoDB
    475_bwf_wc_customers: Data: 1.52MB + Index: 0.20MB + Engine InnoDB
    475_cleantalk_ac_log: Data: 0.22MB + Index: 0.00MB + Engine InnoDB
    475_cleantalk_connection_reports: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    475_cleantalk_no_cookie_data: Data: 3.02MB + Index: 0.00MB + Engine InnoDB
    475_cleantalk_sessions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    475_cleantalk_sfw: Data: 1.52MB + Index: 0.47MB + Engine InnoDB
    475_cleantalk_sfw_logs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    475_cleantalk_spamscan_logs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    475_cleantalk_ua_bl: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    475_cleantalk_wc_spam_orders: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    475_commentmeta: Data: 2.48MB + Index: 4.53MB + Engine InnoDB
    475_comments: Data: 33.56MB + Index: 32.66MB + Engine InnoDB
    475_cp_calculated_fields_form_discount_codes: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    475_cp_calculated_fields_form_posts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    475_cp_calculated_fields_form_revision: Data: 0.14MB + Index: 0.00MB + Engine InnoDB
    475_cp_calculated_fields_form_settings: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    475_failed_jobs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    475_fpd_products: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    475_fpd_views: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    475_hurrytimer_evergreen: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    475_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    475_ms_snippets: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    475_nm_personalized: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    475_options: Data: 5.50MB + Index: 0.23MB + Engine InnoDB
    475_postmeta: Data: 854.78MB + Index: 227.42MB + Engine InnoDB
    475_posts: Data: 10.48MB + Index: 5.77MB + Engine InnoDB
    475_po_plugins: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    475_queue: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    475_sbi_feeds: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    475_sbi_feed_caches: Data: 1.02MB + Index: 0.02MB + Engine InnoDB
    475_sbi_instagram_feeds_posts: Data: 0.09MB + Index: 0.06MB + Engine InnoDB
    475_sbi_instagram_feed_locator: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    475_sbi_instagram_posts: Data: 4.52MB + Index: 0.00MB + Engine InnoDB
    475_sbi_sources: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    475_snippets: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    475_spbc_auth_logs: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    475_spbc_backuped_files: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    475_spbc_backups: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    475_spbc_bfp_blocked: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    475_spbc_firewall_data: Data: 4.52MB + Index: 3.52MB + Engine InnoDB
    475_spbc_firewall_logs: Data: 0.05MB + Index: 0.00MB + Engine InnoDB
    475_spbc_firewall__personal_countries: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    475_spbc_firewall__personal_ips: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    475_spbc_monitoring_users: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    475_spbc_scan_frontend: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    475_spbc_scan_links_logs: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    475_spbc_scan_results: Data: 4.52MB + Index: 1.52MB + Engine InnoDB
    475_spbc_scan_results_log: Data: 1.52MB + Index: 1.52MB + Engine InnoDB
    475_spbc_scan_signatures: Data: 0.13MB + Index: 0.05MB + Engine InnoDB
    475_spbc_sessions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    475_spbc_traffic_control_logs: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    475_stock_log: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    475_termmeta: Data: 16.52MB + Index: 0.30MB + Engine InnoDB
    475_terms: Data: 0.05MB + Index: 0.03MB + Engine InnoDB
    475_term_relationships: Data: 0.19MB + Index: 0.13MB + Engine InnoDB
    475_term_taxonomy: Data: 0.05MB + Index: 0.03MB + Engine InnoDB
    475_tm_taskmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    475_tm_tasks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    475_usermeta: Data: 109.56MB + Index: 33.48MB + Engine InnoDB
    475_users: Data: 1.52MB + Index: 1.05MB + Engine InnoDB
    475_wcfm_enquiries: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    475_wcfm_messages: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    475_wcfm_support: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    475_wc_admin_notes: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    475_wc_admin_note_actions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    475_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    475_wc_customer_lookup: Data: 1.52MB + Index: 1.81MB + Engine InnoDB
    475_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    475_wc_order_coupon_lookup: Data: 0.34MB + Index: 0.41MB + Engine InnoDB
    475_wc_order_product_lookup: Data: 4.52MB + Index: 5.86MB + Engine InnoDB
    475_wc_order_stats: Data: 2.52MB + Index: 2.25MB + Engine InnoDB
    475_wc_order_tax_lookup: Data: 1.52MB + Index: 0.72MB + Engine InnoDB
    475_wc_product_attributes_lookup: Data: 0.08MB + Index: 0.06MB + Engine InnoDB
    475_wc_product_download_directories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    475_wc_product_meta_lookup: Data: 0.23MB + Index: 0.44MB + Engine InnoDB
    475_wc_rate_limits: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    475_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    475_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    475_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    475_wfacp_stats: Data: 0.05MB + Index: 0.06MB + Engine InnoDB
    475_wfco_connectormeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    475_wfco_connectors: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    475_wfco_report_views: Data: 0.06MB + Index: 0.08MB + Engine InnoDB
    475_wfob_stats: Data: 0.45MB + Index: 0.50MB + Engine InnoDB
    475_wfocu_event: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    475_wfocu_event_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    475_wfocu_session: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    475_woobe_history: Data: 2.52MB + Index: 2.13MB + Engine InnoDB
    475_woobe_history_bulk: Data: 0.03MB + Index: 0.03MB + Engine InnoDB
    475_woocommerce_gc_activity: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    475_woocommerce_gc_cards: Data: 0.05MB + Index: 0.06MB + Engine InnoDB
    475_woocommerce_gc_cardsmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    475_wpforms_entries: Data: 8.52MB + Index: 0.13MB + Engine InnoDB
    475_wpforms_entry_fields: Data: 3.52MB + Index: 4.34MB + Engine InnoDB
    475_wpforms_entry_meta: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    475_wpforms_payments: Data: 0.02MB + Index: 0.14MB + Engine InnoDB
    475_wpforms_payment_meta: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    475_wpforms_tasks_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    475_wpf_filters: Data: 0.05MB + Index: 0.00MB + Engine InnoDB
    475_wplc_webhooks: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    475_wpmailsmtp_debug_events: Data: 0.11MB + Index: 0.00MB + Engine InnoDB
    475_wpmailsmtp_emails_log: Data: 0.30MB + Index: 0.06MB + Engine InnoDB
    475_wpmailsmtp_email_tracking_events: Data: 1.02MB + Index: 0.03MB + Engine InnoDB
    475_wpmailsmtp_email_tracking_links: Data: 1.02MB + Index: 1.02MB + Engine InnoDB
    475_wpmailsmtp_tasks_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    475_wsal_metadata: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    475_wsal_options: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    475_wt_iew_action_history: Data: 0.08MB + Index: 0.00MB + Engine InnoDB
    475_wt_iew_mapping_template: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    475_yith_wcwl: Data: 0.06MB + Index: 0.02MB + Engine InnoDB
    475_yith_wcwl_lists: Data: 0.06MB + Index: 0.03MB + Engine InnoDB
    475_yoast_indexable: Data: 0.45MB + Index: 0.33MB + Engine InnoDB
    475_yoast_indexable_hierarchy: Data: 0.05MB + Index: 0.05MB + Engine InnoDB
    475_yoast_migrations: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    475_yoast_primary_term: Data: 0.05MB + Index: 0.03MB + Engine InnoDB
    475_yoast_prominent_words: Data: 0.19MB + Index: 0.28MB + Engine InnoDB
    475_yoast_seo_links: Data: 1.50MB + Index: 0.31MB + Engine InnoDB
    475_yoast_seo_meta: Data: 1.52MB + Index: 0.00MB + Engine InnoDB
    wp_actionscheduler_actions: Data: 0.02MB + Index: 0.11MB + Engine InnoDB
    wp_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_actionscheduler_logs: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_bv_fw_requests: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_bv_ip_store: Data: 0.23MB + Index: 0.14MB + Engine InnoDB
    wp_bv_lp_requests: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_comments: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
    wp_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_options: Data: 0.22MB + Index: 0.03MB + Engine InnoDB
    wp_postmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_posts: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    wp_termmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_terms: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_term_relationships: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_term_taxonomy: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_usermeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_users: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wp_wc_admin_notes: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wc_admin_note_actions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wc_customer_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_wc_order_product_lookup: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    wp_wc_order_stats: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wp_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_wc_product_attributes_lookup: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_wc_product_download_directories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_wc_product_meta_lookup: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
    wp_wc_rate_limits: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    wp_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_woocommerce_order_itemmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_woocommerce_order_items: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_woocommerce_sessions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    wp_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB Post Type Counts amn_wpforms-lite: 2
    attachment: 1692
    blocks: 85
    br_product_filter: 4
    brb_collection: 2
    bwg_gallery: 1
    bwg_share: 1
    carousels: 1
    cartflows_flow: 2
    cartflows_step: 5
    country_restriction: 1
    custom_css: 8
    customize_changeset: 9
    cwginstocknotifier: 160
    docs: 19
    epkb_post_type_1: 6
    hurrytimer_countdown: 8
    jetpack_migration: 2
    jp_img_sitemap: 1
    jp_sitemap: 1
    jp_sitemap_master: 1
    mc4wp-form: 1
    mkb_faq: 1
    nav_menu_item: 175
    oembed_cache: 54
    page: 97
    post: 143
    product: 192
    product_variation: 644
    sa_slider: 2
    shop_coupon: 144
    shop_order: 15746
    shop_order_refund: 988
    sp_wps_shortcodes: 1
    thppopuptemplate: 1
    tm_global_cp: 9
    ux_template: 5
    vpc-config: 15
    vpc-text-component: 4
    wccaf: 2
    wcccf: 6
    wccpf: 2
    wcct_countdown: 9
    wcp_ruleset: 7
    wcpa_pt_forms: 2
    wcps: 1
    wcst_trigger: 7
    wfacp_checkout: 4
    wfob_bump: 6
    wfocu_funnel: 3
    wfocu_offer: 3
    woo-audit-log: 1119
    wp_global_styles: 1
    wpforms: 13
    xlwcty_thankyou: 1 Security Secure connection (HTTPS): ✔
    Hide errors from visitors: ✔ Active Plugins (47) Admin Menu Editor Pro: by Janis Elsts – 2.20
    Affiliate For WooCommerce: by StoreApps – 6.17.0
    ATUM Inventory Management for WooCommerce: by Stock Management Labs™ – 1.9.31.1
    Back In Stock Notifier for WooCommerce | WooCommerce Waitlist Pro: by codewoogeek – 4.0.0
    Breeze: by Cloudways – 2.0.26
    Anti-Spam by CleanTalk: by СleanTalk – 6.12
    Clearpay Gateway for WooCommerce: by Clearpay – 3.5.4
    GTM4WP: by Thomas Geiger – 1.16.2
    Facebook for WooCommerce: by Facebook – 3.0.26
    Flexible Shipping PRO: by Octolize – 2.16.1
    Flexible Shipping: by Octolize – 4.21.4
    Gift Cards - Coupon Input: by SomewhereWarm – 1.0.2
    HurryTimer PRO: by Nabil Lemsieh – 2.10.1
    Index WP MySQL For Speed: by Oliver Jones
    Rick James – 1.4.13 Instagram Feed Pro Business: by Smash Balloon – 6.2.4
    Jetpack: by Automattic – 12.2.1
    Kadence WooCommerce Email Designer: by Kadence WP – 1.5.11
    Klaviyo: by Klaviyo
    Inc. – 3.1.0 Perfmatters: by forgemedia – 2.1.3
    Custom Estimated Delivery Date Format: by PluginHive – 1.0.1
    Product Catalog Feed Pro by PixelYourSite: by PixelYourSite – 5.3.3
    TikTok: by TikTok – 1.1.2
    UK Address Postcode Validation: by Ideal Postcodes – 3.3.1
    Upsell Order Bump Offer for WooCommerce Pro: by WP Swings – 2.1.4
    Upsell Order Bump Offer for WooCommerce: by WP Swings – 2.2.3
    Visual Products Configurator Custom Text Addon: by Orion – 3.2.1
    Visual Products Configurator: by ORION – 7.5
    VPC Color pattern: by Orion – 1.0.0
    Estimated Delivery Date Plugin For WooCommerce: by PluginHive – 2.1.3
    NextMove Lite - Thank You Page for WooCommerce: by XLPlugins – 2.16.0
    WooCommerce Extended Coupon Features PRO: by Soft79 – 3.3.2
    WooCommerce Cost of Goods: by SkyVerge – 2.13.0
    WooCommerce Stripe Gateway: by WooCommerce – 7.4.1
    WooCommerce Gift Cards: by WooCommerce – 1.16.3
    WooCommerce Payments: by Automattic – 6.1.1
    WooCommerce Photo Reviews Premium: by VillaTheme – 1.3.10
    Product SKU Generator for WooCommerce: by SkyVerge – 2.4.8
    WooCommerce - ShipStation Integration: by WooCommerce – 4.3.2 (update to version 4.3.7 is available)
    Extra Product Options & Add-Ons for WooCommerce: by ThemeComplete – 6.3.2
    WooCommerce: by Automattic – 7.8.2
    Yoast SEO Premium: by Team Yoast – 20.8
    Yoast SEO: by Team Yoast – 20.10
    WP Mail SMTP Pro: by WP Mail SMTP – 3.8.1
    WPForms Conversational Forms: by WPForms – 1.11.0
    WPForms Zapier: by WPForms – 1.5.0
    WPForms: by WPForms – 1.8.2.2
    YITH WooCommerce Wishlist: by YITH – 3.22.0 Inactive Plugins (2) BEAR – Bulk Editor and Products Manager Professional for WooCommerce: by realmag777 – 2.1.3.2
    Country Restrictions for WooCommerce: by Addify – 1.4.1 Dropin Plugins (2) advanced-cache.php: advanced-cache.php
    object-cache.php: Object Cache Pro (Drop-in) Must Use Plugins (2) Index WP MySQL For Speed Upgrade Filter for mu-plugins.: by – 1.4.11
    Object Cache Pro (MU): by Rhubarb Group – 1.18.2 Settings API Enabled: ✔
    Force SSL: ✔
    Currency: GBP (£)
    Currency Position: left
    Thousand Separator: ,
    Decimal Separator: .
    Number of Decimals: 2
    Taxonomies: Product Types: bundle (bundle)
    external (external)
    grouped (grouped)
    pw gift card (pw-gift-card)
    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)
    visible (visible) Connected to WooCommerce.com: ✔
    Enforce Approved Product Download Directories: –
    HPOS feature screen enabled: –
    HPOS feature enabled: –
    Order datastore: WC_Order_Data_Store_CPT
    HPOS data sync enabled: – WC Pages Shop base: #6 - /shop/
    Basket: #7 - /cart/
    Checkout: #8 - /checkout/
    My account: #9 - /my-account/
    Terms and conditions: #208 - /terms-and-conditions/ Theme Name: Flatsome Child
    Version: 3.0
    Author URL:
    Child Theme: ✔
    Parent Theme Name: Flatsome
    Parent Theme Version: 3.17.3
    Parent Theme Author URL: https://uxthemes.com
    WooCommerce Support: ✔ Templates Overrides: flatsome/woocommerce/archive-product.php
    flatsome/woocommerce/cart/cart-empty.php
    flatsome/woocommerce/cart/cart-shipping.php
    flatsome/woocommerce/cart/cart.php
    flatsome/woocommerce/checkout/form-checkout.php
    flatsome/woocommerce/checkout/form-coupon.php
    flatsome/woocommerce/checkout/terms.php
    flatsome/woocommerce/checkout/thankyou.php
    flatsome/woocommerce/content-product-cat.php
    flatsome/woocommerce/content-product.php
    flatsome/woocommerce/content-single-product.php
    flatsome/woocommerce/content-widget-product.php
    flatsome/woocommerce/global/breadcrumb.php
    flatsome/woocommerce/global/quantity-input.php
    flatsome/woocommerce/global/wrapper-end.php
    flatsome/woocommerce/global/wrapper-start.php
    flatsome/woocommerce/loop/loop-end.php
    flatsome/woocommerce/loop/loop-start.php
    flatsome/woocommerce/loop/pagination.php
    flatsome/woocommerce/loop/rating.php
    flatsome/woocommerce/loop/result-count.php
    flatsome/woocommerce/loop/sale-flash.php
    flatsome/woocommerce/myaccount/form-login.php
    flatsome/woocommerce/myaccount/navigation.php
    flatsome/woocommerce/notices/error.php
    flatsome/woocommerce/notices/notice.php
    flatsome/woocommerce/notices/success.php
    flatsome/woocommerce/product-searchform.php
    flatsome/woocommerce/single-product/photoswipe.php
    flatsome/woocommerce/single-product/price.php
    flatsome/woocommerce/single-product/product-image.php
    flatsome/woocommerce/single-product/product-thumbnails.php
    flatsome/woocommerce/single-product/rating.php
    flatsome/woocommerce/single-product/related.php
    flatsome/woocommerce/single-product/review.php
    flatsome/woocommerce/single-product/sale-flash.php
    flatsome/woocommerce/single-product/share.php
    flatsome/woocommerce/single-product/short-description.php
    flatsome/woocommerce/single-product/tabs/tabs.php
    flatsome/woocommerce/single-product/title.php
    flatsome/woocommerce/single-product/up-sells.php
    flatsome/woocommerce/single-product-reviews.php
    flatsome/woocommerce/single-product.php Gift Cards Database Version: 1.16.3
    Loopback Test: ✔
    Task Queueing Test: ✔ Admin Enabled Features: activity-panels
    analytics
    product-block-editor
    coupons
    customer-effort-score-tracks
    import-products-task
    experimental-fashion-sample-products
    shipping-smart-defaults
    shipping-setting-tour
    homescreen
    marketing
    mobile-app-banner
    navigation
    onboarding
    onboarding-tasks
    remote-inbox-notifications
    remote-free-extensions
    payment-gateway-suggestions
    shipping-label-banner
    subscriptions
    store-alerts
    transient-notices
    woo-mobile-welcome
    wc-pay-promotion
    wc-pay-welcome-page Disabled Features: core-profiler
    minified-js
    new-product-management-experience
    product-variation-management
    settings
    async-product-editor-category-field Daily Cron: ✔ Next scheduled: 2023-07-04 13:01:58 +01:00
    Options: ✔
    Notes: 11
    Onboarding: completed WooCommerce Payments Version: 6.1.1
    Connected to WPCOM: Yes
    Blog ID: 142766104
    Account ID: acct_1JrUPG2EitTUPaYz Action Scheduler Complete: 126,868
    Oldest: 2023-03-28 17:21:47 +0100
    Newest: 2023-07-04 14:00:03 +0100 Failed: 892
    Oldest: 2022-07-21 15:17:04 +0100
    Newest: 2023-06-29 14:00:09 +0100 Pending: 23
    Oldest: 2023-07-04 14:00:03 +0100
    Newest: 2023-07-08 08:00:04 +0100 Status report information Generated at: 2023-07-04 14:15:55 +01:00
    `
    Saif

    (@babylon1999)

    Thank you for sharing the logs!

    I did some research and still can’t find any clues for wc_facebook_enhanced_catalog_attributes_size .

    If you can ask the developer to provide more context, we’ll be more than happy to investigate further.

    In the meantime, you can check this guide on how to optimize your database size as 2897.79MB is defiantly out of the ordinary: https://world.siteground.com/kb/reduce-database-size-wordpress/

    Let us know if you have any other questions. :‎)

    Thread Starter regalguy

    (@regalguy)

    Thanks for your tips o optimising the database, i already do this daily. It is quite a large ecommerce store.

    I’ve managed found the “_wc_facebook_enhanced_catalog_attributes_size” under X_postmeta table

    Howdy @regalguy

    I’ve managed found the “_wc_facebook_enhanced_catalog_attributes_size” under X_postmeta table

    As I understand, the following 2 related tables can be found in your site’s database:

    • 475_postmeta: Data: 854.78MB + Index: 227.42MB + Engine InnoDB
    • wp_postmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB

    With the first being quite large.

    Thanks for your tips o optimising the database, i already do this daily. It is quite a large ecommerce store.

    Nevertheless, the size of the meta table(s) indicates use of plugins that add meta boxes, too many images (WordPress stores the attachment meta data, compression details and alt tag details in post meta table), custom fields.

    My suggestion would be to try a plugin like “WP Optimze” or “WP Sweep” which can look at the table and remove unnecessary records.

    Thread Starter regalguy

    (@regalguy)

    Hi,

    Yes so “_wc_facebook_enhanced_catalog_attributes_size” is under “475_postmeta”

    I find WP-Optimize to be pretty basic like all other DB cleaners, it just does the standard optimise tables, delete transients and trashed posts etc. Unless I’m missing an option for removing unnecessary records? What option would be to remove unnecessary records?

    Thanks

    Howdy @regalguy

    Yes so “_wc_facebook_enhanced_catalog_attributes_size” is under “475_postmeta”

    I’m glad that this is clarified. Just to note, that table’s size is about 1GB so, yes, it appears it could use some optimization, indeed.

    I find WP-Optimize to be pretty basic like all other DB cleaners, it just does the standard optimise tables, delete transients and trashed posts etc. Unless I’m missing an option for removing unnecessary records? What option would be to remove unnecessary records?

    From what I gather, there is a developer already working with you.

    If otherwise, and you are needing help with customizations or troubleshooting WooCommerce and do not have a developer or company you can depend on, then we’ve got recommendations for you.

    Visit https://woocommerce.com/customizations/ to find the right agency or developer for your specific needs.

    I hope that helps!

    Thread Starter regalguy

    (@regalguy)

    Right, so going back to my orignal question:

    “I’ve been having issues with slow product pages and integration to other services which sync product data. We’ve noticed the field “_wc_facebook_enhanced_catalog_attributes_size” has a size size of over 50MB.

    It looks like it’s adding lots of garage data to the field such a loads of ‘\’ backslashes.”

    Can you please help?

    I don’t have a developer working with me. I’m trying to get some support for this plugin adding garbage data to my database

    Hi @regalguy,

    Are you by any chance adding backslashes or quotes to the size attributes field? if you are, removing them should resolve the issue.

    We fixed a related issue previously. I’ve reopened the issue to have our developers double-check that this isn’t a reoccurrence.

    Hello @regalguy,

    As @sukafia said, we did patch this issue previously. Essentially, what was happening was if the category attribute value contained a special char (“,) such as quotes or backslashes, the value would be escaped causing the backslashes to duplicate indefinitely.

    I can confirm the issue doesn’t happen anymore, which prompts me to believe that your case is a remnant of this bug (before the v2.6.29 release).

    Can you provide an excerpt of the affected SQL row? If we deleted the backlashes from SQL this should resolve the problem the issue.

    Thread Starter regalguy

    (@regalguy)

    Thank you all for your Input. I’ve spent the day deleting all the extra backslashes I can find. Everything seems to be working much better now, product pages load lighting fast and all my products sync correctly to third parties.

    @regalguy

    Glad to hear it! Thank you for sharing this update with us.

    If you have any further questions, I recommend creating a new thread.

    I had the same issue. To fix it, I exported all the products as a csv file and deleted all the “\” in meta attributes and Imported back in. Seem to have done the job. No idea why the attributes would populate with “\”.

    Hi @mj51234

    I had the same issue. To fix it, I exported all the products as a csv file and deleted all the “\” in meta attributes and Imported back in. Seem to have done the job. No idea why the attributes would populate with “\”.

    That’s great to hear! A nice, hands-on workaround.

    Thank you so much for adding your input! Some of our customers might indeed find this guide helpful!

    For context, the attributes would populate with extra backlashes / due to the #2353 bug, that is now fixed.

    We appreciate you being an active part of the community 🙂

    Have a wonderful day!

Viewing 14 replies - 1 through 14 (of 14 total)
  • The topic ‘_wc_facebook_enhanced_catalog_attributes_size – Over 50mb’ is closed to new replies.