[ejabberd] Mysql roster consistency check

David Laban alsuren at gmail.com
Tue Apr 16 22:22:51 MSK 2013


Hello all

I have written a couple of SELECTs that can be used to check the consistency 
of your ejabberd.rosterusers mysql table (useful after a large data migration 
for example). They're potentially quite expensive, so I recommend running them 
on a replica rather than your live environment.

https://github.com/alsuren/ejabberd/commits/roster-consistency

Give them a try and tell me if you find them useful.

David.


More information about the ejabberd mailing list