• Resolved renisauria

    (@renisauria)


    Hi!

    This plugin is increasing the size of wp_options considerably, around 1GB per day. Not sure what temporary data is created in the DB, but I can only remove it if I go in to php myadmin and optimize the table.

    What do you recommend to do in order to prevent this issue? What WP options do I need enabled in order for the plugin clear itself out?

    Thanks!

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Contributor mbrsolution

    (@mbrsolution)

    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

    Plugin Contributor mbrsolution

    (@mbrsolution)

    Hi, is your issue resolved?

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘wp_options gets ridiculously big when I enable this plugin’ is closed to new replies.