Hi, thank you for contacting us.
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 but the developers have also added filters for this 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. If you don’t want to set it up to 1000, you can choose a different value i.e. 2000, 3000, 4000 etc.
Let me know if the above helps you.
Kind regards
