I have just noticed that the number of users in our XWikiAllGroup (6246) differs from the total list of objects in XWikiAllUserGroup (6319) with 73 entries. After some research, I see that the group itself still contains the objects of a lot of previously deleted members. Hence the discrepancy. Now the question: is this a problem that I need to take care of?
I assume that the members are linked to the group via the documents name. So that actually means with the name of the user as this way oidc creates the users profile. In other words: if we had an admin named āJane Doeā for a short time, but she left the company (and we deleted the user) and a new person with the name āJane Doeā arrives a little later, this person is immediately an admin.
Hm, we have an issue. Today I deleted 37 accounts. 36 stayed as zombies and were not removed from the XWikiAllGroup. This time I had all tabs opended until the job really showed ādoneā. (For an unknown reason this takes a long time.) I think I deleted these accounts one by one (including opening the account page in a single tab) with about 10 seconds delay between. (And the job done every time took longer than 10 seconds.)
What is your experience deleting accounts: how long will it take until the job is ādoneā? (Have in mind that we have about 6.500 users in the XWikiAllGroup.)
Which version of XWiki are you using ? The speed to modify very big groups was improved recently by XWIKI-22613, XWIKI-22573 and XWIKI-22782 (so basically need XWiki 17.1+ to have them all, or 16.10.4+ with the workaround configuration explained in XWIKI-22613).
XWIKI-22573 is included in 15.10.13 and the workaround explained in Loading... (stop storing diffs in the history table) should work just fine in 15.10.3 too, and itās by far the main performance penalty.
But anyway, I do recommend moving to a supported LTS branch, indeed.
Yes. But thatās basically exactly what is done in more recent versions of XWiki (the default just changed to 1). The only difference (which can also be applied by hand) is that, in the case of MySQL/MariaDB, we also switched the table which is storing the document history to Compressed row format (ALTER TABLE xwikircs ROW_FORMAT=Compressed).
When I look into our xwiki.cfg I donāt find the key xwiki.store.rcs.nodesPerFull. Can you provide me an actual excerpt of this region so we can fill this is?
xwiki.cfg normally has a lot of useful comments around the entries. I just wanted to participate of those original comment. (But this will at least happen when I update the wiki later and the config is merged I guess.)
This option is still very much internal. We did not dare removing it entirely just yet, but we would really prefer users not to touch this behavior, and eventually entirely remove the concept of diff in the history so that we can simplify a lot the code and fully rely on that to improve other aspects (mainly around the performances of loading a specific version).