[ejabberd] mnesia vs MySQL

Michael Ossareh ossareh at gmail.com
Sat May 24 01:56:12 MSD 2008


On Fri, May 23, 2008 at 2:48 PM, anders conbere <aconbere at gmail.com> wrote:
> On Fri, May 23, 2008 at 2:32 PM, Michael Ossareh <ossareh at gmail.com> wrote:
>> 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

Thanks. We often have users with rosters in the many hundreds.

We just migrated our roster over to mnesia disk. We'll keep an eye on the perf.

>>
>> is that simultaneous users online at once ?
>
> yep, simulated though not live :)
>
> ~ Anders
>
>>
>>>
>>>>
>>>> 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
>> _______________________________________________
>> 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