[ad_1]
When prompted, I updated my WooCommerce database yesterday or the day before. This morning, I received a notice from my ISP that I had exceeded allocated server size. Upon investigating, I found that the MySQL actionscheduler_actions and action_scheduler_logs were 840 Mb and 414 Mb respectively.
Upon studying Woo, I found that the system is generating thousands of actions in the following format:
Hook: woocommerce_run_update_callback
Status: Complete
Arguments: ‘update_callback- => ‘wc_update_721_adjust_new_zealand_states’
Group: woocommerce-db-updates
Recurrence: Non-repeating
How can I turn off these calls to keep my scheduleraction files from bloating?
Thanks for your help!
/ System Log
WordPress Environment
WordPress address (URL):
Site address (URL):
WC Version: 7.2.1
REST API Version: ✔ 7.2.1
WC Blocks Version: ✔ 8.9.2
Action Scheduler Version: ✔ 3.4.0
Log Directory Writable: ✔
WP Version: 6.1.1
WP Multisite: –
WP Memory Limit: 768 MB
WP Debug Mode: –
WP Cron: ✔
Language: en_US
External object cache: –
Server Environment
Server Info: Apache
PHP Version: 7.4.33
PHP Post Max Size: 256 MB
PHP Time Limit: 120
PHP Max Input Vars: 3000
cURL Version: 7.66.0
OpenSSL/1.1.1q-fips
SUHOSIN Installed: –
MySQL Version: 5.7.39-42-log
Max Upload Size: 256 MB
Default Timezone is UTC: ✔
fsockopen/cURL: ✔
SoapClient: ✔
DOMDocument: ✔
GZip: ✔
Multibyte String: ✔
Remote Post: ✔
Remote Get: ✔
Database
WC Database Version: 7.2.1
WC Database Prefix: wp_2413
Total Database Size: 246.79MB
Database Data Size: 194.41MB
Database Index Size: 52.38MB
wp_2413woocommerce_sessions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_2413woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_2413woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_2413woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_2413woocommerce_order_items: Data: 0.11MB + Index: 0.06MB + Engine InnoDB
wp_2413woocommerce_order_itemmeta: Data: 1.52MB + Index: 0.59MB + Engine InnoDB
wp_2413woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_2413woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_2413woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_2413woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_2413woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_2413woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_2413woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_2413woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_2413actionscheduler_actions: Data: 22.05MB + Index: 24.64MB + Engine InnoDB
wp_2413actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_2413actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_2413actionscheduler_logs: Data: 13.52MB + Index: 9.03MB + Engine InnoDB
wp_2413commentmeta: Data: 0.05MB + Index: 0.03MB + Engine InnoDB
wp_2413comments: Data: 5.52MB + Index: 1.23MB + Engine InnoDB
wp_2413et_bloom_stats: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_2413jp_journals: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wp_2413links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_2413mailerlite_forms: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_2413options: Data: 5.34MB + Index: 1.16MB + Engine InnoDB
wp_2413postmeta: Data: 10.52MB + Index: 5.70MB + Engine InnoDB
wp_2413posts: Data: 93.02MB + Index: 1.50MB + Engine InnoDB
wp_2413redirection_404: Data: 1.02MB + Index: 0.16MB + Engine InnoDB
wp_2413redirection_groups: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_2413redirection_items: Data: 0.08MB + Index: 0.09MB + Engine InnoDB
wp_2413redirection_logs: Data: 13.52MB + Index: 4.55MB + Engine InnoDB
wp_2413termmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_2413terms: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_2413term_relationships: Data: 0.22MB + Index: 0.13MB + Engine InnoDB
wp_2413term_taxonomy: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_2413usermeta: Data: 0.30MB + Index: 0.22MB + Engine InnoDB
wp_2413users: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_2413wc_admin_notes: Data: 0.06MB + Index: 0.00MB + Engine InnoDB
wp_2413wc_admin_note_actions: Data: 0.05MB + Index: 0.02MB + Engine InnoDB
wp_2413wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_2413wc_customer_lookup: Data: 0.05MB + Index: 0.03MB + Engine InnoDB
wp_2413wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_2413wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_2413wc_order_product_lookup: Data: 0.08MB + Index: 0.06MB + Engine InnoDB
wp_2413wc_order_stats: Data: 0.06MB + Index: 0.05MB + Engine InnoDB
wp_2413wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_2413wc_product_attributes_lookup: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_2413wc_product_download_directories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_2413wc_product_meta_lookup: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
wp_2413wc_rate_limits: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_2413wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_2413wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_2413wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_2413wfbadleechers: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_2413wfblockediplog: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_2413wfBlockedIPLog: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_2413wfblocks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_2413wfBlocks7: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_2413wfblocksadv: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_2413wfConfig: Data: 0.50MB + Index: 0.00MB + Engine InnoDB
wp_2413wfconfig: Data: 3.52MB + Index: 0.00MB + Engine InnoDB
wp_2413wfCrawlers: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_2413wfcrawlers: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_2413wfFileChanges: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_2413wffilemods: Data: 1.52MB + Index: 0.00MB + Engine InnoDB
wp_2413wfFileMods: Data: 9.52MB + Index: 0.00MB + Engine InnoDB
wp_2413wfHits: Data: 1.02MB + Index: 0.08MB + Engine InnoDB
wp_2413wfhits: Data: 1.52MB + Index: 0.36MB + Engine InnoDB
wp_2413wfhoover: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_2413wfHoover: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_2413wfissues: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_2413wfIssues: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_2413wfknownfilelist: Data: 0.36MB + Index: 0.00MB + Engine InnoDB
wp_2413wfKnownFileList: Data: 4.52MB + Index: 0.00MB + Engine InnoDB
wp_2413wfleechers: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_2413wfLiveTrafficHuman: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_2413wflockedout: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_2413wfLocs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_2413wflocs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_2413wfLogins: Data: 0.36MB + Index: 0.11MB + Engine InnoDB
wp_2413wflogins: Data: 0.05MB + Index: 0.03MB + Engine InnoDB
wp_2413wfls_2fa_secrets: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_2413wfls_settings: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_2413wfnet404s: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_2413wfNotifications: Data: 0.09MB + Index: 0.00MB + Engine InnoDB
wp_2413wfnotifications: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_2413wfPendingIssues: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_2413wfReverseCache: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_2413wfreversecache: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_2413wfscanners: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_2413wfSNIPCache: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_2413wfsnipcache: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_2413wfstatus: Data: 0.14MB + Index: 0.09MB + Engine InnoDB
wp_2413wfStatus: Data: 0.13MB + Index: 0.11MB + Engine InnoDB
wp_2413wfthrottlelog: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_2413wfTrafficRates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_2413wfvulnscanners: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_2413wqp_quizzes: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_2413yoast_indexable: Data: 1.52MB + Index: 0.69MB + Engine InnoDB
wp_2413yoast_indexable_hierarchy: Data: 0.06MB + Index: 0.05MB + Engine InnoDB
wp_2413yoast_migrations: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_2413yoast_primary_term: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_2413yoast_seo_links: Data: 1.06MB + Index: 0.31MB + Engine InnoDB
wp_2413yoast_seo_meta: Data: 0.09MB + Index: 0.00MB + Engine InnoDB
Post Type Counts
amn_mi-lite: 3
attachment: 310
custom_css: 2
et_body_layout: 3
et_header_layout: 4
et_pb_layout: 34
et_template: 20
et_theme_builder: 1
jetpack_migration: 2
jp_img_sitemap: 1
jp_sitemap: 1
jp_sitemap_master: 1
nav_menu_item: 58
oembed_cache: 6
page: 127
post: 1952
product: 58
shop_coupon: 8
shop_order: 839
Security
Secure connection (HTTPS): ✔
Hide errors from visitors: ✔
Active Plugins (19)
Akismet Anti-Spam: by Automattic – 5.0.2
Bloom: by Elegant Themes – 1.3.12
Classic Editor: by WordPress Contributors – 1.6.2
WooCommerce Continue Shopping: by HappyKite – 1.4.4
Cookie Notice & Compliance for GDPR / CCPA: by Hu-manity.co – 2.4.4
Divi Menu Cart: by Milen Krastev – 3.0.1
Elegant Themes Updater: by Elegant Themes – 1.1
Enable Media Replace: by ShortPixel – 4.0.1
Google Analytics for WordPress by MonsterInsights: by MonsterInsights – 8.11.0
Jetpack: by Automattic – 11.6
Redirection: by John Godley – 5.3.6
SiteGround Optimizer: by SiteGround – 7.2.9
UpdraftPlus - Backup/Restore: by UpdraftPlus.Com
DavidAnderson – 1.22.24
Checkout Field Editor for WooCommerce: by ThemeHigh – 1.8.1
Customizer for WooCommerce: by SkyVerge – 2.7.7
WooCommerce Payments: by Automattic – 5.2.0
WooCommerce Shipping & Tax: by WooCommerce – 2.1.0
WooCommerce: by Automattic – 7.2.1
Wordfence Security: by Wordfence – 7.8.2
Inactive Plugins (1)
Yoast SEO: by Team Yoast – 19.13
Dropin Plugins (1)
advanced-cache.php: advanced-cache.php
Settings
API Enabled: –
Force SSL: –
Currency: USD ($)
Currency Position: left
Thousand Separator: ,
Decimal Separator: .
Number of Decimals: 2
Taxonomies: Product Types: external (external)
grouped (grouped)
simple (simple)
subscription (subscription)
variable (variable)
variable subscription (variable-subscription)
Taxonomies: Product Visibility: exclude-from-catalog (exclude-from-catalog)
exclude-from-search (exclude-from-search)
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: ✔
Enforce Approved Product Download Directories: –
Order datastore: WC_Order_Data_Store_CPT
WC Pages
Shop base: #13643 - /index.php/shop/
Cart: ❌ Page does not contain the [woocommerce_cart] shortcode or the woocommerce/cart block.
Checkout: ❌ Page does not contain the [woocommerce_checkout] shortcode or the woocommerce/checkout block.
My account: #13631 - /index.php/shop/my-account/
Terms and conditions: ❌ Page not set
Theme
Name: Divi
Version: 4.19.4
Author URL:
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
WooCommerce Support: ✔
Templates
Overrides: –
Subscriptions
WCS_DEBUG: ✔ No
Subscriptions Mode: ✔ Live
Subscriptions Live URL:
Subscription Statuses: –
WooCommerce Account Connected: ✔ Yes
Active Product Key: ❌ No
Store Setup
Country / State: United States (US) — Virginia
Payment Gateway Support
WooCommerce Payments: products
refunds
multiple_subscriptions
subscription_cancellation
subscription_payment_method_change_admin
subscription_payment_method_change_customer
subscription_payment_method_change
subscription_reactivation
subscription_suspension
subscriptions
gateway_scheduled_payments
tokenization
add_payment_method
PayPal Standard: subscriptions
gateway_scheduled_payments
subscription_payment_method_change_customer
subscription_cancellation
subscription_suspension
subscription_reactivation
products
refunds
PayPal Reference Transactions Enabled: ❌ No
Admin
Enabled Features: activity-panels
analytics
coupons
customer-effort-score-tracks
experimental-products-task
experimental-import-products-task
experimental-fashion-sample-products
shipping-smart-defaults
shipping-setting-tour
homescreen
marketing
multichannel-marketing
mobile-app-banner
navigation
onboarding
onboarding-tasks
remote-inbox-notifications
remote-free-extensions
payment-gateway-suggestions
shipping-label-banner
subscriptions
store-alerts
transient-notices
woo-mobile-welcome
wc-pay-promotion
wc-pay-welcome-page
Disabled Features: minified-js
new-product-management-experience
settings
Daily Cron: ✔ Next scheduled: 2022-12-22 14:21:57 -05:00
Options: ✔
Notes: 120
Onboarding: completed
WooCommerce Payments
Version: 5.2.0
Connected to WPCOM: Yes
Blog ID: 34651714
Account ID: acct_1GiON3JNFfLv4EV5
Action Scheduler
Complete: 68,608
Oldest: 2022-12-21 15:05:56 -0500
Newest: 2022-12-21 15:31:14 -0500
Pending: 2
Oldest: 2022-12-21 18:05:14 -0500
Newest: 2022-12-21 18:05:14 -0500
Status report information
Generated at: 2022-12-21 15:31:14 -05:00
`/
The page I need help with: [log in to see the link]