Prev Next

Database / Mnesia basics Interview questions

What is the difference between ram_copies and disc_copies?

Both storage types keep an active, fast in-memory copy of the table data for reads and writes during normal operation — the difference is entirely about what happens to that data when the node restarts.

ram_copiesdisc_copies
In memory only.In memory AND mirrored to disk.
Data is lost if the node restarts (unless another node still has a copy). Data survives a node restart, reloaded from disk at startup.
Slightly less write overhead (no disk I/O per write). Small extra write overhead to persist changes to disk.

Read speed is essentially the same for both, since both serve reads from the in-memory copy — disc_copies only adds overhead on the write path, in exchange for durability across restarts.

What happens to a ram_copies-only table's data when its node restarts?
How do read speeds compare between ram_copies and disc_copies tables?

Invest now in Acorns!!! 🚀 Join Acorns and get your $5 bonus!
Acorns Logo

Invest now in Acorns!!! 🚀
Join Acorns and get your $5 bonus!

Earn passively and while sleeping

Acorns is a micro-investing app that automatically invests your "spare change" from daily purchases into diversified, expert-built portfolios of ETFs. It is designed for beginners, allowing you to start investing with as little as $5. The service automates saving and investing. Disclosure: I may receive a referral bonus.

Robinhood Logo

Invest now!!! Get Free equity stock (US, UK only)!

Use Robinhood app to invest in stocks. It is safe and secure. Use the Referral link to claim your free stock when you sign up!.

The Robinhood app makes it easy to trade stocks, crypto and more.


Webull Logo

Webull! Receive free stock by signing up using the link: Webull signup.

More Related questions...

What is Mnesia? What is a Mnesia table? What are the storage types available for a Mnesia table? What is a Mnesia schema? How do you create a Mnesia schema? How do you create a Mnesia table? What is a Mnesia transaction? How do you write a record to a Mnesia table? How do you read a record from a Mnesia table? What are dirty operations in Mnesia? What is mnesia:dirty_read/1? What is a Mnesia record? How do you delete a record from a Mnesia table? What is the purpose of mnesia:start/0? How do you stop Mnesia? What are the Mnesia table types (set, ordered_set, bag)? What is a Mnesia index? How do you add a secondary index to a Mnesia table? What is mnesia:info/0 used for? How do you check if Mnesia is running? What is the Mnesia directory (Mnesia.dir)? What is the primary key in a Mnesia table? What is mnesia:select/2 used for? What is record_info used for when creating a Mnesia table? What are the attributes of a Mnesia table? What is a Mnesia node? How do you replicate a table across multiple Mnesia nodes? What is mnesia:table_info/2 used for? Describe the difference between a Mnesia table and an ETS table? Why should Mnesia operations generally run inside a transaction? When should you use dirty operations instead of a transaction? What is the difference between ram_copies and disc_copies? What is disc_only_copies and when would you use it? What happens to a disc_copies table when its node restarts? How do you change a table's storage type at runtime? What is a Mnesia table lock and how does it work? How does Mnesia keep replicated tables consistent across nodes? How do you migrate a Mnesia record definition when its fields change? What is mnesia:transform_table/3 used for? When should you choose bag over set for a Mnesia table? How do you back up a Mnesia database? How do you restore a Mnesia database from a backup? Explain the lifecycle of a Mnesia transaction from start to commit? How do you troubleshoot a Mnesia table stuck in the "loading" state? What is mnesia:force_load_table/1 and when should you use it? What is the difference between mnesia:read/1 and mnesia:wread/1? What is a Mnesia checkpoint used for? How does Mnesia resolve conflicts after a network partition heals?
Show more question and Answers...

Integration

Comments & Discussions