|
|
| Author |
Message |
< Erlang ~ mnesia capacity |
| iWantToKeepAnon |
 Posted: Sat Sep 27, 2008 4:24 am |
 |
|
|
User
Joined: 31 Jul 2007
Posts: 14
Location: Dallas, TX
|
I was wondering how people use mnesia. I read where some record transactions (web based, message passed, etc...) in it for processing, but the enterprise data is usually stored in oracle or something like mysql. But could (or should) I try and store the bulk of my data in it? Why limit mnesia to just transient data. Can mnesia handle multiple tables of 1 million+ records? Is it recoverable? Is it reliable for enterprise data? Or should I stick to comercial solutions for that?
Thanks for any insight you can give. |
|
|
| Back to top |
 
|
| francesco |
| Posted: Sat Sep 27, 2008 6:59 pm |
|
|
|
User
Joined: 07 Jul 2006
Posts: 249
Location: London
|
Usage of Mnesia depends on the size of your data. In the 32 bit implementaiton, you have a 2GB limit to the size of your data.
Large databases in production have in excess of 10 million entries in fragmented tables distributed across many nodes on two machines, mainly used for lookup purposes. These machines are beefed up when it comes to memory.
If your user data will be in excess of the above, you might want to use a more powerful database. At ETC, we tend to use postgres and BDB when Mnesia is not enough. But if we get away with Mnesia, then we use it, as integrating your data store in the same memory space as your glue and logic has many advantages, including speed and ease of maintainence.
If you think your tables will not fit in Mnesia, use it as a local cache to store live session data, deleting it when the session is completed.
You can also read
http://erlang-consulting.com/thesis/dbms_eval.html
Hope this helps,
Francesco
--
http://www.erlang-consulting.com |
|
|
| Back to top |
|
| iWantToKeepAnon |
| Posted: Mon Sep 29, 2008 1:21 pm |
|
|
|
User
Joined: 31 Jul 2007
Posts: 14
Location: Dallas, TX
|
|
| Back to top |
|
|
|
All times are GMT
|
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot attach files in this forum
You cannot download files in this forum
|
|
|
Digg It
Del.icio.us
Reddit
Facebook
Stumble Upon
Technorati
