Audit log bloats database

  • Resolved Daniel

    (@damen02)


    1 year, 6 months ago

    Hi.

    I noticed my database have become huge because of AIOS.
    The aiowps_audit_log table takes nearly 80% of my database.

    I checked the Audit Logs tab and noticed that there are more than 65.000 registers in three moths. Almost all of them are failed access. This is very unusual.

    How ca I prevent database bloating?

    Thanks!

    The page I need help with: [log in to see the link]

Viewing 4 replies - 16 through 19 (of 19 total)
  • Plugin Support hjogiupdraftplus

    (@hjogiupdraftplus)

    Hi @vtad

    No, you can define AIOWPSEC_PURGE_AUDIT_LOGS_AFTER_DAYS to 1, So whenever the next scheduled cronjob runs it tries to check for all the audit log records before 1 days and delete those.

    Regards

    This is clogging up multiple sites. Cleaning the database should be the default, or a setting in the plugin. 200MB of 250MB database is just logging.

    freshpromo

    (@freshpromo)

    I had this problem too, where the wp_aiowps_audit_log table was 360 Mb in size. In the WP backend I cleared all entries from the Audit Log as instructed in this thread. The table which once had 89,000 rows now shows 0, however the size of the table somehow increased from 360 Mb to 455.8 Mb.

    I decided to run the OPTIMIZE TABLE query which generated the output: Table does not support optimize, doing recreate + ...

    The table size did not change when viewing in phpMyAdmin, however upon exporting the entire database, the size is down to 116 Mb whereas before it was over 500. So it appears to have worked.

    However, when viewing the Structure tab in phpMyAdmin, it’s reporting an inaccurate table size. Any idea why this happens and is it ok if I simply delete the wp_aiowps_audit_log table?

    Plugin Support hjogiupdraftplus

    (@hjogiupdraftplus)

    Hi @freshpromo,

    All WordPress tables and AIOS tables wp_aiowps_audit_log use InnoDB table format that is why It do not support Optimize ( MyISAM) type database supports the Optimize operation.

    Please do not Drop table wp_aiowps_audit_log please try Empty table.

    And use below to for innodb if still issue.

    innodb_force_recovery = 1

    Regards

Viewing 4 replies - 16 through 19 (of 19 total)
  • The topic ‘Audit log bloats database’ is closed to new replies.