• Resolved pierregielen

    (@pierregielen)


    I have a problem with the WPAIOS related database table ‘bgoc_aiowps_events’. It now contains 1.509.312 rows and clogs up my database very fast. For what part of WP All in One Security is it used? Since there is no option to delete it from within the plugin itself, it can only grow and I apparently need to remove it manually. Can I safely delete it in PhPMyAdmin?

Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Support vupdraft

    (@vupdraft)

    In the first instance can you try simply deactivating and reactivating the plugin, does this reduce the number of rows.

    Can you also try adding this to your themes functions.php

    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’;

    Thread Starter pierregielen

    (@pierregielen)

    Thank you! It now seems that the database filled up so quickly because of a DDOS attack, causing 1.5 million 404 messages in one day by only a handful of IP addresses.

    I think it would be great if All In One Security could detect such an attack and limit the number of 404 lines itself to a number defined in the settings, without having to change a php file.

    Thread Starter pierregielen

    (@pierregielen)

    I think that there is a closing bracket } missing after the return ‘1000’;

    Plugin Support vupdraft

    (@vupdraft)

    Hi,

    Sincere apologies, it was missing a bracket. As for your suggestion, that is an excessive amount of message. I will talk to our development team about it.

    Plugin Contributor Prashant Baldha

    (@pmbaldha)

    @vupdraft @pierregielen We would like to make max rows capped to 1000 instead of 5000. It might be released in the next release or next to next release.

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘WPAIO clogs up my database’ is closed to new replies.