Invision Community 4: SEO, prepare for v5 and dormant account notifications Matt November 11, 2024Nov 11
Posted March 2Mar 2 Hi,I have been afraid to prune member history because I am not really sure what the effect will be but now my core_member_history table is HUGE. Might even be impacting site performance it's so huge. ~15GB+ (just this one table alone)What happens if I set the prune date in the ACP? Will it impact downloads files orders? Will customers no longer see their order history? Will they lose access to things they bought (files) using downloads (nexus gateway)? Please help me to understand what the impact will be. I don't want to upset my members and customers. Anyone who has used this feature. Let me know. PS: my IP and known devices tables are HUGE also and I did try the prune settings but those don't get any smaller so I have no idea what those prune settings do either. EDIT: also if you know, will kicking off the prune make my site slow to a crawl since it would likely be a massive prune at this point and hammer mysql? or will IPS chunk it and handle it gracefully?
March 3Mar 3 Community Expert If you are referring to manually pruning tables, you shouldnt ever do that. You should only ever use the features built into the software in the member settings section. It would be clearing thing you see on the right panel of a member in the admin CP. It would not wipe things like order history and access to things they have purchased.
March 3Mar 3 Author If you are referring to manually pruning tables, you shouldnt ever do that. You should only ever use the features built into the software in the member settings section. It would be clearing thing you see on the right panel of a member in the admin CP. It would not wipe things like order history and access to things they have purchased.Hi Thank you. I certainly do not want to manually prune any table. I am asking about features available in the ACP. Just wanted to understand what happens before I use it. Will it crash my site if I use it at this point and try to clear 5 years or so? I can't imagine that being anything but a VERY intensive query that is kicked off.
