_wc_facebook_enhanced_catalog_attributes_size – Over 50mb
-
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.
-
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.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
`Thank you for sharing the logs!
I did some research and still can’t find any clues forwc_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 as2897.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. :)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.
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!
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.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!
- The topic ‘_wc_facebook_enhanced_catalog_attributes_size – Over 50mb’ is closed to new replies.