Database / Mnesia basics Interview questions
What are the storage types available for a Mnesia table?
Mnesia supports three storage types per table, letting you trade off speed against durability on a per-table basis:
| ram_copies | disc_copies | disc_only_copies |
| In memory only; fastest, lost on node restart. | In memory AND on disk; fast reads, durable across restarts. | On disk only; slower, used when the dataset is too large to fit comfortably in RAM. |
mnesia:create_table(session, [{ram_copies, [node()]}, {attributes, [id, user, expiry]}]).
A table can even use different storage types on different nodes — for example, keeping
disc_copies on a couple of durable nodes while other nodes hold only ram_copies for
fast local reads, all replicating the same logical table.
More Related questions...