Ithemes filling SQL

Hi Oriver,

The default value for “Days to Keep Database Logs” is 60 days. For file logs it is by default 180 days.

Usually the iTSec plugin will add a cron job (purge-log-entries) with a daily schedule that is responsible for maintaining the logs size.

You could manually clear the logs (and again, and again …), but it would be far better to have this automated.

+++++ To prevent any confusion, I’m not iThemes +++++

• This reply was modified 1 year, 10 months ago by nlpro.
• This reply was modified 1 year, 10 months ago by nlpro.

Hi Oriver,

It may already be working. To check this, follow the steps below.

If not already add the line below to the wp-config.php file:

define('ITSEC_DEBUG', true);

This should add an extra Debug menu item under the Security menu option.

Then navigate to Security > Debug.

In the Scheduler section you should see an entry named purge-log-entries. Additionally, you should see at the bottom of the list of (itsec) cron entries which type of scheduler is currently active (ITSEC_Scheduler_Cron for cron, ITSEC_Scheduler_Page_Load for the page load scheduler).

Another relevant piece of info to check is the current value for the “Days to Keep Database Logs“ setting. We have already seen that the default value is 60 days. But since the setting is configurable it may have a different value in your env.

So in the Settings section of the Debug page select global from the drop-down list and then click on the Load button. Check the value for “log_rotation”.