Hey folks! We have noticed that our XWiki partition is getting fuller and fuller and the culprit seems to be the activitystream_events_status table which is now 7.5 GB. I don’t know where this is coming from or have a clue what the table even means. Does somebody have more info or an idea what I can do about it? How can I analyse the contents of the table? They seem rather cryptic to me.
Best,
Linus
This table contains mapping between users and events, which is what lead to user notifications in the top right corner.
7.5 GB sounds a lot, it’s generally much smaller than the activitystream_events (the one which actually contains events) unless you have a huge number of users watching many active documents. Or maybe something else is generating a lot of user notifications.
Note that those are actually legacy tables kept for retro compatibility reasons (in case some extension directly query those tables), this kind of information is now stored in Solr with a lot less of duplication.
Hi, thanks so much for the information. The activitystream_events is significantly smaller.
Note that those are actually legacy tables kept for retro compatibility reasons (in case some extension directly query those tables), this kind of information is now stored in Solr with a lot less of duplication.
Maybe I can backup and clear the table? Would this break anything?
It depends on the XWiki version. Emptying those tables won’t have any kind of impact in XWiki Standard 14.6+ but previous versions were still relying on it for some less used features (like messaging). Of course even on old versions the worst that can happen when you empty those tables is that you will miss some old notifications, so not a huge functional problem.
The best would probably be to selectively remove all the entries older than a specific date (like one month).
Thank you for the info! That makes a lot of sense. We indeed have a lot of people watching a lot of pages because everyone has subscribed to the entire wiki (with the “subscribe to this wiki” button under the bell) per default. Do you know off the top of your head which option we can change so that people aren’t subscribed to the entire wiki by default? We couldn’t find it until now.
Thank you very much for your help already!