Title: SQL queries keep opened Last modified: September 1, 2016 --- # SQL queries keep opened * Resolved [renandepaula](https://wordpress.org/support/users/renancomn/) * (@renancomn) * [9 years, 9 months ago](https://wordpress.org/support/topic/sql-queries-keep-opened/) * Hi, I just was warned by my hosting support because MYSQL was crashing a lot. The reason behind the table crashing is the not closing of queries. The Sql queries are leaving the connection opened and after that these queries are imposing the load on the mysql which in result crash the tables. * The queries was crashing is related to Abandoned Cart Lite plugin. Query SHOW COLUMNS FROM gynge_ac_abandoned_cart_history_lite LIKE ‘unsubscribe_link’ * Thanks. * [https://wordpress.org/plugins/woocommerce-abandoned-cart/](https://wordpress.org/plugins/woocommerce-abandoned-cart/) Viewing 7 replies - 1 through 7 (of 7 total) * Plugin Contributor [chetnapatel](https://wordpress.org/support/users/chetnapatel/) * (@chetnapatel) * [9 years, 9 months ago](https://wordpress.org/support/topic/sql-queries-keep-opened/#post-7642887) * Hi, * Thank you for informing such issue. We will check this issue. * Please let me know if you have any further queries. * Regards, Chetna Bhutka * [bhavik.kiri](https://wordpress.org/support/users/bhavikkiri/) * (@bhavikkiri) * [9 years, 9 months ago](https://wordpress.org/support/topic/sql-queries-keep-opened/#post-7643045) * Hi Renandepaula, * Thank you for informing us the issue of the open connection of the query. * We are using the global wpdb object for accessing the database. So we do not open the database connection and close it once operation of the query is finished. * However, I have changed the query which you have mentioned in your reply. * It would be also great if it is possible from you to share with us the error messages of the database log file, it will help us to identify the root cause of the issue. * Regards, Bhavik Kiri * Moderator [Jose Castaneda](https://wordpress.org/support/users/jcastaneda/) * (@jcastaneda) * THEME COFFEE MONKEY * [9 years, 9 months ago](https://wordpress.org/support/topic/sql-queries-keep-opened/#post-7643047) * [@bhavik](https://wordpress.org/support/users/bhavik/).kiri please don’t ask for email addresses. I totally get you want to help out but that is a big no- no in these forums: [https://codex.wordpress.org/Forum_Welcome#The_Bad_Stuff](https://codex.wordpress.org/Forum_Welcome#The_Bad_Stuff) * [bhavik.kiri](https://wordpress.org/support/users/bhavikkiri/) * (@bhavikkiri) * [9 years, 9 months ago](https://wordpress.org/support/topic/sql-queries-keep-opened/#post-7643049) * [@jose](https://wordpress.org/support/users/jose/) * Thank you for sharing the link to the bad stuff of the forum. * I’ll take care of this in future. * Regards, Bhavik Kiri * Plugin Contributor [chetnapatel](https://wordpress.org/support/users/chetnapatel/) * (@chetnapatel) * [9 years, 9 months ago](https://wordpress.org/support/topic/sql-queries-keep-opened/#post-7643110) * Hi Renandepaula, * I have noticed that my colleague Bhavik’s last replied has been edited so I assume that you have not received the whole reply of him. * We would like to look into the issue and fix it. So it would be great if you can post your issue on our plugin’s forum Page? So we can more communicate about the issue. * Below is our plugin’s forum page link: [http://www.tychesoftwares.com/forums/forum/woocommerce-abandon-cart-pro/](http://www.tychesoftwares.com/forums/forum/woocommerce-abandon-cart-pro/) * Regards, Chetna Bhutka * Thread Starter [renandepaula](https://wordpress.org/support/users/renancomn/) * (@renancomn) * [9 years, 8 months ago](https://wordpress.org/support/topic/sql-queries-keep-opened/#post-7643116) * Hi, I asked to my hosting for the information that you asked, but they inform that they aren’t able to inform this, because it was in the past. Now the site looks good. * I have excluded and reinstalled Abandoned Cart Lite for WooCommerce, so I don’t know if it’s related. * Besides, sorry can share 🙁 I really don’t know how to get this information * And really thanks for all the active support and help you give. * The best. * Plugin Contributor [chetnapatel](https://wordpress.org/support/users/chetnapatel/) * (@chetnapatel) * [9 years, 8 months ago](https://wordpress.org/support/topic/sql-queries-keep-opened/#post-7643118) * Hi Renandepaula, * It’s ok. No problem. * I am glad to know that everything is working fine on your site. Thank you for appreciating our support. * It would be great if you could write a review for us on our plugins [review ](https://wordpress.org/support/view/plugin-reviews/woocommerce-abandoned-cart) section. That would help immensely. * Please let me know if you have any further queries. * Regards, Chetna Bhutka Viewing 7 replies - 1 through 7 (of 7 total) The topic ‘SQL queries keep opened’ is closed to new replies. * ![](https://ps.w.org/woocommerce-abandoned-cart/assets/icon-256x256.png?rev=2369396) * [Abandoned Cart Lite for WooCommerce](https://wordpress.org/plugins/woocommerce-abandoned-cart/) * [Frequently Asked Questions](https://wordpress.org/plugins/woocommerce-abandoned-cart/#faq) * [Support Threads](https://wordpress.org/support/plugin/woocommerce-abandoned-cart/) * [Active Topics](https://wordpress.org/support/plugin/woocommerce-abandoned-cart/active/) * [Unresolved Topics](https://wordpress.org/support/plugin/woocommerce-abandoned-cart/unresolved/) * [Reviews](https://wordpress.org/support/plugin/woocommerce-abandoned-cart/reviews/) ## Tags * [Crash](https://wordpress.org/support/topic-tag/crash/) * [queries](https://wordpress.org/support/topic-tag/queries/) * [server](https://wordpress.org/support/topic-tag/server/) * [sql](https://wordpress.org/support/topic-tag/sql/) * 7 replies * 0 participants * Last reply from: [chetnapatel](https://wordpress.org/support/users/chetnapatel/) * Last activity: [9 years, 8 months ago](https://wordpress.org/support/topic/sql-queries-keep-opened/#post-7643118) * Status: resolved