[ejabberd] mnesia vs MySQL

anders conbere aconbere at gmail.com
Sat May 24 01:48:23 MSD 2008


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
>
> 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
>


More information about the ejabberd mailing list