[ejabberd] pubsub_item.DAT getting big

Stephan Maihöfer sma at turtle-entertainment.de
Mon Oct 6 14:28:00 MSD 2008


is anyone up for a jabber session to help me on this
problem? over the weekend our database grew to
650 mb again and i have several nodes with hundreds
of items.

i found out with eric last week that it seems that the
pubsub_item mnesia table is not correctly populated but
i get the items and can see them in PSI.

also it seems that items and subnodes are not being deleted
when i delete a colleciton node. sooo...at the moment the
only way to get the server up and running again once the
database reaches the "critical mass" is to stop it, delete
the database, copy stuff over we still need and then start
the jabberserver again, and create all neccessary nodes.

this is a very tedious job and gives us downtime every
five days or so. since all the clustering goes down as
well this means a complete outage of our jabber infrastructure.

i would be very glad if someone could help me with this
problem and am more than willing to spend some time on
jabber to provide the neccessary data.

thanks in advance,

> -----Ursprüngliche Nachricht-----
> Von: ejabberd-bounces at jabber.ru 
> [mailto:ejabberd-bounces at jabber.ru] Im Auftrag von Christophe Romain
> Gesendet: Donnerstag, 2. Oktober 2008 21:10
> An: ejabberd at jabber.ru
> Betreff: Re: [ejabberd] pubsub_item.DAT getting big
> > It's because I do a match on part of the index I guess ?
> yes, and the match makes mnesia testing all records.
> so the more you have nodes, the most consumming it is for 
> each publish.
> _______________________________________________
> ejabberd mailing list
> ejabberd at jabber.ru
> http://lists.jabber.ru/mailman/listinfo/ejabberd

More information about the ejabberd mailing list