Database is way too big due to AIOWPS

Hi,

The plugin has a code which will periodically check the tables created by aiowps and it will cleanup any table which has more than 5000 rows, ie, the code will delete the oldest rows and keep the newest 5000. The “5000” rows is set as a default in the code. However the developers have also added filters to allow you to be able to set your own value.

The filters can be found in the wp-security-backup.php file in the function called aiowps_scheduled_db_cleanup_handler.

The cleanup process is triggered once daily using the inbuilt WordPress “wp_schedule_event”.
One way to trigger the cleanup process immediately is to deactivate and activate the aiowps plugin which should kick off the scheduled event.

To use the filters you should not edit any of this plugin’s files but instead you will need to add some code to your theme’s functions.php file.

For example:

add_filter( 'aiowps_max_rows_event_table', 'change_table_rows_remaining', 10, 1 );
add_filter( 'aiowps_max_rows_failed_logins_table', 'change_table_rows_remaining', 10, 1 );
add_filter( 'aiowps_max_rows_login_attempts_table', 'change_table_rows_remaining', 10, 1 );
add_filter( 'aiowps_max_rows_global_meta_table', 'change_table_rows_remaining', 10, 1 );

function change_table_rows_remaining( $rows ) {
	return '1000';
}

The above will set the maximum number of rows to keep for all of the tables to 1000.

Let me know if the above helps you.

Kind regards

Hi,

What if I would disable the scanner module at all -> then disable the plugin -> then delete that row -> and finally reactivate the plugin again?

I guess you cold try that. But make sure you create a database backup first just in case something happens.

Kind regards