[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.


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


More information about the ejabberd mailing list