[ejabberd] mnesia vs MySQL

Jesse Thompson jesse.thompson at doit.wisc.edu
Mon Jun 2 18:24:24 MSD 2008


Also, look into configuring your mnesia database tables to suit your
hardware limitations and user environment.

Jesse

Michael Ossareh wrote:
> 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
>>
> 
> 
> 

-- 
  Jesse Thompson
  Email/IM: jesse.thompson at doit.wisc.edu
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/x-pkcs7-signature
Size: 3353 bytes
Desc: S/MIME Cryptographic Signature
Url : http://lists.jabber.ru/pipermail/ejabberd/attachments/20080602/921bc2cf/attachment.bin 


More information about the ejabberd mailing list