Title: Plugin creates a 30GB database query Last modified: July 14, 2025 --- # Plugin creates a 30GB database query * Resolved [ntvmd](https://wordpress.org/support/users/ntvmd/) * (@ntvmd) * [11 months, 1 week ago](https://wordpress.org/support/topic/plugin-creates-a-30gb-database-query-2/) * I get a database query by the plug-in _wp\_gla\_merchant\_price\_benchmarks _ * _SELECT /*!40001 SQL\_NO\_CACHE */ * FROM 16749*****\\_gla\\_merchant\\_price\\ _benchmarks WHERE (-9223372036854775808 <= product\\_id AND product\\_id <= 9223372036854775807)_ * The size of a tabel in the database (wp_options) grows to 30 GB and crashes the website. After a manual cleanup it’s 15 MB. * The day after it happended again. * How can I stop _wp\_gla\_merchant\_price\_benchmarks_ from doing this? Viewing 8 replies - 1 through 8 (of 8 total) * Plugin Support [shahzeen(woo-hc)](https://wordpress.org/support/users/shahzeenfarooq/) * (@shahzeenfarooq) * [11 months, 1 week ago](https://wordpress.org/support/topic/plugin-creates-a-30gb-database-query-2/#post-18554784) * Hi there! Thank you for sharing the details about the database issue and the query involving the wp_gla_merchant_price_benchmarks table. I understand how concerning it is when the wp_options table grows excessively large—especially up to 30 GB—and causes your website to crash repeatedly. * Could you please ensure that you’re using the latest version **3.1.1** of the plugin? After updating, please monitor the site to see if the issue persists. * A similar issue was reported in version **3.0.0**, as mentioned here: 🔗 [https://github.com/woocommerce/google-listings-and-ads/pull/2995](https://github.com/woocommerce/google-listings-and-ads/pull/2995) This has been resolved in the latest version. * Let us know how it goes, and we’ll be happy to assist further if needed. * Thread Starter [ntvmd](https://wordpress.org/support/users/ntvmd/) * (@ntvmd) * [11 months, 1 week ago](https://wordpress.org/support/topic/plugin-creates-a-30gb-database-query-2/#post-18554848) * Yes we use 3.1.1 * [Sai (woo-hc)](https://wordpress.org/support/users/saivutukuru/) * (@saivutukuru) * [11 months, 1 week ago](https://wordpress.org/support/topic/plugin-creates-a-30gb-database-query-2/#post-18555222) * Hi [@ntvmd](https://wordpress.org/support/users/ntvmd/), * Thanks for confirming. While the latest version includes a fix for the earlier issue, it looks like your site may still be experiencing similar behavior. * To help us investigate further, could you please share the following: - A fresh **System Status Report** (WooCommerce > Status > Get system report), then paste it into [https://pastebin.com](https://pastebin.com/) or [https://gist.github.com](https://gist.github.com/) - A list of any scheduled tasks shown in the **[WP Crontrol](https://wordpress.org/plugins/wp-crontrol/)** plugin that reference: * `gla_merchant_price_benchmarks` * `update_merchant_price_benchmarks` * `woo_google_listings_ads_*`  * Here’s how to check using **WP Crontrol**: 1. Install and activate the WP Crontrol plugin. 2. Go to **Tools > Cron Events**. 3. Look for related hooks (mentioned above) and check their frequency, next run time, and whether any are stuck or failing. * **Temporary workaround to prevent site crashes:** * If one of the related cron events is causing the table to repopulate quickly or repeatedly: - Click **Edit** next to that cron event in WP Crontrol. - Either delete it or set its next run time far in the future.  * This may temporarily disable certain Google Listings & Ads features like price benchmarks, but it can help stop the wp_options table from ballooning again. * Once we have the requested info, we’ll be able to confirm whether this is a regression or a new issue, and escalate if needed. Appreciate your patience while we dig deeper into this. * Thread Starter [ntvmd](https://wordpress.org/support/users/ntvmd/) * (@ntvmd) * [11 months, 1 week ago](https://wordpress.org/support/topic/plugin-creates-a-30gb-database-query-2/#post-18556696) * I can’t find the cronjob using WP crontrol (It is NOT in the list). * I do see it Woocommerce / Status / Planned actions (tab) * _gla/jobs/update\_merchant\_price\_benchmarks/start_ * It runs at 3:00 during the night but it seems I can’t stop it. I can click “annulate” but on a refresh it gets immediately re-added to the list with pending items. * Thread Starter [ntvmd](https://wordpress.org/support/users/ntvmd/) * (@ntvmd) * [11 months, 1 week ago](https://wordpress.org/support/topic/plugin-creates-a-30gb-database-query-2/#post-18556703) * I googled “how to disable update_merchant_price_benchmarks”. * Seems possible in Google Merchant Center so I also tried that. - This reply was modified 11 months, 1 week ago by [ntvmd](https://wordpress.org/support/users/ntvmd/). * [Sai (woo-hc)](https://wordpress.org/support/users/saivutukuru/) * (@saivutukuru) * [11 months, 1 week ago](https://wordpress.org/support/topic/plugin-creates-a-30gb-database-query-2/#post-18557296) * Thanks for your continued updates. * To help confirm and potentially stop this from recurring, please try the following steps: * **Disable Price Benchmarking in Google Merchant Center** 1. Log in to your [Google Merchant Center](https://merchants.google.com/). 2. From the left-hand menu, go to **Growth** → **Price competitiveness**. 3. Look for an option to disable or opt out of the **Price benchmarks** program. 4. After disabling, give it a little time and monitor whether the cron job continues to regenerate in WooCommerce > Status > Scheduled Actions.  * Disabling this should prevent the job from running again, which may help avoid the `wp_options` table growing excessively. * **Also, please share your latest System Status Report (SSR):** - Go to **WooCommerce → Status → Get system report**. - Copy the entire report and paste it into [https://pastebin.com](https://pastebin.com) or [https://gist.github.com](https://gist.github.com), then share the link here. * This will help us confirm your environment and escalate further if needed. * Let us know how it goes, your feedback could be helpful for others facing the same issue. * Thread Starter [ntvmd](https://wordpress.org/support/users/ntvmd/) * (@ntvmd) * [11 months ago](https://wordpress.org/support/topic/plugin-creates-a-30gb-database-query-2/#post-18561119) * Changing the setting in Google Merchant Center is working. * Plugin Support [shahzeen(woo-hc)](https://wordpress.org/support/users/shahzeenfarooq/) * (@shahzeenfarooq) * [11 months ago](https://wordpress.org/support/topic/plugin-creates-a-30gb-database-query-2/#post-18561183) * Hi there! * Thanks for the update — I’m glad to hear that changing the setting in Google Merchant Center resolved the issue! * I’m so glad we were able to get that sorted for you! If you’re happy with the support you received, would you consider leaving us a quick review? It really helps us out: [https://wordpress.org/support/plugin/google-listings-and-ads/reviews/#new-post](https://wordpress.org/support/plugin/google-listings-and-ads/reviews/#new-post) Viewing 8 replies - 1 through 8 (of 8 total) The topic ‘Plugin creates a 30GB database query’ is closed to new replies. * ![](https://ps.w.org/google-listings-and-ads/assets/icon.svg?rev=2775988) * [Google for WooCommerce](https://wordpress.org/plugins/google-listings-and-ads/) * [Frequently Asked Questions](https://wordpress.org/plugins/google-listings-and-ads/#faq) * [Support Threads](https://wordpress.org/support/plugin/google-listings-and-ads/) * [Active Topics](https://wordpress.org/support/plugin/google-listings-and-ads/active/) * [Unresolved Topics](https://wordpress.org/support/plugin/google-listings-and-ads/unresolved/) * [Reviews](https://wordpress.org/support/plugin/google-listings-and-ads/reviews/) * 8 replies * 3 participants * Last reply from: [shahzeen(woo-hc)](https://wordpress.org/support/users/shahzeenfarooq/) * Last activity: [11 months ago](https://wordpress.org/support/topic/plugin-creates-a-30gb-database-query-2/#post-18561183) * Status: resolved