[ejabberd] mnesia vs MySQL

Michael Ossareh ossareh at gmail.com
Sat May 24 01:32:57 MSD 2008


On Fri, May 23, 2008 at 2:29 PM, anders conbere <aconbere at gmail.com> wrote:
> On Fri, May 23, 2008 at 2:24 PM, mark peleus <mark.peleus at gmail.com> wrote:
>> How can you tell that the database is thrashing to your disks?
>
> We were monitoring disk use on the server (to be fair we were
> monitoring all server resources, but the disks were the bottle neck)
>
>>
>> How many users did cause the problem and how big was the roster?
>
> aprox: 10k users, with 200 roster items in each roster

is that simultaneous users online at once ?

>
>>
>> Do you know if it is easier to cluster with mnesia compared to mysql?
>
> I don't, that's something I'm sure we'll be getting to soon as well.
>
> ~ Anders
>
>>
>> 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
>>
>>
>> _______________________________________________
>> 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
>



-- 
"Don't go through life, grow through life."
- Eric Butterworth


More information about the ejabberd mailing list