Title: Clear 404 log and database table
Last modified: March 13, 2026

---

# Clear 404 log and database table

 *  [zimbo000](https://wordpress.org/support/users/zimbo000/)
 * (@zimbo000)
 * [1 month ago](https://wordpress.org/support/topic/clear-404-log-and-database-table/)
 * I discovered a problem on a site that was generating 1000s of 404 errors. I believe
   I have fixed this but my 404 log, set to keep for a week, had over 66,000 entries
   and was nearly 50 MB. The table wp_redirection_404 has over 63,000 rows.
 * Changing the Option setting to ‘A day’ has reduced the log down to just over 
   3,000 items but the database table is still as big.
 * What’s the best and quickest way to clear out the database table with such a 
   large number of entries?
 * The page I need help with: _[[log in](https://login.wordpress.org/?redirect_to=https%3A%2F%2Fwordpress.org%2Fsupport%2Ftopic%2Fclear-404-log-and-database-table%2F%3Foutput_format%3Dmd&locale=en_US)
   to see the link]_

Viewing 1 replies (of 1 total)

 *  Plugin Author [John Godley](https://wordpress.org/support/users/johnny5/)
 * (@johnny5)
 * [1 month ago](https://wordpress.org/support/topic/clear-404-log-and-database-table/#post-18851404)
 * The size of your database table in MB, and the number of entries, is not always
   connected. You can empty the table (let them expire, select all delete, or TRUNCATE),
   but the database may still report the space as being used as its pre-allocated
   the space. Unless you have a specific reason, I wouldn’t worry about it, and 
   just let your database do its thing.

Viewing 1 replies (of 1 total)

You must be [logged in](https://login.wordpress.org/?redirect_to=https%3A%2F%2Fwordpress.org%2Fsupport%2Ftopic%2Fclear-404-log-and-database-table%2F%3Foutput_format%3Dmd&locale=en_US)
to reply to this topic.

 * ![](https://ps.w.org/redirection/assets/icon-256x256.jpg?rev=983639)
 * [Redirection](https://wordpress.org/plugins/redirection/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/redirection/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/redirection/)
 * [Active Topics](https://wordpress.org/support/plugin/redirection/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/redirection/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/redirection/reviews/)

 * 1 reply
 * 2 participants
 * Last reply from: [John Godley](https://wordpress.org/support/users/johnny5/)
 * Last activity: [1 month ago](https://wordpress.org/support/topic/clear-404-log-and-database-table/#post-18851404)
 * Status: not resolved