• Resolved Igrika

    (@merkucio)


    Hello,

    My options:
    Amount of Live Traffic data to store (number of rows) – 50
    Maximum days to keep Live Traffic data (minimum: 1) – 1

    Despite 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?

Viewing 8 replies - 1 through 8 (of 8 total)
  • 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

    Thread Starter Igrika

    (@merkucio)

    @wfgerald

    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

    Thread Starter Igrika

    (@merkucio)

    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_cleanup

    Hey @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

    Thread Starter Igrika

    (@merkucio)

    @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;
    ?

    • This reply was modified 6 years, 9 months ago by Igrika.
    • This reply was modified 6 years, 9 months ago by Igrika.
    • This reply was modified 6 years, 9 months ago by Igrika.

    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

Viewing 8 replies - 1 through 8 (of 8 total)

The topic ‘wp_wfHits Table’ is closed to new replies.