I’ve already had an offline message table in mysql with more than 8GB. I’ve cleared the table and kept an eye on it.
After a week, my offline messages are already 150MB big.
I’ve looked into the mysql table and the messages there are all pubsub events like this:
<message to="firstname.lastname@example.org" from="email@example.com" id="firstname.lastname@example.org__xxx@etecture.de__aRnPd"><event xmlns="http://jabber.org/protocol/pubsub#event"><items node="http://jabber.org/protocol/tune"><item id="3ff4b198-4260-480a-93df-0fed339d0e1b151" node="http://jabber.org/protocol/tune"><tune xmlns="http://jabber.org/protocol/tune"/></item></items></event></message>
can someone please explain to me, what these messages are and why are they staying there?
it degrades performance and wastes space, so i would be glad to get rid of them.
any hint is appreciated!
P.S.: its a openfire 3.9.2 on debian linux with mysql 5.5 right now. had the same problem with 3.8.x, too.