How to Deal with Millions of Records in 404 Redirection Log
-
The other day I noticed my WordPress database had grown to more than 1.4GB, which made no sense to me. Upon further investigation, I found that it was mostly due to the 404 error log in redirection having roughly 3.5 Million entries.
I was able to luckily spot the DELETE ALL button (I suggest the owner of this plugin, move this button to the top). Not sure why its hided at the button, and as many people have posted on this forum, it seems most do not notice it. Luckily i did and it said me from going through page by page to delete these.
Anyway, I cleared everything, and then this morning after checking the table again using WP Optimize, I saw that another 20k were added in (just 10 hrs later). Which means this will grow again quite rapidly.
How can I resolve this? I don’t understand why this error log table is growing so quickly and why entries are being added. I did massively change the site from a previous Drupal site with different URL paths, however, that was more than a year or so ago, why am I still getting so many 404s. Is there something else that’s going wrong here?
Thanks!
- The topic ‘How to Deal with Millions of Records in 404 Redirection Log’ is closed to new replies.