wfHits starts to become very big

How large is your wfHits table? And how long has the site been operating? I can pass the comment on to the developers, but just want to see if it is unusually large.

my DB is not very large, It has 320MB but from these 320MB, 210MB are taking by wfHits table!

another site DB 600MB from which wfHits table 478MB!!?

Ok, I don’t think that is normal! wfHits is normally cleaned up daily, so that it shouldn’t get excessively large.

Can you check your site’s scheduled jobs, to see if wp-cron is not running? Near the bottom of the Wordfence Options page, there is a link that says “Click to view your systems scheduled jobs in a new window” — then in the list of jobs, do you see any that start before today’s date? For me, there are only about 25 jobs scheduled, but there may be more depending on the plugins you use.

Another possibility is that your database permissions do not allow records to be deleted from the table (or for the table to be truncated). If you are not sure how to check that, your hosting company can probably help.

If you know where to find your site’s error log, there might be some information in there that would help, also.

Wordfence Cron Viewer is full of data starting with 26 may 2014

Ok, it sounds like WordPress’s cron jobs are probably not running. The WordPress core and other plugins use cron for various scheduled tasks, such as deleting old “trash” in your posts and comments periodically.

Some hosting companies disable WordPress’s cron, or you might have plugins or a line in your wp-config.php that has disabled it.

Are you running any other security or performance plugins that might have disabled it?

Does your wp-config.php file have a line that says “define(‘DISABLE_WP_CRON’, ‘true’);” ?

Also, in case it still may be a database permissions issue — do you know if Wordfence’s scheduled scans are running? (You can check this on the Wordfence “Scan” page, by looking at the dates in the yellow Scan Summary box.)

I’m having the same issue. My wfHits table has 508,088 rows and is 74.3MB. Doesn’t look like the crons have been running at all. I didn’t see any WordFence crons in the list until I updated the plugin yesterday. This is all currently at the bottom of the list – https://grab.by/JaOa Which cron job should clean out that table? Is there a way to manually run the job?

The wordfence_daily_cron job would cut down the wfHits table. I don’t know of any good way to run cron jobs manually.

In addition to the items above, you might also try disabling all other plugins, and seeing if wp-cron will run then.

If you are still having trouble with wp-cron, you may be able to use this plugin to run the overdue cron jobs, at least as a temporary solution:
https://www.ads-software.com/plugins/wp-crontrol/

I haven’t used it myself, but it does have an option to run individual cron jobs manually. If you post on the main www.ads-software.com forum about wp-cron not working, someone may be able to help get it to work correctly on your site.