wp_wfHits Table
-
Hello,
My options:
Amount of Live Traffic data to store (number of rows) – 50
Maximum days to keep Live Traffic data (minimum: 1) – 1Despite this my wp_wfHits Table is 85MB.
I have 2 questions:
1. How to clear this table?
2. 2. How to avoid further increase of this table?
-
Hey @merkucio,
It sounds like your site is/was under a pretty heavy attack.
1) You can manually remove the table using a database tool such as phpMyAdmin. Then deactivate and reactivate Wordfence to regenerate the table.
2) You might try decreasing the rows saved, this will help. Then when you notice the hits aren’t so intense you can increase it.
Thanks,
Gerroald
Not agree. I thinks this 2 options: 1. Amount of Live Traffic data to store (number of rows) and 2. Maximum days to keep Live Traffic data (minimum: 1) just doesn’t work for me.
Because there is much more then 50 rows and they are not erased in 1 day.
What do you think?
-
This reply was modified 6 years, 9 months ago by
Igrika.
Hey @merkucio,
I didn’t realize the data was older than the set time.
If you navigate to Wordfence > Tools > Cron Jobs do you see any overdue cron jobs?
Thanks,
Gerroald
Hi @wfgerald
Cron Jobs List of WordPress cron jobs scheduled by WordPress, plugins, or themes. Thu, 02 Jan 2014 03:34:53 +0000 (Overdue) publish_future_post Fri, 03 Jan 2014 03:34:53 +0000 (Overdue) publish_future_post Sun, 05 Jan 2014 03:34:53 +0000 (Overdue) publish_future_post Fri, 10 Jan 2014 03:34:53 +0000 (Overdue) publish_future_post Wed, 19 Nov 2014 04:00:18 +0000 (Overdue) publish_future_post Wed, 19 Nov 2014 06:47:34 +0000 (Overdue) publish_future_post Wed, 19 Nov 2014 22:22:46 +0000 (Overdue) publish_future_post Tue, 16 Dec 2014 06:13:48 +0000 (Overdue) publish_future_post Sat, 20 Dec 2014 03:34:53 +0000 (Overdue) publish_future_post Sun, 21 Dec 2014 13:32:46 +0000 (Overdue) publish_future_post Sun, 21 Dec 2014 23:24:00 +0000 (Overdue) publish_future_post Sun, 21 Dec 2014 23:24:56 +0000 (Overdue) publish_future_post Wed, 24 Dec 2014 03:10:04 +0000 (Overdue) publish_future_post Mon, 26 Jan 2015 04:56:37 +0000 (Overdue) publish_future_post Mon, 26 Jan 2015 22:18:38 +0000 (Overdue) publish_future_post Thu, 07 Jan 2016 05:03:46 +0000 (Overdue) publish_future_post Sat, 29 Oct 2016 11:05:12 +0000 (Overdue) publish_future_post Thu, 17 Nov 2016 10:33:33 +0000 (Overdue) publish_future_post Fri, 18 Nov 2016 16:50:38 +0000 (Overdue) publish_future_post Fri, 18 Nov 2016 16:51:17 +0000 (Overdue) publish_future_post Sat, 19 Nov 2016 16:58:17 +0000 (Overdue) publish_future_post Sun, 20 Nov 2016 10:30:43 +0000 (Overdue) publish_future_post Mon, 21 Nov 2016 11:27:16 +0000 (Overdue) publish_future_post Tue, 22 Nov 2016 16:40:02 +0000 (Overdue) publish_future_post Mon, 28 Nov 2016 19:23:42 +0000 (Overdue) publish_future_post Wed, 30 Nov 2016 15:55:14 +0000 (Overdue) publish_future_post Sun, 01 Jan 2017 01:00:00 +0000 (Overdue) st_availability_cronjob Fri, 03 Feb 2017 06:57:13 +0000 (Overdue) publish_future_post Thu, 30 Mar 2017 03:34:53 +0000 (Overdue) publish_future_post Thu, 27 Apr 2017 19:09:32 +0000 (Overdue) publish_future_post Sun, 30 Apr 2017 16:18:11 +0000 (Overdue) publish_future_post Wed, 03 May 2017 16:33:33 +0000 (Overdue) publish_future_post Wed, 03 May 2017 19:35:14 +0000 (Overdue) publish_future_post Thu, 04 May 2017 07:41:49 +0000 (Overdue) publish_future_post Mon, 08 May 2017 17:54:31 +0000 (Overdue) publish_future_post Mon, 08 May 2017 18:25:26 +0000 (Overdue) publish_future_post Tue, 16 May 2017 15:29:39 +0000 (Overdue) publish_future_post Tue, 16 May 2017 15:34:59 +0000 (Overdue) publish_future_post Tue, 16 May 2017 19:15:41 +0000 (Overdue) publish_future_post Thu, 18 May 2017 13:42:00 +0000 (Overdue) publish_future_post Fri, 30 Jun 2017 14:27:38 +0000 (Overdue) publish_future_post Sat, 15 Jul 2017 13:34:57 +0000 (Overdue) publish_future_post Mon, 17 Jul 2017 09:34:51 +0000 (Overdue) publish_future_post Sun, 23 Jul 2017 10:12:41 +0000 (Overdue) publish_future_post Mon, 31 Jul 2017 17:18:08 +0000 (Overdue) publish_future_post Mon, 31 Jul 2017 18:29:01 +0000 (Overdue) publish_future_post Mon, 09 Oct 2017 11:31:36 +0000 (Overdue) publish_future_post Thu, 26 Oct 2017 07:23:41 +0000 (Overdue) publish_future_post Mon, 27 Nov 2017 08:27:48 +0000 (Overdue) publish_future_post Sun, 03 Dec 2017 08:31:42 +0000 (Overdue) publish_future_post Mon, 12 Feb 2018 19:26:59 +0000 (Overdue) publish_future_post Sat, 24 Feb 2018 18:45:17 +0000 (Overdue) publish_future_post Mon, 05 Mar 2018 19:06:23 +0000 (Overdue) publish_future_post Wed, 07 Mar 2018 07:41:03 +0000 (Overdue) wp_cache_add_site_cache_index Wed, 07 Mar 2018 07:42:25 +0000 (Overdue) wordfence_completeCoreUpdateNotification Wed, 07 Mar 2018 07:42:53 +0000 (Overdue) wp_cache_preload_hook Wed, 07 Mar 2018 07:52:41 +0000 (Overdue) updraft_backup_database Wed, 07 Mar 2018 08:25:50 +0000 (Overdue) wordfence_completeCoreUpdateNotification Wed, 07 Mar 2018 08:25:51 +0000 (Overdue) wordfence_completeCoreUpdateNotification Wed, 07 Mar 2018 13:11:07 +0000 (Overdue) wp_version_check Wed, 07 Mar 2018 13:11:07 +0000 (Overdue) wp_update_plugins Wed, 07 Mar 2018 13:11:07 +0000 (Overdue) wp_update_themes Wed, 07 Mar 2018 13:11:15 +0000 (Overdue) wp_scheduled_delete Wed, 07 Mar 2018 13:16:01 +0000 (Overdue) wp_scheduled_auto_draft_delete Wed, 07 Mar 2018 16:19:12 +0000 (Overdue) wpml-tm-check-overdue-jobs-event Wed, 07 Mar 2018 16:26:52 +0000 (Overdue) delete_expired_transients Thu, 08 Mar 2018 09:12:00 +0000 (Overdue) wordfence_processAttackData Fri, 09 Mar 2018 12:46:39 +0000 (Overdue) wordfence_batchReportFailedAttempts Sat, 10 Mar 2018 15:38:10 +0000 (Overdue) publish_future_post Sat, 10 Mar 2018 16:59:46 +0000 (Overdue) publish_future_post Sat, 10 Mar 2018 17:41:04 +0000 (Overdue) wordfence_completeCoreUpdateNotification Mon, 12 Mar 2018 19:35:45 +0000 (Overdue) wordfence_completeCoreUpdateNotification Sat, 17 Mar 2018 05:27:36 +0000 (Overdue) wordfence_completeCoreUpdateNotification Sat, 31 Mar 2018 08:55:56 +0000 (Overdue) publish_future_post Sat, 31 Mar 2018 12:57:20 +0000 (Overdue) publish_future_post Mon, 02 Apr 2018 10:37:49 +0000 (Overdue) wordfence_completeCoreUpdateNotification Tue, 10 Apr 2018 07:43:20 +0000 (Overdue) wordfence_completeCoreUpdateNotification Tue, 17 Apr 2018 06:56:53 +0000 (Overdue) publish_future_post Tue, 17 Apr 2018 11:37:48 +0000 (Overdue) publish_future_post Tue, 17 Apr 2018 14:10:52 +0000 (Overdue) publish_future_post Tue, 17 Apr 2018 14:56:20 +0000 (Overdue) publish_future_post Wed, 02 May 2018 17:49:36 +0000 (Overdue) publish_future_post Thu, 03 May 2018 12:16:47 +0000 (Overdue) publish_future_post Thu, 03 May 2018 19:38:21 +0000 (Overdue) publish_future_post Fri, 04 May 2018 17:52:14 +0000 (Overdue) publish_future_post Sat, 05 May 2018 07:15:55 +0000 (Overdue) publish_future_post Tue, 08 May 2018 08:49:15 +0000 (Overdue) publish_future_post Sun, 20 May 2018 18:12:52 +0000 (Overdue) publish_future_post Sun, 27 May 2018 19:24:25 +0000 (Overdue) publish_future_post Mon, 28 May 2018 06:30:14 +0000 (Overdue) publish_future_post Mon, 28 May 2018 10:21:04 +0000 (Overdue) publish_future_post Thu, 07 Jun 2018 14:27:10 +0000 (Overdue) wordfence_completeCoreUpdateNotification Thu, 07 Jun 2018 14:27:12 +0000 (Overdue) wordfence_completeCoreUpdateNotification Thu, 07 Jun 2018 14:27:47 +0000 (Overdue) wordfence_completeCoreUpdateNotification Thu, 07 Jun 2018 14:28:19 +0000 (Overdue) wordfence_completeCoreUpdateNotification Thu, 07 Jun 2018 14:28:21 +0000 (Overdue) wordfence_completeCoreUpdateNotification Thu, 07 Jun 2018 14:28:56 +0000 (Overdue) wordfence_version_check Thu, 07 Jun 2018 14:29:56 +0000 (Overdue) wordfence_completeCoreUpdateNotification Thu, 07 Jun 2018 14:29:56 +0000 (Overdue) wordfence_refreshUpdateNotification Thu, 07 Jun 2018 14:29:57 +0000 (Overdue) wp_privacy_delete_old_export_files Fri, 08 Jun 2018 20:03:06 +0000 (Overdue) wordfence_completeCoreUpdateNotification Sun, 24 Jun 2018 12:54:35 +0000 (Overdue) wordfence_completeCoreUpdateNotification Sun, 24 Jun 2018 12:54:46 +0000 (Overdue) wordfence_completeCoreUpdateNotification Tue, 26 Jun 2018 09:21:03 +0000 (Overdue) wordfence_completeCoreUpdateNotification Tue, 26 Jun 2018 09:21:05 +0000 (Overdue) wordfence_completeCoreUpdateNotification Tue, 26 Jun 2018 11:39:09 +0000 (Overdue) upgrader_scheduled_cleanup Tue, 26 Jun 2018 11:41:21 +0000 (Overdue) upgrader_scheduled_cleanup Thu, 28 Jun 2018 10:27:32 +0000 (Overdue) publish_future_post Thu, 28 Jun 2018 20:17:07 +0000 (Overdue) wordfence_completeCoreUpdateNotification Thu, 28 Jun 2018 20:17:09 +0000 (Overdue) wordfence_completeCoreUpdateNotification Wed, 11 Jul 2018 07:25:40 +0000 (Overdue) wordfence_completeCoreUpdateNotification Wed, 11 Jul 2018 07:25:41 +0000 (Overdue) wordfence_completeCoreUpdateNotification Wed, 11 Jul 2018 08:18:49 +0000 (Overdue) wordfence_batchReportBlockedAttempts Wed, 11 Jul 2018 17:33:56 +0000 (Overdue) wordfence_completeCoreUpdateNotification Wed, 11 Jul 2018 17:38:27 +0000 (Overdue) wordfence_completeCoreUpdateNotification Wed, 11 Jul 2018 17:38:27 +0000 (Overdue) wordfence_refreshUpdateNotification Thu, 12 Jul 2018 08:14:45 +0000 (Overdue) update_wpml_config_index Mon, 23 Jul 2018 20:04:19 +0000 (Overdue) wordfence_completeCoreUpdateNotification Mon, 06 Aug 2018 06:13:08 +0000 (Overdue) wordfence_completeCoreUpdateNotification Mon, 06 Aug 2018 06:13:10 +0000 (Overdue) wordfence_completeCoreUpdateNotification Sun, 02 Sep 2018 08:08:31 +0000 (Overdue) wordfence_completeCoreUpdateNotification Sun, 02 Sep 2018 08:08:32 +0000 (Overdue) wordfence_completeCoreUpdateNotification Sun, 02 Sep 2018 09:53:42 +0000 (Overdue) wordfence_completeCoreUpdateNotification Sun, 02 Sep 2018 09:53:42 +0000 (Overdue) wordfence_refreshUpdateNotification Sun, 02 Sep 2018 09:59:17 +0000 (Overdue) wordfence_completeCoreUpdateNotification Sun, 02 Sep 2018 10:01:39 +0000 (Overdue) wordfence_completeCoreUpdateNotification Sun, 02 Sep 2018 10:01:51 +0000 (Overdue) wordfence_completeCoreUpdateNotification Sun, 02 Sep 2018 10:02:09 +0000 (Overdue) wordfence_completeCoreUpdateNotification Sun, 02 Sep 2018 10:02:19 +0000 (Overdue) wordfence_completeCoreUpdateNotification Sun, 02 Sep 2018 10:13:29 +0000 (Overdue) wordfence_completeCoreUpdateNotification Sun, 02 Sep 2018 10:13:43 +0000 (Overdue) wordfence_completeCoreUpdateNotification Sun, 02 Sep 2018 11:04:50 +0000 (Overdue) wordfence_completeCoreUpdateNotification Sun, 02 Sep 2018 11:05:25 +0000 (Overdue) wordfence_completeCoreUpdateNotification Sun, 02 Sep 2018 11:08:23 +0000 (Overdue) wordfence_completeCoreUpdateNotification Thu, 06 Sep 2018 10:23:49 +0000 (Overdue) wordfence_completeCoreUpdateNotification Sun, 16 Sep 2018 09:10:00 +0000 (Overdue) wordfence_completeCoreUpdateNotification Sun, 23 Sep 2018 13:33:01 +0000 (Overdue) wordfence_completeCoreUpdateNotification Sun, 23 Sep 2018 13:33:02 +0000 (Overdue) wordfence_completeCoreUpdateNotification Sun, 23 Sep 2018 13:33:23 +0000 (Overdue) wordfence_completeCoreUpdateNotification Sun, 23 Sep 2018 13:33:33 +0000 (Overdue) wordfence_completeCoreUpdateNotification Sun, 23 Sep 2018 13:33:51 +0000 (Overdue) wordfence_completeCoreUpdateNotification Sun, 23 Sep 2018 13:34:13 +0000 (Overdue) wordfence_completeCoreUpdateNotification Tue, 02 Oct 2018 10:01:43 +0000 (Overdue) otgs_send_components_data Sun, 04 Nov 2018 16:13:54 +0000 (Overdue) wordfence_completeCoreUpdateNotification Sun, 04 Nov 2018 16:13:56 +0000 (Overdue) wordfence_completeCoreUpdateNotification Sun, 04 Nov 2018 16:14:12 +0000 (Overdue) wordfence_completeCoreUpdateNotification Sun, 04 Nov 2018 16:14:26 +0000 (Overdue) wordfence_completeCoreUpdateNotification Sun, 04 Nov 2018 16:17:57 +0000 (Overdue) wordfence_completeCoreUpdateNotification Sun, 04 Nov 2018 16:18:09 +0000 (Overdue) wordfence_completeCoreUpdateNotification Sun, 04 Nov 2018 16:18:28 +0000 (Overdue) wordfence_completeCoreUpdateNotification Sun, 04 Nov 2018 16:18:36 +0000 (Overdue) wordfence_completeCoreUpdateNotification Fri, 09 Nov 2018 09:07:16 +0000 (Overdue) wordfence_completeCoreUpdateNotification Sat, 01 Dec 2018 08:43:29 +0000 (Overdue) wordfence_completeCoreUpdateNotification Sat, 01 Dec 2018 08:43:31 +0000 (Overdue) wordfence_completeCoreUpdateNotification Sat, 01 Dec 2018 08:43:51 +0000 (Overdue) wordfence_completeCoreUpdateNotification Sat, 01 Dec 2018 08:44:11 +0000 (Overdue) wordfence_completeCoreUpdateNotification Sat, 01 Dec 2018 08:44:22 +0000 (Overdue) wordfence_completeCoreUpdateNotification Fri, 07 Dec 2018 17:29:36 +0000 (Overdue) wordfence_completeCoreUpdateNotification Tue, 11 Dec 2018 07:55:08 +0000 (Overdue) wordfence_completeCoreUpdateNotification Tue, 11 Dec 2018 07:55:12 +0000 (Overdue) wordfence_completeCoreUpdateNotification Tue, 11 Dec 2018 07:55:39 +0000 (Overdue) wordfence_completeCoreUpdateNotification Tue, 11 Dec 2018 07:56:07 +0000 (Overdue) wordfence_completeCoreUpdateNotification Tue, 11 Dec 2018 07:56:21 +0000 (Overdue) wordfence_completeCoreUpdateNotification Tue, 11 Dec 2018 16:43:13 +0000 (Overdue) wordfence_completeCoreUpdateNotification Wed, 12 Dec 2018 14:40:25 +0000 (Overdue) wordfence_completeCoreUpdateNotification Wed, 12 Dec 2018 14:41:33 +0000 (Overdue) wordfence_completeCoreUpdateNotification Wed, 19 Dec 2018 06:46:08 +0000 (Overdue) wordfence_completeCoreUpdateNotification Wed, 19 Dec 2018 06:46:09 +0000 (Overdue) wordfence_completeCoreUpdateNotification Tue, 08 Jan 2019 07:25:02 +0000 (Overdue) wordfence_completeCoreUpdateNotification Tue, 08 Jan 2019 07:25:14 +0000 (Overdue) wordfence_completeCoreUpdateNotification Thu, 17 Jan 2019 07:35:57 +0000 (Overdue) wordfence_completeCoreUpdateNotification Thu, 17 Jan 2019 07:35:58 +0000 (Overdue) wordfence_completeCoreUpdateNotification Fri, 15 Feb 2019 06:59:01 +0000 (Overdue) wordfence_completeCoreUpdateNotification Fri, 15 Feb 2019 06:59:03 +0000 (Overdue) wordfence_completeCoreUpdateNotification Fri, 15 Feb 2019 07:32:35 +0000 (Overdue) wordfence_completeCoreUpdateNotification Fri, 15 Feb 2019 18:17:57 +0000 (Overdue) wordfence_completeCoreUpdateNotification Fri, 15 Feb 2019 18:17:58 +0000 (Overdue) wordfence_completeCoreUpdateNotification Sat, 16 Mar 2019 10:36:04 +0000 (Overdue) wordfence_completeCoreUpdateNotification Sat, 16 Mar 2019 10:36:14 +0000 (Overdue) wordfence_completeCoreUpdateNotification Sat, 16 Mar 2019 10:36:26 +0000 (Overdue) wordfence_completeCoreUpdateNotification Sat, 16 Mar 2019 10:36:27 +0000 (Overdue) wordfence_completeCoreUpdateNotification Sun, 07 Apr 2019 18:25:58 +0000 (Overdue) wordfence_completeCoreUpdateNotification Sun, 07 Apr 2019 18:25:59 +0000 (Overdue) wordfence_completeCoreUpdateNotification Sun, 07 Apr 2019 18:26:18 +0000 (Overdue) wordfence_completeCoreUpdateNotification Wed, 17 Apr 2019 09:51:55 +0000 (Overdue) wordfence_completeCoreUpdateNotification Wed, 17 Apr 2019 09:52:06 +0000 (Overdue) wordfence_completeCoreUpdateNotification Wed, 17 Apr 2019 09:52:23 +0000 (Overdue) wordfence_completeCoreUpdateNotification Wed, 17 Apr 2019 09:52:46 +0000 (Overdue) wordfence_completeCoreUpdateNotification Fri, 19 Apr 2019 07:25:32 +0000 (Overdue) wordfence_completeCoreUpdateNotification Fri, 31 May 2019 08:07:29 +0000 (Overdue) wordfence_completeCoreUpdateNotification Fri, 31 May 2019 08:07:31 +0000 (Overdue) wordfence_completeCoreUpdateNotification Fri, 31 May 2019 08:08:31 +0000 (Overdue) wordfence_completeCoreUpdateNotification Fri, 31 May 2019 08:08:45 +0000 (Overdue) wordfence_completeCoreUpdateNotification Fri, 31 May 2019 08:08:47 +0000 (Overdue) wordfence_completeCoreUpdateNotification Fri, 31 May 2019 08:09:15 +0000 (Overdue) wordfence_completeCoreUpdateNotification Fri, 31 May 2019 08:09:28 +0000 (Overdue) wordfence_completeCoreUpdateNotification Fri, 31 May 2019 08:09:40 +0000 (Overdue) wordfence_completeCoreUpdateNotification Fri, 31 May 2019 08:09:54 +0000 (Overdue) wordfence_completeCoreUpdateNotification Fri, 07 Jun 2019 08:35:09 +0000 (Overdue) wordfence_completeCoreUpdateNotification Fri, 07 Jun 2019 08:35:10 +0000 (Overdue) wordfence_completeCoreUpdateNotification Sun, 16 Jun 2019 08:47:49 +0000 (Overdue) wordfence_completeCoreUpdateNotification Sun, 16 Jun 2019 08:48:32 +0000 (Overdue) wordfence_completeCoreUpdateNotification Tue, 18 Jun 2019 06:35:04 +0000 (Overdue) wordfence_completeCoreUpdateNotification Tue, 18 Jun 2019 06:35:15 +0000 (Overdue) wordfence_completeCoreUpdateNotification Tue, 18 Jun 2019 06:35:27 +0000 (Overdue) wordfence_completeCoreUpdateNotification Tue, 18 Jun 2019 06:36:04 +0000 (Overdue) wordfence_completeCoreUpdateNotification Tue, 18 Jun 2019 09:35:51 +0000 (Overdue) recovery_mode_clean_expired_keys Tue, 18 Jun 2019 09:35:56 +0000 (Overdue) wordfence_completeCoreUpdateNotification Tue, 18 Jun 2019 09:35:56 +0000 (Overdue) wordfence_refreshUpdateNotification Sat, 20 Jul 2019 11:12:06 +0000 (Overdue) wordfence_ls_ntp_cron Mon, 02 Sep 2019 09:58:41 +0000 (Overdue) wordfence_daily_cron Mon, 02 Sep 2019 09:58:41 +0000 (Overdue) wordfence_hourly_cron Tue, 03 Sep 2019 12:00:00 +0000 (Overdue) wordfence_email_activity_report Fri, 11 Oct 2019 04:53:29 +0000 ai1wm_storage_cleanupHey @merkucio,
It looks like WordPress is having cron issues. This is causing problems for other plugins such as UpDraft, and WordPress actions such as scheduled posts. You might speak with your host to see if they can find the issue, or possibly set up a manual cron job.
Please let me know how it goes.
Thanks,
Gerroald
@wfgerald
I don’t use scheduled posts or UpDraft(I used it, but not now). And don’t understand how it is related with this table size?Can I clear this table using
DELETE FROM wp_wfHits;
?Hey @merkucio,
For any scheduled event to be triggered wp_cron has to be working. The logs you shared shows multiple cron fails from various plugins and WordPress. Wordfence can’t delete the data during the scheduled times if your cron jobs aren’t working. The result is that your table data will continue to grow, and anything else on the site that relies on any type of schedule will fail as well. This really needs to be addressed for the health and functionality of your site.
https://codex.wordpress.org/Function_Reference/wp_cron
https://codex.wordpress.org/Function_Reference/wp_schedule_event
The easiest way would be to delete the table using a tool like phpMyAdmin. You don’t need to run a query, you can do this in the UI.
https://hostpapasupport.com/delete-table-database-phpmyadmin/
Please note you’ll want to deactivate and reactivate Wordfence to regenerate the table.
Thanks,
Gerroald
Hey @merkucio,
We haven’t heard back from you in a while, so I’ve gone ahead and marked this thread as resolved.
Please feel free to open another thread if you’re still having issues with Wordfence.
Thanks,
Gerroald
-
This reply was modified 6 years, 9 months ago by
The topic ‘wp_wfHits Table’ is closed to new replies.