Frequent Error Establishing Database Connection error

Hello hookclothing

Thanks for contacting WooCommerce support.

I understand you are facing Error Establishing Database Connection error frequently in the last 3 months. You also mentioned that your host has told you that it is happening due to the large database.

To help you further, I’d like to understand more about your setup.
Could you please send me a copy of your site’s System Status?
You can find it via WooCommerce > Status.
Select Get system report and then Copy for support.

Once you’ve done that, you can paste the text in https://gist.github.com
After that, you can paste the Gist link here in your reply.

Looking forward to your response. ??

Hello @doublezed2

Thank you for your reply, I am unfamiliar with Gist, let me know if you’re able to view this link:

https://github.com/hookclothing/status

Thank you!

Thank you for reaching back, with further details on this, @hookclothing. The GitHub link returns an error, though.

As an alternative, feel free to utilize https://paste.mozilla.org/ instead, or paste it here in your response.

To get a copy of your site’s System Status, see here.

Looking forward to hearing from you!

Hi there, below is a copy of the system status

` WordPress Environment

WordPress address (URL): https://hookclothing.com<br>Site address (URL): https://hookclothing.com<br>WC Version: 8.4.0<br>REST API Version: ? 8.4.0<br>WC Blocks Version: ? 11.6.2<br>Action Scheduler Version: ? 3.7.0<br>Log Directory Writable: ?<br>WP Version: 6.4.2<br>WP Multisite: –<br>WP Memory Limit: ? 40 MB - We recommend setting memory to at least 64MB. See: Increasing memory allocated to PHP<br>WP Debug Mode: –<br>WP Cron: –<br>Language: en_US<br>External object cache: – Server Environment

Server Info: Apache<br>PHP Version: 7.4.33<br>PHP Post Max Size: 128 MB<br>PHP Time Limit: 300<br>PHP Max Input Vars: 10000<br>cURL Version: 8.5.0<br>OpenSSL/1.1.1w

SUHOSIN Installed: –<br>MySQL Version: 5.7.44<br>Max Upload Size: 128 MB<br>Default Timezone is UTC: ?<br>fsockopen/cURL: ?<br>SoapClient: ?<br>DOMDocument: ?<br>GZip: ?<br>Multibyte String: ?<br>Remote Post: ?<br>Remote Get: ? Database

WC Database Version: 8.4.0<br>WC Database Prefix: wp_<br>Total Database Size: 834.35MB<br>Database Data Size: 622.96MB<br>Database Index Size: 211.39MB<br>wp_woocommerce_sessions: Data: 80.45MB + Index: 3.66MB + Engine MyISAM<br>wp_woocommerce_api_keys: Data: 0.00MB + Index: 0.01MB + Engine MyISAM<br>wp_woocommerce_attribute_taxonomies: Data: 0.00MB + Index: 0.01MB + Engine MyISAM<br>wp_woocommerce_downloadable_product_permissions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_woocommerce_order_items: Data: 8.53MB + Index: 3.86MB + Engine MyISAM<br>wp_woocommerce_order_itemmeta: Data: 63.43MB + Index: 37.08MB + Engine MyISAM<br>wp_woocommerce_tax_rates: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_woocommerce_tax_rate_locations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_woocommerce_shipping_zones: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_woocommerce_shipping_zone_locations: Data: 0.00MB + Index: 0.01MB + Engine MyISAM<br>wp_woocommerce_shipping_zone_methods: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_woocommerce_payment_tokens: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_woocommerce_payment_tokenmeta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_woocommerce_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_actionscheduler_actions: Data: 1.60MB + Index: 0.65MB + Engine MyISAM<br>wp_actionscheduler_claims: Data: 0.00MB + Index: 0.01MB + Engine MyISAM<br>wp_actionscheduler_groups: Data: 0.00MB + Index: 0.01MB + Engine MyISAM<br>wp_actionscheduler_logs: Data: 1.08MB + Index: 0.74MB + Engine MyISAM<br>wp_commentmeta: Data: 0.40MB + Index: 0.29MB + Engine MyISAM<br>wp_comments: Data: 31.96MB + Index: 11.62MB + Engine MyISAM<br>wp_grab_state_code: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_hustle_entries: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_hustle_entries_meta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_hustle_modules: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_hustle_modules_meta: Data: 0.01MB + Index: 0.01MB + Engine MyISAM<br>wp_hustle_tracking: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_itsec_bans: Data: 0.00MB + Index: 0.01MB + Engine MyISAM<br>wp_itsec_dashboard_events: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_itsec_dashboard_lockouts: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_itsec_distributed_storage: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_itsec_fingerprints: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_itsec_firewall_rules: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>wp_itsec_geolocation_cache: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_itsec_lockouts: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_itsec_logs: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_itsec_mutexes: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_itsec_opaque_tokens: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_itsec_temp: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_itsec_user_groups: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_itsec_vulnerabilities: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>wp_links: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_nivoslider4wp: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_options: Data: 137.08MB + Index: 11.07MB + Engine MyISAM<br>wp_postmeta: Data: 160.40MB + Index: 71.42MB + Engine MyISAM<br>wp_posts: Data: 17.24MB + Index: 4.10MB + Engine MyISAM<br>wp_post_smtp_logmeta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_post_smtp_logs: Data: 9.02MB + Index: 0.00MB + Engine InnoDB<br>wp_pps_countries: Data: 0.01MB + Index: 0.00MB + Engine MyISAM<br>wp_pps_popup: Data: 0.61MB + Index: 0.00MB + Engine MyISAM<br>wp_pps_popup_show_categories: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_smush_dir_images: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_social_users: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_swift_performance_image_optimizer: Data: 11.68MB + Index: 2.50MB + Engine MyISAM<br>wp_swift_performance_warmup: Data: 0.27MB + Index: 0.33MB + Engine InnoDB<br>wp_termmeta: Data: 0.01MB + Index: 0.02MB + Engine MyISAM<br>wp_terms: Data: 0.00MB + Index: 0.01MB + Engine MyISAM<br>wp_term_relationships: Data: 0.21MB + Index: 0.39MB + Engine MyISAM<br>wp_term_taxonomy: Data: 0.00MB + Index: 0.01MB + Engine MyISAM<br>wp_usermeta: Data: 51.41MB + Index: 22.11MB + Engine MyISAM<br>wp_users: Data: 2.49MB + Index: 1.64MB + Engine MyISAM<br>wp_user_registration_sessions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_vtprd_purchase_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_vtprd_purchase_log_product: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_vtprd_purchase_log_product_rule: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_wcpdf_invoice_number: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wc_admin_notes: Data: 0.08MB + Index: 0.00MB + Engine MyISAM<br>wp_wc_admin_note_actions: Data: 0.04MB + Index: 0.01MB + Engine MyISAM<br>wp_wc_category_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_wc_customer_lookup: Data: 1.57MB + Index: 0.97MB + Engine MyISAM<br>wp_wc_download_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_wc_orders: Data: 0.02MB + Index: 0.11MB + Engine InnoDB<br>wp_wc_orders_meta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_wc_order_addresses: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>wp_wc_order_coupon_lookup: Data: 0.05MB + Index: 0.08MB + Engine MyISAM<br>wp_wc_order_operational_data: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_wc_order_product_lookup: Data: 4.70MB + Index: 3.41MB + Engine MyISAM<br>wp_wc_order_stats: Data: 1.64MB + Index: 0.89MB + Engine MyISAM<br>wp_wc_order_tax_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_wc_product_attributes_lookup: Data: 0.09MB + Index: 0.06MB + Engine InnoDB<br>wp_wc_product_download_directories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_wc_product_meta_lookup: Data: 0.44MB + Index: 0.43MB + Engine MyISAM<br>wp_wc_rate_limits: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_wc_reserved_stock: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_wc_tax_rate_classes: Data: 0.00MB + Index: 0.01MB + Engine MyISAM<br>wp_wc_webhooks: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_wfBadLeechers: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wfBlockedCommentLog: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_wfBlockedIPLog: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wfBlocks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_wfBlocks7: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_wfBlocksAdv: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wfConfig: Data: 0.38MB + Index: 0.00MB + Engine InnoDB<br>wp_wfCrawlers: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wfFileChanges: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_wfFileMods: Data: 2.52MB + Index: 0.00MB + Engine InnoDB<br>wp_wfHits: Data: 1.52MB + Index: 0.28MB + Engine InnoDB<br>wp_wfHoover: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_wfIssues: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>wp_wfKnownFileList: Data: 1.52MB + Index: 0.00MB + Engine InnoDB<br>wp_wfLeechers: Data: 0.39MB + Index: 0.00MB + Engine InnoDB<br>wp_wfLiveTrafficHuman: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_wfLockedOut: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wfLocs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wfLogins: Data: 0.25MB + Index: 0.06MB + Engine InnoDB<br>wp_wfNet404s: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_wfNotifications: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wfPendingIssues: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_wfReverseCache: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wfScanners: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wfSNIPCache: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>wp_wfStatus: Data: 0.13MB + Index: 0.09MB + Engine InnoDB<br>wp_wfThrottleLog: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_wfTrafficRates: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_wfVulnScanners: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wpmailsmtp_tasks_meta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_yith_wcwl: Data: 12.06MB + Index: 9.37MB + Engine MyISAM<br>wp_yith_wcwl_lists: Data: 17.09MB + Index: 23.52MB + Engine MyISAM Post Type Counts

amn_mi-lite: 4<br>apifw_inv_templates: 1<br>attachment: 13089<br>custom_css: 1<br>itsec-dash-card: 4<br>itsec-dashboard: 1<br>jetpack_migration: 2<br>nav_menu_item: 48<br>page: 27<br>popup_theme: 6<br>post: 1<br>postman_sent_mail: 250<br>product: 1907<br>product_variation: 2598<br>revision: 3<br>shop_coupon: 239<br>shop_order: 38356<br>shop_order_refund: 1<br>soliloquy: 1<br>user_registration: 1<br>wcpa_pt_forms: 1<br>wooframework: 6<br>wp_email_images: 1 Security

Secure connection (HTTPS): ?<br>Hide errors from visitors: ? Active Plugins (26)

Country Based Payments for WooCommerce: by Ivan Paulin – 1.4.4.1<br>Add Admin CSS: by Scott Reilly – 2.0.1<br>AfterShip Tracking - All-In-One WooCommerce Order Tracking (Free plan available): by AfterShip – 1.17.7<br>Akismet Anti-spam: Spam Protection: by Automattic - Anti-spam Team – 5.3<br>Solid Security Basic: by SolidWP – 9.2.0<br>Classic Editor: by WordPress Contributors – 1.6.3<br>Facebook for WooCommerce: by Facebook – 3.1.6<br>Heartbeat Control by WP Rocket: by WP Rocket – 2.0.1<br>Hide Admin Bar: by David Vongries – 1.0<br>Login No Captcha reCAPTCHA (Google): by Robert Peake and Contributors – 1.7.2<br>MailChimp for WordPress Lite: by ibericode – 2.3.14<br>Points and Rewards for WooCommerce: by WP Swings – 2.1.1<br>Post SMTP: by Post SMTP – 2.8.8<br>Post Types Order: by Nsp Code – 2.1.2<br>Really Simple SSL: by Really Simple Plugins – 7.2.1<br>Recently Registered: by Mika Epstein – 3.5<br>Super Socializer: by Team Heateor – 7.13.63<br>Swift Performance: by SWTE – 2.3.6.15<br>UpdraftPlus - Backup/Restore: by UpdraftPlus.Com<br>DavidAnderson – 1.23.16

WC Hide Shipping Methods: by Rynaldo Stoltz – 1.5<br>WooCommerce Extended Coupon Features FREE: by Soft79 – 3.3.3<br>Table Rate Shipping for WooCommerce: by JEM Plugins – 2.28<br>GrabPay for WooCommerce: by GrabPay – 2.0.4<br>WooCommerce iPay88 Payment Gateway: by VanboDevelops – 1.1.1 (update to version 1.5.2 is available)<br>WooCommerce: by Automattic – 8.4.0<br>YITH WooCommerce Wishlist: by YITH – 3.28.0 Inactive Plugins (2)

Currency Switcher for WooCommerce: by WP Wham – 2.15.2<br>Swift Performance Cache Me - WP Fix It: by WP Fix It – 2.2 Must Use Plugins (1)

Swift Performance early loader: by – Settings

API Enabled: ?<br>Force SSL: –<br>Currency: MYR (RM)<br>Currency Position: left<br>Thousand Separator: ,<br>Decimal Separator: .<br>Number of Decimals: 2<br>Taxonomies: Product Types: external (external)<br>grouped (grouped)<br>simple (simple)<br>variable (variable)

Taxonomies: Product Visibility: exclude-from-catalog (exclude-from-catalog)<br>exclude-from-search (exclude-from-search)<br>featured (featured)<br>outofstock (outofstock)<br>rated-1 (rated-1)<br>rated-2 (rated-2)<br>rated-3 (rated-3)<br>rated-4 (rated-4)<br>rated-5 (rated-5)

Connected to Woo.com: ?<br>Enforce Approved Product Download Directories: –<br>HPOS feature screen enabled: –<br>HPOS feature enabled: –<br>Order datastore: WC_Order_Data_Store_CPT<br>HPOS data sync enabled: – WC Pages

Shop base: #7 - /shop-2/<br>Cart: #680 - /cart/<br>Checkout: #681 - /checkout/<br>My account: #682 - /my-account/<br>Terms and conditions: #513 - /terms-conditions/ Theme

Name: Flatsome<br>Version: 3.18.2<br>Author URL: https://uxthemes.com<br>Child Theme: ? – If you are modifying WooCommerce on a parent theme that you did not build personally we recommend using a child theme. See: How to create a child theme<br>WooCommerce Support: ? Templates

Overrides: flatsome/woocommerce/archive-product.php<br>flatsome/woocommerce/cart/cart-empty.php<br>flatsome/woocommerce/cart/cart-shipping.php<br>flatsome/woocommerce/cart/cart.php<br>flatsome/woocommerce/cart/mini-cart.php<br>flatsome/woocommerce/checkout/form-checkout.php<br>/home/hookclot/public_html/wp-content/plugins/points-and-rewards-for-woocommerce/public/woocommerce/checkout/form-coupon.php<br>flatsome/woocommerce/checkout/order-received.php<br>flatsome/woocommerce/checkout/terms.php<br>flatsome/woocommerce/checkout/thankyou.php<br>flatsome/woocommerce/content-product-cat.php<br>flatsome/woocommerce/content-product.php<br>flatsome/woocommerce/content-single-product.php<br>flatsome/woocommerce/content-widget-product.php<br>flatsome/woocommerce/global/breadcrumb.php<br>flatsome/woocommerce/global/quantity-input.php<br>flatsome/woocommerce/global/wrapper-end.php<br>flatsome/woocommerce/global/wrapper-start.php<br>flatsome/woocommerce/loop/loop-end.php<br>flatsome/woocommerce/loop/loop-start.php<br>flatsome/woocommerce/loop/pagination.php<br>flatsome/woocommerce/loop/rating.php<br>flatsome/woocommerce/loop/result-count.php<br>flatsome/woocommerce/loop/sale-flash.php<br>flatsome/woocommerce/myaccount/form-login.php<br>flatsome/woocommerce/myaccount/navigation.php<br>flatsome/woocommerce/notices/error.php<br>flatsome/woocommerce/notices/notice.php<br>flatsome/woocommerce/notices/success.php<br>flatsome/woocommerce/product-searchform.php<br>flatsome/woocommerce/single-product/photoswipe.php<br>flatsome/woocommerce/single-product/price.php<br>flatsome/woocommerce/single-product/product-image.php<br>flatsome/woocommerce/single-product/product-thumbnails.php<br>flatsome/woocommerce/single-product/rating.php<br>flatsome/woocommerce/single-product/related.php<br>flatsome/woocommerce/single-product/review.php<br>flatsome/woocommerce/single-product/sale-flash.php<br>flatsome/woocommerce/single-product/share.php<br>flatsome/woocommerce/single-product/short-description.php<br>flatsome/woocommerce/single-product/tabs/tabs.php<br>flatsome/woocommerce/single-product/title.php<br>flatsome/woocommerce/single-product/up-sells.php<br>flatsome/woocommerce/single-product-reviews.php<br>flatsome/woocommerce/single-product.php Admin

Enabled Features: activity-panels<br>analytics<br>product-block-editor<br>coupons<br>core-profiler<br>customer-effort-score-tracks<br>import-products-task<br>experimental-fashion-sample-products<br>shipping-smart-defaults<br>shipping-setting-tour<br>homescreen<br>marketing<br>mobile-app-banner<br>navigation<br>onboarding<br>onboarding-tasks<br>product-variation-management<br>product-virtual-downloadable<br>remote-inbox-notifications<br>remote-free-extensions<br>payment-gateway-suggestions<br>shipping-label-banner<br>subscriptions<br>store-alerts<br>transient-notices<br>woo-mobile-welcome<br>wc-pay-promotion<br>wc-pay-welcome-page

Disabled Features: customize-store<br>minified-js<br>new-product-management-experience<br>product-external-affiliate<br>settings<br>async-product-editor-category-field

Daily Cron: ? Next scheduled: 2024-01-09 08:22:38 +08:00<br>Options: ?<br>Notes: 195<br>Onboarding: completed Action Scheduler

Complete: 5,738<br>Oldest: 2023-12-09 05:19:19 +0000<br>Newest: 2024-01-09 04:51:55 +0000

Failed: 263<br>Oldest: 2022-11-12 17:54:09 +0000<br>Newest: 2023-06-30 08:11:26 +0000

Pending: 4<br>Oldest: 2024-01-09 05:39:59 +0000<br>Newest: 2024-01-09 13:24:56 +0000 Status report information

Generated at: 2024-01-09 12:57:33 +08:00<br>`

Hi @hookclothing,

The issue you’re experiencing is often due to a high volume of data requests that your hosting server can’t handle.

I’ve checked the system status reports you’ve shared and noticed that your database size is 622.96 MB. This may or may not be the root cause of the issue you’re experiencing. Nevertheless, I have a few suggestions to help you address this issue:

• Regularly optimize your database. It can help improve its performance. There are many plugins available that can help with this, such as WP-Optimize or Advanced Database Cleaner.
• If your website traffic and data have significantly increased over the years, it might be the best time to upgrade your hosting plan to one that can handle more traffic and data. I recommend you check WooExpress, a fast and secure hosting solution for WooCommerce.
• Use a caching plugin like WPRocket, FlyingPress, Jetpack Boost, or Cloudflare. It can significantly reduce the load on your server by storing frequently accessed data in a way that’s quicker to retrieve.
• Some theme and plugins can put a heavy load on your database. Review your theme and plugins and deactivate or replace unnecessary ones.

If the problem persists, consider hiring a professional to review your site and make necessary adjustments.

I wish I could help more, but hopefully, this gets you going in the right direction to get the job done.