[ejabberd] mnesia vs MySQL

mark peleus mark.peleus at gmail.com
Sat May 24 01:24:21 MSD 2008


How can you tell that the database is thrashing to your disks?

How many users did cause the problem and how big was the roster?

Do you know if it is easier to cluster with mnesia compared to mysql?

Thanks

On Fri, May 23, 2008 at 9:46 AM, anders conbere <aconbere at gmail.com> wrote:

> On Fri, May 23, 2008 at 9:36 AM, mark peleus <mark.peleus at gmail.com>
> wrote:
> > Hi,
> >
> > I've read how to work with ejabberd and  mnesia or MySQL but it is not
> clear
> > to me which one is better and for what purpose.
> >
> > Can you please tell me which one:
> >
> > - have better performance
> > - easier to cluster
> > - works better with large amount of registered users
>
> In our tests with large numbers of users, with large rosters, mnesia
> started thrashing our disks. This was mitigated by moving to MySQL.
> That being said... we're not Mnesia engineers and could be doing
> something wrong.
>
> ~ Anders
>
> > - easier to manage. I use phpmyadmin for mysql. Is there an
> administration
> > tool for mnesia?
> >
> > Thanks.
> >
> > _______________________________________________
> > ejabberd mailing list
> > ejabberd at jabber.ru
> > http://lists.jabber.ru/mailman/listinfo/ejabberd
> >
> >
> _______________________________________________
> ejabberd mailing list
> ejabberd at jabber.ru
> http://lists.jabber.ru/mailman/listinfo/ejabberd
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jabber.ru/pipermail/ejabberd/attachments/20080523/1c7973d5/attachment.htm 


More information about the ejabberd mailing list