The XFF and user agent columns present a lot of duplication, especially with user agents becoming less specific recently (T242825).
It would be better if these are stored in the comment table or alternatively stored in new tables. Storing in new tables would make searching by user agent and xff strings easier to solve.