[NSFW] 2 Million of actionscheduler_logs
-
How can I do to delete more than two million of actionscheduler_logs and more than 900 thousand actionscheduler_actions…
🙁
Best regards
-
This topic was modified 1 year, 6 months ago by
Orsp.
-
This topic was modified 1 year, 6 months ago by
Viewing 8 replies - 1 through 8 (of 8 total)
-
You could purge those records for Action Scheduler using phpMyAdmin.
phpMyAdmin
Thank you for your reply and your suggestion.
I knew about this possibility, via phpMyAdmin (it’s still not a risk-free solution), but I wondered if it’s possible that WooCommerce could be at the origin of this absurd situation… and I can’t find any reasonable cause.
What types of actions show in the actionscheduler_actions database table?
https://github.com/woocommerce/woocommerce/wiki/Database-Description#table-actionscheduler_actions
Hello @lukefiretoss, on database I have this 3 actions:
- actionscheduler_actions
- actionscheduler_claims
- actionscheduler_groups
See screenshot.
Hi @orsp, thanks for letting us know.
It will be great if you could share your current System Status Report, which may give us some more clues here. You can get it by navigating to theWooCommerce / Statussection of your site. Once there, click on theGet system reportbutton and then copy it by clicking on theCopy for supportbutton. Then paste it here in a comment.Hi @seanomattic, thanks for help.
Here the System status report:
WordPress Environment WordPress address (URL): https://www.privatephotoreview.com Site address (URL): https://www.privatephotoreview.com WC Version: 7.3.0 REST API Version: ✔</img> 7.3.0 WC Blocks Version: ✔</img> 9.1.5 Action Scheduler Version: ✔</img> 3.4.0 Log Directory Writable: ✔</img> WP Version: 6.1.1 WP Multisite: – WP Memory Limit: 512 MB WP Debug Mode: – WP Cron: ✔</img> Language: en_GB External object cache: – Server Environment Server Info: LiteSpeed PHP Version: 7.4.33 PHP Post Max Size: 30 MB PHP Time Limit: 300 PHP Max Input Vars: 3000 cURL Version: 7.87.0 OpenSSL/1.1.1s SUHOSIN Installed: – MySQL Version: 5.5.5-10.3.37-MariaDB Max Upload Size: 30 MB Default Timezone is UTC: ✔</img> fsockopen/cURL: ✔</img> SoapClient: ✔</img> DOMDocument: ✔</img> GZip: ✔</img> Multibyte String: ✔</img> Remote Post: ✔</img> Remote Get: ✔</img> Database WC Database Version: 7.3.0 WC Database Prefix: pri_ Total Database Size: 755.45MB Database Data Size: 548.68MB Database Index Size: 206.77MB pri_woocommerce_sessions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM pri_woocommerce_api_keys: Data: 0.00MB + Index: 0.00MB + Engine MyISAM pri_woocommerce_attribute_taxonomies: Data: 0.00MB + Index: 0.01MB + Engine MyISAM pri_woocommerce_downloadable_product_permissions: Data: 0.00MB + Index: 0.01MB + Engine MyISAM pri_woocommerce_order_items: Data: 0.17MB + Index: 0.06MB + Engine InnoDB pri_woocommerce_order_itemmeta: Data: 1.52MB + Index: 0.80MB + Engine InnoDB pri_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB pri_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.05MB + Engine InnoDB pri_woocommerce_shipping_zones: Data: 0.00MB + Index: 0.00MB + Engine MyISAM pri_woocommerce_shipping_zone_locations: Data: 0.00MB + Index: 0.01MB + Engine MyISAM pri_woocommerce_shipping_zone_methods: Data: 0.00MB + Index: 0.00MB + Engine MyISAM pri_woocommerce_payment_tokens: Data: 0.00MB + Index: 0.00MB + Engine MyISAM pri_woocommerce_payment_tokenmeta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM pri_woocommerce_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM pri_actionscheduler_actions: Data: 264.62MB + Index: 69.77MB + Engine MyISAM pri_actionscheduler_claims: Data: 0.00MB + Index: 0.00MB + Engine MyISAM pri_actionscheduler_groups: Data: 0.00MB + Index: 0.01MB + Engine MyISAM pri_actionscheduler_logs: Data: 156.43MB + Index: 106.80MB + Engine MyISAM pri_aioseo_cache: Data: 0.14MB + Index: 0.06MB + Engine InnoDB pri_aioseo_notifications: Data: 0.02MB + Index: 0.06MB + Engine InnoDB pri_aioseo_posts: Data: 0.09MB + Index: 0.02MB + Engine InnoDB pri_cache_content: Data: 0.00MB + Index: 0.00MB + Engine MyISAM pri_cache_module_content: Data: 0.12MB + Index: 0.14MB + Engine MyISAM pri_commentmeta: Data: 0.14MB + Index: 0.10MB + Engine MyISAM pri_comments: Data: 0.65MB + Index: 0.26MB + Engine MyISAM pri_fs_accounts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB pri_fs_account_access_tokens: Data: 0.02MB + Index: 0.00MB + Engine InnoDB pri_fs_account_groups: Data: 0.02MB + Index: 0.00MB + Engine InnoDB pri_fs_account_groups_data: Data: 0.02MB + Index: 0.00MB + Engine InnoDB pri_fs_account_nodes: Data: 0.02MB + Index: 0.00MB + Engine InnoDB pri_fs_account_node_status: Data: 0.02MB + Index: 0.00MB + Engine InnoDB pri_fs_account_sessions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB pri_fs_account_status: Data: 0.02MB + Index: 0.00MB + Engine InnoDB pri_fs_apps: Data: 0.02MB + Index: 0.00MB + Engine InnoDB pri_fs_feeds: Data: 0.02MB + Index: 0.00MB + Engine InnoDB pri_fs_grouped_accounts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB pri_fs_post_comments: Data: 0.02MB + Index: 0.00MB + Engine InnoDB pri_fs_schedules: Data: 0.02MB + Index: 0.00MB + Engine InnoDB pri_gf_addon_feed: Data: 0.08MB + Index: 0.02MB + Engine InnoDB pri_gf_addon_payment_callback: Data: 0.02MB + Index: 0.02MB + Engine InnoDB pri_gf_addon_payment_transaction: Data: 0.02MB + Index: 0.05MB + Engine InnoDB pri_gf_draft_submissions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM pri_gf_entry: Data: 0.14MB + Index: 0.02MB + Engine MyISAM pri_gf_entry_meta: Data: 0.71MB + Index: 0.46MB + Engine MyISAM pri_gf_entry_notes: Data: 0.16MB + Index: 0.05MB + Engine MyISAM pri_gf_form: Data: 0.00MB + Index: 0.00MB + Engine MyISAM pri_gf_form_meta: Data: 1.27MB + Index: 0.00MB + Engine MyISAM pri_gf_form_revisions: Data: 2.81MB + Index: 0.00MB + Engine MyISAM pri_gf_form_view: Data: 1.89MB + Index: 0.84MB + Engine MyISAM pri_gf_rest_api_keys: Data: 0.00MB + Index: 0.00MB + Engine MyISAM pri_links: Data: 0.00MB + Index: 0.00MB + Engine MyISAM pri_login_redirects: Data: 0.00MB + Index: 0.00MB + Engine MyISAM pri_mailchimp_carts: Data: 0.00MB + Index: 0.00MB + Engine MyISAM pri_newsletter: Data: 0.38MB + Index: 0.13MB + Engine InnoDB pri_newsletter_emails: Data: 0.42MB + Index: 0.00MB + Engine InnoDB pri_newsletter_sent: Data: 0.31MB + Index: 0.22MB + Engine InnoDB pri_newsletter_stats: Data: 0.27MB + Index: 0.16MB + Engine InnoDB pri_newsletter_user_logs: Data: 0.05MB + Index: 0.00MB + Engine InnoDB pri_options: Data: 8.99MB + Index: 0.39MB + Engine MyISAM pri_postmeta: Data: 48.00MB + Index: 5.90MB + Engine MyISAM pri_posts: Data: 21.98MB + Index: 1.74MB + Engine MyISAM pri_ppress_forms: Data: 0.00MB + Index: 0.01MB + Engine MyISAM pri_ppress_formsmeta: Data: 0.03MB + Index: 0.02MB + Engine MyISAM pri_ppress_meta_data: Data: 0.00MB + Index: 0.00MB + Engine MyISAM pri_redirection_404: Data: 0.02MB + Index: 0.05MB + Engine InnoDB pri_redirection_groups: Data: 0.02MB + Index: 0.03MB + Engine InnoDB pri_redirection_items: Data: 0.02MB + Index: 0.09MB + Engine InnoDB pri_redirection_logs: Data: 0.02MB + Index: 0.05MB + Engine InnoDB pri_rg_form: Data: 0.00MB + Index: 0.00MB + Engine MyISAM pri_rg_form_meta: Data: 1.19MB + Index: 0.00MB + Engine MyISAM pri_rg_form_view: Data: 2.95MB + Index: 1.58MB + Engine MyISAM pri_rg_incomplete_submissions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB pri_rg_lead: Data: 0.11MB + Index: 0.02MB + Engine MyISAM pri_rg_lead_detail: Data: 1.37MB + Index: 0.90MB + Engine MyISAM pri_rg_lead_detail_long: Data: 0.58MB + Index: 0.02MB + Engine MyISAM pri_rg_lead_meta: Data: 0.00MB + Index: 0.01MB + Engine MyISAM pri_rg_lead_notes: Data: 0.00MB + Index: 0.00MB + Engine MyISAM pri_rg_paypal: Data: 0.01MB + Index: 0.00MB + Engine MyISAM pri_rg_paypal_transaction: Data: 0.00MB + Index: 0.00MB + Engine MyISAM pri_rg_userregistration: Data: 0.00MB + Index: 0.00MB + Engine MyISAM pri_signups: Data: 0.05MB + Index: 0.06MB + Engine InnoDB pri_sliderpro_skins: Data: 0.08MB + Index: 0.00MB + Engine InnoDB pri_sliderpro_sliders: Data: 0.38MB + Index: 0.00MB + Engine InnoDB pri_sliderpro_slides: Data: 0.14MB + Index: 0.00MB + Engine InnoDB pri_termmeta: Data: 0.08MB + Index: 0.08MB + Engine MyISAM pri_terms: Data: 0.13MB + Index: 0.19MB + Engine MyISAM pri_term_relationships: Data: 0.25MB + Index: 0.45MB + Engine MyISAM pri_term_taxonomy: Data: 0.64MB + Index: 0.12MB + Engine MyISAM pri_tm_taskmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB pri_tm_tasks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB pri_usermeta: Data: 4.73MB + Index: 1.71MB + Engine MyISAM pri_users: Data: 0.13MB + Index: 0.10MB + Engine MyISAM pri_wc_admin_notes: Data: 0.05MB + Index: 0.00MB + Engine MyISAM pri_wc_admin_note_actions: Data: 0.02MB + Index: 0.01MB + Engine MyISAM pri_wc_category_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM pri_wc_customer_lookup: Data: 0.08MB + Index: 0.05MB + Engine MyISAM pri_wc_download_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM pri_wc_order_coupon_lookup: Data: 0.00MB + Index: 0.01MB + Engine MyISAM pri_wc_order_product_lookup: Data: 0.15MB + Index: 0.11MB + Engine MyISAM pri_wc_order_stats: Data: 0.07MB + Index: 0.05MB + Engine MyISAM pri_wc_order_tax_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM pri_wc_product_attributes_lookup: Data: 0.02MB + Index: 0.02MB + Engine InnoDB pri_wc_product_download_directories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB pri_wc_product_meta_lookup: Data: 0.01MB + Index: 0.02MB + Engine MyISAM pri_wc_rate_limits: Data: 0.02MB + Index: 0.02MB + Engine InnoDB pri_wc_reserved_stock: Data: 0.00MB + Index: 0.00MB + Engine MyISAM pri_wc_tax_rate_classes: Data: 0.00MB + Index: 0.01MB + Engine MyISAM pri_wc_webhooks: Data: 0.00MB + Index: 0.00MB + Engine MyISAM pri_wpmm_subscribers: Data: 0.00MB + Index: 0.00MB + Engine MyISAM pri_yoast_indexable: Data: 18.55MB + Index: 9.09MB + Engine InnoDB pri_yoast_indexable_hierarchy: Data: 0.27MB + Index: 0.34MB + Engine InnoDB pri_yoast_migrations: Data: 0.02MB + Index: 0.02MB + Engine InnoDB pri_yoast_primary_term: Data: 0.08MB + Index: 0.09MB + Engine InnoDB pri_yoast_seo_links: Data: 4.52MB + Index: 3.03MB + Engine InnoDB pri_yoast_seo_meta: Data: 0.11MB + Index: 0.10MB + Engine MyISAM Post Type Counts acf: 1 amn_exact-metrics: 1 attachment: 16796 avia_framework_post: 3 custom_css: 1 export_template: 1 faq: 3 feedback: 3 jp_img_sitemap: 6 jp_img_sitemap_index: 1 jp_sitemap: 1 jp_sitemap_master: 1 mc4wp-form: 2 nav_menu_item: 119 newsletter: 6 oembed_cache: 42 page: 78 portfolio: 1 post: 2292 product: 88 product_variation: 37 revision: 69 safecss: 1 scheduled_export: 1 shop_coupon: 28 shop_order: 950 shop_order_refund: 1 sidebar: 5 slide: 50 tie_slider: 1 ufaq: 18 uncodeblock: 158 user_request: 25 wooframework: 1834 wp_block: 21 wp_global_styles: 1 wysijap: 1 Security Secure connection (HTTPS): ✔</img> Hide errors from visitors: ✔</img> Active Plugins (38) ManageWP - Worker: by GoDaddy – 4.9.16 Gravity Forms: by Gravity Forms – 2.6.9 Akismet Anti-Spam: by Automattic – 5.0.2 Social Counters - Arqam Lite: by TieLabs – 1.0.9 Yoast Duplicate Post: by Enrico Battocchi and Team Yoast – 4.5 Easy WP SMTP: by Easy WP SMTP team – 1.5.3 FS Poster: by FS-Code – 6.2.4 Google Analytics for WordPress by MonsterInsights: by MonsterInsights – 8.12.1 Gravity Forms Advanced Post Creation Add-On: by Gravity Forms – 1.3 Gravity Forms reCAPTCHA Add-On: by Gravity Forms – 1.1 Gravity Forms User Registration Add-On: by Gravity Forms – 5.0 Jannah Autoload Posts: by TieLabs – 1.2.0 Jannah - Extensions: by TieLabs – 1.0.14 Jannah Speed Optimization: by TieLabs – 1.2.2 Limit log in attempts reloaded: by Limit log in attempts reloaded – 2.25.11 Newsletter - Amazon SES: by The Newsletter Team – 1.3.8 Newsletter - Extended Composer Blocks: by The Newsletter Team – 1.3.8 Newsletter - Addons Manager: by The Newsletter Team – 1.1.8 Newsletter - Geolocation: by The Newsletter Team – 1.1.8 Newsletter - Gravity Forms Addon: by The Newsletter Team – 1.0.7 Newsletter - Import: by The Newsletter Team – 1.3.5 Newsletter - Leads: by The Newsletter Team – 1.2.9 Newsletter - Reports and Retargeting: by The Newsletter Team – 4.4.5 Newsletter: by Stefano Lissa & The Newsletter Team – 7.5.9 OG — Better Share on Social Media: by Marcin Pietrzak – 3.1.9 Otter – Page Builder Blocks & Extensions for Gutenberg: by ThemeIsle – 2.2.0 Otter Pro: by ThemeIsle – 2.2.0 Redirection: by John Godley – 5.3.6 Simple Local Avatars: by 10up – 2.7.3 Taqyeem: by TieLabs – 2.6.5 Ultimate FAQ - WordPress FAQ and Accordion Plugin: by – 2.2.4 UpdraftPlus - Backup/Restore: by UpdraftPlus.Com DavidAnderson – 1.22.24 User Role Editor: by Vladimir Garagulya – 4.63.2 WooCommerce PayPal Payments: by WooCommerce – 2.0.1 WooCommerce: by Automattic – 7.3.0 LightStart - Maintenance Mode, Coming Soon and Landing Page Builder: by Themeisle – 2.6.2 WP-Optimize - Clean, Compress, Cache: by David Anderson Ruhani Rabin Team Updraft – 3.2.10 WPS Hide Login: by WPServeur NicolasKulka wpformation – 1.9.6 Inactive Plugins (0) Must Use Plugins (1) ManageWP - Worker Loader: by GoDaddy – 1.0.0 Settings API Enabled: – Force SSL: – Currency: EUR (€) Currency Position: left Thousand Separator: , Decimal Separator: . Number of Decimals: 2 Taxonomies: Product Types: external (external) grouped (grouped) simple (simple) variable (variable) 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: ✔</img> Enforce Approved Product Download Directories: ✔</img> Order datastore: WC_Order_Data_Store_CPT WC Pages Shop base: #8705 - /bookshop/ Basket: #8706 - /cart/ Checkout: #8707 - /checkout/ My account: #8709 - /my-account/ Terms and conditions: #36616 - /privacy/terms-and-conditions/ Theme Name: Jannah Child Version: 1.0.5 Author URL: https://tielabs.com Child Theme: ✔</img> Parent Theme Name: Jannah Parent Theme Version: 6.1.1 Parent Theme Author URL: https://tielabs.com/ WooCommerce Support: ✔</img> Templates Overrides: – WooCommerce PayPal Payments Onboarded: ✔</img> Shop country code: FR WooCommerce currency supported: ✔</img> Advanced Card Processing available in country: ✔</img> Pay Later messaging available in country: ✔</img> Webhook status: – Vault enabled: ✔</img> Logging enabled: – Reference Transactions: – Used PayPal Checkout plugin: – Tracking enabled: – 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: ✔</img> Next scheduled: 2023-01-18 12:15:29 +01:00 Options: ✔</img> Notes: 113 Onboarding: completed Action Scheduler Canceled: 1 Oldest: 2023-01-17 18:01:03 +0100 Newest: 2023-01-17 18:01:03 +0100 Complete: 912,669 Oldest: 2022-12-20 12:42:21 +0100 Newest: 2023-01-17 18:02:06 +0100 Pending: 2 Oldest: 2023-01-18 17:59:42 +0100 Newest: 2023-01-18 17:59:42 +0100 Status report information Generated at: 2023-01-17 18:03:37 +01:00 `Hey, thanks @orsp!
What’s interesting here is the bulk of these actions are complete and seem to have happened in the past two weeks or so. Does one of your third-party extensions have an automated task that runs really frequently? Maybe every few minutes?Action Scheduler
Canceled: 1
Oldest: 2023-01-17 18:01:03 +0100
Newest: 2023-01-17 18:01:03 +0100Complete: 912,669
Oldest: 2022-12-20 12:42:21 +0100
Newest: 2023-01-17 18:02:06 +0100Pending: 2
Oldest: 2023-01-18 17:59:42 +0100
Newest: 2023-01-18 17:59:42 +0100We haven’t heard back from you in a while, so I’m going to mark this as resolved – we’ll be here if and/or when you are ready to continue.
Viewing 8 replies - 1 through 8 (of 8 total)
- The topic ‘[NSFW] 2 Million of actionscheduler_logs’ is closed to new replies.
