I’ve never heard of anyone who actually uses mnesia for real or would consider it prime-time. I’m no Oracle fanboy but comparing their DB to mnesia is like comparing an oil rig driller to a fisher price screwdriver.
I didn't till I had to become one of them this year. Mnesia is real, it's prime time, but not in place of something like Oracle.
> comparing an oil rig driller to a fisher price screwdriver.
Better analogy would be Comparing SQL Server to Redis. Mnesia is, at it's heart, a(n optionally) Transactional K-V lookup that can be run distributed. It's use case it works VERY well, but I wouldn't consider it a substitute for Relational storage.