Eximstats database is too large

Symptoms

On servers with lower disk performance, you can observe that the below script causes load.

/usr/local/cpanel/scripts/eximstats_spam_check

Description 

By default, cPanel will check for spammers and notify the admin on the server. This functionality is facilitated by a cron that runs the below task:

/usr/local/cpanel/scripts/eximstats_spam_check

This script queries the Eximstats database. It can cause a load on the server if this database gets too large.

For example:

/var/cpanel/eximstats_db.sqlite3 (8GB)

The default retention for this database is 10 days. But many servers may be configured for 30 days. The previous default for this option used to be 30 days in a previous version of cPanel.

Workaround

If this functionality is required, reducing the retention days for Eximstats is recommended.

• Login to WHM
• Navigate to Tweak Settings
• Under "Stats and Logs" log for option:

The interval, in days, to retain Exim stats in the database

• Toggle the default option or reduce the enter a custom number of days.
• Click save to match the change active

Note: During cPanel updates, it will prune the additional data down to the size selected for the number of days to return eximstats information.