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 – http://prntscr.com/pwpp4n
When I refreshed the page it gave me this error – http://prntscr.com/pwppm7
Even the main website url gave me the same error. http://prntscr.com/pwps6fI 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
-
It looks like all failing queries are related to the wp_options table. Can you paste the WooCommerce System Status Report?
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 MyISAMSecurity
Secure connection (HTTPS):
Hide errors from visitorsActive 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.16Inactive 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.11Dropin Plugins (2)
advanced-cache.php advanced-cache.php
object-cache.php object-cache.phpSettings
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: http://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 updateAction 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 ShahHi @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
- The topic ‘Site losing database connection while using admin’ is closed to new replies.