[erlang-questions] MySQl vs. mnesia

Jeff Crane <>
Thu Aug 9 01:28:39 CEST 2007


MySQL > mnesia. I'm an erlang fan, but technically you
dont really have much of a choice.

I'm not sure mnesia shines anywhere but in theory.
Someone needs to talk about a DB's performance over
millions of rows. I can use MSAccess tables for 30,000
records a pop and I get decent performance and no data
loss, until a table flatfile that is over 2G. MySQL4,
I get no data loss until a table is over 4T and that's
FINE.

Note the first paragraph:
http://erlang-consulting.com/thesis/dbms_eval.html

If I can't do a 6 table FK'd join (on tables
containing hundreds of thousands of rows) I can't use
a DB for real work. *shrug*

--- Ben Munat <> wrote:

> Patrick wrote:
> I'm curious why you recommend MySQL over mnesia? Are
> thinking of "business environment" folks who 
> would just be more comfortable with something well
> known like MySQL? Or do you know of 
> data-integrity or performance issues that I should
> know about?
> 
> ...I have not come
> across a single story of data-loss, performance 
> issues or other problems/disasters with mnesia.



       
____________________________________________________________________________________
Building a website is a piece of cake. Yahoo! Small Business gives you all the tools to get online.
http://smallbusiness.yahoo.com/webhosting 



More information about the erlang-questions mailing list