Title: Row in database full
Last modified: August 10, 2023

---

# Row in database full

 *  Resolved [alexisfontana74](https://wordpress.org/support/users/alexisfontana74/)
 * (@alexisfontana74)
 * [2 years, 9 months ago](https://wordpress.org/support/topic/row-in-database-full/)
 * Good morning,
 * I have a line in the database of a customer site that weighs 503.4 MiB: mp_aiowps_audit_log
 * The database capacity is 400 MB but we are currently at a total of 530 MB.
 * I can no longer log into the WP back office.
 * How to clean this database line from phpmyadmin without breaking everything please?

Viewing 3 replies - 1 through 3 (of 3 total)

 *  Plugin Support [aporter](https://wordpress.org/support/users/aporter/)
 * (@aporter)
 * [2 years, 9 months ago](https://wordpress.org/support/topic/row-in-database-full/#post-16962439)
 * Hi,
 * You can just empty the table contents from phpmyadmin, but do not delete the 
   table.
   Before you remove all the rows from the table are you able to check what
   it’s been filled up with?
 * A few others have reported this and theirs are filled with failed login attempts.
 * Now you can either look into preventing them brute force attempts which will 
   stop the logging.
 * Or if you don’t care about the attempts you can either ignore them and change
   the automatic cleanup time, or prevent them from logging at all.
 * By default logs older than 90 days are removed, you can change that time by adding
   this constant to your wp-config:
 * define(‘AIOWPSEC_PURGE_AUDIT_LOGS_AFTER_DAYS’, 10);
 * That will remove logs older than 10 days.
 * Or if you don’t want to log some or all events you can use the following filter:
 * ‘aios_audit_log_record_event’
 * Best Wishes,
 * Ashley
 *  Plugin Support [hjogiupdraftplus](https://wordpress.org/support/users/hjogiupdraftplus/)
 * (@hjogiupdraftplus)
 * [2 years, 9 months ago](https://wordpress.org/support/topic/row-in-database-full/#post-16962450)
 * Hi [@alexisfontana74](https://wordpress.org/support/users/alexisfontana74/)
 * Sorry I am not getting line in database means the total table size for the mp_aiowps_audit_log
   table? If yes and want to delete old records than 1 Aug 2023 as per unix epoch
   time. you may run below query in database. or change last created value as per
   you want to delete old records
 *     ```wp-block-code
       DELETE from mp_aiowps_audit_log WHERE created < 1690848000
       ```
   
 *  Thread Starter [alexisfontana74](https://wordpress.org/support/users/alexisfontana74/)
 * (@alexisfontana74)
 * [2 years, 9 months ago](https://wordpress.org/support/topic/row-in-database-full/#post-16964627)
 * Hello [@aporter](https://wordpress.org/support/users/aporter/) ,
 * Thank you for your feedback.
 * I deleted all the rows from the database and the problem disappeared.
 * Best regards,

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘Row in database full’ is closed to new replies.

 * ![](https://ps.w.org/all-in-one-wp-security-and-firewall/assets/icon-256x256.
   png?rev=2798307)
 * [All-In-One Security (AIOS) – Security and Firewall](https://wordpress.org/plugins/all-in-one-wp-security-and-firewall/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/all-in-one-wp-security-and-firewall/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/all-in-one-wp-security-and-firewall/)
 * [Active Topics](https://wordpress.org/support/plugin/all-in-one-wp-security-and-firewall/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/all-in-one-wp-security-and-firewall/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/all-in-one-wp-security-and-firewall/reviews/)

 * 3 replies
 * 3 participants
 * Last reply from: [alexisfontana74](https://wordpress.org/support/users/alexisfontana74/)
 * Last activity: [2 years, 9 months ago](https://wordpress.org/support/topic/row-in-database-full/#post-16964627)
 * Status: resolved