Where are tables in Mnesia located?

Posted by Sanoj on Stack Overflow See other posts from Stack Overflow or by Sanoj
Published on 2010-04-07T22:21:25Z Indexed on 2010/04/07 22:23 UTC
Read the original article Hit count: 409

Filed under:

erlang

|

mnesia

|

limitations

I try to compare Mnesia with more traditional databases.

As I understand it tables in Mnesia can be located to:

ram_copies - tables are stored in RAM only, so no durability as in ACID.
disc_copies - tables are located on disc and a copy is located in RAM, so the table can not be bigger than the available memory?
disc_only_copies - tables are located to disc only, so no caching in memory and worse performance? And the size of the table are limited to the size of dets or the table has to be fragmented.

So if I want the performance of doing reads from RAM and the durability of writes to disc, then the size of the tables are very limited compared to a traditional RDBMS like MySQL or PostgreSQL.

I know that Mnesia aren't meant to replace traditional RDBMS:s, but can it be used as a big RDBMS or do I have to look for another database?

The server I will use is a VPS with limited amount of memory, around 512MB, but I want good database performance.

Are disc_copies and the other types of tables in Mnesia so limited as I have understood?

© Stack Overflow or respective owner

Related posts about erlang

Starting an Erlang slave node in escript fails when using custom Erlang in Ubuntu 10.4

as seen on Stack Overflow - Search for 'Stack Overflow'
I have the following escript: #!/usr/bin/env escript %%! -name [email protected] main(_) -> NodeName = test, Host = '127.0.0.1', Args = "", {ok, _Node} = slave:start_link(Host, NodeName, Args), io:format("Node started successfully!"). When running it on Ubuntu 10.04… >>> More
How to setup Erlang + Emacs with erlang.el?

as seen on Stack Overflow - Search for 'Stack Overflow'
I have downloaded and installed Erlang and EmacsW32. But how do I use erlang.el in Emacs? Where do I place it or install it? I have read Erlang/OTP R13B04 documentation and Erlang mode for Emacs documentation but I haven't found any information about how to set up it. >>> More
How do I install LFE on Ubuntu Karmic?

as seen on Stack Overflow - Search for 'Stack Overflow'
Erlang was already installed: $dpkg -l|grep erlang ii erlang 1:13.b.3-dfsg-2ubuntu2 Concurrent, real-time, distributed function ii erlang-appmon 1:13.b.3-dfsg-2ubuntu2 Erlang/OTP application monitor ii erlang-asn1 … >>> More
How to switch between the upper and lower pane in emacs?

as seen on Super User - Search for 'Super User'
I am using the erlang mode in Aquamacs. The mode, by default, creates a new pane and buffer "*erlang*" when I hit C-C C-K to compile an erlang file. (as seen in the attached screen shot) What is the easiest way to switch between these two panes? I do not think "C-x b" is applicable in this case… >>> More
Erlang: Mnesia or Mysql ?

as seen on Stack Overflow - Search for 'Stack Overflow'
What DMBS do you use with Erlang ? and Why ? >>> More

Related posts about mnesia

Erlang: Mnesia or Mysql ?

as seen on Stack Overflow - Search for 'Stack Overflow'
What DMBS do you use with Erlang ? and Why ? >>> More
Where are tables in Mnesia located?

as seen on Stack Overflow - Search for 'Stack Overflow'
I try to compare Mnesia with more traditional databases. As I understand it tables in Mnesia can be located to: ram_copies - tables are stored in RAM only, so no durability as in ACID. disc_copies - tables are located on disc and a copy is located in RAM, so the table can not be bigger than the… >>> More
mnesia primary key

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi I have two tables one notes and one tag and I want to make the id from notes primary key to use it in the tag table, but I don't know where I do wrong. My notes id is generate from another table counter, with the function dirty_update_counter. My function for the id_notes from tag looks like… >>> More
Is tcerl for Mnesia production ready? Is there any alternatives?

as seen on Stack Overflow - Search for 'Stack Overflow'
I would like to create a scalable web service using Mnesia as database. However Mnesia per default isn't scalable for persistent storgage since it is using Dets (which has a 2GB limit) as backend. I have seen discussions about extending Mnesia with MnesiaEx and use tcerl as backend. It sounds good… >>> More
Mnesia: A Distributed DBMS Rooted in Concurrency

as seen on Internet.com - Search for 'Internet.com'
Find out what makes Mnesia, the Erlang-based database management system, perfect for distribution across a network of computers. >>> More