Site losing database connection while using admin

  • Hi,

    I have done a WordPress with Woocommerce site for one of my client https://aarshifashions.com.

    Since last 8-10 days, she is facing frequent issues while working on the admin side.

    Some time it works fine, but many a times, when she tries to update a product or a page, it takes a long time after clicking the Update button and then is shows Database connection error.

    I also tried at my end got these errors.

    I got this while updating a product.
    “Connection lost. Saving has been disabled until you’re reconnected. We’re backing up this post in your browser, just in case.”

    See the screen shot here – https://prntscr.com/pwpp4n

    When I refreshed the page it gave me this error – https://prntscr.com/pwppm7
    Even the main website url gave me the same error. https://prntscr.com/pwps6f

    I viewed the error log today and found these entries.
    https://zerobin.net/?002c067f8b952375#IThZx1poYO4fLdpOA8YzXEXOFGbQCmeDpDYjJmcK9z0=

    I contact the support team of the hosting company and they said I need to optimize the mysql queries.

    This is what exactly I have been told by them.

    “When the queries take more than 21 seconds to execute and do not get executed.
    That time it gives that Error of Error connecting to database.
    You will need to optimize your queries so that it does not take greater than 21 Seconds to execute.”

    Please help me out to fix this problem as my client is very annoyed.

    Thanks in advance.

    Regards
    Ketan Shah

