I'm having trouble importing a db locally. So I'm doing a reduction test by importing batches of tables at a time, until I meet the offender.
exp_super_search_terms looks suspiciously offensive. It's weighing in at nearly 60MB and contains what looks like random spammy entries. There are over 1.2million entries in it. Yup, you read correctly. So, I'd like to empty it of it's gunk and possibly disable any future entries being recorded in it.
But the exp_super_search_terms "does not contain a unique column. Grid edit, checkbox, Edit, Copy and Delete features are not available."
So how do I go about flushing it?
And how do I not make it writable anymore, until we sort out the spam barrage?
UPDATE I've emptied the table. But I'd still be interested in knowing how to keep the table in check from further assaults.