The company I work for has an enterprise Wordpress site that was acquired from a different company. I don't know if there was a past hack or if it's just accumulated spam or what, but the
wp_redirection_404 table has grown to roughly 7GB.
I tried grepping the table for Viagra, Versace, Nike, etc. and got pages of results for each. It's obviously full of junk.
It doesn't appear to be doing anything. In fact, when downloading it locally to work on, I don't even bring that table, and I don't notice anything at all. Also, I do a procedure where I must download from a production site sync back into a staging site. Just the process of downloading and uploading usually takes 1.5 hours. By contrast - on another huge Wordpress site, syncing the database usually takes about 45 seconds.
Do I need this table for anything? Can I just empty it? Any sort of complicated scripting to filter legit values just seems too time consuming at this point, as even loading the sql to look at it can take a couple of minutes. Basically - is there anything in this table that I can't do without?
I'm not looking for anecdotal answers, but someone who really knows or at least has had experience with this exact situation.