Viewing 3 replies - 1 through 3 (of 3 total)

  • It looks like all failing queries are related to the wp_options table. Can you paste the WooCommerce System Status Report?

    Thread Starter k_shah_in

    (@k_shah_in)

    Hi,

    Thanks for responding.

    I have pasted the Woocommerce System Status Report below. You can also look at the screenshot of the same at this link. https://drive.google.com/open?id=1hAfZha4tg7iuyEawRBN5SxAIrR9lvXcZ

    WordPress environment
    WordPress address (URL): https://www.aarshifashions.com
    Site address (URL): https://www.aarshifashions.com
    WooCommerce version: 3.8.0
    WooCommerce REST API package: 1.0.2 /home/aarshvnf/public_html/wp-content/plugins/woocommerce/packages/woocommerce-rest-api
    Log directory writable: /home/aarshvnf/public_html/wp-content/uploads/wc-logs/
    WordPress version: 5.3
    WordPress multisite: –
    WordPress memory limit: 1 GB
    WordPress debug mode: –
    WordPress cron:
    Language: en_US
    External object cache:

    Server environment
    Server info: Apache/2.4.39 (cPanel) OpenSSL/1.0.2r mod_bwlimited/1.4 Phusion_Passenger/5.3.7
    PHP version: 7.0.33 – We recommend using PHP version 7.2 or above for greater performance and security. How to update your PHP version
    PHP post max size: 512 MB
    PHP time limit: 180
    PHP max input vars: 1000
    cURL version: 7.62.0, OpenSSL/1.0.2k
    SUHOSIN installed: –
    MySQL version: 5.6.41-84.1-log
    Max upload size: 512 MB
    Default timezone is UTC:
    fsockopen/cURL:
    SoapClient:
    DOMDocument:
    GZip:
    Multibyte string:
    Remote post:
    Remote get:

    Database
    WooCommerce database version: 3.8.0
    Database prefix wp_
    MaxMind GeoIP database: /home/aarshvnf/public_html/wp-content/uploads/GeoLite2-Country.mmdb
    Total Database Size 72.71MB
    Database Data Size 67.11MB
    Database Index Size 5.60MB
    wp_woocommerce_sessions Data: 50.61MB + Index: 1.91MB + Engine MyISAM
    wp_woocommerce_api_keys Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_woocommerce_attribute_taxonomies Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_woocommerce_downloadable_product_permissions Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_woocommerce_order_items Data: 0.02MB + Index: 0.01MB + Engine MyISAM
    wp_woocommerce_order_itemmeta Data: 0.13MB + Index: 0.10MB + Engine MyISAM
    wp_woocommerce_tax_rates Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_woocommerce_tax_rate_locations Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_woocommerce_shipping_zones Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_woocommerce_shipping_zone_locations Data: 0.36MB + Index: 0.38MB + Engine MyISAM
    wp_woocommerce_shipping_zone_methods Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_woocommerce_payment_tokens Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_woocommerce_payment_tokenmeta Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_woocommerce_log Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_blk_sms_logs Data: 0.03MB + Index: 0.00MB + Engine MyISAM
    wp_commentmeta Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wp_comments Data: 0.09MB + Index: 0.05MB + Engine MyISAM
    wp_links Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_ms_snippets Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_options Data: 1.57MB + Index: 0.13MB + Engine MyISAM
    wp_postmeta Data: 3.53MB + Index: 1.09MB + Engine MyISAM
    wp_posts Data: 1.37MB + Index: 0.21MB + Engine MyISAM
    wp_pum_subscribers Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_snippets Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_social_users Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_termmeta Data: 0.02MB + Index: 0.02MB + Engine MyISAM
    wp_terms Data: 0.01MB + Index: 0.03MB + Engine MyISAM
    wp_term_relationships Data: 0.14MB + Index: 0.30MB + Engine MyISAM
    wp_term_taxonomy Data: 0.01MB + Index: 0.02MB + Engine MyISAM
    wp_usermeta Data: 0.03MB + Index: 0.02MB + Engine MyISAM
    wp_users Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wp_wc_download_log Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_wc_product_meta_lookup Data: 0.04MB + Index: 0.06MB + Engine MyISAM
    wp_wc_tax_rate_classes Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wp_wc_webhooks Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_wfblockediplog Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_wfblocks7 Data: 0.01MB + Index: 0.01MB + Engine MyISAM
    wp_wfconfig Data: 3.23MB + Index: 0.01MB + Engine MyISAM
    wp_wfcrawlers Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_wffilechanges Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_wffilemods Data: 3.23MB + Index: 0.70MB + Engine MyISAM
    wp_wfhits Data: 0.43MB + Index: 0.08MB + Engine MyISAM
    wp_wfhoover Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_wfissues Data: 0.01MB + Index: 0.01MB + Engine MyISAM
    wp_wfknownfilelist Data: 1.73MB + Index: 0.22MB + Engine MyISAM
    wp_wflivetraffichuman Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_wflocs Data: 0.01MB + Index: 0.00MB + Engine MyISAM
    wp_wflogins Data: 0.05MB + Index: 0.02MB + Engine MyISAM
    wp_wfnotifications Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_wfpendingissues Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_wfreversecache Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_wfsnipcache Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_wfstatus Data: 0.43MB + Index: 0.16MB + Engine MyISAM
    wp_wftrafficrates Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_yith_wcwl Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_yith_wcwl_lists Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wp_yoast_seo_links Data: 0.01MB + Index: 0.00MB + Engine MyISAM
    wp_yoast_seo_meta Data: 0.01MB + Index: 0.02MB + Engine MyISAM

    Security
    Secure connection (HTTPS):
    Hide errors from visitors

    Active plugins (27)
    AfterShip – WooCommerce Tracking by AfterShip – 1.9.12 – Not tested with the active version of WooCommerce
    HTML in Category Descriptions by Arno Esterhuizen – 1.2.1.1
    Anti-spam by webvitaly – 5.5
    BULK SMS PLANS International SMS Notifications by Bulk SMS Plans Developer Team – 1.0
    Code Snippets by Shea Bunge – 2.13.3
    Contact Form 7 by Takayuki Miyoshi – 5.1.5
    Custom Order Numbers for WooCommerce by Tyche Softwares – 1.2.9 – Not tested with the active version of WooCommerce
    Customer Reviews for WooCommerce by ivole – 3.84 – Not tested with the active version of WooCommerce
    Nextend Social Login by Nextendweb – 3.0.20
    PW WooCommerce Bulk Edit by Pimwick, LLC – 2.61
    Ship to Different Address Unchecked for WooCommerce by eCreations – 1.2 – Not tested with the active version of WooCommerce
    Sucuri Security – Auditing, Malware Scanner and Hardening by Sucuri Inc. – 1.8.21
    Tawk.to Live Chat by Tawkto – 0.4.1
    Category Order and Taxonomy Terms Order by Nsp-Code – 1.5.7
    UpdraftPlus – Backup/Restore by UpdraftPlus.Com, DavidAnderson – 1.16.20
    W3 Total Cache by Frederick Townes – 0.10.2
    Conditional Discounts for WooCommerce by ORION by ORION – 2.8 – Not tested with the active version of WooCommerce
    WooCommerce – Instamojo by instamojo – 1.0.7 – Not tested with the active version of WooCommerce
    Paytm WooCommerce payment gateway by Subhadeep Mondal – 2.0 – Not tested with the active version of WooCommerce
    WooCommerce UPI payment by Kiasa – 1.1 – Not tested with the active version of WooCommerce
    WooCommerce COD Advanced by AheadZen – 1.3.0 – Not tested with the active version of WooCommerce
    WooCommerce Google Analytics Integration by WooCommerce – 1.4.15
    WooCommerce by Automattic – 3.8.0
    Yoast SEO by Team Yoast – 12.5
    WP Mail SMTP by WPForms – 1.7.1
    WP Video Lightbox by Tips and Tricks HQ, Ruhul Amin – 1.8.8
    YITH WooCommerce Wishlist by YITH – 2.2.16

    Inactive plugins (9)
    Akismet Anti-Spam by Automattic – 4.1.3
    BULK SMS PLANS SMS Notifications by Bulk SMS Plans Developer Team – 1.0
    Popup Maker by Popup Maker – 1.8.14
    Simple Custom CSS and JS by SilkyPress.com – 3.28
    Simple Side Tab by Scot Rumery – 1.2.1
    Subscribers.com by Subscribers.com – 1.5.1
    WooCommerce Blocks by Automattic – 2.4.4
    WooSidebars by WooCommerce – 1.4.5
    WP Migrate DB by Delicious Brains – 1.0.11

    Dropin Plugins (2)
    advanced-cache.php advanced-cache.php
    object-cache.php object-cache.php

    Settings
    API enabled: –
    Force SSL: –
    Currency INR (Rs.)
    Currency position left
    Thousand separator ,
    Decimal separator .
    Number of decimals 0
    Taxonomies: Product types simple (simple), grouped (grouped), variable (variable), external (external)
    Taxonomies: Product visibility exclude-from-search (exclude-from-search), exclude-from-catalog (exclude-from-catalog), 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: –

    WooCommerce pages
    Shop base: #8 – /shop/
    Cart: #9 – /cart/
    Checkout: #10 – /checkout/
    My account: #11 – /my-account/
    Terms and conditions: #142 – /terms-of-use/

    Theme
    Name: Flatsome Child
    Version: 3.0
    Author URL:
    Child theme:
    Parent theme name: Flatsome
    Parent theme version: 3.10.0
    Parent theme author URL: https://www.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.php,
    flatsome/woocommerce/content-product_cat.php,
    flatsome/woocommerce/content-single-product.php,
    flatsome/woocommerce/content-widget-product.php,
    flatsome-child/woocommerce/emails/customer-processing-order.php version 3.5.4 is out of date. The core version is 3.7.0,
    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/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
    Outdated templates: Learn how to update

    Action Scheduler
    Action Status Count Oldest Scheduled Date Newest Scheduled Date
    Complete 10 2019-10-21 21:02:06 +0530 2019-11-18 21:07:28 +0530
    Pending 2 2019-11-25 21:07:28 +0530 2019-11-25 21:07:28 +0530
    Canceled 0 – –
    In-progress 0 – –
    Failed 0 – –

    Thanks & regards
    Ketan Shah

    Thread Starter k_shah_in

    (@k_shah_in)

    Hi @josk79!

    Looking at the WooCommerce System Status Report, did you manage to detect any issue which is causing the disconnection problem?

    Thanks & regards
    Ketan Shah

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Site losing database connection while using admin’ is closed to new replies.