XF 2.3 How to prune all reactions given?

rdn

Well-known member
Is there any SQL query that is safe to run and prune all reactions given, stats, and data?
I would like to save database size and performance, as xf_reaction_content table is already large.

1758679841605.webp
 
3.7gb of data and 10gb of indexes isn't too bad. SpaceBattles has ~16gb of data and 47gb of indexes.

Check to see if you have an old user_like_date index covering the same columns as reaction_user_id_reaction_date, you can probably drop that index. The index reaction_user_id also wouldn't be needed if you have a reaction_user_id_reaction_date index (depends on add-on installs I think?)
 
Last edited:
  • Love
Reactions: rdn
Back
Top Bottom